Date: Wed, 5 Jan 2011 22:58:13 +0300 From: Odhiambo Washington <odhiambo@gmail.com> To: FreeBSD <freebsd-questions@freebsd.org> Subject: Re: mysql-5.5.8 & Postfix/Dovecot Message-ID: <AANLkTi=%2BomXazzjjGfEn8iX0hoRX10DyT-zTatLDHBkZ@mail.gmail.com> In-Reply-To: <20110105140935.43e918d8@scorpio> References: <20110105064956.22d5382f@scorpio> <AANLkTik9zieGFgCfUZJ5VnH_H1LVHRVmhL0LRToeqeLn@mail.gmail.com> <20110105140935.43e918d8@scorpio>
next in thread | previous in thread | raw e-mail | index | archive | help
On Wed, Jan 5, 2011 at 10:09 PM, Jerry <freebsd.user@seibercom.net> wrote: > On Wed, 5 Jan 2011 15:37:38 +0300 > Odhiambo Washington <odhiambo@gmail.com> articulated: > > > On Wed, Jan 5, 2011 at 2:49 PM, Jerry <freebsd.user@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 > > I wonder if this is a Dovecot error or a problem with the MySQL > upgrade. Did you try asking Timo regarding the Dovecot problem? In any > case, it might be worth it to file a PR against both Dovecot and MySQL. > Nothing will probably get done until one is filed. > > Such minor breakages (like Dovecot experienced) don't worry me much sometimes. I simply recompile and life continues. When I upgrade a port I always expect (as a matter of principle) that something might go wrong and I go looking for it. However, the breakage with RT is one that has left me so worried - that character set issue, since it manifests itself on the main system, and only with 5.5.8 and not 5.5.7! -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ Damn!!
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?AANLkTi=%2BomXazzjjGfEn8iX0hoRX10DyT-zTatLDHBkZ>