[jffnms-users] mssql counters do not return values

[Dijk, Sebastian van]

Has anyone managed to get some mssql counters into jffnms ?

 

This is what i've done :

 

Interface Type

 ID                    : 10023

Description        : Vecozo MSSQL Information Inter

AD Enabled             

Validate in AD             

Discovery Function (Internal)    : sql_information       

Discovery Parameters             

Discovery Default Poller      : test poller group   

Internal Update Handler             

Manual Interface Add             

Break by Card             

Have Tools             

Have Graph             

Default Graph                  : SQL Users

Default SLA             

RRDTool Structure RRA      : RRA:AVERAGE:0.5:1:<resolution>

RRDTool Resolution          :103680

RRDTool Step                    :300
                                                 

with these fields :

 

ID          Description          Internal Name      Position              Interface Type                                      Field Type              Show      Overwritable              Tracked              Default Value
10026  index                      index              5                          Vecozo MSSQL Information Inter          Index                      Never     
10024  MSSQL Users      sql_users          10                          Vecozo MSSQL Information Inter          RRDTool DS          Never    Type: Counter Min: 0 Max: 1000  
10025  MSSQL Locks      sql_locks          20                          Vecozo MSSQL Information Inter          RRDTool DS          Never    Type: Counter Min: 0 Max: 1000

 

 

poller items :

ID         Description                             Name (Match RRD Struct DS)            Poller Command (file)         Parameters       
10011    Vecozo SQL Locks Poller        sql_locks                                        snmp_counter                    .1.3.6.1.4.1.311.1.4.1.1.2.1.17.0
10010    Vecozo SQL Users Poller        sql_users                                        snmp_counter                    .1.3.6.1.4.1.311.1.4.1.1.2.1.16.0

 

Poller group :

 ID            Description            Interface Type       
10024        Vecozo MSSQL Information Inter

 

with fields :

 

ID        Position        Poller                                Backend       
10026  10               Vecozo SQL Locks Poller      RRD Individual Value
10027  20               Vecozo SQL Users Poller      RRD Individual Value

 

 

 

 

However when i run the poller process i get no values :

 

jffnms:/usr/share/jffnms/engine# php poller.php 57 1256
11:36:15  :  H  57 : Poller Start : 3 Items.
11:36:15  :  H  57 :  I 1256 :  P  10 : sql_locks(.1.3..7.0):  -> rrd():  (time P:5.12 | 4.31)
11:36:15  :  H  57 :  I 1256 :  P  20 : sql_users(.1.3..6.0):  -> rrd():  (time P:1.82 | 2.26)
11:36:15  :  H  57 :  I 1256 :  P LPD : last_poll_date(): 1161682575 -> db(last_poll_date): 1 (time P:0.31 | 2.54)
11:36:15  :  H  57 : Poller End, Total Time: 35.68 msec.

 

tnx in advance !

 

 

Met vriendelijke groet,

 

 

Sebastian van Dijk

-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
jffnms-users mailing list
jffnms-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jffnms-users