Hello, I have a multiserver setup with ispconfig with multiple database servers (two of them a quick and a slow one). I have trouble understanding the intended way to work with databases. I'd like for a client to be able to select their preferred database server, but I can either limit them to only one server. If I leave them unlimited, there's no option to select the server that the customer wants at creation time, and the database is created on the first server all the time. Is this intended or am I missing something? I also found another issue: If I create a database, say on server 2, when the ispconfig interface is running on server 1, then the database is created on server 2 *but* the link in the customer control panel points to the server 1 (as in https://server1:8080/phpmyadmin) and so administration becomes impossible on server 2 via phpmyadmin. I understand that the link to phpmyadmin can be tweaked in the server settings. I tried setting it to [SERVERNAME]/phpmyadmin but the links do not change (do I have to update/resync something?) thank you.
Thats intended. Currently there is no option to let a customer select the database server on its own. There are several options, most admins will configure phpmyadmin (which has multiserver support builtin) on the master server to connect to all database servers, so you wont have to install apache on a database server. As altenative, you can use the placeholder [SERVERNAME] in the database url like: http://[SERVERNAME]/phpmyadmin
I tried that, but the links don't change (the databases were created before this). Is this a setting that only works at creation time?
No, thats a runtime setting. Are you sure that you had the http:// in front? It wont work without that.
Found the issue. I never clicked on the link but was only looking at the toolbar, where I could see the ispconfig server name and not the database.... I just found there's a redirect made by the php. Sorry about that. thanks for helping.
