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

Want to support HowtoForge? Become a subscriber!
Submitted by till (Contact Author) (Forums) on Tue, 2012-02-14 16:43. ::

5 Configure Replication In ISPConfig

Log into ISPConfig on the master server with a webbrowser:

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.


7 Links

Please do not use the comment function to ask for help! If you need help, please use our forum.
Comments will be published after administrator approval.
Submitted by kike (registered user) on Thu, 2013-04-11 11:03.
Same question: How IspConfig 3 manage the load balancing and HA?
Submitted by berry (not registered) on Sun, 2013-02-17 20:55.
hello, thank you very much unbelievable
Submitted by Anonymous (not registered) on Tue, 2012-06-19 14:28.

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.

Submitted by Shelby99 (not registered) on Fri, 2012-05-11 16:49.


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


Username or Password wrong.1

Password lost?

 Anybody know what to do?

Submitted by Ariel (not registered) on Thu, 2012-10-18 18:25.

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.

Submitted by bholt (registered user) on Thu, 2012-11-01 04:19.
Get the password again:
grep -i db_password /usr/local/ispconfig/interface/lib/
Set the password:
mysql -u root -p
mysql> update mysql.user set password=PASSWORD("<PASSWORD>") where User='ispconfig';
mysql> flush privileges;
mysql> quit
Submitted by qqkk (not registered) on Sun, 2012-04-29 16:15.

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

this config for server1 or server2??

Submitted by diablo666 (registered user) on Wed, 2012-06-27 11:48.
I've done on both servers and works correctly
Submitted by esezako (registered user) on Thu, 2012-04-12 09:06.
How IspConfig 3 manage the load balancing apache clusters sessions?
Submitted by moshkys (registered user) on Fri, 2012-03-16 19:57.

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

Submitted by till (registered user) on Tue, 2012-03-27 07:06.
The default ISPConfig login is:

Username: admin
Password: admin

Submitted by Anonymous (not registered) on Sat, 2012-02-18 20:03.

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

Submitted by nitesh (not registered) on Thu, 2014-08-28 15:03.


 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.