Hello, i Dont know when did started but when editting a database setting when remote ip is enabled it is adding my sql servername to the remote iplist and that is no allowed by config so no changes can be made it only happend when changing a database not when creating a new database. Any idees? setup centos stream 8 (working on it ) multiserver setup
Which ISPConfig version? The server name is visible in the remote IP field on the master, or is it just added on the database node?
ISPConfig 3.2.12p1 if i save the setting then the server name of the sql server is visible in the ipfield and a error message is shown Code: 5.22.xxx.xx,sql1.xxx.com
Ok. I guess adding the hostname there makes general sense, but we must adjust the validator then, too.
It is added because mysql uses different permission records for IP and hostname and if only the IP is added, request using the hostname will get rejected. And the IP and hostname are added there automatically as the system adds the IP and hostname of the server of the website where the database belongs to to allow access from website to its database.