A fatal error has occurred DB Error: connect failed.

[p-root]

HI,

I have Linux Server with WHM/Cpanel and mysql on another remote server,now every thing is working fine,but whenever i tried to access webmail through "horde" & "roundcube",both webmail client throws error :-

horde :-

A fatal error has occurred
DB Error: connect failed
Details have been logged for the administrator.

Roundcube :-

DATABASE ERROR: CONNECTION FAILED!

Unable to connect to the database!
Please contact your server-administrator.

Thanks.

[cPanelDon]

HI,

I have Linux Server with WHM/Cpanel and mysql on another remote server,now every thing is working fine,but whenever i tried to access webmail through "horde" & "roundcube",both webmail client throws error :-

horde :-

A fatal error has occurred
DB Error: connect failed
Details have been logged for the administrator.

Roundcube :-

DATABASE ERROR: CONNECTION FAILED!

Unable to connect to the database!
Please contact your server-administrator.

Thanks.

So that we may more accurately assess and diagnose the issue, please check the Horde and Roundcube log files to obtain more specific information; inspecting the log files should reveal detail that may expose a more precise cause.

The log files for Horde may be found in the directory at "/var/cpanel/horde/log/"; here is an example command that may be used via root SSH access to list any Horde log files that may exist:

# find /var/cpanel/horde/log -type f

The log files for Roundcube, if using MySQL, may be found in the directory at "/var/cpanel/roundcube/log/"; here is an example command that may be used via root SSH access to list any Roundcube log files that may exist:

# find /var/cpanel/roundcube/log -type f

The log files may be opened using any text viewer or editor (in read-only mode). The following example commands use "less" to open each log file; to view the latest log entries simply scroll to the end of the file using the key combination Shift+G:

# less /var/cpanel/horde/log/horde_0.log
# less /var/cpanel/roundcube/log/errors

[p-root]

Hi,

please check the below detials :-

I received the find the following logs :-

Sep 22 14:21:09 HORDE [emergency] [horde] DB Error: connect failed:  [nativecode=Access denied for user 'horde'@'hostname.com' (using password: YES)] ** mysql(mysql)://horde:PASSWORD@tcp+hostname.com/horde?persistent=&charset=iso-8859-1&driverconfig=horde&group=horde.perms&table=horde_datatree&table_attributes=horde_datatree_attributes [on line 1637 of "/usr/local/cpanel/base/horde/lib/Horde/DataTree/sql.php"]

~

:-

[22-Sep-2010 12:39:25 +0530]: DB Error: _doConnect: [Error message: Access denied for user 'roundcube'@'hostname.com' (using password: YES)]
[Native code: 1045]
[Native message: Access denied for user 'roundcube'@'hostname.com' (using password: YES)]
 ** mysql(mysql)://roundcube:xxx@hostname.com/roundcube in /usr/local/cpanel/base/3rdparty/roundcube/program/include/rcube_mdb2.php on line 100 (GET /3rdparty/roundcube/index.php)
[22-Sep-2010 12:39:41] MDB2 Error: connect failed (-24): _doConnect: [Error message: Access denied for user 'roundcube'@'hostname.com' (using password: YES)]

[cPanelDon]

Hi,

please check the below detials :-

I received the find the following logs :-

Sep 22 14:21:09 HORDE [emergency] [horde] DB Error: connect failed:  [nativecode=Access denied for user 'horde'@'hostname.com' (using password: YES)] ** mysql(mysql)://horde:PASSWORD@tcp+hostname.com/horde?persistent=&charset=iso-8859-1&driverconfig=horde&group=horde.perms&table=horde_datatree&table_attributes=horde_datatree_attributes [on line 1637 of "/usr/local/cpanel/base/horde/lib/Horde/DataTree/sql.php"]

~

:-

[22-Sep-2010 12:39:25 +0530]: DB Error: _doConnect: [Error message: Access denied for user 'roundcube'@'hostname.com' (using password: YES)]
[Native code: 1045]
[Native message: Access denied for user 'roundcube'@'hostname.com' (using password: YES)]
 ** mysql(mysql)://roundcube:xxx@hostname.com/roundcube in /usr/local/cpanel/base/3rdparty/roundcube/program/include/rcube_mdb2.php on line 100 (GET /3rdparty/roundcube/index.php)
[22-Sep-2010 12:39:41] MDB2 Error: connect failed (-24): _doConnect: [Error message: Access denied for user 'roundcube'@'hostname.com' (using password: YES)]

What method was used to copy the existing MySQL databases, MySQL users, and any MySQL user privileges, to the remote MySQL server?

Please ensure that all MySQL data is copied or moved to the remote MySQL server; this task must be completed in order to successfully utilize the remote MySQL server on a system that contains existing data in the local MySQL installation.

If MySQL data has been properly copied or moved but the difficulty persists, please save fresh backups of all existing MySQL data and then try forcefully re-installing both Horde and Roundcube.

Via root SSH access, the following commands may be used to perform a forced update (i.e., re-install) of both Horde and Roundcube:

# /usr/local/cpanel/bin/update-horde --force
# /usr/local/cpanel/bin/update-roundcube --force