As a test, i'm trying to use this (actually the related MySQL ODBC monitor) on localhost (zenoss server).
The other MySQL zenpack (core) works already, and I have made sure that the mysql-odbc driver is installed.
/etc/odbcinst.ini has the following (odbc.ini is blank):
# Driver from the MyODBC package
# Setup from the unixODBC package
[MySQL]
Description = ODBC for MySQL
Driver = /usr/lib/libmyodbc.so
Setup = /usr/lib/libodbcmyS.so
FileUsage = 1
From the zenpack notes (web), it looks like there are multiple dependencies:
MySQL ODBC -> ODBC -> RDBMS -> Adv Device Details
All of these zenpacks have been installed, and zCollectorPlugins includes:
community.snmp.DatabaseMap
community.odbc.OdbcPlugin
community.odbc.MySqlDatabaseMap
when I run zenmodeler, i see the following output:
2009-06-30 14:41:40 INFO zen.Utils Executing command: /opt/zenoss/bin/zenmodeler run --now --monitor localhost -F -d localhost --weblog
2009-06-30 14:41:41 DEBUG zen.ZenModeler Run in foreground, starting immediately.
2009-06-30 14:41:41 DEBUG zen.ZenModeler Starting PBDaemon initialization
2009-06-30 14:41:41 INFO zen.ZenModeler Connecting to localhost:8789
2009-06-30 14:41:41 DEBUG zen.ZenModeler Logging in as admin
2009-06-30 14:41:41 INFO zen.ZenModeler Connected to ZenHub
2009-06-30 14:41:41 DEBUG zen.ZenModeler Setting up initial services: EventService, ModelerService
2009-06-30 14:41:41 DEBUG zen.ZenModeler Chaining getInitialServices with d2
2009-06-30 14:41:41 DEBUG zen.ZenModeler Loaded service EventService from zenhub
2009-06-30 14:41:41 DEBUG zen.ZenModeler Loaded service ModelerService from zenhub
2009-06-30 14:41:41 DEBUG zen.ZenModeler Queueing event {'severity': 0, 'component': 'zenmodeler', 'agent': 'zenmodeler', 'summary': 'started', 'manager': 'localhost', 'device': 'localhost', 'eventClass': '/App/Start'}
2009-06-30 14:41:41 DEBUG zen.ZenModeler Total of 1 queued events
2009-06-30 14:41:41 DEBUG zen.ZenModeler Calling connected.
2009-06-30 14:41:41 DEBUG zen.ZenModeler fetching monitor properties
2009-06-30 14:41:41 DEBUG zen.ZenModeler Getting threshold classes...
2009-06-30 14:41:41 DEBUG zen.ZenModeler Loading classes ['Products.ZenModel.MinMaxThreshold', 'ZenPacks.community.PointThreshold.thresholds.PointThreshold', 'ZenPacks.community.PredictiveThreshold.thresholds.PredictiveThreshold', 'ZenPacks.community.RangeThreshold.thresholds.RangeThreshold']
2009-06-30 14:41:41 DEBUG zen.ZenModeler Fetching default RRDCreateCommand...
2009-06-30 14:41:41 DEBUG zen.ZenModeler Getting collector thresholds...
2009-06-30 14:41:41 DEBUG zen.thresholds Updating threshold ('zeneventlog cycle time', ('localhost', ''))
2009-06-30 14:41:41 DEBUG zen.thresholds Updating threshold ('zenmodeler cycle time', ('localhost', ''))
2009-06-30 14:41:41 DEBUG zen.thresholds Updating threshold ('zenperfsnmp cycle time', ('localhost', ''))
2009-06-30 14:41:41 DEBUG zen.thresholds Updating threshold ('zenping cycle time', ('localhost', ''))
2009-06-30 14:41:41 DEBUG zen.thresholds Updating threshold ('zenprocess cycle time', ('localhost', ''))
2009-06-30 14:41:41 DEBUG zen.thresholds Updating threshold ('zenwin cycle time', ('localhost', ''))
2009-06-30 14:41:41 DEBUG zen.ZenModeler Getting collector plugins for each DeviceClass
2009-06-30 14:41:41 DEBUG zen.ZenModeler Starting collector loop...
2009-06-30 14:41:41 INFO zen.ZenModeler Collecting for device localhost
2009-06-30 14:41:41 DEBUG zen.ZenModeler Loaded plugin zenoss.snmp.DeviceMap
2009-06-30 14:41:41 DEBUG zen.ZenModeler Loaded plugin HPDeviceMap
2009-06-30 14:41:41 DEBUG zen.ZenModeler Loaded plugin DellDeviceMap
2009-06-30 14:41:41 DEBUG zen.ZenModeler Loaded plugin zenoss.snmp.InterfaceMap
2009-06-30 14:41:41 DEBUG zen.ZenModeler Loaded plugin zenoss.snmp.RouteMap
2009-06-30 14:41:41 DEBUG zen.ZenModeler Loaded plugin zenoss.snmp.IpServiceMap
2009-06-30 14:41:41 DEBUG zen.ZenModeler Loaded plugin zenoss.snmp.HRFileSystemMap
2009-06-30 14:41:41 DEBUG zen.ZenModeler Loaded plugin zenoss.snmp.HRSWRunMap
2009-06-30 14:41:41 DEBUG zen.ZenModeler Loaded plugin HPCPUMap
2009-06-30 14:41:41 DEBUG zen.ZenModeler Loaded plugin DellCPUMap
2009-06-30 14:41:41 DEBUG zen.ZenModeler Loaded plugin DellPCIMap
2009-06-30 14:41:41 DEBUG zen.ZenModeler Loaded plugin community.snmp.DatabaseMap
2009-06-30 14:41:41 DEBUG zen.ZenModeler Loaded plugin community.odbc.OdbcPlugin
2009-06-30 14:41:41 DEBUG zen.ZenModeler Loaded plugin community.odbc.MySqlDatabaseMap
2009-06-30 14:41:41 INFO zen.ZenModeler No WMI plugins found for localhost
2009-06-30 14:41:41 DEBUG zen.ZenModeler Loaded plugin zenoss.snmp.DeviceMap
2009-06-30 14:41:41 DEBUG zen.ZenModeler Loaded plugin HPDeviceMap
2009-06-30 14:41:41 DEBUG zen.ZenModeler Loaded plugin DellDeviceMap
2009-06-30 14:41:41 DEBUG zen.ZenModeler Loaded plugin zenoss.snmp.InterfaceMap
2009-06-30 14:41:41 DEBUG zen.ZenModeler Loaded plugin zenoss.snmp.RouteMap
2009-06-30 14:41:41 DEBUG zen.ZenModeler Loaded plugin zenoss.snmp.IpServiceMap
2009-06-30 14:41:41 DEBUG zen.ZenModeler Loaded plugin zenoss.snmp.HRFileSystemMap
2009-06-30 14:41:41 DEBUG zen.ZenModeler Loaded plugin zenoss.snmp.HRSWRunMap
2009-06-30 14:41:41 DEBUG zen.ZenModeler Loaded plugin HPCPUMap
2009-06-30 14:41:41 DEBUG zen.ZenModeler Loaded plugin DellCPUMap
2009-06-30 14:41:41 DEBUG zen.ZenModeler Loaded plugin DellPCIMap
2009-06-30 14:41:41 DEBUG zen.ZenModeler Loaded plugin community.snmp.DatabaseMap
2009-06-30 14:41:41 DEBUG zen.ZenModeler Loaded plugin community.odbc.OdbcPlugin
2009-06-30 14:41:41 DEBUG zen.ZenModeler Loaded plugin community.odbc.MySqlDatabaseMap
2009-06-30 14:41:41 DEBUG zen.ZenModeler Using community.odbc.OdbcPlugin on localhost
2009-06-30 14:41:41 DEBUG zen.ZenModeler Using community.odbc.MySqlDatabaseMap on localhost
2009-06-30 14:41:41 INFO zen.ZenModeler Python collection device localhost
2009-06-30 14:41:41 INFO zen.ZenModeler plugins: community.odbc.OdbcPlugin, community.odbc.MySqlDatabaseMap
2009-06-30 14:41:41 DEBUG zen.PythonClient Running collection for plugin community.odbc.OdbcPlugin
2009-06-30 14:41:41 ERROR zen.ZenModeler Unable to fill collection slots: [Failure instance: Traceback (failure with no frames): exceptions.ValueError: need more than 1 value to unpack ]
2009-06-30 14:41:41 DEBUG zen.ZenModeler Collection slots filled
2009-06-30 14:41:41 DEBUG zen.ZenModeler Running 1 clients
2009-06-30 14:44:41 DEBUG zen.ZenModeler Running 1 clients
2009-06-30 14:44:42 WARNING zen.ZenModeler Client localhost timeout
2009-06-30 14:44:42 DEBUG zen.ZenModeler Running 0 clients
2009-06-30 14:44:42 INFO zen.ZenModeler Scan time: 180.36 seconds
2009-06-30 14:44:42 DEBUG zen.thresholds Checking value 180.360131025 on Daemons/localhost/zenmodeler_cycleTime
2009-06-30 14:44:42 DEBUG zen.MinMaxCheck Checking zenmodeler_cycleTime 180.360131025 against min None and max 34560.0
2009-06-30 14:44:42 DEBUG zen.ZenModeler Queueing event {'manager': 'localhost', 'eventKey': 'zenmodeler cycle time', 'device': 'localhost', 'eventClass': '/Perf', 'summary': 'Threshold of zenmodeler cycle time restored: current value: 180.36', 'component': '', 'agent': 'zenmodeler', 'severity': 0}
2009-06-30 14:44:42 DEBUG zen.ZenModeler Total of 1 queued events
2009-06-30 14:44:42 DEBUG zen.ZenModeler Sent a 'stop' event
2009-06-30 14:44:42 DEBUG zen.ZenModeler stop() called when not running
2009-06-30 14:44:42 INFO zen.ZenModeler Daemon ZenModeler shutting down
2009-06-30 14:44:42 DEBUG zen.ZenModeler Removing service EventService
2009-06-30 14:44:42 DEBUG zen.ZenModeler Removing service ModelerService
2009-06-30 14:44:43 INFO zen.ZenModeler zenmodeler shutting down
2009-06-30 14:44:43 INFO zen.PerformanceConf configuration collected
I don't see any modifications to the "Software" tab (like the screenshots), and the "Perf" graphs also do not render. zencommand appears not to run any relevant commands to collect the data.
Any advice on how to proceed from here?
Thanks,
-Joseph