Long time lurker, first time poster here.
We are running a multi-server ISPCONFIG3 platform which was setup per the Administrator guide for ISPCONFIG3.
The configuration is such that there are 5 dedicated ISPCONFIG servers as follows:
Server | IP
web1 (ISPCONFIG console loaded here) | 10.10.10.15
mail1 | 10.10.10.14
ns1 | 10.10.10.11
ns2 | 10.10.10.13
db1 | 10.10.10.16
The installation guide was followed to the "T" - all servers are Debian Lenny 5.07 VMs.
There are no issue in creating sites, FTP users, adding/removing/editing DNS records, propagation of these between ns1 and ns2 servers, or problems with mail accounts/databases on mail1.
However, whenever we create a database & user, it is NOT being created at db1. Ironically, the first website and db we setup did work, but something since has broken and we can't seem to figure it out.
/etc/mysql/my.cnf has been checked and confirmed to be listening on all interfaces (both web1 and db1).
Does anyone have any suggestions/advice on what we can check to try and correct?
Thanks in advance for your help!