Wrong replicate ispconfigdb in Muliserver setu

Discussion in 'Installation/Configuration' started by Petr, Nov 8, 2013.

  1. Petr

    Petr New Member

    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)

    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

    Debian 6 , ISP Config

    Any idea please :-( ?

    Last edited: Nov 9, 2013
  2. Croydon

    Croydon ISPConfig Developer ISPConfig Developer

    Please use the latest ISPConfig version that has lots of updates and fixes (including this one I think). You are using, latest is!
    Last edited: Nov 8, 2013
  3. Petr

    Petr New Member

    thanks Croydon, but this opinion not working
  4. Croydon

    Croydon ISPConfig Developer ISPConfig Developer

    Sorry, don't understand what you're trying to tell me :)
    ISPConfig has fixed this issue, so you will have to upgrade to get it fixed.
  5. Petr

    Petr New Member

    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

Share This Page