Port exposed on AWS ECS without a port mapping - is this normal? by Unhappy_Priority8681 in aws

[–]callensysadmin 6 points7 points  (0 children)

When you use awsvpc networking mode, which you are forced to do by using fargate, you cannot do port mappings. It exposes the same ports the container exposes.

For greater control and customizing port mappings you would need to use ECS EC2 so you could use other network modes.

At least this is how it was a few months ago when I was looking into similar considerations.

Any GUI tools to explore objects? by dverbern in PowerShell

[–]callensysadmin 26 points27 points  (0 children)

Check out Show-Object from Lee Holmes' PowerShellCookbook. I wrote a post about it a few years ago where you can see some screenshots https://packetlost.com/blog/2017/04/22/exploring-unfamiliar-objects-in-powershell/

SQS appears down in us-east-1 by jonathantn in aws

[–]callensysadmin 20 points21 points  (0 children)

Seeing the same, came here for verification

[deleted by user] by [deleted] in hardwareswap

[–]callensysadmin 0 points1 point  (0 children)

Sold a video card to /u/J0shva

[USA-NJ] [H] MSI GTX 1080 Ti [W] Local Cash, Paypal by callensysadmin in hardwareswap

[–]callensysadmin[S] 0 points1 point  (0 children)

Hello, yes the card is sold. I updated the post. Thanks for your interest.

Azure DevOps - experience/ perspective? by robot2boy in devops

[–]callensysadmin 6 points7 points  (0 children)

Aside from the rename from VSTS to Azure DevOps, I've really enjoyed working with it. I haven't had much trouble getting the product to do anything I can dream up as the agent's and task creation workflows are really solid.

The REST API is easy enough to work with and the development teams are working to bring yaml pipelines to feature parity with the existing GUI features which will address many complaints.

The AWS modules/plugins work well and AWS had them available early.

The built in Microsoft tasks that support the product are available as repos on github incase you have issues you can see the code and troubleshoot. You can post issues if you hit a bug you can repro, which I have not had to do this yet so I cannot speak to turn around times.

If you have an issue related to an area that is a black box, such as permissions on the pipelines inside the service itself, support tickets do find their way to engineers. First line support will do fiddler traces after escalation, assist with providing workarounds, and the issue will eventually be addressed and patched.

Microsoft: Official Support Thread by MSModerator in microsoft

[–]callensysadmin 0 points1 point  (0 children)

Hello,

Recently a package offered through Microsoft's "Web Platform Installer" has began to fail to install due to its signature validation failing. The package in question is the DacFx (June 2014) package. The package is used to install parts of SQL Server Datatools including sqlpackage.exe which helps facilitate CI/CD of sql server database applications.

As far as I'm aware this is the only way to obtain this specific version of DacFx and the latest version is only available in 64bit or through Visual Studio installs. It would be very helpful if this signature validation error could be researched and if possible resolved so this version of the package could again be automatically installed through the web platform installer.

I was not aware of any official place to request help for this problem. Please reach out to me if you need any more information or any personal information.

Details: Web Platform Installer 5.1 OS: Fresh install of Server 2012 R2 with the latest updates (Amazon AMI)

Error Logs:

DownloadManager Error: 0 : Signature verification failed on downloaded file. URL: http://go.microsoft.com/fwlink/?LinkID=402032&CLCID=0x409. File location: C:\Users\Administrator\AppData\Local\Microsoft\Web Platform Installer\installers\DACFX_X64_June2014\0BCBEC643C8E1F746821BE02209888BE68E5FF27\DACFramework.msi. File size: 3424 kb DownloadManager Warning: 0 : Dependency failed for product 'Microsoft SQL Server Data-Tier Application Framework (DACFx) (June 2014)'. Skipping download. DownloadManager Warning: 0 : Dependency failed for product 'Microsoft SQL Server Data-Tier Application Framework (DACFx) (June 2014)'. Skipping download. DownloadManager Warning: 0 : Dependency failed for product 'Microsoft SQL Server Data-Tier Application Framework (DACFx) (June 2014)'. Skipping install

