Roundcube Error: New DA user-account, new emailaddress: Webmail login fail

BBM

Verified User
Joined
Jun 8, 2013
Messages
416
Location
Dutch Mountains
Made new user-account in DA: newdomain.com
Created new email-account: [email protected]

newdomain/webmail: enter login data -> Roundcube error: "Login fails"

IMAP login: works OK.
Other mailaccount from another user-account works fine in webmail.

/var/log/maillog:
Code:
Aug 28 12:01:02 server dovecot[20204]: auth-worker(29636): shadow([email protected],::1,<XEtLX81XMIAAAAAAAAAAAAAAAAAAAAAB>): unknown user
Aug 28 12:01:02 server dovecot[20204]: auth-worker(29636): passwd([email protected],::1,<XEtLX81XMIAAAAAAAAAAAAAAAAAAAAAB>): unknown user
Aug 28 12:01:02 server dovecot[20204]: imap-login: Login: user=<[email protected]>, method=PLAIN, rip=::1, lip=::1, mpid=29637, secured, session=<XEtLX81XMIAAAAAAAAAAAAAAAAAAAAAB>
Aug 28 12:01:02 server dovecot[20204]: imap([email protected]): Logged out in=29 out=502

Roundcube error-log:
Code:
[28-Aug-2017 11:44:50 +0200]: <b4fqkqom> PHP Error: Failed to create new user in /var/www/html/roundcubemail-1.3.0/progr
am/lib/Roundcube/rcube_user.php on line 686 (POST /webmail/?_task=login&_action=login)
[28-Aug-2017 11:44:50 +0200]: <b4fqkqom> PHP Error: Failed to create a user record. Maybe aborted by a plugin? in /var/w
ww/html/roundcubemail-1.3.0/program/include/rcmail.php on line 650 (POST /webmail/?_task=login&_action=login)
[28-Aug-2017 11:44:55 +0200]: <b4fqkqom> DB Error: [1364] Field 'alias' doesn't have a default value (SQL Query: INSERT 
INTO `users` (`created`, `last_login`, `username`, `mail_host`, `language`) VALUES (now(), now(), '[email protected]'
, 'localhost', 'en_US')) in /var/www/html/roundcubemail-1.3.0/program/lib/Roundcube/rcube_db.php on line 542 (POST /webm
ail/?_task=login&_action=login)
 
It is a late reply, however we had the same problem. The following worked for us and it seems like that this could be a result of a béta version of Roundcube (or possibly an old version).

1. Make a backup of the database.
2. Check if there is any data in the alias folder.
3. If not, it is safe to assume that it is not used. Drop the column or make it nullable.
4. Presto!
 
Back
Top