ispcopy after finished copy job the ispconfig_update.sh --force end with mysql error

Discussion in 'ISPConfig 3 Priority Support' started by Dominik, Feb 10, 2025.

  1. Dominik

    Dominik New Member HowtoForge Supporter

    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
     
  2. Dominik

    Dominik New Member HowtoForge Supporter

    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
     
  3. till

    till Super Moderator Staff Member ISPConfig Developer

    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.
     
  4. Dominik

    Dominik New Member HowtoForge Supporter

    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?
     
  5. till

    till Super Moderator Staff Member ISPConfig Developer

    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.
     

Share This Page