Multiserver setup can't connect to master db

Discussion in 'ISPConfig 3 Priority Support' started by rica5736, Nov 13, 2016.

  1. rica5736

    rica5736 New Member HowtoForge Supporter

    I can't connect to master db e.g. web.example.ltd from other installation instances e.g.. mail.example.ltd even thou i ran the sql commands from the manual... :(

    Output of error:
    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 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:
    
     
    Last edited: Nov 13, 2016
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    Did you use the MySQL root user to conect to the master database?
    Which OS and which MySQL version do you use?
     
  3. rica5736

    rica5736 New Member HowtoForge Supporter

    Debian 8.1 & yes root user mariaDB latest through rep
     
  4. florian030

    florian030 ISPConfig Developer ISPConfig Developer

    And the root-user has permissions to connect from the slaves hostname and ip?
     

Share This Page