We normally come across different errors while logging into an email account. One such error message is ‘Database Error: CONNECTION FAILED’ in Roundcube.
This error is mainly based on the database trouble in the server. Also, it mainly shows while trying to log in to Roundcube. Any updates made in the DirectAdmin can also end up with these errors.
At Bobcares, we receive requests to fix Roundcube errors as a part of our Server Management Services.
Today, let’s see a few causes and how our Support Engineers fix the Database error in Roundcube DirectAdmin.
Causes of Database Error: CONNECTION FAILED in RoundCube and how we fix it?
Roundcube is a popularly used webmail client that is written in PHP. And all the data of Roundcube is stored in a database.
So, the database plays a major role in Roundcube’s functionality. It is very necessary for the database to be up and running well.
Now, let’s see how our Support Engineers fix the error related to RoundCube in DirectAdmin.
1. Empty database
Recently, one of our customers approached us with a Roundcube error. He received the below error message while logging into Roundcube.
DATABASE ERROR: CONNECTION FAILED! Unable to connect to the database! Please contact your server-administrator.
Our Support Engineers started to troubleshoot the error by checking the database. The database was available in the account. But there were no tables within it.
So, we deleted the database using the command
drop database database_name
Then, we ran the below command for the re-working of the RoundCube webmail client
Finally, this fixed the error message.
2. Database doesn’t exist
Sometimes, the database itself goes missing in some accounts which don’t allow the RoundCube to work.
Here is an example where our customer experienced the same error message:
DATABASE ERROR: CONNECTION FAILED!
Our Support Engineers investigated this error and found that the database was not existing in the account.
Also, the database was not present in /var/lib/mysql path. So we ran the build script provided below to fix this error.
3. MySQL functions missing in php.ini
RoundCube is open-source software written in PHP. There can be cases where few functions in the php.ini file will not be set by default.
So, the error will resolve if we set those PHP functions properly. One of our customers was experiencing the same error.
Our Support Engineers found that pdo_mysql.default_socket was not set in the php.ini file.
We, enabled pdo_mysql.default_socket by pointing it to /tmp/mysql.sock. Then, we restarted the php-fpm and this solved the problem.
[Need assistance with RoundCube errors in DirectAdmin? – We’ll help you]
In short, Database Error: Connection Failed error shows up due to database errors or PHP errors. Today, we saw different causes and also saw how our Support Engineers fix it.