DATABASE ERROR: CONNECTION FAILED

Posted: 5p in Exim

Unable to login the Rouncube. Make sure the MySQL password is right

root@server[~]$ grep db_dsnw /usr/local/cpanel/base/3rdparty/roundcube/config/db.inc.php
$rcmail_config[‘db_dsnw’] = ‘mysql://roundcube:ASm_FJDYv2CGfEtH@localhost/roundcube’;

The password in this case is set in the config as: “ASm_FJDYv2CGfEtH”. See if the hash matches what is set for the user:

root@server[~]$ mysql
mysql> use mysql;
mysql> select PASSWORD(‘ASm_FJDYv2CGfEtH’);
mysql> select * from user where User = ’roundcube’;
mysql> update user set Password = PASSWORD(‘ASm_FJDYv2CGfEtH’) where User = ’roundcube’;

If the above didn’t fix it, try to update RoundCube (the right way)

root@server[~]$ mysqldump roundcube > /path/to/backup.sql
root@server[~$ /usr/local/cpanel/bin/update-roundcube –force
root@server[~]$ mysql roundcube < /path/to/backup.sql

If it is not working, please go through these steps

mysql -e “show table status” roundcube |grep -i innodb |awk ‘{print $1,$2}’
cache InnoDB
cache_index InnoDB
cache_messages InnoDB
cache_thread InnoDB
contactgroupmembers InnoDB
contactgroups InnoDB
contacts InnoDB
dictionary InnoDB
identities InnoDB
searches InnoDB
session InnoDB
users InnoDB

Somehow InnoDB had become corrupted and we resolved it by adding

innodb_force_recovery=6

to my.cnf and starting MySQL. Everything was working fine except Roundcube. Commenting out this line and restarting MySQL allowed Roundcube to begin working again.

Advertisements
Comments
  1. Bryan says:

    I have this problem in my server but unfortunately I got error with this command

    mysql> select PASSWORD(‘ASm_FJDYv2CGfEtH’);

    Please help how to get this done..

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s