sql name is added to remote ips

Discussion in 'Installation/Configuration' started by Steffan, Dec 30, 2024.

  1. Steffan

    Steffan Member

    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
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    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?
     
  3. Steffan

    Steffan Member

    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
     
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    Ok. I guess adding the hostname there makes general sense, but we must adjust the validator then, too.
     
  5. Steffan

    Steffan Member

    But i dont addit there. So the question is why is it added by script
     
  6. till

    till Super Moderator Staff Member ISPConfig Developer

    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.
     
  7. Steffan

    Steffan Member

    so then it is a bug by the validation :)
     
  8. till

    till Super Moderator Staff Member ISPConfig Developer

    Yes, I think so. I'll add it to the issue tracker.
     
  9. helmo

    helmo Member HowtoForge Supporter

Share This Page