We are happy to announce that Vesta is back under active development as of 25 February 2024. We are working on v1 candidate and expect to engage more with the community over the coming months. We are committed to open source, and we encourage contributors to help us build the future of Vesta.
Roundcube not start, database problem
Roundcube not start, database problem
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.
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.
Re: Roundcube not start, database problem
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.
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.
Re: Roundcube not start, database problem
Hi skid,
I'll try.
Thank you very much.
Greetings.
I'll try.
Thank you very much.
Greetings.
Re: Roundcube not start, database problem
Can someone please help with roundcube database error?
Re: Roundcube not start, database problem
Login as root on phpMyadmin and check the Roundcube database.
Also, as indicated skid, check the Roundcube configuration file.
Greetings.
Also, as indicated skid, check the Roundcube configuration file.
Greetings.
Re: Roundcube not start, database problem
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.
Code: Select all
$rcmail_config['enable_installer'] = false;
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:
Code: Select all
$rcmail_config['enable_installer'] = false;
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.
Re: Roundcube not start, database problem
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.
Re: Roundcube not start, database problem
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.
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:
Code: Select all
$rcmail_config['db_dsnw'] = 'mysql://roundcube:yourroundcubepassword@localhost/roundcube';
Code: Select all
$ mysql -u root -p'yourrootpassword'
mysql> GRANT ALL PRIVILEGES ON roundcube.* TO roundcube@localhost IDENTIFIED BY 'yourroundcubepassword';
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.
Code: Select all
$ mysql -u root -p'yourrootpassword' roundcube < /home/admin/web/default.domain/public_html/mysql.initial.sql
Re: Roundcube not start, database problem
Main topic about Rouncude "DATABASE ERROR: CONNECTION FAILED!":
viewtopic.php?f=12&t=7065
viewtopic.php?f=12&t=7065