I installed ISPCONFIG on an apache web server, and decided I'd like to add our mail server and DNS Servers to it as well. When I go to run the setup on the other servers, I get errors when it goes to add users to the master server. (see Below output). It definitely has access via the root user to the MYSQL database on the ISPCONFIG server(and local server), but fails when trying to add the server records? What did I do wrong? Code: Adding ISPConfig server record to database. 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:
Yes, the web server which holds the interface has been running for a few months, the mail server is up and has a test account on it, but is not in production.
That is not a supported configuration where ISPConfig can be installed. Meaning that most likely ISPConfig does not work. All the ISPConfig Perfect Server Installation Guides start with an OS installed following the Guide. then ISPConfig is installed on top of that OS.
The web server was set up with isp config on it and is working, does that I wouldn't be able to add an remove servers from the cluster and it all has to be set up at once? Or does that mean I just need to wipe and rebuild the email server?
No, you can add slave servers whenever you want to add them later, no need to set up everything at once. According to the error message in the first post, the user (root ?) that you used to install the slave server has no grant permissions. Fix that root user in the mysql/mariadb server on the master so it has all permissions incl. grant permissions,. then delete in the ispconfig UI the mail domain and mail box that you added as a test, then run the ispconfig uninstall.php script on the slave server to uninstall ispconfig. Then check on the master if the mail server is still listed in the services list, if that's the case, delete it there. Finally install ispconfig with install.php on the mail server again.
