From owner-freebsd-questions@FreeBSD.ORG Wed Jan 5 19:58:46 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 654571065673 for ; Wed, 5 Jan 2011 19:58:46 +0000 (UTC) (envelope-from odhiambo@gmail.com) Received: from mail-qy0-f175.google.com (mail-qy0-f175.google.com [209.85.216.175]) by mx1.freebsd.org (Postfix) with ESMTP id 153098FC0A for ; Wed, 5 Jan 2011 19:58:45 +0000 (UTC) Received: by qyk8 with SMTP id 8so15919337qyk.13 for ; Wed, 05 Jan 2011 11:58:45 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:mime-version:received:in-reply-to :references:from:date:message-id:subject:to:content-type; bh=8bylQ7UkAVKq8CzCYdH9O04Lxyb/psv7+kdp2WRFffE=; b=pRjQl8LBqNFUxPin1UO78arox35pqPUnPhOcFAfolnU567qGBRhmr8hqkZXD/YfrFM 7LrwMDiXte9jg7ClSKufT5i79tXWTWyLzrGOdfcQxGo3ARD4ZL36+7pmdCP91+hJrmLa lq50ajrThIdON8NLNDhQF7Q3/GK3cDXnhKjhg= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :content-type; b=X0LTqOZCf/mXUXZOr/xUkZB1rKB9kL+WCjn9KIGk/8U3F0wAa1WucToV8gqGLMO9Wu Y8QpwdtGlfdke+DVKhr19xZiQKFsW8tIWwb6aI2/fwuqd5kipPcBlSDGE1JsEcbi7qz8 /GCvwZj5VyTyg6ZpYtHYzpbLHP3oDsFp/a09Q= Received: by 10.229.230.198 with SMTP id jn6mr15622655qcb.61.1294257523409; Wed, 05 Jan 2011 11:58:43 -0800 (PST) MIME-Version: 1.0 Received: by 10.229.88.9 with HTTP; Wed, 5 Jan 2011 11:58:13 -0800 (PST) In-Reply-To: <20110105140935.43e918d8@scorpio> References: <20110105064956.22d5382f@scorpio> <20110105140935.43e918d8@scorpio> From: Odhiambo Washington Date: Wed, 5 Jan 2011 22:58:13 +0300 Message-ID: To: FreeBSD Content-Type: text/plain; charset=UTF-8 X-Content-Filtered-By: Mailman/MimeDel 2.1.5 Subject: Re: mysql-5.5.8 & Postfix/Dovecot X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 05 Jan 2011 19:58:46 -0000 On Wed, Jan 5, 2011 at 10:09 PM, Jerry wrote: > 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. > > 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!!