From owner-freebsd-questions@FreeBSD.ORG Thu Oct 6 15:30:22 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 476B716A41F; Thu, 6 Oct 2005 15:30:22 +0000 (GMT) (envelope-from pgiessel@mac.com) Received: from smtpout.mac.com (smtpout.mac.com [17.250.248.71]) by mx1.FreeBSD.org (Postfix) with ESMTP id D49DC43D7E; Thu, 6 Oct 2005 15:30:21 +0000 (GMT) (envelope-from pgiessel@mac.com) Received: from mac.com (webmail19-en1 [10.13.10.174]) by smtpout.mac.com (Xserve/8.12.11/smtpout14/MantshX 4.0) with ESMTP id j96FUJMZ020567; Thu, 6 Oct 2005 08:30:19 -0700 (PDT) Received: from webmail19 (localhost [127.0.0.1]) by mac.com (Xserve/webmail19/MantshX 4.0) with ESMTP id j96FUJe6004429; Thu, 6 Oct 2005 08:30:19 -0700 (PDT) Message-ID: <11656766.1128612619606.JavaMail.pgiessel@mac.com> Date: Thu, 06 Oct 2005 07:30:19 -0800 From: Peter Giessel To: "Greg 'groggy' Lehey" in-reply-to: <20051006005819.GH45811@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> <2878468.1128527493019.JavaMail.pgiessel@mac.com> <20051006005819.GH45811@wantadilla.lemis.com> X-Originating-IP: 158.145.111.132/instID=275 Cc: Jared Kuolt , 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 15:30:22 -0000 On Thursday, October 06, 2005, at 07:22AM, Greg 'groggy' Lehey wrote: >> *** 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. Yes, it worked after the downgrade was complete, but the 051002 17:42:08 connection was the same day, the same time frame (21 seconds later). It worked from the command line, but not from Dovecot. >> *** 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? Yes. That is exactly what I'm saying. >It's not clear that there was anything wrong on the morning of 3 >October. Did you give up or continue? I deinstalled 4.1.14 later on the 2nd and started recompiling 4.0.26. I finished installing and fixing downgrade issues on the 3rd, at which time dovecot connected successfully. >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. I'm not saying anything is wrong with 4.1, I was just trying to point out that there *may* in some cases be compatibility issues with 4.1. It doesn't *always* play nice with others, as the OP claimed, and as you say, its probably a dovecot issue, but downgrading solved it nicely.