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