ok you need to edit the roundcube config file
go to the roundcube install you will find a directory called config
navigate to there then edit the file config.inc.php
find the line that starts with $config['db_dsnw'] you will see it says localhost in the string replace this with the ip or domain name of the remote database server that should work as long as the remote database has the same name
if you need some more help pm me
you will need to set up the correct user name & password for the user on the remote database server
your line should look like $config['db_dsnw'] = 'mysql://bill:gates@localhost/roundcube_database';
say the remote database user is eddie and his password is jobs and the database is called roundcube_remote and the ip of the remote database server is 126.96.36.199
the new line would be $config['db_dsnw'] = 'mysql://eddie:email@example.com/roundcube_remote';
but if your using a host name rather than an IP address and the hostname is remotedb.com
the new line would be $config['db_dsnw'] = 'mysql://eddie:firstname.lastname@example.org/roundcube_remote';
don’t forget to open up port 3306 on the remote database server also all you need is the TCP option opened
Thanks for the explanation but in the config file the domain name of the remote db server is already in the connection string, that’s the domain name I used to add the database server to virtualmin and so that domain name works.
But during installation, roundcube’s installation script created a database but no tables. When installing roundcube with a local database, the script does.
Port 3306 is also open in the firewall. Connecting to that database server from MySQL Workbench works perfectly.