Installing Let’s Encrypt SSL certificates on Ubuntu, things to know

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 …

Counting your slow queries by seconds

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 …

Disabling IPv6 in Firefox

Recently I had an issue where a site was restricting itself to a single IPv4 address. Unfortunately the new server that uses it also supported IPv6. When firefox hit it, the server reported that it wouldn’t work with the new server. I used my favourite site, icanhazip.com to check, and …