I haven't been able to login to my mail server using MySQL authentication and I believe I've found the issue. My POP log says: dovecot: Jun 07 09:58:56 Error: auth(default): sql(dylan at domain.com,127.0.0.1): Password query must return a field named "password" dovecot: Jun 07 09:58:56 Info: pop3-login: Disconnected [127.0.0.1] The password field in MySQL is called "passwd". Am I to understand that there is no way around this? I must rename the field to "password"? My config files all check out. I'm pretty sure I'm at a road block here. Any help would be greatly appreciated. Also, aren't there anough Dovecot users to warrant a forum and/or IRC channel? I cant seem to find either (but thank you for the mailing list!). Thanks all for any help! Dylan
On Fri, 2005-06-24 at 14:04 -0700, Dylan Baxter wrote:> The password field in MySQL is called "passwd". Am I to understand that > there is no way around this? I must rename the field to "password"?Just use SELECT passwd AS password, .... WHERE ... as your SQL statement. johannes -------------- next part -------------- A non-text attachment was scrubbed... Name: signature.asc Type: application/pgp-signature Size: 832 bytes Desc: This is a digitally signed message part URL: <http://dovecot.org/pipermail/dovecot/attachments/20050624/f7c1d06e/attachment-0001.bin>
IRC channel: irc.freenode.net #dovecot Forum: forums are stupid ;-) On 6/24/05, Dylan Baxter <dylan_baxter at hotmail.com> wrote:> I haven't been able to login to my mail server using MySQL authentication > and I believe I've found the issue. > My POP log says: > dovecot: Jun 07 09:58:56 Error: auth(default): > sql(dylan at domain.com,127.0.0.1): Password query must return a field named > "password" > dovecot: Jun 07 09:58:56 Info: pop3-login: Disconnected [127.0.0.1] > > The password field in MySQL is called "passwd". Am I to understand that > there is no way around this? I must rename the field to "password"? > > My config files all check out. I'm pretty sure I'm at a road block here. Any > help would be greatly appreciated. Also, aren't there anough Dovecot users > to warrant a forum and/or IRC channel? I cant seem to find either (but thank > you for the mailing list!). > > Thanks all for any help! > Dylan > > >-- ________________________________________ To avoid being added to my spam filter: 1. Utilize list replies unless otherwise requested. 2. If you DO send me a personal email, use english. 3. HTML isn't cute. It belongs on the web, not in my inbox.