[Dovecot] dovecot+mysql login problem

[Mircea Stefan]

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!