From owner-freebsd-questions@FreeBSD.ORG Wed Jan 5 12:38:10 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 6D921106566B; Wed, 5 Jan 2011 12:38:10 +0000 (UTC) (envelope-from odhiambo@gmail.com) Received: from mail-qw0-f54.google.com (mail-qw0-f54.google.com [209.85.216.54]) by mx1.freebsd.org (Postfix) with ESMTP id C93DD8FC12; Wed, 5 Jan 2011 12:38:09 +0000 (UTC) Received: by qwj9 with SMTP id 9so14984345qwj.13 for ; Wed, 05 Jan 2011 04:38:09 -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:cc:content-type; bh=3/J+Bn96olNWAT/a3Y09xhTmi51i+5dK9r3tbwwZPBM=; b=UebZ47XiqXQdqL+oEKBsFbxIAcvM1aMCPjZm5Gj2uR+Wxqw3QrgMC2E/oBRJlvzjeA +3RSLgl53p9obdHKLvn19h/ZPIi6uxJ1maCuy+e5ZnMguEb0GJKE6JHBd73g0W1TCaq3 6+57Oyo/kSZCNxRiN6Wm70vJGlP1OEaColpgA= 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 :cc:content-type; b=uFF/rQX3M8nhtcTqXK+DLgR4Bj6eI6FJ7R1aixFnIlXqxQrj80Ugtmi9xDSvs3kaUW c3rkBmPkF8fAg/ZkP3MVCFXQ8d4ejeKesmPsk1WsuSMGWrLHx7pBJ+MiuRuchX0NVXeS 0QDbI/rEMurEp3jk2TUMtsyHwtFBZ4Ccl4P9E= Received: by 10.229.95.81 with SMTP id c17mr19725993qcn.99.1294231089118; Wed, 05 Jan 2011 04:38:09 -0800 (PST) MIME-Version: 1.0 Received: by 10.229.88.9 with HTTP; Wed, 5 Jan 2011 04:37:38 -0800 (PST) In-Reply-To: <20110105064956.22d5382f@scorpio> References: <20110105064956.22d5382f@scorpio> From: Odhiambo Washington Date: Wed, 5 Jan 2011 15:37:38 +0300 Message-ID: To: FreeBSD Content-Type: text/plain; charset=UTF-8 X-Content-Filtered-By: Mailman/MimeDel 2.1.5 Cc: ale@freebsd.org 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 12:38:10 -0000 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 -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ Damn!!