Author:
erics, May 19th, 2023
I was unable to login from my old iMac running Yosemite to my new iMac running Ventura using RSA keys. It turns out that RSA key support was disabled in Ventura. To correct the problem, I added the following two lines to the bottom of /etc/ssh/sshd_config:
|
|
HostkeyAlgorithms +ssh-rsa PubkeyAcceptedAlgorithms +ssh-rsa |
Categories: How-To's, Technology Tags: denied, HostKeyAlgorithms, howto, key, login, MacOS, OSX, Permission, Pubkey, PubkeyAcceptedAlgorithms, PublicKey, RSA, ssh, sshd, tips, Ventura, Yosemite
| 
No comments
Author:
erics, May 9th, 2023
I have been using RSA SSH keys forever to login to my various AWS EC2 instances. With macOS Ventura 13.3.1 ssh failed with the “Permission Denied” error. Using ssh -vvv, I saw that the RSA key was now being rejected. After much research, I decided to implement new keys on the client (Ventura) side using […]
Categories: How-To's, Technology Tags: AWS, denied, ed25519, Error, Generate, howto, key, Linux, MacOS, Permission Denied, public, Public Key, ssh, ssh-keygen, sshd, tips, Ventura
| No comments
Author:
erics, February 19th, 2022
I went to perform a yum update and got the following error:
|
|
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql The GPG keys listed for the "MySQL 5.7 Community Server" repository are already installed but they are not correct for this package. Check that the correct key URLs are configured for this repository. Failing package is: mysql-community-server-5.7.37-1.el7.x86_64 GPG Keys are configured as: file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql |
SOLUTION: Import the needed new key and manually edit the config files before retrying the yum update.
|
|
rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022 |
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:
|
|
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql |
MODIFY ONE […]
Categories: How-To's, Technology Tags: GPG, GPG Key, key, mysql, Yum, yum update
| 2 comments
Author:
erics, 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 […]
Categories: How-To's, Technology Tags: ask, Check, Checking, Host, howto, interactive, key, known_hosts, prompt, ssh, Strict, StrictHostKeyChecking, tips
| No comments
Author:
erics, January 10th, 2020
|
|
openssl rsa -in ~/.ssh/id_rsa -out ~/.ssh/id_rsa.pem |
Categories: How-To's, Technology Tags: .pem, convert, howto, id_rsa, id_rsa.pem, id_rsa.pub, key, openssl, Private, private key, RSA, ssl, tips
| No comments
Author:
erics, 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.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 |
$querytop = get_posts(array( 'post_type' => 'books', 'numberposts' => -1, 'orderby' => 'meta_value', 'meta_key' => 'book_seq', 'order' => 'ASC', 'meta_query' => array( // meta query takes an array of arrays, watch out for this! array( 'key' => 'book_seq', 'value' => array('', 'NULL'), 'compare' => 'NOT IN' ) ) )); $querybottom = get_posts(array( 'post_type' => 'books', 'numberposts' => -1, 'orderby' => 'post_title', 'order' => 'ASC', 'meta_query' => array( // meta query takes an array of arrays, watch out for this! array( 'key' => 'book_seq', 'compare' => 'NOT EXISTS' ) ) )); $query = array_merge($querytop, $querybottom); |
Categories: How-To's, Technology Tags: bottom, Compare, cpt, Exists, Filter, Float, get_posts, howto, key, meta_key, meta_value, NOT EXISTS, NOT IN, Order, OrderBy, post_type, Query, Seq, Sequence, sort, tips, top, Value, WordPress
| No comments
Author:
erics, April 16th, 2019
Problem: Trying to run a yum -y update as root aborts with the following error:
|
|
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. Failing package is: sysbench-1.0.17-2.el6.x86_64 GPG Keys are configured as: file:///etc/pki/rpm-gpg/RPM-GPG-KEY-Percona |
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/
Categories: How-To's, Technology Tags: GPG, howto, key, Keys, Percona, percona-release, release, tips, update, Yum, yum update
| 1 comment
Author:
erics, 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
Categories: How-To's, Technology Tags: .pem, .pub, Amazon, apple, AWS, cli, howto, key, key-pair, KeyPair, Linux, Mac, MacOS, macosx, Pubkey, public, Public Key, ssh-keygen, tips
| No comments
Author:
erics, 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 […]
Categories: How-To's, Technology Tags: apple, Arrow, Cursor, Excel, howto, key, Keyboard, Mac, Move, MS Excel, tips
| No comments
Author:
erics, 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 […]
Categories: How-To's, Technology Tags: apt-get, Debian, Error, howto, key, Linux, public, Public Key, tips
| No comments
