One of my recurring annoyances is that the AWS cli utility doesn’t support a CSV output option. This command fixes this (at least for snapshot data). aws ec2 describe-snapshots –owner-ids 12345 –output json |jq -r ‘.Snapshots[] | [.Description, .Encrypted, .OwnerId, .Progress, .SnapshotId, .StartTime, .State, .VolumeId, .VolumeSize, .StorageTier] | @csv’ >snapshots.csv …
One of the common issues with modern fonts is that certain characters can be easily confused. These include the letters and numbers 0,O,o,1,l,i and has been the subject of an XKCD comic. Here are two simple scripts to generate a random alpha-numeric password which avoids ambiguous characters. First python: #!/usr/bin/python …
The command line in Linux is powerful, but it also allows a user to do a lot of dangerous things. Removing files with a wildcard is one of those things where a misplace space or typoed command can remove a lot more files that expected. One of the worst feelings …
Sometimes you may find that you are getting a lot of unwelcome traffic from a particular country. This may be a compromised server trying to find exploits, or sometimes it a badly tuned search engine that is hammering your webserver. In this post, I’ll provide a script that will help …
For more details about X.509 certificates, you can read the wikipedia article at https://en.wikipedia.org/wiki/X.509 Display Certificate Values subject, expiry, signature algorithm, fingerprint, modulus md5 sum CERT=crt.pem echo; echo “Cert:” $CERT; CERTV=$(openssl x509 -text -noout -in $CERT);echo -n “Subject: “;echo “$CERTV”|grep -i [S]ubject:|cut -d ‘:’ -f 2;echo -n “Issuer Date: “;echo …
Creating a User / Role Mysql: mysql> GRANT ALL PRIVILEGES ON dbname.* TO ‘dbuser’@’%’ IDENTIFIED BY ‘dbpass’; (The above grants full access to the named database to the named user connecting from any host on the internet identifying using the given password. If granting privileges this way, it’s important to …
Initializing the DBMS (Note that this assumes no meta-database or anything exists at the present time.) Mysql: Just start the mysqld daemon if he mysql meta-database doesn’t exist. (see below) Postgresql: linux# su -c “initdb -D /path/to/data/dir” postgres Starting the DBMS Mysql: linux# service mysql start Postgresql: linux# service postgresql …
Preparing your server for SSL If you are installing SSL and Let’s Encrypt on Ubuntu for the first time, you should first enable SSL on your apache install. If you don’t you will get this error message: SSLCertificateFile: file ‘/etc/apache2/insert_cert_file_path’ does not exist or is empty First enable SSL: sudo …
I needed to check the performance of a database after some changes. This gets me some raw numbers on the performance of the slow queries log in MySQL: tail -n 10000 log-slow-queries.log|grep Query|awk ‘{print $3}’|awk -F . ‘{print $1}’|sort -n|uniq -c|awk ‘{print $2″ “$1}’ It outputs seconds taken, and number …
I had a mysqldump that wasn’t playing nice and would error out 745,273 lines into the dump. The error log wasn’t useful so to look at the exact line, I did this: sed -n “745273 p” dump.sql The syntax is: sed -n “linenumber p” file.txt