From owner-freebsd-questions@FreeBSD.ORG Wed Jan 5 19:09:41 2011 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 7ACB5106566B for ; Wed, 5 Jan 2011 19:09:41 +0000 (UTC) (envelope-from freebsd.user@seibercom.net) Received: from mail-yi0-f54.google.com (mail-yi0-f54.google.com [209.85.218.54]) by mx1.freebsd.org (Postfix) with ESMTP id 2BFE38FC08 for ; Wed, 5 Jan 2011 19:09:40 +0000 (UTC) Received: by yie19 with SMTP id 19so4286118yie.13 for ; Wed, 05 Jan 2011 11:09:40 -0800 (PST) Received: by 10.150.198.11 with SMTP id v11mr22808834ybf.77.1294254579290; Wed, 05 Jan 2011 11:09:39 -0800 (PST) Received: from scorpio.seibercom.net (cpe-071-070-216-068.nc.res.rr.com [71.70.216.68]) by mx.google.com with ESMTPS id v8sm11633543yba.14.2011.01.05.11.09.37 (version=TLSv1/SSLv3 cipher=RC4-MD5); Wed, 05 Jan 2011 11:09:38 -0800 (PST) Received: from scorpio (zeus [192.168.1.1]) (using TLSv1 with cipher DHE-RSA-AES128-SHA (128/128 bits)) (No client certificate requested) (Authenticated sender: FreeBSD.user@scorpio.seibercom.net) by scorpio.seibercom.net (Postfix) with ESMTPSA id D03C2E5485F for ; Wed, 5 Jan 2011 14:09:36 -0500 (EST) Date: Wed, 5 Jan 2011 14:09:35 -0500 From: Jerry To: FreeBSD Message-ID: <20110105140935.43e918d8@scorpio> In-Reply-To: References: <20110105064956.22d5382f@scorpio> Organization: seibercom.net X-Mailer: Claws Mail 3.7.8 (GTK+ 2.22.1; amd64-portbld-freebsd8.2) Face: iVBORw0KGgoAAAANSUhEUgAAADAAAAAwBAMAAAClLOS0AAAAJFBMVEUeH4oAAI3//v8LDHmw s8gyNZ/b3ej7+vn+/v////+PjIc8Plaj/TnQAAACNElEQVQ4jaXUvW/aQBQAcFtKGZLFT+YY 3D1SR9SKoRMncE3IggU4kicGi1JYOgQwyYrgnLlSzhsoNkTuVJEp+ef6ztiAoV3aJ+QPfufn s987S/5fQvoXYPjztmfc514Ks+5JfGUCfrzt4+VabF+jwEV4DGEXN8N4p16sPLxHX07/V3qX yfF5D2H6K4V8j9NkyAphvkjBembD5PDFk3zeTzP1jcksyaV9w+d4ELmUoOp8N2p8uQVyhTAT uawnKNH2mie5lJp48mscUcbJUvg0mR6APwAoye9AMyWozY4gAh0vcxa5FJ4TKCuODESWtfkB 8AEQSupUXNIYH8FSC2w8X3eMBNbbVJpJ7MgECO5yJ9DUEWCYkzNAlsRsgwLQ1GkWqELbkDOh 1bUzoHagYkNh9MXlK/MQoA42gTxz2bhPM2DJedm8MZx6cNfJgEZJ5cmwPp5FZ/Ye8O2qTrFV dgOrHkZRBoheJiGrRquwAhnQ6GeTePPerWVmQelAQ5lwNqtvQd2lcooAV74/zR1BIRS19fy5 ru+B/8ReW9pYKMPjt609zDaitHHTGOO+Zu7gHvsKE7XbeE1QVuJXomIFuZgUJdXQdhpqEELc /e8RLjfi+cQ01yMdWot8UcCVxEWHEkcUrsDGuhaIEoM9kfgAR6jxHcmEV7tNURAl8KTHN9iF McKGFHGO62O62UMpbmlVuogQ7ndL8zXCiLeBy3xpfrqaXS/+AHDG4o8AvhuPeezD/3xL/hy/ Adjlg2odglF2AAAAAElFTkSuQmCC Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit Subject: Re: mysql-5.5.8 & Postfix/Dovecot X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list Reply-To: FreeBSD List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 05 Jan 2011 19:09:41 -0000 On Wed, 5 Jan 2011 15:37:38 +0300 Odhiambo Washington articulated: > On Wed, Jan 5, 2011 at 2:49 PM, Jerry > 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/Handle.pm > 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, 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. -- Jerry ✌ FreeBSD.user@seibercom.net Disclaimer: off-list followups get on-list replies or get ignored. Please do not ignore the Reply-To header. __________________________________________________________________ And that's the way it is... Walter Cronkite