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: 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 and your client applications helps protect against “man in the middle” attacks by … Read more

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 … Read more

Linux mount CIFS Windows Share

CIFS stands for Common Internet File System. This is application-level network protocol mainly used to provide shared access to files, printers, serial ports, and miscellaneous communications between nodes. You can access CIFS share from Linux and mount them as a regular filesystem. This is handy if there is a backup service like Infrascale where you … Read more

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

Read more

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:

  1. Create two AD Groups named AWS-Production and AWS-Dev. AWS Production will have users that have administrative access and the AWS-Dev will have S3 , EC2 and RDS servies in AWS.
  2. Create users that will go into the accounts.
  3. Give the users email address (e.g., dev@myemail.com).
  4. Add users to the AWS-Production and AWS-Dev groups.

Read more

Unable to remote desktop to Server 2012 after adding user to Remote Desktop Users Group

Are you having trouble accessing your Windows Server 2012 machine using remote desktop, even after adding the user to the Remote Desktop Users group? Remote Desktop appears to accept the login credentials but then you receive the following error message: “To sign in remotely, you need the right to sign in through Remote Desktop Services. … Read more