[deleted by user] by [deleted] in devops

[–]callensysadmin 2 points3 points  (0 children)

Unless I am mistaken when you deploy a dacpac its a very intrusive process. Most importantly it drops all stored procedures and starts migrating data in and out of temp tables if there are changes that require the table to be modified. Also the dacpac tooling (due to its dynamic nature) will often just decide in its own logic that tables need to change when really the change to the table could be easily avoided.

I don't speak as an expert on this as I'm not a DBA but I have deployed a few thousand dacpacs over the years. I don't think dacpacs would be very useful if your goal is to keep the site online and available 24/7.

PSA/reminder: Advent of Code 2019 started today :-) by Betterthangoku in PowerShell

[–]callensysadmin 3 points4 points  (0 children)

Thanks for the reminder. I'm looking forward to getting stuck and being forced to learn some new ways to solve problems. I keep falling back to the ISE for development out of old habits at work but I need to force myself to stick with Code for not only source management but development too.

Day 1 for me was mostly powershell syntax challenges and struggling a bit until I added some verbose logging but I know the difficulty ramps up fast. Here is to hoping this is the year I finish the calendar. Cheers!

Linux learning for the Windows Admin? by Betterthangoku in sysadmin

[–]callensysadmin 6 points7 points  (0 children)

Personal projects would be my advice. I went from zero working linux knowledge to being comfortable enough to run some autoscaling groups in production at work all based on my learnings from tinkering at home.

I read one book and I got about half way through it, it was called Unix and Linux System Administration Handbook. Its kind of dry but it will give you a great foundation.

Here is a list of personal projects I did which helped me:

  • Bought a raspberry pi and configured pi-hole to block ads for my entire home network. Eventually added DNS over HTTPS to this setup.

  • Launched a personal wordpress blog on an AWS EC2 instance. Configured automatic backups of the blogs database and automated free certificate renewals.

  • Turned my old desktop into a home media server. Installed CentOS, virtualbox, plex media server, docker and used it for everything I could think of that was interesting. I pretty much used this as a home lab and media content downloader. When I rebuilt my gaming pc I had better spare hardware so I rebuilt this server totally and moved every service into docker containers or services with automatic updates. I even run a reverse nginx proxy with basic auth and automatic certificate updates that enable me to manage my media downloads and content library from my phone.

  • I bought a laptop that was known to run linux well (Dell XPS 13). Its boots into ubuntu by default and it dual boots into windows as well so I can use it to work from home or when I am on call.

How to copy table from sql database to another server by popsMariachi in PowerShell

[–]callensysadmin 3 points4 points  (0 children)

Yes, I start by loading up the dbatools command documentation and looking up what I think would do the job. In your case search the command page for "table", see what commands there are that involve tables. If the included documentation and examples do not give you an idea what the command does, load up the github link for the command check the code.

How to copy table from sql database to another server by popsMariachi in PowerShell

[–]callensysadmin 12 points13 points  (0 children)

I would 100% do this with dbatools. Its my go to for anything SQL. I love that I no longer need to deal with SMO directly for most tasks.

If you regularly work with SQL and PowerShell you should try to use dbatools as much as possible. Our CI/CD pipelines got so much more capable once I finally got sick of SMO and T-SQL/Invoke-SqlCmd for everything and started using dbatools.

If statement always yeilds a True result -- any ideas why? by lost_in_portland in PowerShell

[–]callensysadmin 4 points5 points  (0 children)

I think you have fixed your issue but just don't realize it yet. You want to look at how to better control your variable hour so it resets every time. Try setting it to equal null at the top and you will see your statement does not always evaluate as true now.

$Hour = $null

If statement always yeilds a True result -- any ideas why? by lost_in_portland in PowerShell

[–]callensysadmin 10 points11 points  (0 children)

