multi server ispconfig

Discussion in 'Installation/Configuration' started by chief, Apr 2, 2019.

  1. chief

    chief Member

    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?
     
  2. nhybgtvfr

    nhybgtvfr Active Member

    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.
     
  3. chief

    chief Member

    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)
     
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    This happens when the hostnames of the servers are not setup correctly in the /etc/hosts file on both systems before you start the installation or when you blocked access to mysql from slave server. The slave is now unable connect to master which means that it can not fetch any config changes. If its the hostname problem, then you will have to fix the hosts files, then run an ispconfig update on the slave and choose to reconfigure permissions in master database. And if you blocked mysql access with a firewall, unblock it.
     
  5. nhybgtvfr

    nhybgtvfr Active Member

    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.
     
  6. chief

    chief Member

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

    chief Member

    i checked the firewall, ran in terminal on master server
    Code:
    [email protected]:/home/dave# ufw status
    Status: inactive
    [email protected]:/home/dave# ufw enable
    Command may disrupt existing ssh connections. Proceed with operation (y|n)? y
    Firewall is active and enabled on system startup
    [email protected]:/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
     
  8. chief

    chief Member

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

Share This Page