We have one particular user getting "Login Failed" when trying to login. It is reproduceable. We can see the user is successfully authenticating in our Dovecot IMAP logs, however, we see the following in the Roundcube errors log:
[27-Jan-2012 10:11:26] MDB2 Error: constraint violation (-3): _doQuery: [Error message: Could not execute statement]
[Last executed query: EXECUTE mdb2_statement_mysql_546da8936f0f40f0b75818b97958d58631f551734 USING @0, @1, @2, @3]
[Native code: 1062]
[Native message: Duplicate entry 'rwrgroup-mail.garlic.com' for key 2]
[27-Jan-2012 10:11:26 -0800]: DB Error: MDB2 Error: constraint violation Query: _doQuery: [Error message: Could not execute statement] [Last executed query: EXECUTE mdb2_statement_mysql_546da8936f0f40f0b75818b97958d58631f551734 USING @0, @1, @2, @3] [Native code: 1062] [Native message: Duplicate entry 'rwrgroup-mail.garlic.com' for key 2] in /usr/share/roundcubemail-0.5-rc/program/include/rcube_mdb2.php on line 650 (POST /roundcube/?_task=&_action=login)
[27-Jan-2012 10:11:26 -0800]: PHP Error: Failed to create new user in /usr/share/roundcubemail-0.5-rc/program/include/rcube_user.php on line 473 (POST /roundcube/?_task=&_action=login)
[27-Jan-2012 10:11:26 -0800]: PHP Error: Failed to create a user record. Maybe aborted by a plugin? in /usr/share/roundcubemail-0.5-rc/program/include/rcmail.php on line 747 (POST /roundcube/?_task=&_action=login)
Can someone please explain this error to me, and hopefully how to resolve this?
Thanks,
-Robert
