multi server ispconfig

Hi,
I have a working multi server setup of control / web server, a mail server and 2 dns servers.
what i want to achieve is another web server with its own emails and databases so i can rent that to a customer, so it is self contained.
I did try standalone and get my dns servers todo dmarc, spf and dkim, but as the client, web site, email domain and mail boxes are not created or configured via the control panel- it didnt 100% work. cannot create dmarc records and using mxtoolbox.com fails tests.
what would the best route be for me to do this?

 

i've not done this with emails, i've always just used a single central server for that, but it should work the same.
what i've done is just installed another server following the perfect server tutorials. install ispconfig onto it, joining it to the existing multi-server setup.
you will need to have mail, web, file, and DB services enabled on the server under system - server services.
and you'll need to configure each service correctly.
then either create a new limit template, specifying only that server for web/email/database limits. and assign that template to the client.
or when adding a client, change to the limits tab, and specify the server there for web/email/database with a custom config.

 

Having this issue now, i did read it maybe because installer is using a
Unable to connect to mysql server Access denied for user 'root'@'new.server' (using password: YES)

 

is this when trying to join the new server to the existing multi-server setup?

did you create the root account on the master servers MySQL first?

CREATE USER 'root'@'192.168.0.107' IDENTIFIED BY 'myrootpassword';
GRANT ALL PRIVILEGES ON * . * TO 'root'@'192.168.0.107' 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 ;
CREATE USER 'root'@'ns1.example.tld' IDENTIFIED BY 'myrootpassword';
GRANT ALL PRIVILEGES ON * . * TO 'root'@'ns1.example.tld' 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 ;

changing '192.168.0.107', 'ns1.example.tld' and 'myrootpassword' as necessary.

 

yes, i created the 2 accounts. IPaddress and hostname.

 

i checked the firewall, ran in terminal on master server

Code:

root@web:/home/dave# ufw status
Status: inactive
root@web:/home/dave# ufw enable
Command may disrupt existing ssh connections. Proceed with operation (y|n)? y
Firewall is active and enabled on system startup
root@web:/home/dave# ufw status
Status: active

now when i run the setup, it tries to connect but times out. I did read that by default it should be disbled. so at this point not sure of a direction to follow.
do i enable the UFW, next question is how do i allow 1 IP in. if not and UFW stays disabled what could be stopping it.
you did say it may be blocked by MYSQL, but if i added the 2 accounts (IP and hostname) does that allow it?

I await the words of wisdom

dave

 

we had a silly moment, used wrong password. now sorted..