curl https://bintray.com/sbt/rpm/rpm | sudo tee /etc/yum.repos.d/bintray-sbt-rpm.repo
sudo yum install sbt

postsuper -d ALL deferred

Result e.g.:

postsuper: Deleted: 712 messages

GRANT ALL PRIVILEGES ON db_name.* to 'new_user'@'hostname' IDENTIFIED BY 'password';

Can’t take much credit for this how to guide. I followed the post on the forum (below) and can confirm that it does work.

Tools/Materials needed:

• Star head screw drivers (large and small head)
• Small flat head screw driver
• 4 core electrical cable
• Cable stripper

Steps to install:

**Make sure power to boiler is turned off at the fuse box and tested**

1. Hook up electrical cable to heat link as shown:

N – Neutral – Blue wire

L – Live – Brown wire

2 – (Common) – Grey wire

3 – (Call for heat) – Black wire

I can’t take any credit for this script. Rich Adams created it and shared kindly on github:

https://gist.github.com/richadams/384020d6e4e6d4f400d7

Steps:

1. Login to AWS account

2. IAM > Users > Username > Security Credentials > Create Access Key

3. Add ‘Access key Id’ and ‘Secret access key’ to relevant section in the script

4. Make sure script is executable (chmod +x)

5. Run script, outputting security groups to text file i.e.

sh aws_security_group_details.sh >> aws_all_regions_secgroups.txt

6. Remove access key from AWS > IAM if not longer required

Code below in case the version is removed from github: