iRedMail for Centos 5.7

I tried iRedMail today on a Centos 5.7 server. The installation seems to smooth if you keep the distro's main packages unchanged.

Namely I have had enabled the remi repo which upgrades php and mysql packages. When installing iRedMail the upgraded packages

of mysql gave some syntax errors on some .sql scripts. After some search I manually configured them afterwards. So now iRedMail seems working.

One must notice that iRedMail tried to install required packages dont checking if they are already installed or not. So this is problematic. But there are some

ways disabling this behaviour.

Here are the sql problems I got

ERROR 1064 (42000) at line 4 in file: '/usr/share/doc/policyd-1.82/DATABASE.mysql': You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 6 which is resolved by changing all occurences of TYPE with ENGINE in the script.

ERROR 1064 (42000) at line 17 in file: '/var/www/iRedAdmin-0.1.6/docs/samples/iredadmin.sql': You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(14) NOT NULL DEFAULT CURRENT_TIMESTAMP, which is resolved by deleting the number 14 at TIMESTAMP(14).

Because of those errors the user ireadadmin is not configured and I was getting internal server error at page www.domain.com/ireadadmin. The I found the password of iredadmin user at file /var/www/iredadmin/settings.ini and gave the grants.

Also I got some errors beforehand when initiating mysql server. I recognised that the lines

default-character-set   = utf8

skip-locking  at my.cnf  causing mysql die. So I commented them out and mysql began working.

What I learnt form this journey:

1- Keep the distro's packages unchanged if you want to use iRedMail.

2- Let iRedMail install those packages,ie. remove the packages which are pre-installed.