1 (edited by bsdkom 2013-03-11 22:59:37)

Topic: Unable to login in roundcube

==== Required information ====
- iRedMail version:  iRedMail-0.8.3
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): mysql
- Linux/BSD distribution name and version: Ubuntu 12.04.2 LTS
- Related log if you're reporting an issue:
====
Hi All,
I need your help. I installed iredmail a few days ago. Everything was ok, but today i just updated ubunut and reboot system.
After that i cannot log in from web or any email clients. the message i got is login failed.
For several hours i'm trying to find an answer on web but no luck yet.


Mar 11 16:54:27 auth: Debug: client in: AUTH    1       PLAIN   service=imap    secured lip=127.0.0.1   rip=127.0.0.1   lport=143       rport=41653     resp=AGl0LWFkbWluQG1lZHVuaXYubHZpdi51YQB0b2VyNGV2ZXI=
Mar 11 16:54:27 auth-worker: Debug: sql(it-admin@website.com,127.0.0.1): query: SELECT password FROM mailbox WHERE username='it-admin@website.com' AND active='1'
Mar 11 16:54:27 auth: Debug: client out: OK     1       user=it-admin@website.com
Mar 11 16:54:27 auth: Debug: master in: REQUEST 459407361       15147   1       a2f40086e5299758031a4d26712dc7a7
Mar 11 16:54:27 auth-worker: Debug: sql(it-admin@website.com,127.0.0.1): SELECT CONCAT(mailbox.storagebasedirectory, '/', mailbox.storagenode, '/', mailbox.maildir) AS home, CONCAT('*:bytes=', mailbox.quota*1048576) AS quota_rule FROM mailbox,domain WHERE mailbox.username='it-admin@website.com' AND mailbox.domain='website.com' AND mailbox.`enableimapsecured`=1 AND mailbox.domain=domain.domain AND domain.backupmx=0 AND domain.active=1 AND mailbox.active=1
Mar 11 16:54:27 auth-worker: Info: sql(it-admin@website.com,127.0.0.1): Unknown user
Mar 11 16:54:27 auth: Error: userdb(it-admin@website.com,127.0.0.1): user not found from userdb sql
Mar 11 16:54:27 auth: Debug: master out: NOTFOUND       459407361
Mar 11 16:54:27 imap: Error: Authenticated user not found from userdb, auth lookup id=459407361 (client-pid=15147 client-id=1)

SQL command
mysql> USE vmail;
mysql> SELECT password FROM mailbox WHERE username='user@website.com' AND active='1';

return
+------------------------------------+
| password                           |
+------------------------------------+
| xxxxxxxxxxxxxxxxxxxxxx. |
+------------------------------------+
1 row in set (0.00 sec)

2

Re: Unable to login in roundcube

bsdkom wrote:

==== Required information ====
- iRedMail version:  iRedMail-0.8.3
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): mysql
- Linux/BSD distribution name and version: Ubuntu 12.04.2 LTS
- Related log if you're reporting an issue:
====
Hi All,
I need your help. I installed iredmail a few days ago. Everything was ok, but today i just updated ubunut and reboot system.
After that i cannot log in from web or any email clients. the message i got is login failed.
For several hours i'm trying to find an answer on web but no luck yet.


Mar 11 16:54:27 auth: Debug: client in: AUTH    1       PLAIN   service=imap    secured lip=127.0.0.1   rip=127.0.0.1   lport=143       rport=41653     resp=AGl0LWFkbWluQG1lZHVuaXYubHZpdi51YQB0b2VyNGV2ZXI=
Mar 11 16:54:27 auth-worker: Debug: sql(it-admin@website.com,127.0.0.1): query: SELECT password FROM mailbox WHERE username='it-admin@website.com' AND active='1'
Mar 11 16:54:27 auth: Debug: client out: OK     1       user=it-admin@website.com
Mar 11 16:54:27 auth: Debug: master in: REQUEST 459407361       15147   1       a2f40086e5299758031a4d26712dc7a7
Mar 11 16:54:27 auth-worker: Debug: sql(it-admin@website.com,127.0.0.1): SELECT CONCAT(mailbox.storagebasedirectory, '/', mailbox.storagenode, '/', mailbox.maildir) AS home, CONCAT('*:bytes=', mailbox.quota*1048576) AS quota_rule FROM mailbox,domain WHERE mailbox.username='it-admin@website.com' AND mailbox.domain='website.com' AND mailbox.`enableimapsecured`=1 AND mailbox.domain=domain.domain AND domain.backupmx=0 AND domain.active=1 AND mailbox.active=1
Mar 11 16:54:27 auth-worker: Info: sql(it-admin@website.com,127.0.0.1): Unknown user
Mar 11 16:54:27 auth: Error: userdb(it-admin@website.com,127.0.0.1): user not found from userdb sql
Mar 11 16:54:27 auth: Debug: master out: NOTFOUND       459407361
Mar 11 16:54:27 imap: Error: Authenticated user not found from userdb, auth lookup id=459407361 (client-pid=15147 client-id=1)

SQL command
mysql> USE vmail;
mysql> SELECT password FROM mailbox WHERE username='user@website.com' AND active='1';

return
+------------------------------------+
| password                           |
+------------------------------------+
| xxxxxxxxxxxxxxxxxxxxxx. |
+------------------------------------+
1 row in set (0.00 sec)

Sorry for inconvenience

I found where was the problem. The previous post helped me to investigate it. ( http://www.iredmail.org/forum/topic4017 … olved.html  )

The problem was that in table domain the field active = 0. I didn't understand how it happened.