How To Install/Update CPAN on MacOS Mojave with fatal error: ‘EXTERN.h’ file not found

Author: , June 12th, 2019

The Problem Tried to install the latest version of cpan and got stuck. Tracked it down to the dependency module Mac::SystemDirectory which was failing to build:

The Solution Use the MacOS installer command to deploy the needed files:

The, rerunning the cpan install works:

How To Fix YUM Update Errors with Percona GPG Keys

Author: , April 16th, 2019

Problem: Trying to run a yum -y update as root aborts with the following error:

The solution, found on the Percona website, is this: sudo yum update percona-release Source URL: https://www.percona.com/blog/2019/02/05/new-percona-package-signing-key-requires-update-on-rhel-and-centos/

How To Fix WordPress Missing “Add New” Button in Plugins and Menu Choice “Dashboard > Updates”

Author: , April 17th, 2017

If you are missing either your “Dashboard > Updates” menu choice, or the “Add New” button or menu choice in the Plugins section, do this to correct it: Edit the wp-config.php file, and change two lines to be false instead of true: For example, here are the two lines fixed:

How To Fix apt-get Errors on Old Ubuntu Hosts

Author: , August 3rd, 2016

As usual, whenever I have to do sysadmin on a Ubuntu-based OS, I find problems. When will people realize what a horrible OS it is? In this case, packages needed were unavailable. For apt-get to function, the file /etc/apt/sources.list must be edited to change all URLs from security.ubuntu.com and archive.ubuntu.com to old-releases.ubuntu.com, using the sed […]

How To Update the innodb_log_file_size Setting in MySQL

Author: , October 29th, 2014

[root@db1 ~]# service mysqld stop [root@db1 ~]# cd /var/lib/mysql [root@db1 mysql]# ls -l ib_logfile? -rw-rw—- 1 mysql mysql 5242880 Oct 29 23:00 ib_logfile0 -rw-rw—- 1 mysql mysql 5242880 Oct 29 22:38 ib_logfile1 [root@db1 mysql]# mv ib_logfile0 ib_logfile0.old [root@db1 mysql]# mv ib_logfile1 ib_logfile1.old [root@db1 ~]# vi /etc/my.cnf innodb_log_file_size=64M # comment out the old value, if one […]

How To Easily Update Your WordPress URL After A Server Move

Author: , February 6th, 2012

To convert FROM dev TO www:

To convert FROM www TO dev:

How To Fix Broken Boot After Yum Update On Amazon Linux

Author: , January 20th, 2012

Stop the instance first…YMMV:

http://aws.amazon.com/amazon-linux-ami/latest-release-notes/