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 ?@?
    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 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:
    
     
    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