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

Author: erics, September 13th, 2023

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

shell> aws ec2 authorize-security-group-ingress --group-id sg-NNNNNNNN --protocol tcp --port 80 --cidr '0.0.0.0/0'

1	shell> aws ec2 authorize-security-group-ingress --group-id sg-NNNNNNNN --protocol tcp --port 80 --cidr '0.0.0.0/0'

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

shell> aws ec2 revoke-security-group-ingress --group-id sg-NNNNNNNN --protocol tcp --port 80 --cidr '0.0.0.0/0'

1	shell> aws ec2 revoke-security-group-ingress --group-id sg-NNNNNNNN --protocol tcp --port 80 --cidr '0.0.0.0/0'

## List security groups by security group ID

shell> aws ec2 describe-security-groups --output json | jq -r '.SecurityGroups[]|.GroupId+" "+.GroupName'

1	shell> aws ec2 describe-security-groups --output json \| jq -r '.SecurityGroups[]\|.GroupId+" "+.GroupName'

## List inbound rules for a specific security group ID

shell> aws ec2 describe-security-groups --group-ids sg-NNNNNNNN --output json | jq -r '.SecurityGroups[].IpPermissions[]|. as $parent|(.IpRanges[].CidrIp+" "+($parent.ToPort|tostring))'

1	shell> aws ec2 describe-security-groups --group-ids sg-NNNNNNNN --output json \| jq -r '.SecurityGroups[].IpPermissions[]\|. as $parent\|(.IpRanges[].CidrIp+" "+($parent.ToPort\|tostring))'

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

Categories: How-To's, Technology Tags: Add, AWS, aws cli, cli, Delete, Group, howto, Remove, security, Security Group, tips | No comments

How To Fix WordPress Missing “Add New” Button in Plugins and Menu Choice “Dashboard > Updates”

Author: erics, 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:

define('DISALLOW_FILE_EDIT', false);
define('DISALLOW_FILE_MODS',false);

1 2	define('DISALLOW_FILE_EDIT', false); define('DISALLOW_FILE_MODS',false);

Categories: How-To's, Technology Tags: Add, Add New, Button, Disable, DISALLOW, DISALLOW_FILE_EDIT, DISALLOW_FILE_MODS, false, howto, Missing, tips, update, WordPress | No comments

How To Add a Column of Numbers Using AWK

Author: erics, January 1st, 2015

awk ‘{sum+=$1}END{print sum}’ inputFile

Categories: How-To's, Technology Tags: Add, AWK, bash, Command line, howto, Math, Shell, Sum, tips | No comments

How To Sort Text as a Number in MySQL

Author: erics, July 11th, 2013

select theField from theTable order by theField+0; ~OR~ select theField from theTable order by CAST(theField AS UNSIGNED);

Categories: How-To's, Technology Tags: 0, Add, Cast, howto, Number, sort, String, text(), tips, Zero | No comments

How To Sum the Values of Form Fields

Author: erics, October 3rd, 2012

var sum = 0;
// loop through each field
jQuery(".sum").each(function() {
   //add only if the value is number
   if( ! isNaN(this.value) && this.value.length != 0 ) {
      sum += parseFloat(this.value);
   }
});
//.toFixed() rounds the sum to 2 decimal places
jQuery("#sum").html(sum.toFixed(2));

1

2

3

4

5

6

7

8

9

10

var sum = 0;

// loop through each field

jQuery(".sum").each(function() {

//add only if the value is number

if( ! isNaN(this.value) && this.value.length != 0 ) {

sum += parseFloat(this.value);

}

});

//.toFixed() rounds the sum to 2 decimal places

jQuery("#sum").html(sum.toFixed(2));

Categories: How-To's, Technology Tags: Add, form, howto, JQuery, Math, Sum, tips | No comments

S	M	T	W	T	F	S
	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

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

How To Fix WordPress Missing “Add New” Button in Plugins and Menu Choice “Dashboard > Updates”

How To Add a Column of Numbers Using AWK

How To Sort Text as a Number in MySQL

How To Sum the Values of Form Fields

Our Link Network

Business

Client Websites

Fine Dining

Friends & Family

Galleries

Health

Resources

Technology

Travel

The Archives

Latest Ramblings…

Various Topics of No Interest