mysql-5.5.8 & Postfix/Dovecot

[Odhiambo Washington]

On Wed, Jan 5, 2011 at 2:49 PM, Jerry <freebsd.user at seibercom.net> 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)<http://bestpractical.com/rt>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:

<cut>
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/Handle.pm line 508.
*** Error code 255
</cut>

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,
throttling
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/ld-elf.so.1:
/usr/local/lib/libmysqlclient.so.16: version libmysqlclient_16 required by
/usr/local/libexec/dovecot/auth not defined



-- 
Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
+254733744121/+254722743223
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
Damn!!