ISPConfig upgrade on multiserver (2nodes) fail on second node

Hello,

we have issue for upgrading the second node (mailserver) on multiserver setup.
First we upgraded Debian on both server 10 -> 11 -> 12. Then Run successfully
-> ispconfig_update.sh --force
on main server.

Both servers have same MySQL root password. I also tried I can login from mail server to main server SQL database with root credentials.

Code:

>> Update
Operating System: Debian 12.0 (Bookworm) or compatible
This application will update ISPConfig 3 on your server.
Shall the script create a ISPConfig backup in /var/backup/ now? (yes,no) [yes]:
Creating backup of "/usr/local/ispconfig" directory...
Creating backup of "/etc" directory...
Creating backup of "/etc/letsencrypt" directory...
Checking MariaDB version 10.11.6 .. OK
MySQL master server hostname [mainserver]:
MySQL master server port [3306]:
MySQL master server root username [root]:
MySQL master server root password []: xxxxxxxxxxxx
MySQL master server database name [dbispconfig]:
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

I also tried to change the $clientdb_host on mail server to IP of mail server as I can login comma line with sql client. But the error is still the same.

Code:

root@mailserver:~# cat /usr/local/ispconfig/server/lib/mysql_clientdb.conf
<?php
$clientdb_host                  = 'localhost';
$clientdb_user                  = 'root';
$clientdb_password              = 'xxxxxxxxxxxx';
?>

 

Try: https://forum.howtoforge.com/thread...-access-denied-for-user-root-localhost.90965/

 

Thank you.

I read the thread many times (also before opening new), and finally got the resolution by adding the user on mailserver:

Code:

CREATE USER 'root'@'127.0.0.1' IDENTIFIED BY 'xxxxxxxxxxxxxx';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'127.0.0.1';
ALTER USER 'root'@'localhost' IDENTIFIED BY 'xxxxxxxxxxxxxxxx';
flush privileges;

I was looking at the master server and there is not this user, so it confused me.