hobbit-perl dbcheck not updating rrd files
list Stefan van der Walt
Hi guys
I am not sure what i'm doing wrong here, but i'm not getting full
functionality out of dbcheck.pl and graphs.
I'm running linux, centos 5, with xymon 4.3.2, connecting to an oracle9i
database on HPUX 11.23
My tasks file has this
[dbslow]
ENVFILE /home/hobbit/server/etc/xymonserver.cfg
NEEDS xymond
CMD $BBHOME/ext/dbcheck.pl all
LOGFILE $BBSERVERLOGS/bb-dbslow.log
INTERVAL 20m
and debug=2 gives me this, among other things:
dbcheck.pl version 1.09 - column Extent lifetime 60, tested in ~ 00:00:00
(max 01:00:00)
Wed May 11 14:05:32 2011:CALL : Hobbit_fd_lib::send_bb line 964
Wed May 11 14:05:32 2011:DEBUG: TEST=hitcache, TYPE=status+60,
EVENT=HitCache, SENDTYPE=2, TESTLIVE=60, SUMREPTIME=0
Wed May 11 14:05:32 2011:CALL : Hobbit_fd_lib::send_bb line 964
Wed May 11 14:05:32 2011:DEBUG: BBDISPLAY: 172.24.44.34, hostname: mp2qgt3,
type: status+60, event: HitCache, time: 00:00:00, color=green
Wed May 11 14:05:32 2011:CALL : Hobbit_fd_lib::send_bb line 964
Wed May 11 14:05:32 2011:DEBUG: COMPLETE MESSAGE:status+60 mp2qgt3.HitCache
green Wed May 11 14:05:32 2011
<!--
PinSQLArea:99.85
PinTblProc:99.56
PinBody:100.00
PinTrigger:98.88
HitSQLArea:98.40
HitTblProc:97.94
HitBody:99.79
HitTrigger:95.35
BlBuffHit:99.81
RowCache:99.76
-->
I'm not getting errors or warnings, and the pages all display their info
that is submitted.
However the graphs are empty because the RRD files are not being updated
with the data above.
Is it because it's enclosed in <!-- --> ?
Do I need to change the lifetime that is 60?
Thanks for any help
Stef
list Stefan van der Walt
Occasionally when i change something in dbchec.pl and run it manually, it will update the rrds once, which will reflect in the graph. So i get occasional dots in the graphs. Rollback Utilization and Database invalid object are updating their respective RRDs, but the rest are not. Has anyone got all the graphs working? Can I maybe see a sample of your configuration and scripts? I want to compare mine.
▸
On 11 May 2011 14:25, Stefan <user-651f11aa7267@xymon.invalid> wrote:
Hi guys
I am not sure what i'm doing wrong here, but i'm not getting full
functionality out of dbcheck.pl and graphs.
I'm running linux, centos 5, with xymon 4.3.2, connecting to an oracle9i
database on HPUX 11.23
My tasks file has this
[dbslow]
ENVFILE /home/hobbit/server/etc/xymonserver.cfg
NEEDS xymond
CMD $BBHOME/ext/dbcheck.pl all
LOGFILE $BBSERVERLOGS/bb-dbslow.log
INTERVAL 20m
and debug=2 gives me this, among other things:
dbcheck.pl version 1.09 - column Extent lifetime 60, tested in ~ 00:00:00
(max 01:00:00)
Wed May 11 14:05:32 2011:CALL : Hobbit_fd_lib::send_bb line 964
Wed May 11 14:05:32 2011:DEBUG: TEST=hitcache, TYPE=status+60,
EVENT=HitCache, SENDTYPE=2, TESTLIVE=60, SUMREPTIME=0
Wed May 11 14:05:32 2011:CALL : Hobbit_fd_lib::send_bb line 964
Wed May 11 14:05:32 2011:DEBUG: BBDISPLAY: 172.24.44.34, hostname: mp2qgt3,
type: status+60, event: HitCache, time: 00:00:00, color=green
Wed May 11 14:05:32 2011:CALL : Hobbit_fd_lib::send_bb line 964
Wed May 11 14:05:32 2011:DEBUG: COMPLETE MESSAGE:status+60 mp2qgt3.HitCache
green Wed May 11 14:05:32 2011
<!--
PinSQLArea:99.85
PinTblProc:99.56
PinBody:100.00
PinTrigger:98.88
HitSQLArea:98.40
HitTblProc:97.94
HitBody:99.79
HitTrigger:95.35
BlBuffHit:99.81
RowCache:99.76
-->
I'm not getting errors or warnings, and the pages all display their info
that is submitted.
However the graphs are empty because the RRD files are not being updated
with the data above.
Is it because it's enclosed in <!-- --> ?
Do I need to change the lifetime that is 60?
Thanks for any help
Stef
list Stefan van der Walt
Now i see that the only time it actually updates the graphs is when i physically restart xymon.
▸
On 12 May 2011 09:35, Stefan <user-651f11aa7267@xymon.invalid> wrote:
Occasionally when i change something in dbchec.pl and run it manually, it will update the rrds once, which will reflect in the graph. So i get occasional dots in the graphs. Rollback Utilization and Database invalid object are updating their respective RRDs, but the rest are not. Has anyone got all the graphs working? Can I maybe see a sample of your configuration and scripts? I want to compare mine. On 11 May 2011 14:25, Stefan <user-651f11aa7267@xymon.invalid> wrote:Hi guys I am not sure what i'm doing wrong here, but i'm not getting full functionality out of dbcheck.pl and graphs. I'm running linux, centos 5, with xymon 4.3.2, connecting to an oracle9i database on HPUX 11.23 My tasks file has this [dbslow] ENVFILE /home/hobbit/server/etc/xymonserver.cfg NEEDS xymond CMD $BBHOME/ext/dbcheck.pl all LOGFILE $BBSERVERLOGS/bb-dbslow.log INTERVAL 20m and debug=2 gives me this, among other things: dbcheck.pl version 1.09 - column Extent lifetime 60, tested in ~ 00:00:00 (max 01:00:00) Wed May 11 14:05:32 2011:CALL : Hobbit_fd_lib::send_bb line 964 Wed May 11 14:05:32 2011:DEBUG: TEST=hitcache, TYPE=status+60, EVENT=HitCache, SENDTYPE=2, TESTLIVE=60, SUMREPTIME=0 Wed May 11 14:05:32 2011:CALL : Hobbit_fd_lib::send_bb line 964 Wed May 11 14:05:32 2011:DEBUG: BBDISPLAY: 172.24.44.34, hostname: mp2qgt3, type: status+60, event: HitCache, time: 00:00:00, color=green Wed May 11 14:05:32 2011:CALL : Hobbit_fd_lib::send_bb line 964 Wed May 11 14:05:32 2011:DEBUG: COMPLETE MESSAGE:status+60 mp2qgt3.HitCache green Wed May 11 14:05:32 2011 <!-- PinSQLArea:99.85 PinTblProc:99.56 PinBody:100.00 PinTrigger:98.88 HitSQLArea:98.40 HitTblProc:97.94 HitBody:99.79 HitTrigger:95.35 BlBuffHit:99.81 RowCache:99.76 --> I'm not getting errors or warnings, and the pages all display their info that is submitted. However the graphs are empty because the RRD files are not being updated with the data above. Is it because it's enclosed in <!-- --> ? Do I need to change the lifetime that is 60? Thanks for any help Stef