mirroring issue

Discussion in 'Installation/Configuration' started by lifeisboost, May 18, 2010.

  1. lifeisboost

    lifeisboost New Member

    I am trying to mirror my main ispconfig3 server to another server. I installed everything on the slave server to the debian perfect setup chose expert installed and no control panel. I joined it to the master server and it shows in the master server. When i chose this server as a mirror of the main server, only the first website was mirrored. i had to change 1 setting in each site for it to mirror the others. then none of the email accounts or domains mirrored over. i changed one setting but nothing worked. i manually checked the mysql tables and there where no domains or users added. I also checked logs and saw no errors.
     
  2. till

    till Super Moderator Howtoforge Staff HowtoForge Supporter ISPConfig Developer

    Enable debugging in the server settings of the slave server in ispconfig and then check the ispconfig.log on the slave server on the shell for errors.
     
  3. damir

    damir New Member

    As i recall new mirroring function is for settings and configuration only? Data is not mirrored.
     
  4. lifeisboost

    lifeisboost New Member

    What i am trying to do is replicate all the the users and settings, I use rsync for the data.
    Till, it is sending the replicate commands and the server sees them as i see them in debug. If i update the spam settings on the account it will update it in the spam tables of the slave, but how can i get it to replicate the user data and mail domains to the slave?

    the first slave mail server i setup it worked flawlesly, this second one is giving me the fits on replicating the mail users and domains
     
  5. till

    till Super Moderator Howtoforge Staff HowtoForge Supporter ISPConfig Developer

    The data is not send from the master to the slave, it is requested by the slave. In other words, the slave queries the mysql database on the master once a minute to check if there are any chnages and then it replicates these changes into its database. You see the replication in the log when you enable debugging for the slave. To debug this, see #2 in this thread.
     
  6. lifeisboost

    lifeisboost New Member

    Code:
    18.05.2010-10:57 - DEBUG - Set Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
    18.05.2010-10:57 - DEBUG - No Updated records found, starting only the core.
    18.05.2010-10:57 - DEBUG - Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
    18.05.2010-10:58 - DEBUG - Set Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
    18.05.2010-10:58 - DEBUG - No Updated records found, starting only the core.
    18.05.2010-10:58 - DEBUG - Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
    18.05.2010-10:59 - DEBUG - Set Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
    18.05.2010-10:59 - DEBUG - No Updated records found, starting only the core.
    18.05.2010-10:59 - DEBUG - Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
    18.05.2010-11:00 - DEBUG - Set Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
    18.05.2010-11:00 - DEBUG - No Updated records found, starting only the core.
    18.05.2010-11:00 - DEBUG - Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
    18.05.2010-11:01 - DEBUG - Set Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
    18.05.2010-11:01 - DEBUG - No Updated records found, starting only the core.
    18.05.2010-11:01 - DEBUG - Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
    18.05.2010-11:02 - DEBUG - Set Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
    18.05.2010-11:02 - DEBUG - No Updated records found, starting only the core.
    18.05.2010-11:02 - DEBUG - Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
    18.05.2010-11:03 - DEBUG - Set Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
    18.05.2010-11:03 - DEBUG - No Updated records found, starting only the core.
    18.05.2010-11:03 - DEBUG - Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
    18.05.2010-11:04 - DEBUG - Set Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
    18.05.2010-11:04 - DEBUG - No Updated records found, starting only the core.
    18.05.2010-11:04 - DEBUG - Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
    18.05.2010-11:05 - DEBUG - Set Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
    18.05.2010-11:05 - DEBUG - No Updated records found, starting only the core.
    18.05.2010-11:05 - DEBUG - Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
    18.05.2010-11:06 - DEBUG - Set Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
    18.05.2010-11:06 - DEBUG - No Updated records found, starting only the core.
    18.05.2010-11:06 - DEBUG - Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
    18.05.2010-11:07 - DEBUG - Set Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
    18.05.2010-11:07 - DEBUG - No Updated records found, starting only the core.
    18.05.2010-11:07 - DEBUG - Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
    18.05.2010-11:08 - DEBUG - Set Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
    18.05.2010-11:08 - DEBUG - No Updated records found, starting only the core.
    18.05.2010-11:08 - DEBUG - Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
    18.05.2010-11:09 - DEBUG - Set Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
    18.05.2010-11:09 - DEBUG - No Updated records found, starting only the core.
    18.05.2010-11:09 - DEBUG - Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
    18.05.2010-11:10 - DEBUG - Set Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
    18.05.2010-11:10 - DEBUG - No Updated records found, starting only the core.
    18.05.2010-11:10 - DEBUG - Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
    18.05.2010-11:11 - DEBUG - Set Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
    18.05.2010-11:11 - DEBUG - No Updated records found, starting only the core.
    18.05.2010-11:11 - DEBUG - Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
    18.05.2010-11:12 - DEBUG - Set Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
    18.05.2010-11:12 - DEBUG - No Updated records found, starting only the core.
    18.05.2010-11:12 - DEBUG - Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
    18.05.2010-11:13 - DEBUG - Set Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
    18.05.2010-11:13 - DEBUG - No Updated records found, starting only the core.
    18.05.2010-11:13 - DEBUG - Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
    18.05.2010-11:14 - DEBUG - Set Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
    18.05.2010-11:14 - DEBUG - No Updated records found, starting only the core.
    18.05.2010-11:14 - DEBUG - Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
    18.05.2010-11:15 - DEBUG - Set Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
    18.05.2010-11:15 - DEBUG - No Updated records found, starting only the core.
    18.05.2010-11:15 - DEBUG - Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
    18.05.2010-11:16 - DEBUG - Set Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
    18.05.2010-11:16 - DEBUG - No Updated records found, starting only the core.
    18.05.2010-11:16 - DEBUG - Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
    


    okay, so how do i get the slave to request all of the email account information? do i need to change the password on all accounts? and how o i get it to request all of the domains and aliases?
     
  7. till

    till Super Moderator Howtoforge Staff HowtoForge Supporter ISPConfig Developer

    The slave mirrors only new changes. It is not able to request old changes. Have you added accounts before the setup was completed with the slave server?
     
  8. lifeisboost

    lifeisboost New Member

    yes this slave is a replacement for another server. so all accounts where setup on the master already.

    it seems there should be a script to allow everything to be replicated if you ever have to replace a slave on an existing master/slave setup.
     
  9. till

    till Super Moderator Howtoforge Staff HowtoForge Supporter ISPConfig Developer

    Ok. What you can do is that you copy the content of all mail_* database tables to the new server manually. This brute force nmethod will work for the mail system as the accounts are virtual users. It will not work for websites.
     
  10. lifeisboost

    lifeisboost New Member

    Thanks, thats what i figured had to be done. Could there be a solution added that when soemone adds a slave to an existing master there is a script that replicates this data?
     
  11. till

    till Super Moderator Howtoforge Staff HowtoForge Supporter ISPConfig Developer

    Feel free to make a feature request for it in the bugtracker :)
     

Share This Page