restoring an ISP cluster

Discussion in 'ISPConfig 3 Priority Support' started by lee.veal, Aug 15, 2013.

  1. lee.veal

    lee.veal Member HowtoForge Supporter

    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 ?
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    Check that the value in the "updated" column of this server in the "server" table on the master is not higher then the highs datalog_id in the sys_datalog column as a server node processes only changes were sys_datalog.datalog_id < server.updated
     
  3. lee.veal

    lee.veal Member HowtoForge Supporter

    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
     
    Last edited: Aug 15, 2013
  4. lee.veal

    lee.veal Member HowtoForge Supporter

    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)
     
  5. lee.veal

    lee.veal Member HowtoForge Supporter

    [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'.
     
    Last edited: Aug 15, 2013
  6. till

    till Super Moderator Staff Member ISPConfig Developer

    They dont have o be the, same number as not all changes are or all servers. So the value in updated column is the last change that was made for this server.
     
  7. lee.veal

    lee.veal Member HowtoForge Supporter

    Thanks Till !
     

Share This Page