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