Hi! I did your HOW TO for multiserver setup: https://www.howtoforge.com/multiser...se-servers-on-debian-squeeze-with-ispconfig-3 But i did it with 2 vm Ubuntu 14.04 servers, one master for all except mail and the slave only for mail. When installing the mail server with instructions for ISPConfig 3 install: Select language (en,de) [en]: <-- en Installation mode (standard,expert) [standard]: <-- expert Full qualified hostname (FQDN) of the server, eg server1.domain.tld [mail.example.tld]: <-- mail.example.tld MySQL server hostname [localhost]: <-- localhost MySQL root username [root]: <-- root MySQL root password []: <-- Enter your MySQL root password here MySQL database to create [dbispconfig]: <-- dbispconfig MySQL charset [utf8]: <-- utf8 Shall this server join an existing ISPConfig multiserver setup (y,n) [n]: <-- y MySQL master server hostname []: <-- web.example.tld MySQL master server root username [root]: <-- root MySQL master server root password []: <-- Enter the root password of the master server here MySQL master server database name [dbispconfig]: <-- dbispconfig Configure Mail (y,n) [y]: <-- y At this setting i had to input the password off the slave server else it said "Unable to connect to MySql"! MySQL master server root password []: <-- Enter the root password of the master server And i from the slave server i can ping the master and also connect to it's mysql with mysql -u root -p -h <master-server-ip>. After this i could install ISpconfig and connect the servers in ISPConfig off the master-server. So my questions are: 1. Is there an mistake in the how to or is my install wrong? 2. On what server should i install Squirrelmail, and can i install it after ispconfig? 3. How to test, see if it works.... does it create any syslinks or files on the mail-server when i create email domain and mailbox? I can't test the emails because i'm allready running a mail serve... at least i think i can't. Thanks for help and your HOW TO guides!
Make sure you have the MYSQL privileges setup on the master. Like: CREATE USER 'root'@'192.168.0.106' IDENTIFIED BY 'myrootpassword'; GRANT ALL PRIVILEGES ON * . * TO 'root'@'192.168.0.106' IDENTIFIED BY 'myrootpassword' WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ; If using a Firewall make sure port 3306 is open on the master.
Thanks for the quick awnser. Yes i have set privileges on the master that way and for the conn from the hostname to. Do all slave servers need the same mysql password as master?
Your DB server is not fail-safe and if your MySQL server fails you'll have a downtime. Take a look here for basic example of MySQL failover setup. Check you MySQL bind address on both servers and also check if your iptables config allows remote connections to the TCP:3306 port.
I followed these steps (source: cibercity.biz) At /etc/my.cnf [mysqld] user = mysql pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port = 3306 basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp language = /usr/share/mysql/English bind-address = 65.55.55.2 # skip-networking
