{"id":7062,"date":"2021-08-05T10:06:48","date_gmt":"2021-08-05T04:36:48","guid":{"rendered":"https:\/\/www.skynats.com\/?p=7062"},"modified":"2024-12-11T13:15:12","modified_gmt":"2024-12-11T07:45:12","slug":"how-to-fix-database-error-connection-failed","status":"publish","type":"post","link":"https:\/\/www.skynats.com\/blog\/how-to-fix-database-error-connection-failed\/","title":{"rendered":"How To Fix “Database Error Connection Failed” -Roundcube Cpanel"},"content":{"rendered":"\n

Roundcube is a free, open-source webmail software, and Cpanel currently uses it as the default webmail client. Some of our clients have encountered the “Database Error Connection Failed” issue in Roundcube. If you’re facing this error, here’s how to fix the “Database Error Connection Failed” – Roundcube Cpanel<\/a> and get your webmail working again.<\/p>\n\n\n\n

Causes of Roundcube “Database error connection failed” <\/h3>\n\n\n\n

Roundcube uses MySQL or SQLite as the database type and it stores all the details like email users, contacts, address books, etc.<\/p>\n\n\n\n

So it will need the proper connection to the database, if the connection between the database and this application is not working well it will show this database error connection failed.<\/p>\n\n\n\n

\"Database<\/figure>\n\n\n\n

This error can be caused mainly because of the below reasons :<\/p>\n\n\n\n

    \n
  1. Database server is not running :<\/li>\n<\/ol>\n\n\n\n

    When the Mysql server is down the Roundcube can’t connect to its database and it produces the database connection failed error.<\/p>\n\n\n\n

    2. A corrupted Roundcube database :<\/p>\n\n\n\n

    MySQL \/SQLite database with some missing data or tables with bugs can also cause this issue. In the Cpanel server, the details of all Cpanel domain’s emails are stored in a single Roundcube database and this also can make the database very huge. This also can cause a database connection failed error in Roundcube.<\/p>\n\n\n\n

    Solution :<\/strong><\/p>\n\n\n\n

      \n
    1. Check MySQL connection :<\/li>\n<\/ol>\n\n\n\n

      Check the MySQL database server status using the given command ;<\/p>\n\n\n\n

      service mysqld status<\/code><\/pre>\n\n\n\n
      If it is not running try to restart the MySQL service (You can also check the MySQL logs ).<\/p>\n\n\n\n
      2. Repair\/ Restore the Database :<\/p>\n\n\n\n
      First, we have to check the Roundcube database is accessible from the command line.<\/p>\n\n\n\n
      mysql -u roundcube -p\nmysql> show databases;<\/code><\/pre>\n\n\n\n
      Then you can check the tables in the Roundcube database using the below command ;<\/p>\n\n\n\n
      mysql > show tables;<\/code><\/pre>\n\n\n\n
      If all the tables are present there then you can repair the Roundcube database as below. (Take a backup for the database for safety)<\/p>\n\n\n\n
      mysqlcheck -r roundcube<\/code><\/pre>\n\n\n\n
      The Roundcube can be rebuild from the command line using this command. (You can do this if the database or table is missing and it will rebuild the Roundcube database)<\/p>\n\n\n\n
      \/usr\/local\/cpanel\/bin\/update-roundcube --force<\/code><\/pre>\n\n\n\n
      If you have the latest database backup available for Roundcube then you can restore the Roundcube database backup.<\/p>\n\n\n\n
      mysql roundcube < roundcube.sql<\/code><\/pre>\n\n\n\n
      You can then remove the existing Roundcube database after the restoration of the database from the latest backup (Take a backup of the existing Roundcube database for a safety measure).<\/p>\n\n\n\n
      Then you can drop the existing database using ;<\/p>\n\n\n\n
      mysql > drop database roundcube_old;<\/code><\/pre>\n\n\n\n
      3. Convert To SQLite Database type :<\/p>\n\n\n\n
      If you face this issue only with MySQL database then you can try to switch the Roundcube database to SQLite. <\/p>\n\n\n\n
      As of Cpanel 11.4.x, Roundcube only supports SQLite.<\/p>\n\n\n\n
      Pros for using SQLite for Roundcube : <\/p>\n\n\n\n