run ispconfig_update.sh after hostname change

Discussion in 'Installation/Configuration' started by progressed36, Apr 29, 2021.

  1. progressed36

    progressed36 Member

    Hi all,

    I have been searching my ass of how to fix this. The hostname of a vps changed of a multiserver setup and i wish to update ispconfig. After running ispconfig_update.sh and filling in the MySQL master server i get back:

    Code:
    Unable to connect to mysql server Access denied for user 'root'@'web06.OLDDOMAINNAME.com' (using password: YES)
    Somewhere there is still a reference where the ip translates to the old hostname. When i ping on the master or child server the old hostname is not pingable.

    My question is... where can i find this reference as all points are changed where olddomainname.com is newdomainname.com
     
  2. Th0m

    Th0m ISPConfig Developer Staff Member ISPConfig Developer

    You can change the credentials manually in /usr/local/ispconfig/interface/lib/config.inc.php and /usr/local/ispconfig/server/lib/config.inc.php - make sure you created a MySQL user on the master host for [email protected] (as done in the Multiserver guide)
     
  3. Jesse Norell

    Jesse Norell ISPConfig Developer Staff Member ISPConfig Developer

    Also (in addition to updating the mysql user entries) ensure your hosts file is correct, and you might check your reverse dns while you're at it (likely not the source of your current issue, but potentially related to your change).
     
  4. progressed36

    progressed36 Member

    I wanted to follow up on this one. Thank you for your input, but all it was was a ordinary reboot of the master server. Somehow even though there was no reference to the old domainname in the host or any other file MySQL probably cached it somewhere somehow. After googling the issue more this is what i found in the manual:

    So we learn every day :)
     
    till, Jesse Norell and Th0m like this.

Share This Page