1 Topic by racedirector

  • racedirector
  • Member
  • Offline
  • Registered: 2010-12-29
  • Posts: 23

Topic: New install, Roundcube login failure

I have just completed a test install using my own version of MySQL, PHP & Apache to allow me to switch to nginx in the future. I followed the document on manually installing iRedmail and everything went well after a few tries.

Everything was installed and after restarting all the related services I tried logging into Roundcube and it continually gives me a login failure. I check with Postfix Admin and the user is there as it should be so I updated the password just incase but still get login failures for webmail

Can anyone suggest where I might look to sure this problem. I was hoping to install in my second sever to go live early next week but this has sort of stopped me in my tracks. Any suggestions welcome...

Cheers
Bruce

----

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,082

Re: New install, Roundcube login failure

Roundcube is configured to log into /var/log/maillog in iRedMail, please check it first.

3 Reply by racedirector

  • racedirector
  • Member
  • Offline
  • Registered: 2010-12-29
  • Posts: 23

Re: New install, Roundcube login failure

Ok checked and monitored maillog with tail -f. On attempting to login this gets logged:

Jan  7 01:24:38 svr1 roundcube: MDB2 Error: unknown error (-1): _execute: [Error message: Unable to execute statement] [Last executed query: DELETE FROM session WHERE sess_id=?] [Native code: 0] 
Jan  7 01:24:38 svr1 roundcube: [07-Jan-2011 01:24:38 +1100]: DB Error: MDB2 Error: unknown error Query: _execute: [Error message: Unable to execute statement] [Last executed query: DELETE FROM session WHERE sess_id=?] [Native code: 0]  in /var/www/roundcubemail-0.3.1/program/include/rcube_mdb2.php on line 627 (POST /webmail/?_task=&_action=login) 
Jan  7 01:24:38 svr1 roundcube: MDB2 Error: unknown error (-1): _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: 0] 
Jan  7 01:24:38 svr1 roundcube: [07-Jan-2011 01:24:38 +1100]: DB Error: MDB2 Error: unknown error 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: 0]  in /var/www/roundcubemail-0.3.1/program/include/rcube_mdb2.php on line 627 (POST /webmail/?_task=&_action=login) 
Jan  7 01:24:38 svr1 roundcube: [07-Jan-2011 01:24:38 +1100]: PHP Error: Failed to create new user in /var/www/roundcubemail-0.3.1/program/include/rcube_user.php on line 451 (POST /webmail/?_task=&_action=login) 
Jan  7 01:24:38 svr1 roundcube: [07-Jan-2011 01:24:38 +1100]: PHP Error: Failed to create a user record. Maybe aborted by a plugin? (POST /webmail/?_task=&_action=login) 
Jan  7 01:24:38 svr1 roundcube: MDB2 Error: unknown error (-1): _execute: [Error message: Unable to execute statement] [Last executed query: DELETE FROM session WHERE sess_id=?] [Native code: 0] 
Jan  7 01:24:38 svr1 roundcube: [07-Jan-2011 01:24:38 +1100]: DB Error: MDB2 Error: unknown error Query: _execute: [Error message: Unable to execute statement] [Last executed query: DELETE FROM session WHERE sess_id=?] [Native code: 0]  in /var/www/roundcubemail-0.3.1/program/include/rcube_mdb2.php on line 627 (POST /webmail/?_task=&_action=login) 
Jan  7 01:24:38 svr1 roundcube: MDB2 Error: unknown error (-1): _execute: [Error message: Unable to execute statement] [Last executed query: INSERT INTO session        (sess_id, vars, ip, created, changed)        VALUES (?, ?, ?, FROM_UNIXTIME(1294323878), FROM_UNIXTIME(1294323878))] [Native code: 0] 
Jan  7 01:24:38 svr1 roundcube: [07-Jan-2011 01:24:38 +1100]: DB Error: MDB2 Error: unknown error Query: _execute: [Error message: Unable to execute statement] [Last executed query: INSERT INTO session (sess_id, vars, ip, created, changed) VALUES (?, ?, ?, FROM_UNIXTIME(1294323878), FROM_UNIXTIME(1294323878))] [Native code: 0]  in /var/www/roundcubemail-0.3.1/program/include/rcube_mdb2.php on line 627 (POST /webmail/?_task=&_action=login)

Those question marks in the insert statement are a bit of a worry......

4 Reply by racedirector

  • racedirector
  • Member
  • Offline
  • Registered: 2010-12-29
  • Posts: 23

Re: New install, Roundcube login failure

Hmmmm, one more thing. In iRedmail.tips the entry for Webmail has no password, all others do - phpmyadmin, postfixadmin, awstats

    * Login account:
        - Username: www@xyz.com, password:

5 Reply by ZhangHuangbin

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

Re: New install, Roundcube login failure

Seems roundcube already let you log in. Did you change any setting in Roundcube? e.g. add new plugins, modify source files, etc.
Any change to MySQL database of roundcube? Does it exist?

6 Reply by racedirector

  • racedirector
  • Member
  • Offline
  • Registered: 2010-12-29
  • Posts: 23

Re: New install, Roundcube login failure

Nope, no changes aside from the install. roundcube DD exists but is totally empty

Post's attachments

Screen shot 2011-01-06 at 3.32.47 PM.png
Screen shot 2011-01-06 at 3.32.47 PM.png 57.88 kb, file has never been downloaded. 

You don't have the permssions to download the attachments of this post.

7 Reply by racedirector

  • racedirector
  • Member
  • Offline
  • Registered: 2010-12-29
  • Posts: 23

Re: New install, Roundcube login failure

Ok, cancel this one - I've given up. Please see my new thread for what I am trying to do....

Cheers