A time ago I setup ISPConfig with a multi server setup with about 25 servers. Now I'm trying to update all the servers to the latest ISPConfig but found that I did not write down all the passwords I used to connect the slave servers to the master server. Is there a way to retrieve / reset those passwords? I don't want to add them to the setup again since I will lose a lot of settings.
You don't need to know the mysql password for each slave (though it's stored in /usr/local/ispconfig/server/lib/mysql_clientdb.conf if you ever do), all you need to know is the mysql root password for the master server.
If you lost the slave's mysql-root-password for the master-server, you can change the password for root@slave and root@slave-ip in mysql.user on the master.
I was looking for an option in ISPConfig to reset the password but this solution works fine for me. Thanks for the swift reply!
No, the root mysql account on the master is only used by the installer, and you enter the password manually.
Unfortunately I had to create a new master server. The master is ok but I lost the connection with the slave. All tasks that are for the Slave are only in the queue and do not execute
Look up the "dbmaster" username and password from config.inc.php on the slave, and add that user with that password on the master. You will also need to add a "root@slave-server" (add both for the hostname and the slave's ip) with root permissions if you haven't yet. Then run the installer on the slave and answer yes to "reconfigure services on the master server".
Right. I did the procedures. Now I think it's working. It was giving error in the FTP of the Slave. I updated the /etc/pure-ftpd/db/mysql.conf file with the correct password and it worked again. In this file the MYSQLServer field would be the same 127.0.0.1? ( In slave )
Code: mai 24 15:18:24 ispconfig mariadbd[1471355]: 2022-05-24 15:18:24 2325 [Warning] Access denied for user 'ispconfig'@'localhost' (using password: YES) Code: SHOW GRANTS FOR CURRENT_USER; +---------------------------------------------------------------------------------------------------------------------------+ | Grants for ispconfig@localhost | +---------------------------------------------------------------------------------------------------------------------------+ | GRANT ALL PRIVILEGES ON *.* TO `ispconfig`@`localhost` IDENTIFIED BY PASSWORD 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXxx' | | GRANT ALL PRIVILEGES ON `dbispconfig`.* TO `ispconfig`@`localhost` | +---------------------------------------------------------------------------------------------------------------------------+ Sorry, another doubt. I updated both config.inc.php on master ispconfig. The password used works to log in locally (mysql -u ispconfig -p). But when I look at the mariadb.service service, it's always denied. Is there another file, even if it's mysql that we usually configure?
I noticed that the database backup of the sites stopped being made. the web is ok. Running server.sh: Code: mysqldump: Couldn't execute 'SHOW FUNCTION STATUS WHERE Db = 'sitedb'': Cannot load from mysql.proc. The table is probably corrupted (1728) 28.05.2022-06:52 - ERROR - Failed to make backup of database sitedb, because mysqldump failed My version of database 10.5.15-MariaDB ISPConfig Version: 3.2.8p1 Debian 11
I found the problem. The ispconfig user password in the /etc/dovecot/dovecot-sql.conf file was out of date, so it was constantly showing an error.
