[Dovecot] dovecot+mysql login problem
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=AG1pcmNlYQBzdGVmYW4= Dec 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
participants (2)
-
Mircea Stefan
-
Timo Sirainen