- Zenoss Resource Manager 4.2.4
- Zenoss Resource Manager 4.2.5
While attempting to update/patch Resource Manager 4.2.5, the update fails due to insufficient permissions. The error is similar to the following:
Checking database connectivity and permissions... Checking ZenDS zodb connectivity... /opt/zends/bin/.mysqladmin: connect to server at 'my.server.name' failed error: 'Access denied for user 'root'@'my.server.name.' (using password: NO)' ERROR: ZenDS for zodb is not running or permissions are broken - aborting
The ZenUp grant checking code assumes restrictive permission grants for the zep-user and zodb-user. These users are defined in the /opt/zenoss/etc/global.conf file.
The root user is assumed to have permissions on every database.
Perform the following procedure to add the appropriate grant to the zenoss user:
- Add the appropriate permissions as the root user, for example:
su - root GRANT PROCESS, SUPER ON *.* TO 'zenoss'@'my.server.name' IDENTIFIED BY PASSWORD 'zenoss'
NOTE: Change my.server.name to your fully qualified domain server name.
- Restart zeneventserver as the zenoss user:
su - zenoss zeneventserver restart