MilesWeb
MilesWeb Hosting Forum

Please login or register.

Login with username, password and session length

 

News:

SMF - Just Installed!


Author Topic: Roundcube - DATABASE ERROR: CONNECTION FAILED!  (Read 4227 times)

0 Members and 1 Guest are viewing this topic.

Offline Dipak Bhoi

  • MilesWeb Team Member
  • Full Member
  • ***
  • Posts: 208
  • Karma: +5/-0
    • View Profile
    • MilesWeb Internet Services
Roundcube - DATABASE ERROR: CONNECTION FAILED!
« 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.



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 !!!
MilesWeb.com
cPanel Hosting in India - cPanel Hosting in India.

Grab an SSL for your website and SAVE 20% now. Coupon Code SSLSAVE20.

MilesWeb Hosting Forum

Roundcube - DATABASE ERROR: CONNECTION FAILED!
« on: January 22, 2014, 12:21:59 AM »