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… Continue reading Let’s Encrypt when your server is behind a firewall and you can’t use DNS Challenge
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 … Continue reading MSSQL ODBC Client on Debian 9 Stretch
I quite often want to convert mp3 files to m4b, Apple’s proprietary nastiness. There is pacpl of course but that has issues these days, particularly with copying the id3 tags to the new file. FFmpeg can do it when you build from source (I just found a nice script that will build it from source for… Continue reading convert mp3 to m4b on the linux command line
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… Continue reading FreeTDS is a bag of razorblades use, Microsoft ODBC Driver for Linux instead
Use fail2ban with WordPress to prevent xlmrpc.php DDoS attacks
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… Continue reading Howto quickly find your Beaglebone Black’s IP address
Using a method I previously wrote about, it’s quite easy to backup your Beaglebone Black over the network. ssh root@bbb ‘tar cf – / 2>/dev/null’ | pv -cN tar \ | bzip2 | pv -cN bzip2 > bbb-backup-tar.bz2 It runs the bzip compression locally because presumably it will be faster than on the Beaglebone Black.… Continue reading Backup your Beaglebone Black
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… Continue reading Printing from Windows to a samba shared CUPS-PDF printer sometimes fails
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… Continue reading automysqlbackup ERRORS REPORTED: MySQL Backup error Log Warning: Skipping the data of table mysql.event. Specify the –events option explicitly.
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 ->… Continue reading increase wordpress Maximum upload file size beyond 8MB.