Ok i want/need a HA setup for pop boxs and apache. so all requests come into a public ip and the router/firewall then passes that to one of x servers in the group, So if a box fails its just a case forwarding the traffic to the lowest load box. The traffic routing isnt a problem the mailboxs are. I have setup a vanilla install of ISPConfig 3 RC1 on ubuntu 8.10 base without any real problems and obviously need to setup another (The aim is for 4) Now HA with apache is fairly easy just sync the site dbs apache/config and contents (unless im missing something) my problem lies in A: Syncing the pop user (ISPConfig added) database between all servers in the group B: Making all the mailboxs available on all servers and in sync now i think i have a way of syncing the mailboxs (once created) using imapsync from a script using a csv for the user passwords (security?) I just need a way of only having to enter new users sites etc on one of the ISPConfig servers. If you spot a glaring hole in this plan please stop me now If there is a way to automate this as much as possible i am more than open to suggestions Fr0sty
Just create one master server in ispconfig 3 and add all other servers as additional servers. The edit the file /usr/local/ispconfig/server/lib/config.inc.php on all slave servers and set the server_id to the same Id then the master server (most likely server_id = 1) so that all other servers replicate the configuration done on the master server. Then delete all entrys in the server database table except of the entry for the master server.
First thx for the reply this sounds like the perfect answer to my problem i am having a few issues with virtual users in pop3 first i need to iron out but will start a new thread. Fr0sty
right i think i have followed your instructions right i have installed master working fine attached a slave Then edited /usr/local/ispconfig/server/lib/config.inc.php on the slave and set its server id to 1 (same as the master) Removed the entry in the master db for the slave server Code: mysql> SELECT * FROM `server` LIMIT 0, 30 ; +-----------+------------+-------------+---------------+----------------+----------------+---------------------+-------------+------------+------------+-------------+-----------+----------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------+--------+ | server_id | sys_userid | sys_groupid | sys_perm_user | sys_perm_group | sys_perm_other | server_name | mail_server | web_server | dns_server | file_server | db_server | vserver_server | config | updated | active | +-----------+------------+-------------+---------------+----------------+----------------+---------------------+-------------+------------+------------+-------------+-----------+----------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------+--------+ | 1 | 1 | 1 | riud | riud | r | master.wkdr3d.co.uk | 1 | 1 | 1 | 1 | 1 | 1 | [global] webserver=apache mailserver=postfix dnsserver=mydns [server] auto_network_configuration=n ip_address=192.168.0.105 netmask=255.255.255.0 gateway=192.168.0.1 hostname=server1.domain.tld nameservers=192.168.0.1,192.168.0.2 [mail] module=postfix_mysql maildir_path=/var/vmail/[domain]/[localpart] homedir_path=/var/vmail mailuser_uid=5000 mailuser_gid=5000 mailuser_name=vmail mailuser_group=vmail relayhost= relayhost_user= relayhost_password= mailbox_size_limit=0 message_size_limit=0 [getmail] getmail_config_dir=/etc/getmail [web] website_path=/var/clients/client[client_id]/web[website_id] website_symlinks=/var/www/[website_domain]/:/var/clients/client[client_id]/[website_domain]/ vhost_conf_dir=/etc/apache2/sites-available vhost_conf_enabled_dir=/etc/apache2/sites-enabled [fastcgi] fastcgi_starter_path=/var/www/php-fcgi-scripts/[system_user]/ fastcgi_starter_script=.php-fcgi-starter fastcgi_alias=/php/ fastcgi_phpini_path=/etc/php5/cgi/ fastcgi_children=8 fastcgi_max_requests=5000 fastcgi_bin=/usr/bin/php-cgi [jailkit] jailkit_chroot_home=/home/[username] jailkit_chroot_app_sections=basicshell editors extendedshell netutils ssh sftp scp groups jk_lsh jailkit_chroot_app_programs=/usr/bin/groups /usr/bin/id /usr/bin/dircolors /usr/bin/lesspipe /usr/bin/basename /usr/bin/dirname /usr/bin/nano /usr/bin/pico | 24 | 1 | +-----------+------------+-------------+---------------+----------------+----------------+---------------------+-------------+------------+------------+-------------+-----------+----------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------+--------+ 1 row in set (0.00 sec) And the same query on the slave Code: Database changed mysql> SELECT * FROM `server` LIMIT 0, 30 ; +-----------+------------+-------------+---------------+----------------+----------------+---------------------+-------------+------------+------------+-------------+-----------+----------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------+--------+ | server_id | sys_userid | sys_groupid | sys_perm_user | sys_perm_group | sys_perm_other | server_name | mail_server | web_server | dns_server | file_server | db_server | vserver_server | config | updated | active | +-----------+------------+-------------+---------------+----------------+----------------+---------------------+-------------+------------+------------+-------------+-----------+----------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------+--------+ | 1 | 1 | 1 | riud | riud | r | master.wkdr3d.co.uk | 1 | 1 | 1 | 1 | 1 | 1 | [global] webserver=apache mailserver=postfix dnsserver=mydns [server] auto_network_configuration=n ip_address=192.168.0.105 netmask=255.255.255.0 gateway=192.168.0.1 hostname=server1.domain.tld nameservers=192.168.0.1,192.168.0.2 [mail] module=postfix_mysql maildir_path=/var/vmail/[domain]/[localpart] homedir_path=/var/vmail mailuser_uid=5000 mailuser_gid=5000 mailuser_name=vmail mailuser_group=vmail relayhost= relayhost_user= relayhost_password= mailbox_size_limit=0 message_size_limit=0 [getmail] getmail_config_dir=/etc/getmail [web] website_path=/var/clients/client[client_id]/web[website_id] website_symlinks=/var/www/[website_domain]/:/var/clients/client[client_id]/[website_domain]/ vhost_conf_dir=/etc/apache2/sites-available vhost_conf_enabled_dir=/etc/apache2/sites-enabled [fastcgi] fastcgi_starter_path=/var/www/php-fcgi-scripts/[system_user]/ fastcgi_starter_script=.php-fcgi-starter fastcgi_alias=/php/ fastcgi_phpini_path=/etc/php5/cgi/ fastcgi_children=8 fastcgi_max_requests=5000 fastcgi_bin=/usr/bin/php-cgi [jailkit] jailkit_chroot_home=/home/[username] jailkit_chroot_app_sections=basicshell editors extendedshell netutils ssh sftp scp groups jk_lsh jailkit_chroot_app_programs=/usr/bin/groups /usr/bin/id /usr/bin/dircolors /usr/bin/lesspipe /usr/bin/basename /usr/bin/dirname /usr/bin/nano /usr/bin/pico | 0 | 1 | +-----------+------------+-------------+---------------+----------------+----------------+---------------------+-------------+------------+------------+-------------+-----------+----------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------+--------+ 1 row in set (0.00 sec) Added some domains and email accounts on the master then watched them leave the job queue but they dont get replicated Any ideas?
The server table in the slave db only contained its own record ? with server id of 2 The MasterDB has both server records I did try to break down how the replication proccess works started with the cron then checked server.php (enabled DEBUG) made sure the user/pass in the config file could access the masterdb Yes ran php -q server.php to initiate an update and it gives the "No Updated records found, starting only the core" from the Else statement in the update check as $tmp_num_records returns no value. even though on the masterdb the sys_datalog table contains entrys marked pending with server id of 1 Need to eat now will take a break for a while, my heads shot .