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:

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.

 

7 Links

up

Copyright © 2012 Till Brehm
All Rights Reserved.
add comment | view as pdf view as pdf | print: this | all page(s)
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.
load balancing and HA?
Submitted by kike (registered user) on Thu, 2013-04-11 11:03.
Same question: How IspConfig 3 manage the load balancing and HA?
reply | view as pdf view as pdf
thank you
Submitted by berry (not registered) on Sun, 2013-02-17 20:55.
hello, thank you very much unbelievable
reply | view as pdf view as pdf
Hello! First of thank your
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.

reply | view as pdf view as pdf
Can't do the first login
Submitted by Shelby99 (not registered) on Fri, 2012-05-11 16:49.

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?

reply | view as pdf view as pdf
Re: Can't do the first login
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.

reply | view as pdf view as pdf
Re: Re: Can't do the first login
Submitted by bholt (registered user) on Thu, 2012-11-01 04:19.
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
reply | view as pdf view as pdf
Then open System > Server
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??

reply | view as pdf view as pdf
Re: Then open System > Server
Submitted by diablo666 (registered user) on Wed, 2012-06-27 11:48.
I've done on both servers and works correctly
reply | view as pdf view as pdf
How IspConfig 3 manage the
Submitted by esezako (registered user) on Thu, 2012-04-12 09:06.
How IspConfig 3 manage the load balancing apache clusters sessions?
reply | view as pdf view as pdf
log in problem
Submitted by moshkys (registered user) on Fri, 2012-03-16 19:57.

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

reply | view as pdf view as pdf
Re: log in problem
Submitted by till (registered user) on Tue, 2012-03-27 07:06.
The default ISPConfig login is:

Username: admin
Password: admin

reply | view as pdf view as pdf
This tutorial describes the
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 redundancy,  high 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

reply | view as pdf view as pdf