Follow

Zenoss Resource Manager 4.2.5 requires updated database grants for patching

Applies To

  • Zenoss Resource Manager 4.2.4
  • Zenoss Resource Manager 4.2.5

Summary

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.

Procedure

Perform the following procedure to add the appropriate grant to the zenoss user:

  1. 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.

  2. Restart zeneventserver as the zenoss user:
    su - zenoss
    zeneventserver restart
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk