Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

RoundCube : DATABASE ERROR: CONNECTION FAILED!

Discussion in 'E-mail Discussion' started by Astral God, Aug 30, 2012.

  1. Astral God

    Astral God Well-Known Member

    Joined:
    Sep 27, 2010
    Messages:
    180
    Likes Received:
    0
    Trophy Points:
    66
    Location:
    127.0.0.1
    cPanel Access Level:
    Root Administrator
    Hi.

    Since this morning, users can't connect to their Webmail:

    When they click on RoundCube (the only webmail available), they get this:

    Code:
    DATABASE ERROR: CONNECTION FAILED!
    
    Unable to connect to the database!
    Please contact your server-administrator.
    
    All the websites are working fine, cPanel and WHM too, and under Service Status, all services are UP.

    Thanks.
     
  2. Astral God

    Astral God Well-Known Member

    Joined:
    Sep 27, 2010
    Messages:
    180
    Likes Received:
    0
    Trophy Points:
    66
    Location:
    127.0.0.1
    cPanel Access Level:
    Root Administrator
    my.cnf is causing this issue.

    With the default content:

    Code:
    local-infile = 0
    innodb_file_per_table = 1
    
    no problem.

    With customized content:

    Code:
    skip-networking
    skip-innodb
    slow_query_log
    safe-show-database
    local-infile = 0
    innodb_file_per_table = 1
    thread_cache_size = 4
    
    we have the issue above, and the line is skip-innodb

    Is InnoDB a condition to have RoundCube functioning ? :confused:
     
    #2 Astral God, Aug 30, 2012
    Last edited: Aug 30, 2012
  3. ElChefe

    ElChefe Registered

    Joined:
    Mar 10, 2011
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    51
    Location:
    Austin, Texas, United States
    The roundcube database uses InnoDB tables in its database:

    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
     
  4. mike_

    mike_ Member

    Joined:
    Aug 22, 2011
    Messages:
    6
    Likes Received:
    2
    Trophy Points:
    53
    Found this thread via Google as we were having a similar issue. Roundcube would either get stuck in a redirect loop or fail with "DATABASE ERROR: CONNECTION FAILED".

    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.
     
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice