ispconfig should not expect mysql on localhost
Currently ispconfig3 works incorrectly if mysql database is not hosted on the same machine as ispconfig (i.e. mysql is not on localhost).
Some examples follow.
Problem: In /usr/local/ispconfig/server/lib/mysql_clientdb.conf $clientdb_host is set as localhost (this led me to ask for reopening of bug #404 (closed) but that perhaps is not the same problem)
Result: It is impossible to create new databases
Possible solution: $clientdb_host should be set to whatever is entered when installing ispconfig
Problem: When creating a new database if remote access is disabled, new user is created with rights from localhost, but that is localhost to the db server, not ispconfig server
Result: Website is not able to access the database
Possible solution: Always also create rights for the host from which ispconfig connects, or maybe add some information about the situation, when creating database.
Problem: When logged in as admin go to System > Edit server > [server name]. It is possible to check "DB-Server" there. It is unclear what this checkbox does in this situation.
Possible solution: Add an explanation what would change if db server is checked/unchecked. As a client I was able to create a new database with both.
This was tested on 3.0.1.4 beta