Database error: connection failed in roundcube

DATABASE ERROR: CONNECTION FAILED

Make sure the MySQL password of Roundcube is correct as follows:

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

The password in this case is set in the config as: "xyz". See if the hash matches what is set for the user:

root@server[~]$ mysql

mysql> use mysql;

mysql> select PASSWORD('xyz');

mysql> select * from user where User = 'roundcube';

mysql> update user set Password = PASSWORD('xyz') where User = 'roundcube';

If the above did not fix it, try to update. Update RoundCube.

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




The issue should be fixed now. :-)

Thank you.