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

How To Install A Network Solutions EV SSL Certificate On CentOS Apache 2

Author: , October 11th, 2011

Create the server key from your original private key by removing the pass-phase:

These are the files that NetSol provided me in the download .zip file (domain name changed to protect the innocent):

Network Solutions does not make it easy on you – in the install docs they tell you there is yet […]

How To Get root Access To An AWS Instance At Launch

Author: , August 3rd, 2011

First use SSH to login as the ec2-user:

erics@zeus:/Users/erics # ssh -i foo.pem ec2-user@thehost.foo Last login: Tue Nov 19 20:28:19 2013 from foo.bar __| __|_ ) _| ( / Amazon Linux AMI ___|\___|___| https://aws.amazon.com/amazon-linux-ami/2013.09-release-notes/ No packages needed for security; 7 packages available Run “sudo yum update” to apply all updates. [ec2-user@xyz ~]$ sudo su […]

How To Fix Webmin SSL Setup Errors

Author: , October 19th, 2010

I was getting this error:

Edit the file /etc/webmin/miniserv.conf and add: