Access denied for one slave server to master database server

Discussion in 'ISPConfig 3 Priority Support' started by Taleman, Jul 24, 2019.

Tags:
  1. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    Running ispconfig_update.sh fails on one of my slaves. There were 4 of them, and other three were OK. Any ideas why it fails on this one host? I have checked /etc/hosts are correct on all hosts in the multiserver setup, I can ping both ways, PHPMyadmin shows database users for all hosts with name and IP and identical settings. No error in logs on master server. The error during ispconfig_update.sh is
    Code:
    MySQL master server database name [dbispconfig]:

Unable to connect to mysql server Access denied for user 'root'@'ns2.mydomain.tld' (using password: YES)
MySQL master server hostname [master.mydomain.tld]:
     
    Taleman, Jul 24, 2019
    #1
  2. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    Before the above post I had reset the password for ns2, now I also reset it for the IP-number. After that it worked.
    Curiouser and curiouser.
    But I am happy now and can now update the master when all slaves got the update.
     
    Taleman, Jul 24, 2019
    #2
    till likes this.
  3. till

    till Super Moderator Staff Member ISPConfig Developer

    The root user to install updates of slave servers exists twice, once for the IP and once for the hostname, if you change the password, you'll have to change both users.
     
    till, Jul 24, 2019
    #3

Share This Page