1 Topic by Bozra

  • Bozra
  • Member
  • Offline
  • Registered: 2011-07-22
  • Posts: 86

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 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,088

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 Reply by Bozra

  • Bozra
  • Member
  • Offline
  • Registered: 2011-07-22
  • Posts: 86

Re: One account cannot login to webmail

Dear Zhang,

i am using Red Hat 4.1.2

4 Reply by Bozra

  • Bozra
  • Member
  • Offline
  • Registered: 2011-07-22
  • Posts: 86

Re: One account cannot login to webmail

Dear Zhang,

i am using  Centos  4.1.2,iredmail with LDAP

5 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,088

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 Reply by Bozra

  • Bozra
  • Member
  • Offline
  • Registered: 2011-07-22
  • Posts: 86

Re: One account cannot login to webmail

sorry my mistake

it is  CentOS release 5.7 (Final)

7 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,088

Re: One account cannot login to webmail

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