#1  
Old 15th August 2013, 01:42
lee.veal lee.veal is offline
Member
 
Join Date: Apr 2013
Posts: 34
Thanks: 6
Thanked 5 Times in 5 Posts
Default 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 ?
Reply With Quote
Sponsored Links
  #2  
Old 15th August 2013, 08:13
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 35,778
Thanks: 821
Thanked 5,333 Times in 4,184 Posts
Default

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
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 15th August 2013, 15:24
lee.veal lee.veal is offline
Member
 
Join Date: Apr 2013
Posts: 34
Thanks: 6
Thanked 5 Times in 5 Posts
Default

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 by lee.veal; 15th August 2013 at 15:56.
Reply With Quote
  #4  
Old 15th August 2013, 16:08
lee.veal lee.veal is offline
Member
 
Join Date: Apr 2013
Posts: 34
Thanks: 6
Thanked 5 Times in 5 Posts
Default

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)
Reply With Quote
  #5  
Old 15th August 2013, 17:44
lee.veal lee.veal is offline
Member
 
Join Date: Apr 2013
Posts: 34
Thanks: 6
Thanked 5 Times in 5 Posts
Angry

[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_per m_user`,`sys_perm_group`,`sys_perm_other`,`server_ id`,`email`,`password`,`name`,`uid`,`gid`,`maildir `,`quota`,`cc`,`homedir`,`autoresponder`,`autoresp onder_start_date`,`autoresponder_end_date`,`autore sponder_subject`,`autoresponder_text`,`move_junk`, `custom_mailfilter`,`postfix`,`access`,`disableima p`,`disablepop3`,`disabledeliver`,`disablesmtp`,`l ogin`,`disablesieve`,`disablelda`,`disabledoveadm` ,`last_quota_notification`) VALUES ('7541','28','257','riud','riud','','7','dandpmari ne@XXXX.net','$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','dandpmar ine@XXXXX.net','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_per m_user`,`sys_perm_group`,`sys_perm_other`,`server_ id`,`email`,`password`,`name`,`uid`,`gid`,`maildir `,`quota`,`cc`,`homedir`,`autoresponder`,`autoresp onder_start_date`,`autoresponder_end_date`,`autore sponder_subject`,`autoresponder_text`,`move_junk`, `custom_mailfilter`,`postfix`,`access`,`disableima p`,`disablepop3`,`disabledeliver`,`disablesmtp`,`l ogin`,`disablesieve`,`disablelda`,`disabledoveadm` ,`last_quota_notification`) VALUES ('7541','28','257','riud','riud','','7','dandpmari ne@XXXXX.net','$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','dandpmar ine@XXXXX.net','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 by lee.veal; 15th August 2013 at 17:56.
Reply With Quote
  #6  
Old 15th August 2013, 20:03
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 35,778
Thanks: 821
Thanked 5,333 Times in 4,184 Posts
Default

Quote:
Originally Posted by lee.veal View Post
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
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.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
The Following User Says Thank You to till For This Useful Post:
lee.veal (15th August 2013)
  #7  
Old 15th August 2013, 21:52
lee.veal lee.veal is offline
Member
 
Join Date: Apr 2013
Posts: 34
Thanks: 6
Thanked 5 Times in 5 Posts
 
Smile

Thanks Till !
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
mysql and mail problem viritech General 3 16th October 2012 12:54
error after apt-get update (lwresd) ngoyette Installation/Configuration 2 1st October 2012 18:27
ISP Config 3 Postfix won't receive external mail pchelp2u Server Operation 18 19th August 2011 15:31
ISPConfig3 Mail Warn Errors reason8 General 3 25th November 2009 13:58
How to retrieve email? (Postfix / Courier) Merritt General 20 5th April 2009 14:26


All times are GMT +2. The time now is 22:56.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.