DB cannot be created in remote server

Discussion in 'ISPConfig 3 Priority Support' started by Stelios, Nov 29, 2022.

Tags:
  1. Stelios

    Stelios Active Member HowtoForge Supporter

    Hi all,

    I've added a new web/db server to my multi server setup.
    I can login fine with root pass from my controlpanel server (dedicated with just the panel) to the remote DB server without a problem but when I create a DB to that server it doesn't created at all.
    Under controlpanel shows all ok, that DB is indeed created but showing the DBs on that server shows nothing apart from the default ones.
    When I select the user view from mysql table I can see that the user that I assigned via ispconfig panel is not there at all.

    How can I troubleshoot this?
     
    Stelios, Nov 29, 2022
    #1
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    That's not what ISPConfig is doing. the master system does not connect to a slave server node. The slave nodes connect to master system (and not as root) to fetch changes.

    The most likely reason for such an issue is that you changed the MySQL root password on that database server node but did not update the password in /usr/local/ispconfig/server/lib/mysql_clientdb.conf file.
     
    Last edited: Nov 29, 2022
    till, Nov 29, 2022
    #2
  3. Stelios

    Stelios Active Member HowtoForge Supporter

    @till there is no /usr/Local/ispconfig/server/lib/mysql_clientdb.conf in any of my servers. The mysql root pass is the same I haven't done any change.
     
    Stelios, Nov 29, 2022
    #3
  4. Stelios

    Stelios Active Member HowtoForge Supporter

    Ignore my previous post, just found it.
     
    Stelios, Nov 29, 2022
    #4
  5. Stelios

    Stelios Active Member HowtoForge Supporter

    You were correct till , that was the problem. Thanks a lot
     
    Stelios, Nov 29, 2022
    #5
  6. till

    till Super Moderator Staff Member ISPConfig Developer

    Sorry for the type (big L) in the path. Corrected that in my initial post now just in case someone finds the thread later.
     
    till, Nov 29, 2022
    #6

Share This Page