From owner-freebsd-questions@FreeBSD.ORG Wed Oct 5 15:51:36 2005 Return-Path: X-Original-To: freebsd-questions@freebsd.org Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 09E1B16A41F; Wed, 5 Oct 2005 15:51:36 +0000 (GMT) (envelope-from pgiessel@mac.com) Received: from smtpout.mac.com (smtpout.mac.com [17.250.248.47]) by mx1.FreeBSD.org (Postfix) with ESMTP id B109B43D45; Wed, 5 Oct 2005 15:51:35 +0000 (GMT) (envelope-from pgiessel@mac.com) Received: from mac.com (webmail07-en1 [10.13.11.149]) by smtpout.mac.com (Xserve/8.12.11/smtpout09/MantshX 4.0) with ESMTP id j95FpXRu020721; Wed, 5 Oct 2005 08:51:33 -0700 (PDT) Received: from webmail07 (localhost [127.0.0.1]) by mac.com (Xserve/webmail07/MantshX 4.0) with ESMTP id j95FpXfd008698; Wed, 5 Oct 2005 08:51:33 -0700 (PDT) Message-ID: <2878468.1128527493019.JavaMail.pgiessel@mac.com> Date: Wed, 05 Oct 2005 07:51:33 -0800 From: Peter Giessel To: "Greg 'groggy' Lehey" in-reply-to: <20051005011853.GY67381@wantadilla.lemis.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit references: <0AF4AD10803F7A4FBA74930BBB1174029242DE@mail.ipayone.com> <43417A61.30005@dot.state.ak.us> <20051005011853.GY67381@wantadilla.lemis.com> X-Originating-IP: 158.145.111.132/instID=96 Cc: Jared Kuolt , "Peter A. Giessel" , freebsd-questions@freebsd.org Subject: Re: Which MySQL version best to use and with/without linux threads? 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 Oct 2005 15:51:36 -0000 On Wednesday, October 05, 2005, at 07:31AM, Greg 'groggy' Lehey wrote: >On Monday, 3 October 2005 at 10:37:21 -0800, Peter A. Giessel wrote: >> On 10/3/2005 09:41, Jared Kuolt seems to have typed: >>> There really isn't any reason not to >>> anymore since everything is backwards compatible. >> >> I've found that Dovecot 1.0a3 has a problem with 4.1.x, > >Can you give more details? Sure, FreeBSD 4.11, I upgraded Dovecot to 1.0a3 from the ports collection using Portmanager (portmanager -u), fixed the configuration files (as they had changed from Dovecot 0.99), and Dovecot couldn't login to MySQL anymore. I turned on logging on MySQL and Dovecot: *** Dovecot Log *** dovecot: Oct 02 17:21:50 Error: auth-worker(default): mysql: Connect failed to localhost (aukebay): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) - waiting for 1 seconds before retry dovecot: Oct 02 17:24:34 Error: auth-worker(default): mysql: Connect failed to localhost (aukebay): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) - waiting for 5 seconds before retry dovecot: Oct 02 17:24:34 Error: auth-worker(default): sql(user,192.168.0.16): Password query failed: Not connected to database dovecot: Oct 02 17:41:41 Warning: Killed with signal 15 dovecot: Oct 02 17:41:47 Error: auth-worker(default): mysql: Connect failed to localhost (aukebay): Access denied for user 'abbc'@'localhost' (using password: YES) - waiting for 1 seconds before retry dovecot: Oct 02 17:43:13 Warning: Killed with signal 15 dovecot: Oct 02 17:43:19 Error: auth-worker(default): mysql: Connect failed to localhost (aukebay): Access denied for user 'abbc'@'localhost' (using password: YES) - waiting for 1 seconds before retry *** End Log Snipet *** *** dovecot_info log *** dovecot: Oct 02 17:21:48 Info: Dovecot v1.0.alpha3 starting up dovecot: Oct 02 17:24:47 Info: imap-login: Disconnected: user=, method=PLAIN, rip=192.168.0.16, lip=192.168.0.16, TLS dovecot: Oct 02 17:41:45 Info: Dovecot v1.0.alpha3 starting up dovecot: Oct 02 17:43:18 Info: Dovecot v1.0.alpha3 starting up dovecot: Oct 03 08:53:55 Info: Dovecot v1.0.alpha3 starting up dovecot: Oct 03 08:53:56 Info: auth-worker(default): mysql: Connected to localhost (aukebay) *** end dovecot_info Snipet *** *** MySQL Log 4.1.14 *** 051002 17:41:47 1 Connect Access denied for user 'abbc'@'localhost' (using password: YES) 051002 17:42:08 2 Connect abbc@localhost on 051002 17:42:10 2 Quit 051002 17:43:19 3 Connect Access denied for user 'abbc'@'localhost' (using password: YES) *** End Log Snipet *** *** MySQL Log after downgrading (4.0.26) *** 051003 8:53:56 5 Connect abbc@localhost on aukebay 051003 9:03:59 5 Quit *** End Log Snipet *** The 17:42:08 connection is when I: # mysql -u abbc -p logged in from the command line using the password in the dovecot config file. I didn't touch the dovecot config file after downgrading, and I used the same .sql file to populate the database with both version of MySQL, so the password was unchanged. If there are any details that you need that I'm leaving out that I can provide, please let me know.