Issues with secondary server

Discussion in 'ISPConfig 3 Priority Support' started by Alexander Foti, Nov 7, 2017.

  1. Alexander Foti

    Alexander Foti New Member HowtoForge Supporter

    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 [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:​

    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.
     
    Last edited: Nov 7, 2017
  2. Croydon

    Croydon ISPConfig Developer ISPConfig Developer

    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.
     
    Jesse Norell likes this.

Share This Page