RoundCube : DATABASE ERROR: CONNECTION FAILED!

[Astral God]

Hi.

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

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

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]

my.cnf is causing this issue.

With the default content:

local-infile = 0
innodb_file_per_table = 1

no problem.

With customized content:

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 ?

 

[ElChefe]

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_]

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.