Skip site navigation (1)Skip section navigation (2)
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>