Hello , I have this problem " not replicate some tables in ispconfigdb" in multiserver setup. Example new mysqldb is replicate OK. ( replicate web_database table in ispconfigdb is working fine) But new mysqldb USER is NOT replicate ( Problem is in web_database_user table ). On phpmyadmin looking bad database_user_id - same id for another user between Master/Slave table ( see on picture) test: 1) I am create new db user 2) In ispconfigdb on Master server is write new user (working OK ) 3) On slave servers is change not write (probem) 4) jobque is emty 5 ) master:~# /usr/local/ispconfig/server/server.sh finished. (On master and all slaves servers is all OK) I am go test: restart mysql on all server I am go test: reinstall ispconfig with reconfigure permition I am go test: Resync clientdb config (isp config gui tools>sync tools) the problem is still system: Debian 6 , ISP Config 3.0.5.2 Any idea please :-( ? thanks, Petr
Please use the latest ISPConfig version that has lots of updates and fixes (including this one I think). You are using 3.0.5.2, latest is 3.0.5.3!
Sorry, don't understand what you're trying to tell me ISPConfig 3.0.5.3 has fixed this issue, so you will have to upgrade to get it fixed.
Yes, you was right. fault was in me. In one test step I replaced dbispconfig databese from backup on the master server, but not the slaves. Therefore, replication not working. Solution: I dbispconfig restored to all serverch to the same date and do a manual update ISPConfig again. Synchronizing work now, everything looks OK Many thanks for the help
