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.
Installing VestaCP on Ubuntu 16.04.2 LTS - fixing Roundcube
Installing VestaCP on Ubuntu 16.04.2 LTS - fixing Roundcube
Hello VestaCP Users
I wanted to briefly share my experience of installing VestaCP on my tiny VDS.
First of all the context for me opting for VestaCP as a Control Panel. I only have a very small virtual server (30GB 512MB RAM) so needed something which allows me to avoid DNS, Spam and Anti virus features. Vesta looks great and allows a really lightl deployment. Up until recently I've been using ISPConfig but feel it is overkill for such a small server.
I prepped my new server with a basic clean Ubuntu server install - 16.04.2 LTS (64 bit version)
The only items I installed were the standard utilities and OpenSSH server. I finally made sure the server, had a static IP, and FQDN and was updated with latest packages:
apt-get update && apt-get upgrade && apt-get dist-upgrade
I then installed VestaCP using the procedure on the Vesta website.
Everything seem OK until I tried to access Roundcube webmail using /webmail after my domain main. The login window came up but contained an white error error complaining Roundcube could not connect to the database.
I searched the web, and the VestaCP website to see what the problem could be. I found some information but not not the complete answer in one post.
In brief it seems the VestaCP install script did not completely set up Roundcube. The steps I made to fix it were this:-
- Find the password Roundcube has set (I believe this is config.inc.php in /etc/roundcube)
- Log into phpmyadmin as root user
- Create user called roundcube specifying the password you found in config.inc.php
- Create database call roundcube
- Import correct MySQL initialiser file into roundcube db (see details below)
- Reboot server
The roundcube database you just created above will be bare and needs initialising but take care to use the right sql file. The one you need to use is the file which is provided with the version of roundcube which got installed, not simply the one from the latest Roundcube release. The correct file was actually sitting on my new server in this location.... /usr/share/dbconfig-common/data/roundcube/install/mysql
I found the easiest way to import that file using MySQL session on shell session.
(I did try the mysql file from the Roundcube latest release but it didn't work. The version which got installed was 1.2beta)
Once I had carried out these steps and rebooted the server I was able to use roundcube.
I am a novice enthusiast who just wants to run his own server so please forgive any errors but I wanted to share this in case it helps anyone else use VestaCP on Ubuntu 16.04.2 LTS.
Regards
Karl
I wanted to briefly share my experience of installing VestaCP on my tiny VDS.
First of all the context for me opting for VestaCP as a Control Panel. I only have a very small virtual server (30GB 512MB RAM) so needed something which allows me to avoid DNS, Spam and Anti virus features. Vesta looks great and allows a really lightl deployment. Up until recently I've been using ISPConfig but feel it is overkill for such a small server.
I prepped my new server with a basic clean Ubuntu server install - 16.04.2 LTS (64 bit version)
The only items I installed were the standard utilities and OpenSSH server. I finally made sure the server, had a static IP, and FQDN and was updated with latest packages:
apt-get update && apt-get upgrade && apt-get dist-upgrade
I then installed VestaCP using the procedure on the Vesta website.
Everything seem OK until I tried to access Roundcube webmail using /webmail after my domain main. The login window came up but contained an white error error complaining Roundcube could not connect to the database.
I searched the web, and the VestaCP website to see what the problem could be. I found some information but not not the complete answer in one post.
In brief it seems the VestaCP install script did not completely set up Roundcube. The steps I made to fix it were this:-
- Find the password Roundcube has set (I believe this is config.inc.php in /etc/roundcube)
- Log into phpmyadmin as root user
- Create user called roundcube specifying the password you found in config.inc.php
- Create database call roundcube
- Import correct MySQL initialiser file into roundcube db (see details below)
- Reboot server
The roundcube database you just created above will be bare and needs initialising but take care to use the right sql file. The one you need to use is the file which is provided with the version of roundcube which got installed, not simply the one from the latest Roundcube release. The correct file was actually sitting on my new server in this location.... /usr/share/dbconfig-common/data/roundcube/install/mysql
I found the easiest way to import that file using MySQL session on shell session.
(I did try the mysql file from the Roundcube latest release but it didn't work. The version which got installed was 1.2beta)
Once I had carried out these steps and rebooted the server I was able to use roundcube.
I am a novice enthusiast who just wants to run his own server so please forgive any errors but I wanted to share this in case it helps anyone else use VestaCP on Ubuntu 16.04.2 LTS.
Regards
Karl