Date: Wed, 05 Oct 2005 07:51:33 -0800 From: Peter Giessel <pgiessel@mac.com> To: "Greg 'groggy' Lehey" <grog@freebsd.org> Cc: Jared Kuolt <jkuolt@ipayone.com>, "Peter A. Giessel" <peter_giessel@dot.state.ak.us>, freebsd-questions@freebsd.org Subject: Re: Which MySQL version best to use and with/without linux threads? Message-ID: <2878468.1128527493019.JavaMail.pgiessel@mac.com> In-Reply-To: <20051005011853.GY67381@wantadilla.lemis.com> References: <0AF4AD10803F7A4FBA74930BBB1174029242DE@mail.ipayone.com> <43417A61.30005@dot.state.ak.us> <20051005011853.GY67381@wantadilla.lemis.com>
next in thread | previous in thread | raw e-mail | index | archive | help
On Wednesday, October 05, 2005, at 07:31AM, Greg 'groggy' Lehey <grog@FreeBSD.org> 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=<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.
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?2878468.1128527493019.JavaMail.pgiessel>