Category Archives: FreeBSD Administration

MySQL innodb buffer pool size issues

I’m currently archiving some database records from our AVS logging platform. My previous technique was to rename the logging table and create a new one, leaving the renamed table to be cut up as required.  I had to do it … Continue reading

Posted in FreeBSD Administration, MySQL | Tagged , , , , | Leave a comment

MIMEDefang – processing the valid users list ( filter_recipient() )

I’m rebuilding our spam scanning platform at the moment and making some changes/improvements along the way. One of our issues was that we want to show customers ‘just how bad it is’ without spam scanning and so would like to … Continue reading

Posted in FreeBSD Administration, MIMEDefang, MySQL, Perl | Tagged , , , , | Leave a comment

FreeBSD8.2 to FreeBSD9.0 upgrade – ssh key issue

Well in a desperate attempt to get ahead of the curve, I decided to update to FreeBSD 9.0 RELEASE before I put my new mailout servers into production. All has gone well except that on boot I get the following … Continue reading

Posted in FreeBSD Administration | Tagged , , | Leave a comment

OpenSSL Creating a CSR with Additional names

As part of the new bailout project here at Gconnect, I needed an SSL cert with an additional domain in it. the first is the name of the server, the second is the name of the cluster. In order to … Continue reading

Posted in FreeBSD Administration | Tagged , , , , | Leave a comment

FreeBSD & Carp – failover and load balancing

FreeBSD supports CARP (Common Address Redundancy Protocol) and has done for many years now. We’ve been using it here at Gconnect as part of our ‘Mailout’ system with no issues at all and it’s served use well since FreeBSD version … Continue reading

Posted in FreeBSD Administration | Tagged , , , | Leave a comment

Testing SMTP-AUTH from the command line

I’m building a new pair of ‘mail-relay’ servers for customers to mail out through. Customers can only use SMTP-AUTH to send mail, but i needed a method of testing the mechanism. Actually I’ll be using MySQL based usernames and passwords, … Continue reading

Posted in FreeBSD Administration, Perl | Tagged , , | Leave a comment

Resetting file permissions for WordPress

WordPress seems to be a minefield when it comes to file permissions. Sometimes we just want to start again and reset the files back to a nice safe setup. Here is my 3 liner to reset  directory permissions back to … Continue reading

Posted in Apache, FreeBSD Administration | Tagged , | Leave a comment

Sloppy File Handling – Perl

When reading around the subject of file handling in Perl its easy to get sloppy, phrases like ‘automatic cleanup’ and the like lull us into believing that the close statement is just a ‘nice to have’. Well this burnt me … Continue reading

Posted in FreeBSD Administration, MySQL, Perl | Tagged , , , | Leave a comment

Synchronising Nameservers (Bind + FreeBSD) with Perl

A funny thing happened to a colleague’s name servers the other day. Whilst very diligent in almost every respect when it comes to failover, redundancy, etc, etc he was bitten by a simple yet overlooked  issue. We all synchronise name … Continue reading

Posted in FreeBSD Administration, Perl | Tagged , , | Leave a comment

FreeBSD ZFS Deduplication

Time to prove or disprove the ZFS dedup capabilities. First its important to understand that as with compression, if we change the settings on the storage block then only new data written to that area will be de-duped or compressed. … Continue reading

Posted in FreeBSD Administration, ZFS | Tagged , , | Leave a comment