Hi,
now that zenoss is running fine i try to do some more checks.
I need to monitor a MySQL Database (beside other things) and as there are
Nagios Plugins i thought, well, why not use them?
I wrote a small shell script that refomats the output (a classical one-liner)
so that it looks like that:
$ $ZENHOME/libexec/test_mysql -H localhost -u zenoss -p ******
OK|Uptime=1967508 Threads=3 Questions=1762580 Slowqueries=0 Opens=0
Flushtables=1 Opentables=64 Queriespersecondavg=0.896
seems ok, or am i wrong here?
I made a template (in the GUI) called MySQL, added one datasource called
CheckMySQL:
NAME: CheckMySQL
Source Type: COMMAND
Enabled : true
Use SSH: false
Component: dbcheck
Event Class: /DB
Event Key: CheckMySQL
Severity: Warning
Cylce Time: 300
Command Template: /opt/zenoss/libexec/test_mysql -H ${device/id} -u zenoss -p
*****
Then added Data Points named Uptime, Threads, Questions, ...
all are Type: Gauge, Line Type: Line, rest left as per default.
And a Graph named MySQL with CheckMySQL_Opentables,
CheckMySQL_Queriespersecondavg, CheckMySQL_Slowqueries, CheckMySQL_Threads as
Data Sources.
Now i added my Template to localhost, so it has two Templates: Device and MySQL
and here it starts to puzzle me...
when i run zencommand run -d localhost -v 10 on the console (as user zenoss) i
get the following output:
DEBUG:zen.zencommand:run
DEBUG:zen.zencommand:Connecting to localhost
DEBUG:zen.zencommand:Logging in as admin
WARNING:zen.zencommand:Reconnected to ZenHub
DEBUG:zen.zencommand:setting up services EventService, CommandConfig
DEBUG:zen.zencommand:chaining getInitialServices with d2
DEBUG:zen.zencommand:callback after getting service EventService
DEBUG:zen.zencommand:callback after getting service CommandConfig
DEBUG:zen.zencommand:Calling connected.
DEBUG:zen.zencommand:connected
DEBUG:zen.zencommand:Fetching config
DEBUG:zen.zencommand:Updated configCycleInterval config to 360
INFO:zen.zencommand:---------- - schedule has 0 commands
DEBUG:zen.zencommand:Finished config fetch
INFO:zen.zencommand:---------- - schedule has 0 commands
DEBUG:zen.zencommand:removing service EventService
DEBUG:zen.zencommand:removing service CommandConfig
INFO:zen.zencommand:zencommand shutting down
it seems, that it simply ignores this template???
btw. i also tries to simply create a local copy of the device template under
localhost, add the datasource there and so on, but the result is exactly the
same.
now, it seems that i'm really stuck and need a fair bit of help ;-)
Thanks a lot!
Michael
------------------------
Michael Joncic
-------------------- m2f --------------------
Read this topic online here:
http://community.zenoss.com/forums/viewtopic.php?p=11356#11356
-------------------- m2f --------------------
_______________________________________________
zenoss-users mailing list
[email protected]
http://lists.zenoss.org/mailman/listinfo/zenoss-users
