How to add and delete security group rules in AWS via the CLI (and list them too!)

Author: , September 13th, 2023

Add inbound rule(s) for a security group ID:

## Delete inbound rule(s) for a security group ID

## List security groups by security group ID

## List inbound rules for a specific security group ID

Thanks to: https://www.bluematador.com/learn/aws-cli-cheatsheet

How To Fix Mouse Scrolls the Command Line History Instead of the Window Buffer in Terminal

Author: , May 23rd, 2023

In the macOS Terminal, my mouse scroll wheel would magically start scrolling the command line history instead of the window buffer scroll bar on the right to show window history. This happened when an SSH session was disconnected or timed out. The fix is to run the reset command.

How To Get A Reverse DNS Lookup On The Command Line

Author: , September 1st, 2021

There are three commands in Linux to easily get a reverse DNS lookup with: dig, host and nslookup. Here are examples of each: shell> dig -x 3.214.2.238 +short

shell> dig -x 3.214.2.238

shell> host 3.214.2.238

shell> nslookup 3.214.2.238

How To Fix aws Command Error “You must specify a region”

Author: , July 29th, 2021

I was getting error “You must specify a region” when running any aws CLI command. The fix: Using the aws command:

which will automatically add the following to the file ~/.aws/config:

You many simply edit the ~/.aws/config file yourself and append the same thing:

How To Control Output Formatting Via The MySQL Shell CLI

Author: , May 26th, 2021

-N: No column headers -B: Batch mode – use tabs as field separators https://dev.mysql.com/doc/mysql-shell/8.0/en/mysql-shell-output-formats.html Multiple Formats Available: Table Format – use –result-format=table, alias –table Tab Separated Format – use –result-format=tabbed, alias –tabbed Vertical Format – use –result-format=vertical, alias –vertical JSON Format Output – use –result-format=VALUE, alias –json[=pretty|raw|off] VALUE may be one of: json or […]

How To Fix “IOError: [Errno 10] No child processes” When Running the aws CLI Command from Perl WWW-REST-Apid

Author: , December 3rd, 2020

Problem While running the aws cli command from a Perl async command inside apid, I go the following error:

Solution The issue turned out to be a bug in Python2.7, so I upgraded to Python3.4, then uninstalled and re-installed the aws cli software so that it used the proper Python34 version. Procedure

https://docs.aws.amazon.com/cli/latest/userguide/install-cliv2-linux.html […]

How To Extract Time Machine Logs Via Terminal

Author: , November 2nd, 2020

How To Show the Origin in Git

Author: , January 30th, 2020

Recently, I wanted to see the “origin” of the git repository I was working in. The command is: git remote -v For example:

How To Update a WordPress Plugin Manually Using rsync

Author: , January 24th, 2020

If you are unable to update a plugin via the WP admin console, then you can do the update manually. Download the zip file to your local hard drive and extract it. Then, from the command line, do the test run first:

*Make sure to use the trailing slashes with rsync for proper operation […]

Slick Command-Line Tricks for a Tungsten MySQL / MariaDB Database Cluster

Author: , July 16th, 2019

Tungsten Clustering provides high availability, disaster recovery, and a host of other benefits for MySQL / MariaDB / Percona Server databases. In this blog post we will explore some of the shell aliases I use every day to administer various Tungsten Clusters.