Connect to Azure Database with Mysql with mysql command line

Azure Mysql database in encrypted by default. The mysql connection fails when trying to login: ERROR 9002 (28000): SSL connection is required. Please specify SSL options and retry. Azure Database for MySQL supports connecting your Azure Database for MySQL server to client applications using Secure Sockets Layer (SSL). Enforcing SSL connections between your database server…

Using SED in Linux to Edit Large Files

Recently I encountered a server that had an Apache configuration file that was over 500,000 lines. Changes needed to make were to comment out the CustomLog line for each domain in /etc/httpd/httpd.conf. For this command, I used SED. NAME sed – stream editor for filtering and transforming text SYNOPSIS sed [OPTION]… {script-only-if-no-other-script} [input-file]… DESCRIPTION Sed…

Some Articles and Videos on Setting Up Windows for AD, ADFS, ADCS

Microsoft Windows Below are some articles and video that I found to be useful to set up Windows for Active Directoiry, ADFS, ADCS and AWS. Domain Controller/Active Directory https://social.technet.microsoft.com/wiki/contents/articles/22622.building-your-first-domain-controller-on-2012-r2.aspx https://blogs.technet.microsoft.com/canitpro/2017/02/22/step-by-step-setting-up-active-directory-in-windows-server-2016/ https://msdn.microsoft.com/en-us/library/bb742437.aspx

Enabling Federation to AWS Using Windows Active Directory, ADFS, and SAML 2.0

Setting up and Enabling Federation to AWS Using Windows Active Directory, ADFS, and SAML 2.0. This KB assumes that you have a windows server with IIS, Active Directory, Active Directory Federation Services and Certificate Services Installed. First, perform the following in your domain: Create two AD Groups named AWS-Production and AWS-Dev. AWS Production will have…