mirroring issue

[lifeisboost]

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.

[till]

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.

[damir]

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

[lifeisboost]

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

[till]

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.

[lifeisboost]

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?

[till]

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?

[lifeisboost]

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.

[till]

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.

[lifeisboost]

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?