The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

A fatal error has occurred DB Error: connect failed.

Discussion in 'E-mail Discussions' started by p-root, Sep 21, 2010.

  1. p-root

    p-root Active Member

    Joined:
    Nov 1, 2008
    Messages:
    31
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    INDIA
    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.
     
  2. cPanelDon

    cPanelDon cPanel Quality Assurance Analyst
    Staff Member

    Joined:
    Nov 5, 2008
    Messages:
    2,557
    Likes Received:
    7
    Trophy Points:
    38
    Location:
    Houston, Texas, U.S.A.
    cPanel Access Level:
    DataCenter Provider
    Twitter:
    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:
    Code:
    # 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:
    Code:
    # 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:
    Code:
    # less /var/cpanel/horde/log/horde_0.log
    # less /var/cpanel/roundcube/log/errors
     
  3. p-root

    p-root Active Member

    Joined:
    Nov 1, 2008
    Messages:
    31
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    INDIA
    Hi,

    please check the below detials :-

    I received the find the following logs :-
    Code:
    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"]
    ~

    :-
    Code:
    [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)]
     
  4. cPanelDon

    cPanelDon cPanel Quality Assurance Analyst
    Staff Member

    Joined:
    Nov 5, 2008
    Messages:
    2,557
    Likes Received:
    7
    Trophy Points:
    38
    Location:
    Houston, Texas, U.S.A.
    cPanel Access Level:
    DataCenter Provider
    Twitter:
    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:
    Code:
    # /usr/local/cpanel/bin/update-horde --force
    # /usr/local/cpanel/bin/update-roundcube --force
     
Loading...

Share This Page