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.

RoundCube : DATABASE ERROR: CONNECTION FAILED!

Discussion in 'E-mail Discussions' 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:
    16
    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:
    16
    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:
    1
    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:
    1
    Trophy Points:
    1
    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