Hi, This is my MySQL table: <snip> mysql> select username, password from mailbox; +----------+----------+ | username | password | +----------+----------+ | mircea | stefan | +----------+----------+ 1 row in set (0.00 sec) </snip> When I try to login (pop3) I recive "-ERR Authentication failed." <snip> +OK Dovecot ready. user mircea +OK pass stefan -ERR Authentication failed. </snip> maillog: <snip> Dec 27 20:54:38 pluto dovecot: auth-worker(default): sql(mircea,10.13.15.2): query: SELECT password FROM mailbox WHERE username = 'mircea' Dec 27 20:54:38 pluto dovecot: auth(default): client in: AUTH^I1^IPLAIN^Iservice=POP3^Ilip=10.13.15.1^Irip=10.13.15.2^Iresp=AG1pcmNlYQBzdGVmYW4Dec 27 20:54:39 pluto dovecot: auth(default): client out: FAIL^I1^Iuser=mircea </snip> I started a mysql client and ran: <snip> mysql> SELECT password FROM mailbox WHERE username = 'mircea'; +----------+ | password | +----------+ | stefan | +----------+ 1 row in set (0.00 sec) </snip> What's the problem? Thank you and Happy Holidays!
On Tue, 2005-12-27 at 21:01 +0200, Mircea Stefan wrote:> Hi, > > This is my MySQL table: > > <snip> > mysql> select username, password from mailbox; > +----------+----------+ > | username | password | > +----------+----------+ > | mircea | stefan | > +----------+----------+ > 1 row in set (0.00 sec) > </snip> > > When I try to login (pop3) I recive "-ERR Authentication failed."in dovecot-sql.conf, set: default_pass_scheme = PLAIN -------------- next part -------------- A non-text attachment was scrubbed... Name: not available Type: application/pgp-signature Size: 189 bytes Desc: This is a digitally signed message part Url : http://dovecot.org/pipermail/dovecot/attachments/20051230/09ad43a9/attachment.pgp