Hello I have following issue: debian stable squeezy, multiserver, ispconfig 3.0.5.2 I have changed the server list on Code: Remote Access IPs (separate by , and leave blank for any) but mysql db on destination server is not changed accordingly. So I enabled debug and issue cron command at linux shell to investigate; what I see is that is replaced (correctly) record on web_database Code: 11.04.2013-09:49 - DEBUG - Set Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock 11.04.2013-09:49 - DEBUG - Found 1 changes, starting update process. 11.04.2013-09:49 - DEBUG - Replicated from master: REPLACE INTO web_database (`database_id`,`sys_userid`,`sys_groupid`,`sys_perm_user`,`sys_perm_group`,`sys_perm_other`,`server_id`,`parent_domain_id`,`type`,`database_name`,`database_name_prefix`,`database_user_id`,`database_ro_user_id`,`database_charset`,`remote_access`,`remote_ips`,`backup_copies`,`active`,`backup_interval`) VALUES ('604','1','25','riud','ru','','4','1468','mysql','studiocombruschi_wp','','442','0','utf8','y','213.152.201.162,172.16.21.162','7','y','daily') 11.04.2013-09:49 - DEBUG - Calling function 'db_update' from plugin 'mysql_clientdb_plugin' raised by event 'database_update'. 11.04.2013-09:49 - DEBUG - Processed datalog_id 1029129 11.04.2013-09:49 - DEBUG - Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock finished. but it is not changed in any way user table of mysql database, so the server that should be allowed to access, is not allowed. What I missed? What am I doing wrong? many thnx
mysql propagation is broken multiserver - debian wheezy - mysql This issuue is very easily reproducible: 1. login as client 2. create e new user and a new database 3. database and user are created correctly on controlpanel (master server) 4. they are correctly propagated to second server 5. try to change password and you will get this issue: Code: 13.04.2013-22:24 - DEBUG - Replicated from master: REPLACE INTO web_database_user (`database_user_id`,`sys_userid`,`sys_groupid`,`sys_perm_user`,`sys_perm_group`,`sys_perm_other`,`server_id`,`database_user`,`database_user_prefix`,`database_password`) VALUES ('','','','','','','49','jonnywp','','*A01D6B3C20044849CBB0EA6AC658C0D8CC086A5D') 13.04.2013-22:24 - DEBUG - Calling function 'db_user_update' from plugin 'mysql_clientdb_plugin' raised by event 'database_user_update'. 13.04.2013-22:24 - DEBUG - Changing MySQL user password for: jonnywp@localhost 13.04.2013-22:24 - DEBUG - Processed datalog_id 1030242 13.04.2013-22:24 - DEBUG - Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock as you can see, `database_user_id`,`sys_userid`,`sys_groupid`,`sys_perm_user`,`sys_perm_group`,`sys_perm_other` are *empty* so, you will find another jonnywp user without any id on web_database_user table. Password is changed on mysql db. If you try to chage password logged as admin, second record is created too, but password is not changed