Multiserver setup not creating Mysql users for satellite servers

Discussion in 'Installation/Configuration' started by antleo, Dec 13, 2019.

  1. antleo

    antleo New Member

    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:
    
     
  2. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    Were the servers where you installed ISPConfig old servers already running in production?
     
  3. antleo

    antleo New Member

    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.
     
  4. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    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.
     
  5. antleo

    antleo New Member

    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?
     
  6. till

    till Super Moderator Staff Member ISPConfig Developer

    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.
     

Share This Page