Ispconfig 3.2 mysql refuse IP address with remote access

Discussion in 'Installation/Configuration' started by francoisPE, Oct 30, 2020.

  1. francoisPE

    francoisPE Active Member HowtoForge Supporter

    ISPC is 5 days old.
    I try a PM but I didn't succeed in putting image in... ! only through url !?
     
  2. ahrasis

    ahrasis Well-Known Member HowtoForge Supporter

    I don't think the problem is coming from the ISPConfig GUI but it may come from your multi server setup.
     
  3. Samuelet

    Samuelet New Member

  4. Th0m

    Th0m ISPConfig Developer Staff Member ISPConfig Developer

    Yes, we'll dig into that.
     
  5. francoisPE

    francoisPE Active Member HowtoForge Supporter

    it describes exactly what's happening for me.
    but, I don't understand what below coment from Till means
    "Check the client limits of the client that owns this website, probably you missed settings a default database server there."
    In my case, there is no client, I do it as c0/default.
    when entering in mysql on ns2, 'show databases;' gives
    | Database |
    +--------------------+
    | c0nextcloud_db |
    | dbispconfig |
    | information_schema |
    | mysql |
    | opendmarc |
    | performance_schema |
    | roundcube

    I discover that I didn't run mysql_secure_installation on ns2
    I did, but, I am worried to remove "remote root access". It is in the manual, so I follow...
    I also create users ns1, ns2, IP1, IP2, grant privileges and flush as in manual pge 30-31. It seems to be for web interface but I try to see.
    both changes had no good effect...
     
    ahrasis likes this.
  6. francoisPE

    francoisPE Active Member HowtoForge Supporter

    I try from both server : mysql -u root -h Ipoftheotherserver -p
    Both accepts access after password entry...
     
  7. francoisPE

    francoisPE Active Member HowtoForge Supporter

    I note that when I create a db
    - from ns1, remote access is possible to activate for ns2.
    - from ns2, remote access is impossible ...
    ns1, is where is mysql "ispc main" database
     
  8. Th0m

    Th0m ISPConfig Developer Staff Member ISPConfig Developer

    We are looking into this issue, see the GitLab issue.
     
    ahrasis likes this.
  9. francoisPE

    francoisPE Active Member HowtoForge Supporter

    I looked at it.
    I though I could provide more details on it on that thread.
     

Share This Page