[dapper] MySQL-update brakes postfix-mysql configuration

[Anders Wallenquist]

Upgrade from mysql-server-5.0.21-3ubuntu1 to 5.0.22-0ubuntu6.06.6 brakes a running configuration with postfix-mysql

mail.log:
Jan 3 11:06:01 ask postfix/trivial-rewrite[31284]: fatal: mysql:/etc/postfix/mysql-mydestinations.cf(0,lock|fold_fix): table lookup problem

syslog:
Jan 3 11:09:06 ask postfix/smtpd[21793]: warning: problem talking to service rewrite: Success
Jan 3 11:09:06 ask postfix/master[21769]: warning: process /usr/lib/postfix/trivial-rewrite pid 31612 exit status 1
Jan 3 11:09:06 ask postfix/master[21769]: warning: process /usr/lib/postfix/trivial-rewrite pid 31613 exit status 1
Jan 3 11:09:06 ask postfix/smtpd[21874]: warning: problem talking to service rewrite: Success
Jan 3 11:09:06 ask postfix/master[21769]: warning: process /usr/lib/postfix/trivial-rewrite pid 31615 exit status 1
Jan 3 11:09:06 ask postfix/smtpd[22777]: warning: problem talking to service rewrite: Success
Jan 3 11:09:06 ask postfix/smtpd[22432]: warning: problem talking to service rewrite: Success
Jan 3 11:09:06 ask postfix/smtpd[21938]: warning: problem talking to service rewrite: Success
Jan 3 11:09:06 ask postfix/master[21769]: warning: process /usr/lib/postfix/trivial-rewrite pid 31614 exit status 1
Jan 3 11:09:06 ask postfix/master[21769]: warning: process /usr/lib/postfix/trivial-rewrite pid 31616 exit status 1
Jan 3 11:09:06 ask postfix/master[21769]: warning: process /usr/lib/postfix/trivial-rewrite pid 31617 exit status 1
Jan 3 11:09:06 ask postfix/smtpd[22587]: warning: problem talking to service rewrite: Success

[Anders Wallenquist (aw)]

It seems to be the MySQL-update that brakes the chroot-environment that PostFix runs with.

A work-a-round is to do:

ln /var/run/mysql/mysql.sock /var/spool/postfix/run/mysql/mysql.sock

But this has to be done every time there is a change to /var/run/mysql/mysql.sock . This is a dangerous problem that happens on every running LTS-system and causes a lot of downtime and failsearch. Not what to be expected on a high profile LTS server system.

A reinstall of postfix or postfix-mysql may have eliminated the error also. I think this relation is something that package management would have found out and taken care of.

if ( mysql-server-package is changed ) {
   reinstall *-mysql-packages (reinstall all installed related packages, postfix-mysql in this case)
}

[Andreas Moog (ampelbein)]

Thank you for taking the time to report this bug and helping to make Ubuntu better. You reported this bug a while ago and there hasn't been any activity in it recently. We were wondering is this still an issue for you? Can you try with latest Ubuntu release? Thanks in advance.

[Andreas Moog (ampelbein)]

We are closing this bug report because it lacks the information we need to investigate the problem, as described in the previous comments. Please reopen it if you can give us the missing information, and don't hesitate to submit bug reports in the future. To reopen the bug report you can click on the current status, under the Status column, and change the Status back to "New". Thanks again!