Hi, One day, one problem... I have lost my master server (userdel -r -f on a user that had / as home directory...) Now I have reinstalled it, recovered my dbispconfig database (1 day lost), stopped cron on slave servers. I have tested root access to my mysql on master from my 3 slaves. (mysql account + fw rule recreated) What are the steps that I should take in order to make my master server (used only as a manager for my clients) functional again ? Thank you very much.
Did you recover all databases (ikl. the mysql.mysql database of the master which contains the mysql logins) or only the dbispconfig database?
Ok,so currently all the ispcsrv* users are missing in the mysql master. Thats the users that the slaves use to fetch data from the master. Please download the ispconfig tar.gz on one of the slaves, unpack it and run the update.php script in the install folder. when the installer asks you to reconfigure the mysql users on the master server, choose yes. When the update is finished, check on the master server if the ispcsrv* users exist now.
done, it has recreated the the ispcsrv6 user on the master database, so I have to do that with all my slave servers ?
No error messages anywhere, but none of my changes are executed on my slaves. My old master server was apache and my new one is nginx, so I changed the settings in the "server" table, "config" value, so ispconfig knows that it is running on nginx now. Any idea on what I have missed ?
Enable debugging for one of the slaves on the master: http://www.faqforge.com/linux/debugging-ispconfig-3-server-actions-in-case-of-a-failure/ then run the server.sh script on the slave and check the output.
Nothing shows in the debug, the script ends normally with "Finished". So I started debugging the script and the problem is the datalog as I have lost 1 day operations on my master server (the database was 1 day old) so the last_datalog_id > max (updated) for each of my slaves (for the moment) How to smoothly get out of this situation ?
The last data log Id is stored in the master database only, so there should be no differences. But you can adjust the updated column in the server table on the master if necessary, it contains the last processed I'd for a server.
all good, I had to change the updated column on the slave servers because the latest datalog id on the master was lower than the updated column on the slaves, so slaves wouldn't execute lastest commands from master. commands are now executed on slaves, hope I won't have problems later with this change because some of the operations that were executed between the restore of the master and now are lost on the master. thanks anyway.
