Hi all Latest version of ISPconfig (3.1.7), master all working well. Adding the secondary server though gives me the following errors: Adding ISPConfig server record to database. 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: The slave server has full permissions for the master server via mysql, with both the IP address and hostname: MariaDB [(none)]> SHOW GRANTS FOR 'root'@'192.168.5.39' -> ; +-------------------------------------------------------------------------------------------------------------------------+ | Grants for [email protected] | +-------------------------------------------------------------------------------------------------------------------------+ | GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.5.39' IDENTIFIED BY PASSWORD 'hashyhashy' | +-------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec) MariaDB [(none)]> SHOW GRANTS FOR 'root'@'slaveservername.domain.com' -> ; +------------------------------------------------------------------------------------------------------------------------------+ | Grants for root'@'slaveservername.domain.com | +------------------------------------------------------------------------------------------------------------------------------+ | GRANT USAGE ON *.* TO 'root'@'slaveservername.domain.com' IDENTIFIED BY PASSWORD 'hashyhashy' | +------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec) Even after these errors, the server does show up under the master through the control panel, but all queries queue up against the server and never get processed. The Sql log on the master server shows the slave server connecting in as root succesfully: 171106 18:57:56 2112 Connect [email protected] as anonymous on dbispconfig 2112 Quit 2113 Connect [email protected] as anonymous on 2113 Query USE `dbispconfig` 2113 Query UPDATE `dbispconfig`.`server` SET dbversion = 84 WHERE server_id = 2................................................... Carrying out its SET config query successfully,. Then connecting as ispcsrv2 unsuccesfully: 2120 Connect [email protected] as anonymous on dbispconfig 2120 Init DB Access denied for user 'ispcsrv2'@'slaveservername.domain.com' to database 'dbispconfig' 2121 Connect [email protected] as anonymous on dbispconfig 2121 Init DB Access denied for user 'ispcsrv2'@'slaveservername.domain.com' to database 'dbispconfig' Any guidance would be appreciated.
You are missing the GRANT OPTION for your remote root user. So it cannot use GRANT commands and that's why it fails. Code: GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.5.39' IDENTIFIED BY PASSWORD 'hashyhashy' WITH GRANT OPTION would be correct. After that you can just do an ISPConfig update on the slave and answer yes when asked for reconfiguring permissions in master database.
