Hello,
Receiving error while trying to access the Roundcube in cPanel server.
DATABASE ERROR: CONNECTION FAILED!
Unable to connect to the database!e
Please contact your server-administrator.
Can anyone please help me out?
Roundcube Database Error cPanel
Moderator: Staff
cPanel Server Management
@ 30$ Onwards
@ 30$ Onwards
Re: Roundcube Database Error cPanel
Hi Jackk,
It seems like you are having issue with mysql. Please check that your MySQL is running or not.
# /etc/init.d/mysql status
OR
# service mysql status
If it is not running restart the service by below command and see if the Roundcube is accessible.
# /etc/init.d/mysql start
OR
# service mysql start
It seems like you are having issue with mysql. Please check that your MySQL is running or not.
# /etc/init.d/mysql status
OR
# service mysql status
If it is not running restart the service by below command and see if the Roundcube is accessible.
# /etc/init.d/mysql start
OR
# service mysql start
Re: Roundcube Database Error cPanel
Hi Tommy,
I have checked the status of MySQL and found it is working fine. I have also restarted service to see if that fix the issue, but unfortunately, it doesn't.
# service mysql restart
Please help?
I have checked the status of MySQL and found it is working fine. I have also restarted service to see if that fix the issue, but unfortunately, it doesn't.
# service mysql restart
Please help?
Re: Roundcube Database Error cPanel
Hi Jackk,
In most of the cases, "DATABASE ERROR: CONNECTION FAILED!" error occurs when the MySQL is down or having issues with MySQL.
Since you have checked and restarted MySQL based on Tommy's advice and the issue keeps existing, this can be of something else.
Follow below checks to ensure everything is working fine:
1. Check the database connectivity from the command line
For this, you require Roundcube password. Execute the below command to know the Roundcube password.
Command:
# grep -i "db_dsnw" /usr/local/cpanel/base/3rdparty/roundcube/config/config.inc.php
Output :
$config['db_dsnw'] = 'mysql://roundcube:vbtPXwX#&&@aS7L@unix(/var/lib/mysql/mysql.sock)/roundcube';
From the output, we get know that the password is "vbtPXwX#&&@aS7L"
Now check the database connectivity using below command
# mysql -u roundcube -p
You will be prompted for Roundcube password. Provide the password received earlier(vbtPXwX#&&@aS7L).
If you are able to get in, check whether the database and tables are existing under the database.
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| roundcube |
+--------------------+
2 rows in set (0.09 sec)
mysql> use roundcube;
mysql> show tables;
+---------------------+
| Tables_in_roundcube |
+---------------------+
| cache |
| cache_index |
| cache_messages |
| cache_thread |
| contactgroupmembers |
| contactgroups |
| contacts |
| cp_schema_version |
| dictionary |
| identities |
| searches |
| session |
| system |
| users |
+---------------------+
14 rows in set (0.00 sec)
If you can see the above output, then DB connection is fine.
2. Now try repairing the database.
# mysqlcheck -r roundcube
Once the table is repaired, check Roundcube is working or not.
3. If the issue still exists, rebuild RoundCube and all will be fine.
# /usr/local/cpanel/bin/update-roundcube --force
Note : Please do backup RoundCube DB before performing rebuild. So if anything goes wrong after rebuild you can safely restore from backup.
Roundcube DB backup command :
# mysqldump roundcube > roundcube.sql
Roundcube DB restore command :
# mysqldump roundcube < roundcube.sql
Shaan N
Linux Support Engineer.
Nixtree Solutions
Managed Full Server Backups
https://www.nixtree.com/managed-backups.php
Follow us on : https://twitter.com/nixtree
In most of the cases, "DATABASE ERROR: CONNECTION FAILED!" error occurs when the MySQL is down or having issues with MySQL.
Since you have checked and restarted MySQL based on Tommy's advice and the issue keeps existing, this can be of something else.
Follow below checks to ensure everything is working fine:
1. Check the database connectivity from the command line
For this, you require Roundcube password. Execute the below command to know the Roundcube password.
Command:
# grep -i "db_dsnw" /usr/local/cpanel/base/3rdparty/roundcube/config/config.inc.php
Output :
$config['db_dsnw'] = 'mysql://roundcube:vbtPXwX#&&@aS7L@unix(/var/lib/mysql/mysql.sock)/roundcube';
From the output, we get know that the password is "vbtPXwX#&&@aS7L"
Now check the database connectivity using below command
# mysql -u roundcube -p
You will be prompted for Roundcube password. Provide the password received earlier(vbtPXwX#&&@aS7L).
If you are able to get in, check whether the database and tables are existing under the database.
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| roundcube |
+--------------------+
2 rows in set (0.09 sec)
mysql> use roundcube;
mysql> show tables;
+---------------------+
| Tables_in_roundcube |
+---------------------+
| cache |
| cache_index |
| cache_messages |
| cache_thread |
| contactgroupmembers |
| contactgroups |
| contacts |
| cp_schema_version |
| dictionary |
| identities |
| searches |
| session |
| system |
| users |
+---------------------+
14 rows in set (0.00 sec)
If you can see the above output, then DB connection is fine.
2. Now try repairing the database.
# mysqlcheck -r roundcube
Once the table is repaired, check Roundcube is working or not.
3. If the issue still exists, rebuild RoundCube and all will be fine.
# /usr/local/cpanel/bin/update-roundcube --force
Note : Please do backup RoundCube DB before performing rebuild. So if anything goes wrong after rebuild you can safely restore from backup.
Roundcube DB backup command :
# mysqldump roundcube > roundcube.sql
Roundcube DB restore command :
# mysqldump roundcube < roundcube.sql
Shaan N
Linux Support Engineer.
Nixtree Solutions
Managed Full Server Backups
https://www.nixtree.com/managed-backups.php
Follow us on : https://twitter.com/nixtree
Re: Roundcube Database Error cPanel
Hi Shaan,
You are Awesome!
The issue has been solved by Roundcube rebuild.
Thanks a Billion.
You are Awesome!
The issue has been solved by Roundcube rebuild.
Thanks a Billion.