Making Soda Bread

Ok, so not everything here is technology, sometimes you need to change things up. I had a craving for soda bread, so I made some, and here is how I did it. The recipe: 8 oz Plain white flour 1/2 teaspoon baking soda 1/2 teaspoon salt Enough buttermilk to make …

Disaster planning and disaster recovery

Companies talk about disaster recovery strategies, but I  think it’s more important to think about planning for a disaster. A good plan for a disaster will minimize your downtime, and make any disaster recovery actions that are needed work much more smoothly. The first thing to consider is what is …

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 …