If I had planned ahead, I would have generated my mysqldump file with the –add-drop-table command line option to add the DROP TABLE IF EXISTS `tablename` but I didn’t, so when my 39GB mysqldump file had a Foreign key constraint error on line 34233, I would have had to generate a whole new one to […]

Let’s Encrypt has just released their newest intermediate certificate authority, Let’s Encrypt X3 and with that, it’s now compatible with Windows XP for users using Chrome and antique Internet Explorer. While I’ve already been delving into the system, it’s now going to be my go-to with that last minor hiccup for users who couldn’t/wouldn’t update […]

So after following all the guides I could find, I had XMPP handling state information for my asterisk boxes, but then I wanted to add another server to the mix. res_xmpp.c:1397 xmpp_pubsub_handle_error: Error performing operation on PubSub node device_state, 403. Here’s the details derived from http://xmpp.org/extensions/xep-0060.html#owner-affiliations So, to query the current affiliations I ran: <iq […]

After running a name server for a while, you’re going to get a knock at the door one day from the Internet Police because your DNS server is spewing up crap all over the interwebs. So, to block those lookups from even hitting your bind name server, you can throw iptables in the mix and […]

For whatever reason, someone thought it would be a grand idea to have 250 web sites in one subversion repository, that repository, now converted to git, is now 2.5GB and bloated as can be. Some of the data in there can just sit there and rot, but some of it is still quite useful, so […]

Found this perfectly summarized guide to making a Windows 7 bootable USB install drive. Something I’ve done repeatedly but never had such a succinct list of tasks to get it done. Please note: during this procedure you’ll lose any data on your USB flash drive. Please be extra careful during formatting, choosing the wrong drive […]

Occasionally my mysql mirror server will crash or the power will go off on it since it’s not mission critical, it’s not on a UPS. Typically I’d use this “opportunity” to build a new mysqldump or rsync the live mysql database folder and start a new mirror, but that takes a whack of time that […]

Security is of utmost concern, and the ever-changing, ever-evolving security world demands you keep up with securing your systems. Fortunately, browsers like Firefox and Chrome have made it their practice to disable weak encryption but if you’re running some older systems you’ll need to update them so visitors can still access your site. The latest […]

There’s a new BIND vulnerability in the wild that users can use to remote execute denial of service attacks. For most distributions it’s just a matter of an apt-get update or a yum update but according to this post I found on The Register’s comments from an anonymous user, there’s an extra step required with […]

(2016-05-16 Updated for latest Raspbian Jessie) With the advent of the Rasperry Pi 2, it’s time to get into the Pi-ecosystem again and one of the things I wanted to see if there was more performance on was the use of chromium in my stats board. I followed this guide a while back and I […]