Database error connection failed unable to connect to the database please contact your server administrator

Hello there. So it’s my first post here. I decided to make an account here cuz I cant find any solution out there regarding my problem.

My server runs Ubuntu 14.04. Btw, I use the free trial Amazon EC2.

I wanted to create an mail account: info@mydomain.com from the VESTA CP

After that I tried to open the webmail but then I saw this error message:

DATABASE ERROR: CONNECTION FAILED!

Unable to connect to the database!
Please contact your server-administrator.

I then checked the error log:

[11-Feb-2015 14:55:44 +0000]: DB Error: SQLSTATE[28000] [1045] Access denied for user 'roundcube'@'localhost' (using password: YES) (GET /webmail/)
[11-Feb-2015 14:55:47 +0000]: DB Error: SQLSTATE[28000] [1045] Access denied for user 'roundcube'@'localhost' (using password: YES) in /usr/share/roundcube/program/lib/Roundcube/rcube_db.php on line 155 (GET /webmail/)
[11-Feb-2015 14:55:47 +0000]: DB Error: SQLSTATE[28000] [1045] Access denied for user 'roundcube'@'localhost' (using password: YES) (GET /webmail/)

I don’t know how to solve this problem. Please help me.

Here:
/etc/roundcube/debian-db.php
$dbpass= …

And there:
/var/lib/roundcube/config/db.inc.php
$rcmail_config[‘db_dsnw’] = …

skurudo wrote:Here:
/etc/roundcube/debian-db.php
$dbpass= …

And there:
/var/lib/roundcube/config/db.inc.php
$rcmail_config[‘db_dsnw’] = …

HI there, thanks for the reply. Unfortunately I don’t know the password of the user roundcube. Do you know how can I get the password from user roundcube?

By the way, because I don’t know the password of this user roundcube. I decided to make a new user named admin_roundcube and also a new database named admin_roundcube

Then I changed /var/lib/roundcube/config/db.inc.php and /etc/roundcube/debian-db.php with new user and database.
But it doesnt solve my problem. Later I got this message:

[12-Feb-2015 14:27:56 +0000]: DB Error: [1146] Table 'admin_roundcube.session' doesn't exist (SQL Query: SELECT vars, ip, changed FROM session WHERE sess_id = 'ae8dkd4rs70ld5mm2irebu1v41') in /usr/share/roundcube/program/lib/Roundcube/rcube_db.php on line 417 (GET /webmail/)
[12-Feb-2015 14:27:56 +0000]: DB Error: [1146] Table 'admin_roundcube.session' doesn't exist (GET /webmail/)
[12-Feb-2015 14:27:56 +0000]: DB Error: [1146] Table 'admin_roundcube.session' doesn't exist (SQL Query: INSERT INTO session (sess_id, vars, ip, created, changed) VALUES ('ae8dkd4rs70ld5mm2irebu1v41', 'dGVtcHxiOjE7bGFuZ3VhZ2V8czo1OiJlbl9VUyI7dGFza3xzOjU6ImxvZ2luIjs=', '172.31.44.1', '2015-02-12 14:27:56', '2015-02-12 14:27:56')) in /usr/share/roundcube/program/lib/Roundcube/rcube_db.php on line 417 (GET /webmail/)

Hi, guys. I finally solved it. Here are the steps that I’ve done

1. Log in to PhpMyAdmin
2. Create database named roundcube and user named roundcube MANUALLY
3. Go to localhost —> roundcube (database) —> SQL
4. and pasted this code: http://trac.roundcube.net/browser/githu … a833535cd4 and run it
5. edit /etc/roundcube/db.inc.php, debian-db.php and /var/lib/roundcube/config/db.inc.php with new password (I also replaced localhost with 127.0.0.1
6. Create an email account. Eg. info@maindomain.com
7. Open webmail. Log in. DONE

So long way. But you made it! Good.

You needed only change password for user roundcube, if you don’t have it and then change configs above.

Well, I noticed the same bug on Debian and Today on Ubuntu 14.04 fresh install.

Infact, Roundcube Databse doesn’t even exist after my VestaCP install.

on CentOS the Vesta installer install everything fine, but not on Ubuntu and Debian

mehargags wrote:
on CentOS the Vesta installer install everything fine, but not on Ubuntu and Debian

I make many installation on Debian and don’t see a problem, I think it’s repository based problem, guys.

skurudo wrote:

mehargags wrote:
on CentOS the Vesta installer install everything fine, but not on Ubuntu and Debian

I make many installation on Debian and don’t see a problem, I think it’s repository based problem, guys.

The problem exists on Ubuntu as well. Methinks something somewhere is not working properly because I can consistently reproduce this issue.

I just installed the RoundCube php mail client. I check the MySQL database and the new table was created, but through browser I’m getting the following error:

DATABASE ERROR: CONNECTION FAILED!

Unable to connect to the database!
Please contact your server-administrator.

I check the debian-db.php and the login parameters are correct, I also tried through terminal and I can connect to the db using this parameter

$dbuser='roundcube';
$dbpass='mypass';
$basepath='';
$dbname='roundcube';
$dbserver='';
$dbport='';
$dbtype='mysql';

asked Oct 11, 2011 at 15:15

It seemingly being an Ubuntu system you can also install the driver directly using apt-get.

$ sudo apt-get install php-mdb2-driver-mysql

(The package has been a part of Ubuntu since 10.04.)

answered Oct 11, 2011 at 17:27

1) Enable mysql logging and see whether it is generating any relavent info.

2) Make sure that sql safe mode is not enabled in php

3) Enable sql trace mode in php.ini and see whether it is generating any additional debug info which might be useful.

answered Oct 11, 2011 at 16:46

I’ve just had this error and the change from localhost to 127.0.0.1 fixed it for me!

mysql://roundcube:mypass@127.0.0.1/roundcubemail is now working

answered Jan 24, 2013 at 3:08

Database connection errors happens when the followings happens:

1. You don’t have proper database info set up in the configuration file (config/db.inc.php)
2. Your system don’t have the requirements needed to run roundcube.

To solve the first problem, you need to configure the following parameter correctly

$rcmail_config['db_dsnw'] = '{db_provider}://{username}:{password}@{host}/{database}';

• {db_provider} is database agent such as mysql, mysqli, sqlite etc
• {username} is your username to the database
• {password} is your password to the database
• {host} is either localhost or some host parameter for the location of your database server
• {database} is your database name, by default it is roundcubemail

Example:

$rcmail_config['db_dsnw'] = 'mysql://myuser:mypassword@localhost/roundcubemail';

To solve the second problem, you need to run the installer to verify your system. Please remove installer/folder once you have done the installation.

To run the test: go to {roundcube_domain}/installer/index.php.

And you will see all the requirements needed to run roundcube. Follow the instruction, you will be running roundcube in no time.

Maybe set $dbserver=''; to $dbserver='localhost'; instead of leaving it blank.

I had the same issue. This may help someone. Mine was installed using webmin

go to roundcube install location. usually it’s like

/home/domain/public_html/roundcube

open config.inc.php in /home/domain/public_html/roundcube/config

find the line like

$config['db_dsnw'] = 'mysql://mysqluser:password@localhost/database';

either change password here or change the password for user name mysqluser