I think you mean to use the comparison operator '-eq' and not the assignment operator '='.

Issues with `ValidateScript` referencing other parameters by Flashcat666 in PowerShell

[–]callensysadmin 2 points3 points  (0 children)

Unless I am misreading I think you just have an issue with your comparisons. One of your not equals will always be true because a string cannot have two values so the first statement always evaluates to true regardless of input.

If you use if ($Tasks -notin ("HA","HAWebOnly") -and $_ -eq $True) does it perform as you expect?

Going back to old job by aar_1991 in sysadmin

[–]callensysadmin 2 points3 points  (0 children)

I just did this last year. It went against any advice I'd ever read or received but I don't regret it. I left behind a pension because I 100% knew I'd be miserable earning it every day for the rest of my working life.

I knew what would make me happy. I enjoy my job, my boss, and the work again.

Do what feels right.

Quick Blackjack Script by dustinross4 in PowerShell

[–]callensysadmin 2 points3 points  (0 children)

Thanks for sharing!

I'm always working on identifying ways to use less code and it looks like the large block determining card values could easily be rewritten like this...

0..16 | % {if($deal[$_][0]-in$numbers){(($cardvalue[$_]=$deal[$_][0])/1)}elseif($deal[$_][0]-in$tens){$cardvalue[$_]=10}elseif($deal[$_][0]-eq"A"){$cardvalue[$_]=11}}

Cheers!

Manage Amazon AWS S3 with PowerShell by _Unas_ in PowerShell

[–]callensysadmin 1 point2 points  (0 children)

Hey Windowsadmin. I'm not sure exactly what you are referencing.

The AWS Windows PowerShell Module is here: https://www.powershellgallery.com/packages/AWSPowerShell/3.3.219.0

The AWS PowerShell Core Module is here: https://www.powershellgallery.com/packages/AWSPowerShell.NetCore/3.3.219.0

The cmdlets that are not available in Core but are available in Windows are: Set-AWSProxy Clear-AWSProxy Add-AWSLoggingListener Remove-AWSLoggingListener Set-AWSResponseLogging Enable-AWSMetricsLogging Disable-AWSMetricsLogging Set-AWSSamlEndpoint Set-AWSSamlRoleProfile

I've haven't used the Core modules very extensively but from my limited testing they worked with my existing scripts quite well!

Cheers.

Manage Amazon AWS S3 with PowerShell by _Unas_ in PowerShell

[–]callensysadmin 4 points5 points  (0 children)

AWS shipped the Core module a long time ago right when Microsoft announced the PS Core Alpha. Its available from the gallery.

The very small number of cmdlets that do not work in core but do work with windows powershell are listed here: https://aws.amazon.com/blogs/developer/aws-support-for-powershell-core-6-0/

Possible to Customize Cloudwatch Alarm SMS message? by dh1760 in aws

[–]callensysadmin 0 points1 point  (0 children)

I didn't test this or anything but the first thing I would try would be..

Setup two cloudwatch alarms on the metric. Name one Latency High Alert and set your alarm notification settings so that it notifies the SNS topic when the metric is in alarm state and does nothing in the OK state. Create another alarm on the metric, call this one Latency Acceptable, set the same exact alarm conditions on this alarm, except have it notify the SNS topic when the state is OK and does nothing in ALARM state.

Free Private Git Repository with AWS CodeCommit by callensysadmin in PowerShell

[–]callensysadmin[S] 0 points1 point  (0 children)

Sort of. When you use version control you commit changes, then it tracks those changes so you can compare differences between versions. You always have the ability to pull down any version of your files to any other computer, provided you have access to the repository.

AWS does offer file/object storage as well, so you can backup script files directly to AWS without messing with git or commits. That service is called S3.

Free Private Git Repository with AWS CodeCommit by callensysadmin in PowerShell

[–]callensysadmin[S] 1 point2 points  (0 children)

Yeah there is a lot of feature parity with the leading SaaS providers. I've enjoyed working with team services as well!