We use UnixODBC for this so please verify that your isql can access the server.
Javier Dijk, Sebastian van wrote: > 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 -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Javier Szyszlican, Project Leader, JFFNMS [EMAIL PROTECTED] I hope JFFNMS or I were helpful to you, if you can, please donate at http://jffnms.org/donate ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ jffnms-users mailing list jffnms-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jffnms-users
