Change MySQL 5.5 default character-set to UTF8

Last night cPanel upgraded the version of MySQL on one of our servers to the latest MySQL 5.5. Unfortunately this results in over 4000 emails from that server, crying that various websites couldn't connect to the MySQL database. The error found in /var/log/mysqld.log was

InnoDB: Error: log file ./ib_logfile0 is of different size 0 5242880 bytes
InnoDB: than specified in the .cnf file 0 26214400 bytes!
131218 23:06:21 [ERROR] Plugin 'InnoDB' init function returned error.
131218 23:06:21 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
131218 23:06:21 [ERROR] /usr/sbin/mysqld: unknown variable 'default-character-set=utf8'
131218 23:06:21 [ERROR] Aborting

Read more…

Installing Majordomo on a cPanel box with Exim

I've posted this how-to simply as a way to remember how I did this. For all those that want to use Majordomo mailing list app on a cPanel box, while running Exim, here is no frills tutorial. I've used this on several boxes over the last five years without issue. The setup allows you to manage individual lists by domain. Each of your accounts can have their own majordomo lists. There is no control panel for this setup, and all the editing takes place on the commend line. Hope someone finds it useful. 

Read more…

Ensure PEAR on cPanel is up-to-date

On one of my cpanel boxes, I kept getting Deprecated warnings from PHP stemming from PEAR Config.php, Register.php and HTTP_Upload.php. When I logged into the cpanel control panel, it shoed that PEAR…

Read more…