RoundCube : DATABASE ERROR: CONNECTION FAILED!

Astral God

Well-Known Member
Sep 27, 2010
180
0
66
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.
 

Astral God

Well-Known Member
Sep 27, 2010
180
0
66
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:
 
Last edited:

ElChefe

Registered
Mar 10, 2011
1
0
51
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
 

mike_

Member
Aug 22, 2011
6
2
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.