How To Solve MySQL GPG Key Errors During yum update

Author: , February 19th, 2022

I went to perform a yum update and got the following error:

SOLUTION: Import the needed new key and manually edit the config files before retrying the yum update.

I had to edit two files: mysql-community-source.repo and mysql-community.repo

For 5.7 – add -2022 to the key name: i.e.: ORIGINAL:

MODIFY ONE […]

How To Prevent SSH From Prompting When The Host Is Unknown

Author: , January 26th, 2022

If you are asked “Are you sure you want to continue connecting (yes/no)?” when trying to connect via SSH, then the remote host’s identification key has not yet been stored in your ~/.ssh/known_hosts file. This then requires you to type the full string “yes” in order to proceed because the default value for ssh is […]

How To Convert An RSA Private Key to PEM Format

Author: , January 10th, 2020

How To Dual-Sort Query Results In WordPress Using get_posts

Author: , September 12th, 2019

Needed to build a feature for a Bookstore tool to have an optional sequence number for the Custom Post Type “books” that would allow items with a seq number to float to the top of the list and be sorted by seq #. The rest of the books would show underneath, sorted alphabetically.

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 Obtain a Public Key from an AWS .pem Private Key on Linux and Mac

Author: , February 4th, 2019

Use the ssh-keygen command on a computer to which you’ve downloaded your private key .pem file; for example: First, ensure permissions will allow ssh-keygen to work: chmod 600 /path/to/the/file/your-key-pair.pem Then generate an RSA public key: ssh-keygen -y -f /path/to/the/file/your-key-pair.pem > your-key-pair.pub

How To Fix Excel for Mac Arrow Keys Do Not Move Cell Cursor

Author: , April 5th, 2017

As per MS Support page: “My arrow keys don’t move from cell to cell” Press SHIFT+F14 to toggle the Scroll Lock to the off position. Applies To: Excel for Mac 2011 Cause: Scroll Lock is turned on and causing the arrow keys to scroll the workbook area. Solution: Turn off Scroll Lock. Typically, when a […]

How To Fix “No Public Key Available” Errors for apt-get update on Debian

Author: , June 29th, 2016

root@myHost # apt-get update Hit http://cloudfront.debian.net wheezy Release.gpg Hit http://cloudfront.debian.net wheezy-updates Release.gpg Hit http://cloudfront.debian.net wheezy-backports Release.gpg Hit http://cloudfront.debian.net wheezy Release Hit http://cloudfront.debian.net wheezy-updates Release Hit http://cloudfront.debian.net wheezy-backports Release Hit http://cloudfront.debian.net wheezy/main Sources Hit http://cloudfront.debian.net wheezy/main amd64 Packages Hit http://cloudfront.debian.net wheezy/main Translation-en Hit http://cloudfront.debian.net wheezy-updates/main Sources Hit http://security.debian.org wheezy/updates Release.gpg Get:1 http://cloudfront.debian.net wheezy-updates/main amd64 Packages/DiffIndex [2,488 […]

How To Force Key Repeat in MacOSX 10.10 Yosemite

Author: , March 19th, 2015

defaults write -g ApplePressAndHoldEnabled -bool false

How To Install Continuent Tungsten Replicator Using Puppet on AWS

Author: , April 15th, 2014

https://github.com/continuent/continuent-puppet-tungsten As user root: vi /root/install.pp

yum install puppet mkdir -p /etc/puppet/modules puppet module install continuent/tungsten puppet apply /root/install.pp