Fixing broken DNS lookups in spamassassin

I talked about the joys of running my own mail server last week only to find that my mail server was broken yesterday. Spamassassin stopped doing DNS lookups for RBL and SPF checks. I had one of these moments:

My logs looked like this: plugin: eval failed: available_nameservers: No DNS servers available! plugin: eval failed: available_nameservers: No DNS servers available! rules: failed to run NO_DNS_FOR_FROM RBL test, skipping: (available_nameservers: [.

Read more →

MySQLTuner v1.3.0

It’s been three long years since the last MySQLTuner release but you’ll now find version 1.3.0 available on GitHub. You can get it from the git repository or via these extremely simple methods: wget -O mysqltuner.pl mysqltuner.pl wget –trust-server-names mysqltuner.pl There are a bunch of new features and fixes that you can find in the list of commits from today (2014-02-21). Some of the bigger adjustments include: Basic support for MariaDB 10.
Read more →

MySQLTuner mentioned at the O’Reilly MySQL Conference

If you push play, the video should scoot out to about the 14m40s mark where MySQLTuner appears on one of the slides. Thanks to Trent Hornibrook for letting me know!
Read more →

CPAN: Automatically install dependencies without confirmation

I enjoy using CPAN because it installs Perl modules with a simple interface, fetches dependencies, and warns you when things are about to end badly. However, one of my biggest complaints is when it constantly confirms installing dependencies. While this is an annoyance if you have to install a module with many dependencies (or if you’re working with CPAN on a new server), you can tell CPAN to automatically confirm the installation of dependencies.
Read more →

MySQLTuner 0.9.9 is now available

MySQLTuner 0.9.9 is now available for download. There’s a new wiki for the script at wiki.mysqltuner.com. The new wiki contains links to downloads, changelogs, and other details. If you want to know when the latest releases are available, there are multiple options: Follow RackerHacker on Twitter Sign up for the MySQLTuner mailing list Use the –checkversion option when you run the script
Read more →