Postfix and lastest Debian/Testing Mysql 5 upgrade
Today I have upgraded my mail server.
As usual I did
#apt-get update #apt-get dist-upgrade
Always goes well but after some minutes I was in panic because my postfix server did not receive messages as usual.
There is some log messages:
Sep 24 06:44:14 localhost postfix/trivial-rewrite: fatal: mysql:/etc/postfix/mysql_virtual_alias_maps.cf(0,lock|fold_fix): table lookup problem Sep 24 06:44:14 localhost postfix/pickup: 1BE73105714: uid=106 from=<logcheck> Sep 24 06:44:14 localhost postfix/cleanup: warning: 1BE73105714: virtual_alias_maps map lookup problem for firstname.lastname@example.org
With last upgrade the mantainer of mysql package has removed `old_passwords` row.
There isn’t a postfix package upgrade, so due to recovery I have enabled old password.
Open your /etc/mysql/my.cnf and add this row
old_passwords = true
under `mysqld` section.
Good luck and see you soon!