Let’s Encrypt when your server is behind a firewall and you can’t use DNS Challenge

Sometimes you want to give a server that is  behind a firewall a valid SSL certificate. Let’s Encrypt provides a nice solution for this called DNS Challenge. The problem with DNS Challenge is it may require some manual configuring to on your server to set it up. That is all fine and good but sometimes […]

MSSQL ODBC Client on Debian 9 Stretch

Many years ago fREW Schmidt wrote a very handy article on installing MSSQL ODBC drivers in debian. Since then Microsoft have improved their support of debian somewhat and things have changed making it easier to install, however they still (as at 2017-11-06) have not released proper drivers for Debian Stretch. Add the microsoft repo echo  […]

FreeTDS is a bag of razorblades use, Microsoft ODBC Driver for Linux instead

According to @mst FreeTDS is a bag of razorblades. That’s right folks, don’t use it. The new way to go is Microsoft ODBC Driver for SQL Server on Linux. Unfortunately its a nightmare to install on debian. Luckily some very smart people wrote a lovely little howto: Install and Configure the MS ODBC Driver on […]

Howto quickly find your Beaglebone Black’s IP address

Whenever I connect my Beaglebone Black (BBB) to a network, I have to work out it’s IP address so I can ssh into it. This can be tricky. Some of your options are: connect to the serial terminal, or connect over the usb network interface which gives the BBB the address 192.168.7.2, log in and […]

Printing from Windows to a samba shared CUPS-PDF printer sometimes fails

I had this problem where prints to our CUPS-PDF printer sometimes failed to be processed on the server. The job would disappear as though it has been printed but nothing else would happen. Printing from the same application to a Windows based PDF printer, and then printing the resulting PDF via Adobe Acrobat to the […]

automysqlbackup ERRORS REPORTED: MySQL Backup error Log Warning: Skipping the data of table mysql.event. Specify the –events option explicitly.

I was receiving email error messages from cron like this from my autbackupmysql on a regular basis: ERRORS REPORTED: MySQL Backup error Log for somehost.com.dxa – 2014-05-01_06h26m — Warning: Skipping the data of table mysql.event. Specify the –events option explicitly. It turns out that mysqldump now warns you if the events table is not being […]

increase wordpress Maximum upload file size beyond 8MB.

There is at least three places you need to set the maximum upload file size in WordPress. First check your php.ini upload_max_filesize = 64M; post_max_size = 64M; Restart Apache after making this change. Then if you are using WordPress multi-site, you need change a setting in the backend. Visit My Sites -> Network Admin -> […]