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 ?@? Error: WARNING: Unable to set rights of user in master database: dbispconfig Query: GRANT SELECT, INSERT ON ?? TO ?@? Error: WARNING: Unable to set rights of user in master database: dbispconfig Query: GRANT SELECT, UPDATE(`status`, `error`) ON ?? TO ?@? Error: WARNING: Unable to set rights of user in master database: dbispconfig Query: GRANT SELECT, UPDATE(`status`) ON ?? TO ?@? Error: WARNING: Unable to set rights of user in master database: dbispconfig Query: GRANT SELECT, UPDATE(`updated`) ON ?? TO ?@? 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 ?@? Error: WARNING: Unable to set rights of user in master database: dbispconfig Query: GRANT SELECT ON ?? TO ?@? Error: WARNING: Unable to set rights of user in master database: dbispconfig Query: GRANT SELECT, UPDATE (`action_state`, `response`) ON ?? TO ?@? Error: WARNING: Unable to set rights of user in master database: dbispconfig Query: GRANT SELECT, INSERT , DELETE ON ?? TO ?@? Error: WARNING: Unable to set rights of user in master database: dbispconfig Query: GRANT SELECT, INSERT, UPDATE ON ?? TO ?@? Error: WARNING: Unable to set rights of user in master database: dbispconfig Query: GRANT SELECT, INSERT, UPDATE ON ?? TO ?@? Error: WARNING: Unable to set rights of user in master database: dbispconfig Query: GRANT SELECT, UPDATE, DELETE ON ?? TO ?@? Error: WARNING: Unable to set rights of user in master database: dbispconfig Query: GRANT SELECT, DELETE ON ?? TO ?@? Error: WARNING: Unable to set rights of user in master database: dbispconfig Query: GRANT SELECT, INSERT, DELETE ON ?? TO ?@? Error: WARNING: Unable to set rights of user in master database: dbispconfig Query: GRANT SELECT, INSERT, DELETE ON ?? TO ?@? 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 ?@? Error: WARNING: Unable to set rights of user in master database: dbispconfig Query: GRANT SELECT, INSERT, UPDATE ON ?? TO ?@? Error: WARNING: Unable to set rights of user in master database: dbispconfig Query: GRANT SELECT ON ?? TO ?@? Error: WARNING: Unable to set rights of user in master database: dbispconfig Query: GRANT SELECT, INSERT ON ?? TO ?@? Error: WARNING: Unable to set rights of user in master database: dbispconfig Query: GRANT SELECT, UPDATE(`status`, `error`) ON ?? TO ?@? Error: WARNING: Unable to set rights of user in master database: dbispconfig Query: GRANT SELECT, UPDATE(`status`) ON ?? TO ?@? Error: WARNING: Unable to set rights of user in master database: dbispconfig Query: GRANT SELECT, UPDATE(`updated`) ON ?? TO ?@? 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 ?@? Error: WARNING: Unable to set rights of user in master database: dbispconfig Query: GRANT SELECT ON ?? TO ?@? Error: WARNING: Unable to set rights of user in master database: dbispconfig Query: GRANT SELECT, UPDATE (`action_state`, `response`) ON ?? TO ?@? Error: WARNING: Unable to set rights of user in master database: dbispconfig Query: GRANT SELECT, INSERT , DELETE ON ?? TO ?@? Error: WARNING: Unable to set rights of user in master database: dbispconfig Query: GRANT SELECT, INSERT, UPDATE ON ?? TO ?@? Error: WARNING: Unable to set rights of user in master database: dbispconfig Query: GRANT SELECT, INSERT, UPDATE ON ?? TO ?@? Error: WARNING: Unable to set rights of user in master database: dbispconfig Query: GRANT SELECT, UPDATE, DELETE ON ?? TO ?@? Error: WARNING: Unable to set rights of user in master database: dbispconfig Query: GRANT SELECT, DELETE ON ?? TO ?@? Error: WARNING: Unable to set rights of user in master database: dbispconfig Query: GRANT SELECT, INSERT, DELETE ON ?? TO ?@? Error: WARNING: Unable to set rights of user in master database: dbispconfig Query: GRANT SELECT, INSERT, DELETE ON ?? TO ?@? 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 ?@? Error: WARNING: Unable to set rights of user in master database: dbispconfig Query: GRANT SELECT, INSERT, UPDATE ON ?? TO ?@? 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 root@slavehostname and root@slaveip 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
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.
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 root@slaveip | +--------------------------------------------------------------------------------------------------------------------------------------------+ | GRANT ALL PRIVILEGES ON *.* TO 'root'@'slaveip' IDENTIFIED BY PASSWORD '-----' WITH GRANT OPTION | +--------------------------------------------------------------------------------------------------------------------------------------------+ mysql> SHOW GRANTS FOR 'root'@'slavehostname'; +---------------------------------------------------------------------------------------------------------------------------------------------+ | Grants for root@slavehostname | +---------------------------------------------------------------------------------------------------------------------------------------------+ | GRANT ALL PRIVILEGES ON *.* TO 'root'@'slavehostname' IDENTIFIED BY PASSWORD '-----' WITH GRANT OPTION | +---------------------------------------------------------------------------------------------------------------------------------------------+
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
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.
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?
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.
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 ispcsrv0@slavehostname 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 ispcsrv0@slavehostname 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.')
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..
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.
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)
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
