I have migrated succsessfull 3 servers debian 8 to debian in a multiserver enviorement build the new server as recommended here https://www.howtoforge.com/tutorial/debian-minimal-server/ and installed rest + needed services recomended here https://www.howtoforge.com/tutorial...-9-stretch-apache-bind-dovecot-ispconfig-3-1/ and did migrate with isp_copy, then shut down the old server and replaced the name and the IP so they were the same as the old server. Everything went fine and is working. Same for the fourth server a slave, but when I startet the isp_copy I got a warning similar to "Unable to connect to mysql server Host '172.16.1.245' is not allowed to connect to this MariaDB server", but the copy went fine and teh server seams to work fine. When I no do the recommended ispconfig update I get the above error when the update tries to connect the master. Need a hint where to look for the problem Thanks Rainer
Add a root user in mysql on the master which is allowed to connect from the IP and hostname of the (new) slave server.
OK, but why did it wok all the time, the error was, as I said, even on the old slave and teh new slave has the same ip than the old one. But I will try, which table? Thanks Rainer
What happend, just found all users in mysql.user except local root, ispconfig and phpmyadmin are lost on the master server? But everything worked fin till the fourth server a slave. I is not a cattastrohe as it is my internal test system, but I wonder how that happend. Thanks Rainer P.S. the master server was the third I migrated, it is possible that migrating / copying the master the user entries in the mysql.user database are not copied? Unforuately I deletet teh old master in case of space problems.
ISPCopy copies the ispconfig mysql user, all users that start with ispcsrv* and all mysql users created within ISPConfig on that server.
Ok, but why they are lost all, so recreating the root users would be not the problem just work and for three servers not too much, but for the ispconfig users how do I get the password? Thanks Rainer P.S. not the ispconfig but ispcsrvx user
I don't know why the ispcsrv* users were not migrated on your system. Which version of ISPCopy did you use? The passwords of the ispcsrv users are in the config.inc.php files of the slaves. When you do an ispconfig update on a slave and choose to reconfigure permissions in master database, then the ispcsrv user of that node is probably added back. At least it's worth a try before you re-add it manually.
I used, I think, the latest version. paid and downloaded last saterday, that means 2 days ago. thanks for help, will give feedback. Rainer
If I remember correctly, that version should contain the ispcsrv* migration part. At least I see it here in my code management system, will test it again with a multiserver setup.
OK I had created the root user manually and had run the update scripts, the ispcsrv* are recreated on name and ip address. Thanks again for help, next i will do a try on the hot system, and check everything before deleting an old server. is there a recomanded order in copying, slaves first, master first? In any case it is a fine tool for upgrading server to new versions, still some work creating and configuring the new servers. Rainer
