Hi, hi have a multiserver setup, one of the slaves should be migratet to an new host because of bad performance from the hardware. The old Host ist web,Email only and should be copied to a new slave. I installed the new slave like the old slave both ubuntu 24 LTS ISPconfig singel install on the new slave. After that i did run the ispcopy script on the old slave. The IP and the Servername from the new slave differes from the old slave. After the copy process was finished i do a ispconfig_update.sh --force like till explained in other posts (https://forum.howtoforge.com/threads/replace-server-in-cluster.86308/#post-417808) the new slave was entered in the mysql db on the master CREATE USER 'root'@'10..x.x.x' IDENTIFIED BY 'pw'; GRANT ALL PRIVILEGES ON * . * TO 'root'@'x.x.x.x' IDENTIFIED BY 'pw' WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ; But i still got this error Checking ISPConfig database .. mysqlcheck: Got error: 1698: Access denied for user 'root'@'localhost' when trying to connect OK ERROR 1698 (28000): Access denied for user 'root'@'localhost' Unable to call mysql command line with credentials from mysql_clientdb.conf Is there anything else i have to do? Regards Dominik
When i try to connect from the new slave over the cli to the master mysql server mysql -u root -h 10.x.x.x -pPassword the connection can be established
This error is not the connection to the master; it is the connection to the local database. Please test it on the new slave like this: mysql -u root -h localhost -p and mysql -u root -h 127.0.0.1 -p using the password from the file /usr/local/ispconfig/server/lib/mysql_clientdb.conf Both commands must work, the first one is a connection trough the socket, the second one trough the network interface.
Yes thats the problem, i found it. /usr/local/ispconfig/server/lib/mysql_clientdb.conf Her was the old root password for the local mysql. The new slave has another mysql root password. Thanks Can you please tell me if i can bring the new slave with the copied data with a new ip and a new name in the cluster? Or should i change the Hostname and IP from the new server to the name and ip of the old server?
When you run an ISPConfig update on the new system and choose to reconfigure services in the master database, then this new node will be connected to the master instead of the old one. Before you do the update, take care that the new server is able to connect with root mysql user on the master.