Login problem for one account only

[edwardo]

I use RoundCube for multiple accounts, but I'm having a problem logging in with one account.
I forgot the password, so updated it in the mysql db:
update mailuser set crypt=ENCRYPT('password') where clear='user';

The courier IMAP daemon uses the same table, and it accepts the username/password when I test it using telnet (see below), but RoundCube reports a login error

the errorlog states:
[24-Oct-2007 00:50:59 +0100] IMAP Error: Authentication for user@domain_name failed (LOGIN): "a001 NO Login failed." in on line 0

Your assistance is appreciated!


IMAP test:

mail-server:~# telnet localhost 143
Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.
* OK [CAPABILITY IMAP4rev1 UIDPLUS CHILDREN NAMESPACE THREAD=ORDEREDSUBJECT THREAD=REFERENCES SORT QUOTA IDLE ACL ACL2=UNION STARTTLS]
Courier-IMAP ready. Copyright 1998-2005 Double Precision, Inc. See COPYING for distribution information.

01 LOGIN user@domain_name password
01 OK LOGIN Ok.

02 LIST "" *
* LIST (\Marked \HasNoChildren) "." "INBOX"
02 OK LIST completed

03 SELECT INBOX
* FLAGS (\Draft \Answered \Flagged \Deleted \Seen \Recent)
* OK [PERMANENTFLAGS (\* \Draft \Answered \Flagged \Deleted \Seen)] Limited
* 41 EXISTS
* 41 RECENT
* OK [UIDVALIDITY 1193151914] Ok
* OK [MYRIGHTS "acdilrsw"] ACL
03 OK [READ-WRITE] Ok

04 STATUS INBOX (MESSAGES)
* STATUS "INBOX" (MESSAGES 41)
04 OK STATUS Completed.

[edwardo]

more info:

My mail log /var/log/mail.info shows that when I attmept to login via RoundCube, it considers the login successful:

Oct 24 22:47:01 myserver imapd: LOGIN, user=user@domain_name, ip=[::ffff:192.168.1.2], protocol=IMAP
Oct 24 22:47:01 myserver imapd: LOGOUT, user=user@domain_name, ip=[::ffff:192.168.1.2], headers=0, body=0, rcvd=25, sent=180, time=0

Unfortunately, RoundCube doesn't agree!

[edwardo]

I had created this user but had never logged in. I changed the password and wasn't able to login via RoudCube, but was via other IMAP clients.

This was because $rcmail_config['auto_create_user'] was set to FALSE

I changed it to TRUE and was able to log in