Vesta Control Panel - Forum

Hello,

I have a problem with Roundcube, when I try to access to webmail, show the error: DATABASE ERROR: CONNECTION FAILED!

It is a clean install of VESTA CP, and it seems that the installation failed.

Also, how I can update Roundcube to the latest version 0.9.5 available on their website?

Thanks for your help, greetings.

Database configuration can be found here /etc/roundcubemail/db.inc.php or here /etc/roundcube/db.inc.php
Check if rcmail_config string is configured correctly and database server is actually alive.

Roundcube can be upgraded using custom software repository or you can download it and install manually.

Hi skid,

I'll try.

Thank you very much.

Greetings.

Can someone please help with roundcube database error?

Login as root on phpMyadmin and check the Roundcube database.

Also, as indicated skid, check the Roundcube configuration file.

Greetings.

This issue appeared for me because roundcubemail wasn't fully installed and configured during the Vesta install process. To get it working I needed to set the following line to true instead of false in /etc/roundcubemail/main.inc.php:
Then run the roundcubemail installer by going to http://mydomain.com/webmail/installer/

And to complete the installer successfully after I got to the point that it complained that I had no readable config.inc.php I needed to copy the config.inc.php the installer generated into /etc/roundcubemail/ and set that file to the same readability as the other config files in that directory and then set the same option:
once again to true, but in the new file config.inc.php rather than /etc/roundcubemail/main.inc.php.

The installation then completed correctly and at that point I set the enable_installer lines I referenced above back to false in both /etc/roundcubemail/main.inc.php and in /etc/roundcubemail/config.inc.php so that they would no longer be in installer mode. Not sure if this is a Vesta bug – my understanding was that dependencies like Roundcubemail would be completely installed and configured in the Vesta install process but maybe that's incorrect.

I am still having this issue, and going to http://mysite/webmail/installer just takes me to a 404 error page as shown in the instructions on the above post.

This is still an issue. I would've preferred Roundcube to not install at all so I could've installed it manually, instead of having a broken install shipped with Vesta.

Here's my solution for the latest Vesta version.

1. Find Roundcube's DB config by opening /etc/roundcube/db.inc.php. Look for the $rcmail_config['db_dsnw'] option. Should look like this:
2. Now connect to MySQL and setup the user/password/database combo found above.
3. Get the latest Roundcube database structure file (called mysql.initial.sql) from Roundcube's Github repo: https://github.com/roundcube/roundcubem ... nitial.sql

4. Upload the file to your server, for example using the default Vesta domain's FTP. In my case I uploaded it to /home/admin/web/default.domain/public_html/mysql.initial.sql.

5. Now inject the database structure into the newly created database.
That's it.

Main topic about Rouncude "DATABASE ERROR: CONNECTION FAILED!":
viewtopic.php?f=12&t=7065