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)
----
Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.