1

Topic: One account cannot login to webmail

i have a problem with one user  cannot log in to the webmail -on the logs i get below errorrs

Duplicate entry 'abc@domain.com-127.0.0.1' for key 2]
Dec 13 12:06:48 pop roundcube: DB Error: MDB2 Error: constraint violation Query: _execute: [Error message: Unable to execute statement] [Last executed query: INSERT INTO users (created, last_login, username, mail_host, alias, language) VALUES (now(), now(), ?, ?, ?, ?)] [Native code: 1062] [Native message: Duplicate entry 'abc@domain.com-127.0.0.1' for key 2]  in /var/www/roundcubemail-0.5.3/program/include/rcube_mdb2.php on line 642 (POST /mail/?_task=login&_action=login)

How can this be solved?

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2

Re: One account cannot login to webmail

May i know which Linux/BSD distribution and release you're running?

I got same issue on openSUSE-12.1 final release, and got it fixed with below SQL command:

# mysql -uroot -p
mysql> USE roundcubemail;
mysql> ALTER TABLE session CHANGE sess_id sess_id VARCHAR(128) NOT NULL;                                                   

This is a bug in Roundcube. Reference: http://trac.roundcube.net/ticket/1488196

3

Re: One account cannot login to webmail

Dear Zhang,

i am using Red Hat 4.1.2

4

Re: One account cannot login to webmail

Dear Zhang,

i am using  Centos  4.1.2,iredmail with LDAP

5

Re: One account cannot login to webmail

iRedMail doesn't support Red Hat/CentOS 4.x, i'm afraid your version number is wrong. You can find it in file /etc/redhat-release.

6

Re: One account cannot login to webmail

sorry my mistake

it is  CentOS release 5.7 (Final)

7

Re: One account cannot login to webmail

There's a duplicate entry in MySQL table "roundcubemail.users". You may want to delete it first.