Postfix Cyrus Web cyradm HOWTO

3.8.4. Upgrading from 0.5.3 to 0.5.4

In version 0.5.4 there is a small database enhancement. You can upgrade your

database by issuing the MySQL script that comes with the distribution.

mysql mail  u mail  p < \

scripts/upgrade 0.5.3 to 0.5.4_mysql.sql

Since Version 0.5.3 web cyradm has full support for DES crypted passwords. You

can use the php script

migrate.php

to convert the users passwords from plain text

to unix compatible crypt (DES).

Migration from plain to crypt

cannot be undone

Be sure to have a recent backup of your database before

doing anything with the migration script.

4. Configuring MySQL

4.1. Securing MySQL

Because you are using MySQL to authenticate users, you need to restrict network

access to port 3306.

The easiest way is to only bind MySQL to the loopback interface 127.0.0.1. This

makes sure nobody can connect to your MySQL daemon via the network.

Edit

/etc/init.d/mysql.server

and change line 107 as following:

Original line:

$bindir/safe_mysqld   datadir=$datadir   pid file=$pid_file&

Changed line:

$bindir/safe_mysqld   datadir=$datadir   pid file=$pid_file \

  bind address=127.0.0.1&

Restart your MySQL daemon by issuing the command

/etc/init.d/mysql.server

start

21