Master database permissions error on ISPConfig update

Discussion in 'Installation/Configuration' started by InboxSys, Feb 19, 2024.

  1. InboxSys

    InboxSys New Member

    Hello,

    When trying to update from 3.2.11p1 to 3.2.11p2 on an ISPConfig slave server, I have a problem reconfiguring the permissions in the master database. After answering "yes" when asked if I want to "Reconfigure Permissions in master database", I see the following error:

    Code:
    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(`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 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`, `rendered_zone`) 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 ON ?? TO ?@?
     Error: 
    
    Debian Bookworm is running on both master and slave with the latest versions of mariadb and apache.

    mariadb Ver 15.1 Distrib 10.11.6-MariaDB, for debian-linux-gnu (x86_64) using EditLine wrapper
    Server version: Apache/2.4.57 (Debian)
    Server built: 2023-04-13T03:26:51

    I've seen a very old issue with the same problem, but unfortunately, no solution: https://forum.howtoforge.com/threads/error-on-updating.83146/

    I'm thankful for any help with this issue!
     
  2. InboxSys

    InboxSys New Member

    Code:
    skip-name-resolve=1
    was set in mysql config on the master. Removing this solved the issue.
     
    Th0m, till and ahrasis like this.

Share This Page