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: 1 2 3 4 5 The GPG keys listed for the "Percona-Release YUM repository – x86_64" repository are already installed but they are not correct for this package. Check that the correct key URLs are configured for this repository.   […]

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: 1 2 define(’DISALLOW_FILE_EDIT’, false); define(’DISALLOW_FILE_MODS’,false); […]

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 and to, 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: 1 2 3 4 5 use yourDatabase; UPDATE wp_options SET option_value = REPLACE(option_value, ‘’, ‘’); UPDATE wp_posts SET post_content = REPLACE(post_content, ‘’, ‘’); UPDATE wp_posts SET guid = REPLACE(guid, ‘’, ‘’); UPDATE wp_postmeta SET meta_value = REPLACE(meta_value, ‘’, ‘’); use yourDatabase; UPDATE wp_options SET option_value = REPLACE(option_value, ‘’, ‘’); […]

How To Fix Broken Boot After Yum Update On Amazon Linux

Author: , January 20th, 2012

Stop the instance first…YMMV: 1 2 3 4 5 yourHost# ec2-describe-images describe-images -o amazon –filter "manifest-location=*pv-grub-hd0_1.02-i386*" –region us-east-1 IMAGE   aki-805ea7e9    ec2-public-images/pv-grub-hd0_1.02-i386.gz.manifest.xml amazon  available   public      i386    kernel              instance-store  paravirtual xen   yourHost# ec2-modify-instance-attribute –kernel aki-805ea7e9 –region us-east-1 i-39764XXX kernel  i-39764XXX  aki-805ea7e9 yourHost# ec2-describe-images describe-images […]