How To Upgrade MySQL to 8.0 on CentOS/AWS Linux

Author: , August 31st, 2023

START: Server version: 5.7.43-log MySQL Community Server (GPL) FINISH: Server version: 8.0.34-log MySQL Community Server (GPL)

https://dev.mysql.com/doc/refman/8.0/en/default-privileges.html Check and veify your my.cnf ssl entries if you see the following error in the /var/log/mysqld.log file at startup:

How To Convert from AWS Instance Family t2 to t3 with Enhanced Networking on Amazon Linux 1

Author: , June 10th, 2021

I wanted to change instance type from t2 to t3, but got an error when i went to start the instance:

I found this AWS docs page: https://docs.aws.amazon.com/AWSEC2/latest/UserGuide/enhanced-networking-ena.html Below are the steps I need to follow on AWS Linux 1. Summary Steps Pre-flight tests on t2 modinfo ena -> see “ERROR: modinfo: could not […]

How To Fix “IOError: [Errno 10] No child processes” When Running the aws CLI Command from Perl WWW-REST-Apid

Author: , December 3rd, 2020

Problem While running the aws cli command from a Perl async command inside apid, I go the following error:

Solution The issue turned out to be a bug in Python2.7, so I upgraded to Python3.4, then uninstalled and re-installed the aws cli software so that it used the proper Python34 version. Procedure

https://docs.aws.amazon.com/cli/latest/userguide/install-cliv2-linux.html […]

How To Install MySQL 8.0 on AWS Linux 2

Author: , November 18th, 2020

How To Upgrade Certbot, Python and PIP on AWS Linux 1

Author: , May 6th, 2020

I ran letsencrypt-auto renew and got the following error:

The solution in this article gave me the answer:

Turns out Python was old at version 2.7, so did the following also:

Also had to change the cron job script to call certbot directly instead of letsencrypt-auto : vi /root/letsencrypt-cron.sh

How To Upgrade MySQL to 5.7 on CentOS/AWS Linux

Author: , December 7th, 2017

START: Server version: 5.5.54-log MySQL Community Server (GPL) FINISH: Server version: 5.7.20-log MySQL Community Server (GPL)

If you do not restart MySQL server at the end, you will get this error:

Check and veify your my.cnf ssl entries if you see the following error in the /var/log/mysqld.log file at startup:

How To Patch the ShellShock bash Bug on Older or Beta AWS Linux AMI’s

Author: , October 1st, 2014

This is the standard upgrade method for AWS Linux AMI’s:

Or use this for the version 2012.09, 2012.03, or 2011.09 repositories:

For older AWS Linux AMI’s, you may not be able to use the standard upgrade method as described in this link: https://alas.aws.amazon.com/ALAS-2014-419.html These are the steps needed to manually patch bash 4.1: […]

How to Install Apache mod_evasive on AWS Linux/CentOS

Author: , July 26th, 2014

I was getting tired of using iptables to block the various hackers and bots constantly slamming my servers (the Chinese are the worst offenders by far – curse them!). I found the Apache module mod_evasive and installed it. Here are links to various articles about mod_evasive: http://www.zdziarski.com/blog/?page_id=442 https://coderwall.com/p/eouy3g http://www.crucialp.com/resources/tutorials/server-administration/flood-protection-dos-ddos-protection-apache-1.3-2.0-mod_dosevasive-avoiding-denial-of-service-attacks.php Add the Module to Apache I […]

How to Patch CGI::Application::Plugin::ConfigAuto to Run Perl in Taint Mode

Author: , April 13th, 2012

I had to patch the distribution by adding the following variable into the code: $Config::Auto::Untaint = 1; Here is the fix on AWS Linux: vim /usr/local/share/perl5/CGI/Application/Plugin/ConfigAuto.pm 141 sub cfg { 142 my $self = shift; 143 144 if (!$self->{__CFG}) { 145 require Config::Auto; 146 $Config::Auto::Untaint = 1; (ADD THIS NEW LINE HERE)