Sunday, October 25, 2009

Worked on e-mail web interface at

Now looking at making exim get its info from mysql.

Needed to install an exim version with mysql driver:
apt-get install exim4-daemon-heavy
Did the above for cirrus as well.

This seems to be the way to test exim:
sudo exim4 -C /etc/exim4/exim4.conf.template-db -bv -d
Actually, the above didn't quite work, I think some other config file must also be included.

Had to reset replication for common database. Did this:

flush tables with read lock;
mysqldump --all-databases --master-data --port=3306 --ssl --ssl-ca=mysql-ca-cert.pem -p >dbdump.db
unlock tables;

mysql1 -p
Wrote a backup script for the common mysql database, script & backups in /var/backup/mysql, hourly crontab action installed.

No comments: