Installing A Web, Email & MySQL Database Cluster On Debian 6.0 With ISPConfig 3 - Page 5

5 Configure Replication In ISPConfig

Log into ISPConfig on the master server with a webbrowser:

http://192.168.0.105:8080

Click on System > Server Services > server2.example.tld:

Select "server1.example.tld" in the "is mirror of" field and click on Save.

Then open System > Server Config and enable the checkbox "Connect Linux userid to webid" on the "Web" tab:

 

6 Additional Notes

When you want to activate a firewall on the master or slave server, ensure that you open port 3306 for MySQL on both servers.

 

Share this page:

13 Comment(s)

Add comment

Comments

From: Anonymous at: 2012-02-18 19:03:48

Easy to understand written toutorial - but I miss some points you mentioned in the introduction:

 

This tutorial describes the installation of a clustered web, email, database and DNS server to be used for redundancyhigh availability and load balancing on Debian 6 with the ISPConfig 3...

 

What I miss are postfix (queue) redundancy, amavis (temp + quarantine)redundancy as well as handling logfiles (if complete logfiles to be archived for some month -> Vorratsdatenspeicherung). Just copying /vmail from server 1 to server 2 isn't redundancy, the loss of mails is possible.

How to switch between services (or servers) if one goes down or isn't reachable and how is load balancing solved?

just my 2 cents
Alois

From: nitesh at: 2014-08-28 14:03:08

Hello,

 I also read that tutorial and this is too good. But i just want to ask if my master server goes down then how can  i run services on server 2 so my webistes will not go down.

 Please update on this.

From: at: 2012-03-16 18:57:48

 Hello, What user and password i need to ISPConfig control panel login ?

From: at: 2012-03-27 06:06:43

The default ISPConfig login is:

Username: admin
Password: admin

From: at: 2012-04-12 08:06:47

How IspConfig 3 manage the load balancing apache clusters sessions?

From: qqkk at: 2012-04-29 15:15:17

Then open System > Server Config and enable the checkbox "Connect Linux userid to webid" on the "Web" tab:

this config for server1 or server2??

From: at: 2012-06-27 10:48:47

I've done on both servers and works correctly

From: Shelby99 at: 2012-05-11 15:49:13

Hi

I can't login on default admin admin account. Every time i try on both servers i get this error:

ERROR

Username or Password wrong.1

Password lost?
 

 Anybody know what to do?

From: Ariel at: 2012-10-18 17:25:01

Same incident here.

 I've used these queries to the DB:

 mysql> select username, passwort, md5('admin')  from sys_user\G

*************************** 1. row ***************************

    username: admin

    passwort: 21232f297a57a5a743894a0e4a801fc3

md5('admin'): 21232f297a57a5a743894a0e4a801fc3

1 row in set (0.00 sec)

So, the password for 'admin' user is 'admin' but the interface does not allow me to log on.

From: at: 2012-11-01 03:19:23

Get the password again:

Code:
grep -i db_password /usr/local/ispconfig/interface/lib/config.inc.php
Set the password:
Code:
mysql -u root -p
mysql> update mysql.user set password=PASSWORD("<PASSWORD>") where User='ispconfig';
mysql> flush privileges;
mysql> quit

From: Anonymous at: 2012-06-19 13:28:14

Hello! First of thank your very much for this nice tut. I also solved the problem regarding to the login problem for the ISPconfig web interface. 

Only one thing I left: The configuration at the end "Connect Linux userid to webid". Do I have to set this configuration for both servers?

 Thank you, mic.

From: berry at: 2013-02-17 19:55:11

hello, thank you very much unbelievable

From: at: 2013-04-11 10:03:58

Same question: How IspConfig 3 manage the load balancing and HA?