Add a slave server to master failed

Discussion in 'Installation/Configuration' started by Systech, Feb 19, 2025.

  1. Systech

    Systech New Member

    I am currently setting up a new system (ubuntu 24.04) and using a master slave system. I did this a few years ago and nothing has changed in the setup to date. I followed the current instructions again and created a user on the master as described for both the server name and the IP of the slave (sslroot and GRANT ALL PRIVILEGES ON * . * TO ‘sslroot’ ...). The password is different from the SQL password on the master (autocreate) and slave (autocreate). When adding slave I get the error message.
    ERROR 1698 (28000): Access denied for user ‘root’@‘localhost’
    ERROR: Unable to load SQL-Dump into database table.
    [INFO] Adding PHP version(s) to ISPConfig.
    [ERROR] Exception occurred: ISPConfigOSException -> Could not read ISPConfig settings file. (/ispconfig.ai.php:15)
    What surprises me is the error message root‘@’localhost' when I log in as [email protected]. I have of course tried all other passwords and then get the error message as expected
    Unable to connect to mysql server Access denied for user ssroot‘@’slaveserver.tld' (using password: YES)
    A connection directly with the sql client to the master works without problems. I have now tested all variants (I have also set up the user root for the slaveserver and also set GRANT all) and I am getting nowhere. Does anyone have an idea where my error is?
     
  2. Systech

    Systech New Member

    To all,
    the error is always in front of the screen. I forgot to write down the new mysql password of slave when running installer again. Sorry for the confusion!
    Kind Regards,
    Matthias
     
    till likes this.

Share This Page