MilesWeb Hosting Forum

Web Hosting Technical Support => Errors and Solutions => Topic started by: Dipak Bhoi on January 22, 2014, 12:21:59 AM

Title: Roundcube - DATABASE ERROR: CONNECTION FAILED!
Post by: Dipak Bhoi on January 22, 2014, 12:21:59 AM
Hello guys,

Today one of our client was facing an issue with roundcube as show in following image.

(https://www.milesweb.com/hosting-faqs/wp-content/uploads/2014/01/roundcuberror.jpg)

After investigating on this issue, I found that my.cnf is causing this issue

The roundcube database uses InnoDB tables in its database:

Quote
#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

This error is generating becasue, InnoDB had become corrupted and solved it by adding
innodb_force_recovery=6 to my.cnf and restarting MySQL service.

Quote
#vi /etc/my.cnf
[mysqld]
innodb_force_recovery=6
:wq
# /etc/init.d/mysql restart
Shutting down MySQL.........................               [  OK  ]
Starting MySQL.                                            [  OK  ]

I have commented this line and restart the MySQL and Roundcube being working again.

Quote
#vi /etc/my.cnf
[mysqld]
#innodb_force_recovery=6
:wq
# /etc/init.d/mysql restart
Shutting down MySQL.........................               [  OK  ]
Starting MySQL.                                            [  OK  ]

Enjoy !!!