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.
Remote Database Help
Remote Database Help
Read this thread viewtopic.php?f=10&t=4054 and am still having issues.
I am trying to get a remote MySQL DB working with Vesta CP. Here is where I am at:
I am using Digital Ocean and have identical Ubuntu 12.04.4 X64 servers. One is running Vesta, the other MySQL. Both are on a private network. I set up a remote user on the MySQL called VestaUser and allowed remote access using the private IP address from the Vesta CP server. I ran the following code on the Vesta CP server:
Everything looks good and I am able to choose my private IP address to create DB's in the Vesta CP without error messages. However a few issues arise.
-Both localhost and my private IP address are options in the drop down still even after I suspended localhost.
-When I create a DB using the private IP drop-down and click "Open phpMyAdmin", it doesn't open as it points to the private IP not a public one...how do I set it to go to the public when using a private IP (If possible?)?
-When I visit the public IP phpMyAdmin of the remote MySQL server, none of the databases that I created in VestaCP exist. Does that make sense?
I am trying to get a remote MySQL DB working with Vesta CP. Here is where I am at:
I am using Digital Ocean and have identical Ubuntu 12.04.4 X64 servers. One is running Vesta, the other MySQL. Both are on a private network. I set up a remote user on the MySQL called VestaUser and allowed remote access using the private IP address from the Vesta CP server. I ran the following code on the Vesta CP server:
Code: Select all
v-add-database-host mysql new-server.com root password
Code: Select all
v-list-database-hosts
Code: Select all
v-suspend-database-host mysql localhost
-Both localhost and my private IP address are options in the drop down still even after I suspended localhost.
-When I create a DB using the private IP drop-down and click "Open phpMyAdmin", it doesn't open as it points to the private IP not a public one...how do I set it to go to the public when using a private IP (If possible?)?
-When I visit the public IP phpMyAdmin of the remote MySQL server, none of the databases that I created in VestaCP exist. Does that make sense?
Re: Remote Database Help
Since I haven't received a response, does anyone know if there is a tutorial written on this topic that I can reference?
Re: Remote Database Help
Hi,
This problem is confirmedBoth localhost and my private IP address are options in the drop down still even after I suspended localhost
Re: Remote Database Help
Hi. Too need this option.imperio wrote:Hi,This problem is confirmedBoth localhost and my private IP address are options in the drop down still even after I suspended localhost
I would like to remove "LOCAL HOST" from drop down menu.
Any help?
Re: Remote Database Help
Ok Got-it..maniekandan55 wrote:Hi. Too need this option.imperio wrote:Hi,This problem is confirmedBoth localhost and my private IP address are options in the drop down still even after I suspended localhost
I would like to remove "LOCAL HOST" from drop down menu.
Any help?
Simply edit the file:
/usr/local/vesta/conf/mysql.conf
Than 'Restart MySQL service'.
- The dropdown sequence & the hosts are following from this file.
- The Database maximum DBs counting also from here.
Re: Remote Database Help
Thanks! I was looking for this solution!maniekandan55 wrote: Ok Got-it..
Simply edit the file:
/usr/local/vesta/conf/mysql.conf
Than 'Restart MySQL service'.
- The dropdown sequence & the hosts are following from this file.
- The Database maximum DBs counting also from here.
Re: Remote Database Help
Ok, closed.