Adding New server to Mutilserver

Discussion in 'Installation/Configuration' started by DWChris, Jan 8, 2018.

  1. DWChris

    DWChris New Member

    Hi,
    I am very new to ISPconfig and a bit of novice Linux user.

    I have been tasked with adding a second dns server to our exsisting multiserver setup. running through the guides and using the setup script I am getting the following errors.

    Code:
    Adding ISPConfig server record to database.
    
    PHP Warning:  mysqli_query(): MySQL server has gone away in /tmp/ispconfig3_install/install/lib/mysql.lib.php on line 233
    PHP Warning:  mysqli_query(): Error reading result set's header in /tmp/ispconfig3_install/install/lib/mysql.lib.php on line 233
    WARNING: Unable to set rights of user in master database: dbispconfig
    Query: GRANT SELECT ON ?? TO [email protected]?
    Error:
    WARNING: Unable to set rights of user in master database: dbispconfig
    Query: GRANT SELECT, INSERT ON ?? TO [email protected]?
    Error:
    WARNING: Unable to set rights of user in master database: dbispconfig
    Query: GRANT SELECT, UPDATE(`status`, `error`) ON ?? TO [email protected]?
    Error:
    WARNING: Unable to set rights of user in master database: dbispconfig
    Query: GRANT SELECT, UPDATE(`status`) ON ?? TO [email protected]?
    Error:
    WARNING: Unable to set rights of user in master database: dbispconfig
    Query: GRANT SELECT, UPDATE(`updated`) ON ?? TO [email protected]?
    Error:
    WARNING: Unable to set rights of user in master database: dbispconfig
    Query: GRANT SELECT, UPDATE (`ssl`, `ssl_letsencrypt`, `ssl_request`, `ssl_cert`, `ssl_action`, `ssl_key`) ON ?? TO [email protected]?
    Error:
    WARNING: Unable to set rights of user in master database: dbispconfig
    Query: GRANT SELECT ON ?? TO [email protected]?
    Error:
    WARNING: Unable to set rights of user in master database: dbispconfig
    Query: GRANT SELECT, UPDATE (`action_state`, `response`) ON ?? TO [email protected]?
    Error:
    WARNING: Unable to set rights of user in master database: dbispconfig
    Query: GRANT SELECT, INSERT , DELETE ON ?? TO [email protected]?
    Error:
    WARNING: Unable to set rights of user in master database: dbispconfig
    Query: GRANT SELECT, INSERT, UPDATE ON ?? TO [email protected]?
    Error:
    WARNING: Unable to set rights of user in master database: dbispconfig
    Query: GRANT SELECT, INSERT, UPDATE ON ?? TO [email protected]?
    Error:
    WARNING: Unable to set rights of user in master database: dbispconfig
    Query: GRANT SELECT, UPDATE, DELETE ON ?? TO [email protected]?
    Error:
    WARNING: Unable to set rights of user in master database: dbispconfig
    Query: GRANT SELECT, DELETE ON ?? TO [email protected]?
    Error:
    WARNING: Unable to set rights of user in master database: dbispconfig
    Query: GRANT SELECT, INSERT, DELETE ON ?? TO [email protected]?
    Error:
    WARNING: Unable to set rights of user in master database: dbispconfig
    Query: GRANT SELECT, INSERT, DELETE ON ?? TO [email protected]?
    Error:
    WARNING: Unable to set rights of user in master database: dbispconfig
    Query: GRANT SELECT, UPDATE(`dnssec_initialized`, `dnssec_info`, `dnssec_last_signed`) ON ?? TO [email protected]?
    Error:
    WARNING: Unable to set rights of user in master database: dbispconfig
    Query: GRANT SELECT, INSERT, UPDATE ON ?? TO [email protected]?
    Error:
    WARNING: Unable to set rights of user in master database: dbispconfig
    Query: GRANT SELECT ON ?? TO [email protected]?
    Error:
    WARNING: Unable to set rights of user in master database: dbispconfig
    Query: GRANT SELECT, INSERT ON ?? TO [email protected]?
    Error:
    WARNING: Unable to set rights of user in master database: dbispconfig
    Query: GRANT SELECT, UPDATE(`status`, `error`) ON ?? TO [email protected]?
    Error:
    WARNING: Unable to set rights of user in master database: dbispconfig
    Query: GRANT SELECT, UPDATE(`status`) ON ?? TO [email protected]?
    Error:
    WARNING: Unable to set rights of user in master database: dbispconfig
    Query: GRANT SELECT, UPDATE(`updated`) ON ?? TO [email protected]?
    Error:
    WARNING: Unable to set rights of user in master database: dbispconfig
    Query: GRANT SELECT, UPDATE (`ssl`, `ssl_letsencrypt`, `ssl_request`, `ssl_cert`, `ssl_action`, `ssl_key`) ON ?? TO [email protected]?
    Error:
    WARNING: Unable to set rights of user in master database: dbispconfig
    Query: GRANT SELECT ON ?? TO [email protected]?
    Error:
    WARNING: Unable to set rights of user in master database: dbispconfig
    Query: GRANT SELECT, UPDATE (`action_state`, `response`) ON ?? TO [email protected]?
    Error:
    WARNING: Unable to set rights of user in master database: dbispconfig
    Query: GRANT SELECT, INSERT , DELETE ON ?? TO [email protected]?
    Error:
    WARNING: Unable to set rights of user in master database: dbispconfig
    Query: GRANT SELECT, INSERT, UPDATE ON ?? TO [email protected]?
    Error:
    WARNING: Unable to set rights of user in master database: dbispconfig
    Query: GRANT SELECT, INSERT, UPDATE ON ?? TO [email protected]?
    Error:
    WARNING: Unable to set rights of user in master database: dbispconfig
    Query: GRANT SELECT, UPDATE, DELETE ON ?? TO [email protected]?
    Error:
    WARNING: Unable to set rights of user in master database: dbispconfig
    Query: GRANT SELECT, DELETE ON ?? TO [email protected]?
    Error:
    WARNING: Unable to set rights of user in master database: dbispconfig
    Query: GRANT SELECT, INSERT, DELETE ON ?? TO [email protected]?
    Error:
    WARNING: Unable to set rights of user in master database: dbispconfig
    Query: GRANT SELECT, INSERT, DELETE ON ?? TO [email protected]?
    Error:
    WARNING: Unable to set rights of user in master database: dbispconfig
    Query: GRANT SELECT, UPDATE(`dnssec_initialized`, `dnssec_info`, `dnssec_last_signed`) ON ?? TO [email protected]?
    Error:
    WARNING: Unable to set rights of user in master database: dbispconfig
    Query: GRANT SELECT, INSERT, UPDATE ON ?? TO [email protected]?
    Error:
    
    After the errors it then wants to proceed with the rest of the script and after choosing the dns option and leaving the others it says ISPconfig has been installed, it does not show up on the web interface and the installer wont run again because it thinks its already installed. (luckily I have a snapshot from just before running the install so can get back and run it again.)
    The new server is centos and the master is ubuntu.
    I have made sure they are in each others host files.
    The master sql has permissions for [email protected] and [email protected]
    I have confirmed that I can login to mysql from the slave onto the master ok.

    Any help with the issue would be much appreciated.
    Thanks
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    The installer asked for the mysql root password of the master server and it seems that you used a mysql user there which was not the root user (has not the same permissions than the root user) and therefore, the installation failed. The grant permission seems to be missing for the mysql user you used.
     
  3. DWChris

    DWChris New Member

    Hi thanks for replying so quickly.

    I have checked the permissions and it looks like they should be ok?

    Code:
    mysql> SHOW GRANTS FOR 'root'@'slaveip';
    +--------------------------------------------------------------------------------------------------------------------------------------------+
    | Grants for [email protected]                                                                                                              |
    +--------------------------------------------------------------------------------------------------------------------------------------------+
    | GRANT ALL PRIVILEGES ON *.* TO 'root'@'slaveip' IDENTIFIED BY PASSWORD '-----' WITH GRANT OPTION |
    +--------------------------------------------------------------------------------------------------------------------------------------------+
    
    
    
    mysql> SHOW GRANTS FOR 'root'@'slavehostname';
    +---------------------------------------------------------------------------------------------------------------------------------------------+
    | Grants for [email protected]                                                                                                              |
    +---------------------------------------------------------------------------------------------------------------------------------------------+
    | GRANT ALL PRIVILEGES ON *.* TO 'root'@'slavehostname' IDENTIFIED BY PASSWORD '-----' WITH GRANT OPTION |
    +---------------------------------------------------------------------------------------------------------------------------------------------+
     
  4. DWChris

    DWChris New Member

    Just to add a bit more info in case it helps for any more suggestions.
    The master server is version 3.0.4.5 and the errors I reported above are from doing a new slave install using version 3.1.10.
    When trying to install the slave using the 3.0.4.5 setup it is a similar but different error as follows.
    Code:
    Adding ISPConfig server record to database.
    
    WARNING: Unable to set rights of user in master database: dbispconfig
    Query: GRANT SELECT ON dbispconfig.`server` TO 'ispcsrv0'@'slavehostname'
    Error: MySQL server has gone away
    WARNING: Unable to set rights of user in master database: dbispconfig
    Query: GRANT SELECT, INSERT ON dbispconfig.`sys_log` TO 'ispcsrv0'@'slavehostname'
    Error: MySQL server has gone away
    WARNING: Unable to set rights of user in master database: dbispconfig
    Query: GRANT SELECT, UPDATE(`status`) ON dbispconfig.`sys_datalog` TO 'ispcsrv0'@'slavehostname'
    Error: MySQL server has gone away
    WARNING: Unable to set rights of user in master database: dbispconfig
    Query: GRANT SELECT, UPDATE(`status`) ON dbispconfig.`software_update_inst` TO 'ispcsrv0'@'slavehostname'
    Error: MySQL server has gone away
    WARNING: Unable to set rights of user in master database: dbispconfig
    Query: GRANT SELECT, UPDATE(`updated`) ON dbispconfig.`server` TO 'ispcsrv0'@'slavehostname'
    Error: MySQL server has gone away
    WARNING: Unable to set rights of user in master database: dbispconfig
    Query: GRANT SELECT, UPDATE (`ssl_request`, `ssl_cert`, `ssl_action`) ON dbispconfig.`web_domain` TO 'ispcsrv0'@'slavehostname'
    Error: MySQL server has gone away
    WARNING: Unable to set rights of user in master database: dbispconfig
    Query: GRANT SELECT ON dbispconfig.`sys_group` TO 'ispcsrv0'@'slavehostname'
    Error: MySQL server has gone away
    WARNING: Unable to set rights of user in master database: dbispconfig
    Query: GRANT SELECT, UPDATE (`action_state`, `response`) ON dbispconfig.`sys_remoteaction` TO 'ispcsrv0'@'slavehostname'
    Error: MySQL server has gone away
    WARNING: Unable to set rights of user in master database: dbispconfig
    Query: GRANT SELECT, INSERT , DELETE ON dbispconfig.`monitor_data` TO 'ispcsrv0'@'slavehostname'
    Error: MySQL server has gone away
    WARNING: Unable to set rights of user in master database: dbispconfig
    Query: GRANT SELECT, INSERT, UPDATE ON dbispconfig.`mail_traffic` TO 'ispcsrv0'@'slavehostname'
    Error: MySQL server has gone away
    WARNING: Unable to set rights of user in master database: dbispconfig
    Query: GRANT SELECT, INSERT, UPDATE ON dbispconfig.`web_traffic` TO 'ispcsrv0'@'slavehostname'
    Error: MySQL server has gone away
    WARNING: Unable to set rights of user in master database: dbispconfig
    Query: GRANT SELECT ON dbispconfig.`server` TO 'ispcsrv0'@'slaveip'
    Error: MySQL server has gone away
    WARNING: Unable to set rights of user in master database: dbispconfig
    Query: GRANT SELECT, INSERT ON dbispconfig.`sys_log` TO 'ispcsrv0'@'slaveip'
    Error: MySQL server has gone away
    WARNING: Unable to set rights of user in master database: dbispconfig
    Query: GRANT SELECT, UPDATE(`status`) ON dbispconfig.`sys_datalog` TO 'ispcsrv0'@'slaveip'
    Error: MySQL server has gone away
    WARNING: Unable to set rights of user in master database: dbispconfig
    Query: GRANT SELECT, UPDATE(`status`) ON dbispconfig.`software_update_inst` TO 'ispcsrv0'@'slaveip'
    Error: MySQL server has gone away
    WARNING: Unable to set rights of user in master database: dbispconfig
    Query: GRANT SELECT, UPDATE(`updated`) ON dbispconfig.`server` TO 'ispcsrv0'@'slaveip'
    Error: MySQL server has gone away
    WARNING: Unable to set rights of user in master database: dbispconfig
    Query: GRANT SELECT, UPDATE (`ssl_request`, `ssl_cert`, `ssl_action`) ON dbispconfig.`web_domain` TO 'ispcsrv0'@'slaveip'
    Error: MySQL server has gone away
    WARNING: Unable to set rights of user in master database: dbispconfig
    Query: GRANT SELECT ON dbispconfig.`sys_group` TO 'ispcsrv0'@'slaveip'
    Error: MySQL server has gone away
    WARNING: Unable to set rights of user in master database: dbispconfig
    Query: GRANT SELECT, UPDATE (`action_state`, `response`) ON dbispconfig.`sys_remoteaction` TO 'ispcsrv0'@'slaveip'
    Error: MySQL server has gone away
    WARNING: Unable to set rights of user in master database: dbispconfig
    Query: GRANT SELECT, INSERT , DELETE ON dbispconfig.`monitor_data` TO 'ispcsrv0'@'slaveip'
    Error: MySQL server has gone away
    WARNING: Unable to set rights of user in master database: dbispconfig
    Query: GRANT SELECT, INSERT, UPDATE ON dbispconfig.`mail_traffic` TO 'ispcsrv0'@'slaveip'
    Error: MySQL server has gone away
    WARNING: Unable to set rights of user in master database: dbispconfig
    Query: GRANT SELECT, INSERT, UPDATE ON dbispconfig.`web_traffic` TO 'ispcsrv0'@'slaveip'
    Error: MySQL server has gone away
    Any further help would be much appreciated.

    Thanks
     
  5. till

    till Super Moderator Staff Member ISPConfig Developer

    All nodes of a multiserver system must use the same ispconfig version, adding 3.1.x to a 3.0.5 master cannot work. According to the error, I would guess that the mysql server dropped the connection.
     
  6. DWChris

    DWChris New Member

    ah that makes sense with trying the new installer thanks.

    What would be the best way to troubleshoot the dropped connection on the old installer please?
    Is there something I need to configure on the master to stop if from dropping the connection?
     
  7. till

    till Super Moderator Staff Member ISPConfig Developer

    I did not had such a dropped connection issue yet. You can try to check the logs on the master if you can find the reason for that there and you can try to run the commands (from second install attempt, the first ones from ispconfig 3.1 contain placehlders) like:

    GRANT SELECT, INSERT ON dbispconfig.`sys_log` TO 'ispcsrv0'@'slavehostname'

    through mysql command when connected from slave to master with the same root user credentials to see if they work.
     
  8. DWChris

    DWChris New Member

    I am able to run the commands manually from the slave with root.
    Looking at the user list there was no user for ispcsrv0 on the master so it looks like there was an issue creating it.
    I created it and gave it full access to the dbispconfig database on the master.

    After reviewing the mysql logs on the master I can see entries like this
    Connect [email protected] on
    So it looks like the slave is able to talk to the master now but it is not appearing on the list of servers on the webpage.

    Is there something else I need to do to get the slave to try and add itself?

    Also noticed the lines after the connect line in the master mysql log are always the same.
    Code:
    Connect    [email protected] on
    Query    SET NAMES utf8
    Query    SET character_set_results = 'utf8', character_set_client = 'utf8', character_set_connection = 'utf8', character_set_database = 'utf8', character_set_server = 'utf8'
    Init DB    dbispconfig
    Query    SELECT * FROM server WHERE server_id = 0
    Init DB    dbispconfig
    Query    INSERT INTO sys_log (server_id,datalog_id,loglevel,tstamp,message) VALUES ('0',0,'0','1515499201','There is already an instance of server.php running. Exiting.')
     
    Last edited: Jan 9, 2018
  9. DWChris

    DWChris New Member

    I have seen about running the server.sh manually on the slave for debug output.
    It starts with
    Code:
    09.01.2018-15:03 - DEBUG - Set Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
    09.01.2018-15:03 - DEBUG - Found 157 changes, starting update process.
    09.01.2018-15:03 - DEBUG - Replicated from master: REPLACE INTO sys_group (`groupid`,`name`,`description`,`client_id`) VALUES ('2','dw','','1')
    09.01.2018-15:03 - DEBUG - Processed datalog_id 3
    09.01.2018-15:06 - DEBUG - Replicated from master: REPLACE INTO client (`client_id`,`sys_userid`,`sys_groupid`,`sys_perm_user`,`sys_perm_group`,`sys_perm_other`,`company_name`,`company_id`,`contact_name`,`customer_no`,`vat_id`,`street`,`zip`,`city`,`state`,`country`,`telephone`,`mobile`,`fax`,`email`,`internet`,`icq`,`notes`,`default_mailserver`,`limit_maildomain`,`limit_mailbox`,`limit_mailalias`,`limit_mailaliasdomain`,`limit_mailforward`,`limit_mailcatchall`,`limit_mailrouting`,`limit_mailfilter`,`limit_fetchmail`,`limit_mailquota`,`limit_spamfilter_wblist`,`limit_spamfilter_user`,`limit_spamfilter_policy`,`default_webserver`,`limit_web_ip`,`limit_web_domain`,`limit_web_quota`,`web_php_options`,`limit_web_subdomain`,`limit_web_aliasdomain`,`limit_ftp_user`,`limit_shell_user`,`ssh_chroot`,`limit_webdav_user`,`default_dnsserver`,`limit_dns_zone`,`limit_dns_slave_zone`,`limit_dns_record`,`default_dbserver`,`limit_database`,`limit_cron`,`limit_cron_type`,`limit_cron_frequency`,`limit_traffic_quota`,`limit_client`,`limit_mailmailinglist`,`limit_openvz_vm`,`limit_openvz_vm_template_id`,`parent_client_id`,`username`,`password`,`language`,`usertheme`,`template_master`,`template_additional`,`created_at`,`id_rsa`,`ssh_rsa`) VALUES ('1','1','1','riud','riud','','info','','info info','info','','','','','','GB','','','','','http://','','','2','-1','-1','-1','-1','-1','-1','0','-1','-1','-1','0','0','0','1','','-1','-1','no,fast-cgi,cgi,mod,suphp','-1','-1','-1','0','no,jailkit,ssh-chroot','0','0','-1','-1','-1','1','-1','0','url','5','-1','1','-1','0','0','0','info','info','en','default','0','','','','')
    
    Then after waiting about 10 minutes this
    Code:
    09.01.2018-13:27 - WARNING - DB::connect()-> mysql_select_db MySQL server has gone away
    09.01.2018-13:27 - WARNING - DB::connect()-> mysql_select_db MySQL server has gone away
    09.01.2018-13:27 - WARNING - DB::connect()-> mysql_select_db MySQL server has gone away
    09.01.2018-13:27 - WARNING - DB::connect()-> mysql_select_db MySQL server has gone away
    09.01.2018-13:27 - WARNING - DB::connect()-> mysql_select_db MySQL server has gone away
    09.01.2018-13:27 - WARNING - DB::connect()-> mysql_select_db MySQL server has gone away
    09.01.2018-13:27 - WARNING - DB::connect()-> mysql_select_db MySQL server has gone away
    09.01.2018-13:27 - WARNING - DB::connect()-> mysql_select_db MySQL server has gone away
    09.01.2018-13:27 - WARNING - DB::connect()-> mysql_select_db MySQL server has gone away
    09.01.2018-13:27 - WARNING - DB::connect()-> mysql_select_db MySQL server has gone away
    09.01.2018-13:27 - WARNING - DB::connect()-> mysql_select_db MySQL server has gone away
    09.01.2018-13:27 - WARNING - DB::connect()-> mysql_select_db MySQL server has gone away
    09.01.2018-13:27 - WARNING - DB::connect()-> mysql_select_db MySQL server has gone away
    PHP Fatal error:  Allowed memory size of 1073741824 bytes exhausted (tried to allocate 130968 bytes) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 100
    
    When viewing the mysql processes on the master I can see a connection for the slave but it is marked sleep the whole time.
    Not really sure why adding this additional server is being so complicated, there's no reason in the logs for the dropped connection..
     
  10. till

    till Super Moderator Staff Member ISPConfig Developer

    That's a problem specific to your setup and not an issue with adding a node to an ISPConfig server in general. I add nodes regularly on client systems worldwide and never had the issue you describe here. The problem seems to be your mysql master instance which drops connections and this cause the slave connects and the installation to fail. Or it's a firewall or network issue.
     
  11. DWChris

    DWChris New Member

    Sorry if it seemed like I was having a dig that really wasn't my intention, just getting a bit frustrated, really appreciate the help you have given me so far!

    I have checked the firewall on both sides and there is nothing logged as being blocked to and from the servers from each other (there are rules to allow any traffic to and from their ip addresses).
    Its just strange because I can manually log into mysql as root to each other and make changes which also makes me think the firewall is ok.

    Although I have the allow anything rules to each other I could try adding rules for the specific ports, as well as 3306 and 53 is there anyother ports ISPconfig needs? (the slave is just being used for DNS)
     
  12. till

    till Super Moderator Staff Member ISPConfig Developer

    The only connection that ISPConfig is doing to the master is mysql, so port 3306 from slave to master should be enough for this part. If you need to have someone look at your issue directly, contact the ISPConfig business support: https://www.ispconfig.org/get-support/?type=ispconfig
     

Share This Page