mysql-5.5.8 & Postfix/Dovecot

Odhiambo Washington odhiambo at
Wed Jan 5 12:38:10 UTC 2011

On Wed, Jan 5, 2011 at 2:49 PM, Jerry <freebsd.user at> wrote:

> I have seen it posted here and on the Dovecot forum that upgrading to
> mysql-5.5.8 on FreeBSD breaks both Postfix and Dovecot. Apparently
> reverting to the mysql-client-5.5.7 corrects this problem.
> Can any one else confirm this or is this simply an isolated incident?
> If this is correct, is there a PR filed against it? I was not able to
> locate one. Specifically, I am interested in the interaction on an
> FreeBSD-8.2 / amd64 system.
I haven't filed a case though. My system is 8.2-STABLE/i386.
I was running 5.5.7 with Request Tracker
(Devel)<>and all played nice until I
upgraded to 5.5.8. As this is a test platform, I
wanted to install the next devel version of RT when I encountered a problem
with initializing the database:
I get this error:

DBD::mysql::st execute failed: 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 'ENGINE=InnoDB  CHARACTER SET utf8' at line 15 at
/usr/home/wash/Tools/RT/RT-4/rt-4.0.0rc1/sbin/../lib/RT/ line 508.
*** Error code 255

My worry is so much about the character set error.

I also found my dovecot broken:

Jan 05 15:26:16 master: Error: service(auth): child 46112 returned error 1
Jan 05 15:26:16 master: Error: service(auth): command startup failed,
Jan 05 15:26:51 pop3-login: Error: Timeout waiting for handshake from auth
server. my pid=46111, input bytes=0
Jan 05 15:27:16 auth: Error: /libexec/
/usr/local/lib/ version libmysqlclient_16 required by
/usr/local/libexec/dovecot/auth not defined

Best regards,
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

More information about the freebsd-questions mailing list