restoring an ISP cluster

Hello,

I am trying to move our ISPConfig servers to a new virtual platform. I am having issues getting the mail users to copy of to the mail server. I have tried to resync the databases but they never get copied over,

I updated the server_id to match the new mail servers_id, I have verified server connections and job queue processing

What am I doing wrong ?

 

227712 mail1 (new mail server)

214618 web1 (master server)


How do i correct this ? Just change the mail server value to the web servers value ?

sys_datalog.datalog_id has 0 rows on mail1

and now the Jobqueue for mail1 is 12k backed up , when I run the update command it just hangs

 

database connection has been verified

mysql -h web1 -u ispcsrv7 -p dbispconfig
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3646
Server version: 5.5.32-0ubuntu0.12.04.1 (Ubuntu)

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show tables;
+-----------------------+
| Tables_in_dbispconfig |
+-----------------------+
| aps_instances |
| mail_traffic |
| monitor_data |
| server |
| software_update_inst |
| sys_datalog |
| sys_group |
| sys_log |
| sys_remoteaction |
| web_backup |
| web_domain |
| web_traffic |
+-----------------------+
12 rows in set (0.00 sec)

 

[RESOLVED]
The issue was with the file permissions on /var/vmail They where still being rsynced. Setting the correct file permissions allowed for user replication
[/RESOLVED]


server.php output

It looks like it replicates one user then stops

5.08.2013-15:38 - DEBUG - Set Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
15.08.2013-15:38 - DEBUG - Set Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
15.08.2013-15:38 - DEBUG - Found 12194 changes, starting update process.
15.08.2013-15:38 - DEBUG - Found 12194 changes, starting update process.
15.08.2013-15:38 - DEBUG - Replicated from master: REPLACE INTO mail_user (`mailuser_id`,`sys_userid`,`sys_groupid`,`sys_perm_user`,`sys_perm_group`,`sys_perm_other`,`server_id`,`email`,`password`,`name`,`uid`,`gid`,`maildir`,`quota`,`cc`,`homedir`,`autoresponder`,`autoresponder_start_date`,`autoresponder_end_date`,`autoresponder_subject`,`autoresponder_text`,`move_junk`,`custom_mailfilter`,`postfix`,`access`,`disableimap`,`disablepop3`,`disabledeliver`,`disablesmtp`,`login`,`disablesieve`,`disablelda`,`disabledoveadm`,`last_quota_notification`) VALUES ('7541','28','257','riud','riud','','7','[email protected]','$1$4h64EgUw$skQVTje0nejGjM4XBnhjH.','288677','5000','5000','/var/vmail/XXXX.net/dandpmarine','53477376','','/var/vmail','n','0000-00-00 00:00:00','0000-00-00 00:00:00','Out of office reply','','y','','y','n','n','n','n','n','[email protected]','n','n','n','0000-00-00')
15.08.2013-15:38 - DEBUG - Replicated from master: REPLACE INTO mail_user (`mailuser_id`,`sys_userid`,`sys_groupid`,`sys_perm_user`,`sys_perm_group`,`sys_perm_other`,`server_id`,`email`,`password`,`name`,`uid`,`gid`,`maildir`,`quota`,`cc`,`homedir`,`autoresponder`,`autoresponder_start_date`,`autoresponder_end_date`,`autoresponder_subject`,`autoresponder_text`,`move_junk`,`custom_mailfilter`,`postfix`,`access`,`disableimap`,`disablepop3`,`disabledeliver`,`disablesmtp`,`login`,`disablesieve`,`disablelda`,`disabledoveadm`,`last_quota_notification`) VALUES ('7541','28','257','riud','riud','','7','[email protected]','$1$4h64EgUw$skQVTje0nejGjM4XBnhjH.','288677','5000','5000','/var/vmail/XXXXX.net/dandpmarine','53477376','','/var/vmail','n','0000-00-00 00:00:00','0000-00-00 00:00:00','Out of office reply','','y','','y','n','n','n','n','n','[email protected]','n','n','n','0000-00-00')
15.08.2013-15:38 - DEBUG - Calling function 'user_update' from plugin 'mail_plugin' raised by event 'mail_user_update'.
15.08.2013-15:38 - DEBUG - Calling function 'user_update' from plugin 'mail_plugin' raised by event 'mail_user_update'.

 

Thanks Till !