From owner-freebsd-questions@FreeBSD.ORG Thu Oct 6 00:58:21 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 AA0F516A41F for ; Thu, 6 Oct 2005 00:58:21 +0000 (GMT) (envelope-from grog@lemis.com) Received: from ext-gw.lemis.com (ext-gw.lemis.com [150.101.14.10]) by mx1.FreeBSD.org (Postfix) with ESMTP id EB2CE43D49 for ; Thu, 6 Oct 2005 00:58:20 +0000 (GMT) (envelope-from grog@lemis.com) Received: from wantadilla.lemis.com (wantadilla.lemis.com [192.109.197.135]) by ext-gw.lemis.com (Postfix) with ESMTP id BC3CA1310CC; Thu, 6 Oct 2005 10:28:19 +0930 (CST) Received: by wantadilla.lemis.com (Postfix, from userid 1004) id 9831C8521B; Thu, 6 Oct 2005 10:28:19 +0930 (CST) Date: Thu, 6 Oct 2005 10:28:19 +0930 From: Greg 'groggy' Lehey To: Peter Giessel Message-ID: <20051006005819.GH45811@wantadilla.lemis.com> References: <0AF4AD10803F7A4FBA74930BBB1174029242DE@mail.ipayone.com> <43417A61.30005@dot.state.ak.us> <20051005011853.GY67381@wantadilla.lemis.com> <2878468.1128527493019.JavaMail.pgiessel@mac.com> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="54ZiyWcDhi/7bWb8" Content-Disposition: inline In-Reply-To: <2878468.1128527493019.JavaMail.pgiessel@mac.com> User-Agent: Mutt/1.4.2.1i Organization: The FreeBSD Project Phone: +61-8-8388-8286 Fax: +61-8-8388-8725 Mobile: +61-418-838-708 WWW-Home-Page: http://www.FreeBSD.org/ X-PGP-Fingerprint: 9A1B 8202 BCCE B846 F92F 09AC 22E6 F290 507A 4223 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: Thu, 06 Oct 2005 00:58:21 -0000 --54ZiyWcDhi/7bWb8 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Wednesday, 5 October 2005 at 7:51:33 -0800, Peter Giessel wrote: > 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 This looks like the server wasn't running. > 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 And this is a second attempt. The MySQL users haven't been set up correctly. > *** End Log Snipet *** > > *** dovecot_info log *** > .... > dovecot: Oct 03 08:53:56 Info: auth-worker(default): mysql: Connected to localhost (aukebay) > *** end dovecot_info Snipet *** This is an entirely different time frame, of course. > *** MySQL Log 4.1.14 *** > 051002 17:41:47 1 Connect Access denied for user 'abbc'@'localhost' (using password: YES) This is the same authentication problem seen from the other side. > 051002 17:42:08 2 Connect abbc@localhost on And this > *** End Log Snipet *** > > *** MySQL Log after downgrading (4.0.26) *** > 051003 8:53:56 5 Connect abbc@localhost on aukebay And this is the next day. It looks as if it worked. > *** 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. So you're saying that the authentication problem was despite proven good user name and password? > If there are any details that you need that I'm leaving out that I > can provide, please let me know. It's not clear that there was anything wrong on the morning of 3 October. Did you give up or continue? There have been some changes to authentication (in particular, password hashing) between 4.0 and 4.1. It's possible that you need to do something to your Dovecot configuration, but unfortunately I don't know Dovecot at all. Greg -- See complete headers for address and phone numbers. --54ZiyWcDhi/7bWb8 Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.1 (FreeBSD) iD8DBQFDRHarIubykFB6QiMRAqZ3AJ9opVyCtq5JVq9w4rP3s7eLEPxujACcDjpv KCuxwyDaLuPc1ixptFxkidU= =bIBh -----END PGP SIGNATURE----- --54ZiyWcDhi/7bWb8--