, db remote does not propagate

Discussion in 'General' started by maumar, Apr 11, 2013.

  1. maumar

    maumar Member HowtoForge Supporter

    I have following issue:
    debian stable squeezy, multiserver, ispconfig

    I have changed the server list on
     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

    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',',','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
    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
  2. maumar

    maumar Member HowtoForge Supporter

    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:

    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: [email protected]
    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
    Last edited: Apr 13, 2013

Share This Page