MySQL Collation and Character Set

Importing databases from MySQL 3.2 to MySQL 5 - When I create a database using Plesk it creates it as utf8 (Character Set) and utf8_general_ci(Collation) but when I create a database using PhpMyAdmin the database is created as latin1 (Character Set) and... » More

Apache MaxRequestsPerChild 10000

We found that Apache 1.3 was periodically using up all the memory and swap space on a machine and stumbling on the post below we decided to reduce MaxRequestsPerChild from the apache conf advised value of 10000 for Solaris down to 100 or 500. Hopefully... » More

Plesk Horde Issues with Sending Mail

For future reference ...Had a few issues related to Horde sending mail. Although it appeared as though the mails were sent there was an issue with Horde using Sendmail.One proposed solution was to edit php.ini and amend the disable_functions line in... » More

PHP LDAP Search Root of Active Directory

Using PHP to query Active Directory resulted in a few problems e.g.Warning: ldap_search() : Search: Can't contact LDAP server in ... ldap_search(): Search: Operations errorWarning: ldap_search() : Search: Partial results and referral received The... » More

Prettifying Nagios

The default installation of Nagios is pretty ugly but can be tarted up with the Nuvola icons and some stylesheets from the following page:;d=1 Scroll down the page to the files section... » More

New iPod Nano Video on Ubuntu

Used the instructions at the following link: get the new iPod Nano Video working. Shame Apple can't be more open!Now to work out how to get videos working... » More

MySQL: mysql is not running but lock exists

A MySQL crash on Red Hat system resulted with:/etc/init.d/mysql statuscoming back with: mysql is not running but lock existsSolved by removing the lock file: rm /var/lock/subsys/mysql If this happens again it may also be necessary to remove the pid file... » More

Password-less SSH for Rsync from Solaris

This short article will demonstrate by example password-less ssh from a Solaris 8 box which will backup the contents of a linux box using rsync.In the example there are 2 users involved and 2 machines involved:User: bak2solaris Machine: mylinuxbox... » More

SpamAssassin: Overriding default scores

If desired the default scores for rules in spamassassin (located in /usr/share/spamassassin/ can be changed by setting the scores either in /etc/mail/spamassassin/ or another .cf file in the directory. For example, could... » More