Using snmpgetnext vs snmpgetnext (SQL Server 2000 snmp)

amccool · Post by **amccool** » Mon Sep 25, 2006 4:59 pm

I am working toward getting ms sql to deliver data for graphing and need to use snmpgetnext

How do I utilize snmpgetnext rather than the standard snmpget?

There are many threads stating how mssql's snmp wont return data when using snmpget, however, snmpgetnext does work.

I noticed that in the configuration->settings->paths there is a binary location for calling snmpgetnext. However, I dont see which Data Query or Data Template can utilize this call.

Can anyone point me in the right direction? I should have thought someone would have written the snmp generic OID script to call snmpgetnext.

BTW this is on a debian box so WMI is out.

Thanks,
Alex

Post by **TheWitness** » Mon Sep 25, 2006 7:50 pm

Well, unfortunately, we don't have a function for the snmpgetnext, although we are asking for this (due to MacTrack). So, I wrote all of MacTrack and some of Cacti, so I guess my enhancements make it quicker.

So, your solution is to use a script rather than an snmp query. This will resolve your problem. If it's snmp data query (table based), the you run a script query, otherwise, simply run a script.

TheWitness

amccool · Post by **amccool** » Mon Sep 25, 2006 8:04 pm

Thanks, I appreciate the effort. I kinda figured that might be the case, so I'm about half way done with a script for it. The major bummer is the snmp isn't really indexed, so I have to do it in a custom fashion

If you get a chance post back to let me know which version is going to be getting the snmpgetnext functionality.

Thanks,
Alex

amccool · Post by **amccool** » Tue Sep 26, 2006 12:55 pm

I wrote a small perl script using snmpgetnext to query on hosts

Its working rather well. No doubt that some cleanup would be good, but I thought that people may want to start graphing sql server snmp from linux sooner than later

Crackerjack · Post by **Crackerjack** » Tue Oct 24, 2006 4:40 pm

I tried using these configs and they seem to be half working... for some reason, the spaces between the commandline parameters were lost, so I had to go in and add them back. All the graphs come back with everything as "nan"... but when I run the script manually, this is what I get:

UserConnections: 228 TotalLocks:212 TotalBlockingLocks:1 UsersBlocked:1

so it looks like the script is doing its job, but the information just doesnt flow back to cacti properly? has anybody gotten this to work?

Post by **TheWitness** » Tue Oct 24, 2006 7:23 pm

You have a space between "UserConnections:" and "228". That won't work.

TheWitness

Crackerjack · Post by **Crackerjack** » Tue Oct 24, 2006 7:55 pm

well, i don't *actually* have a space there, i was typing what i was reading on the other monitor, sorry.

another oddity is that the "5 minute average daily" graph shows "week 31, week 32', etc... very confusing

amccool · Post by **amccool** » Tue Oct 31, 2006 8:12 pm

I ran into the same issue with daily, weekly graphs showing the monthlies

its not related to the script and template, buyt due to a cacti upgrade problem

Luckily, It's easily fixed

go to console, datasources, --RRA and correct to taste (see attached)

WimanX · Post by **WimanX** » Wed Jan 17, 2007 4:01 am

I dont get the graph to work, only showing "nan" as values

Error in the cacti log file:
CMDPHP: Poller[0] ERROR: SQL Exec Failed "delete from data_input_data where data_input_id=14"

have installed the xml's and copied the SQL_STATS.PL to the correct path

please advice

Edit:
Its against a SQL2003 server

Post by **TheWitness** » Wed Jan 17, 2007 6:04 am

Do you actually have the Microsoft Agent Extensions loaded. AKA, have you confirmed that the host responds to the correct MIBS?

TheWitness

WimanX · Post by **WimanX** » Wed Jan 17, 2007 8:32 am

TheWitness wrote:Do you actually have the Microsoft Agent Extensions loaded. AKA, have you confirmed that the host responds to the correct MIBS?

TheWitness

the SNMP Service is up and running, all the other graphs are working fine...

I installed the NET::SNMP perl and then i get another error
"CMDPHP: Poller[0] Host[33] DS[890] WARNING: Result from CMD not valid. Partial Result: ERROR: Community not"

Guess that the comminity is not valid, but what about the other graphs that are working fine...

Post by **TheWitness** » Wed Jan 17, 2007 5:34 pm

You might have a separate community required for that section of the agent. I don't know. I've never used it.

TheWitness

igonzalez · Post by **igonzalez** » Wed Jan 24, 2007 9:27 pm

I'm getting nan values as well with the following error in the cacti logs:

CMDPHP: Poller[0] Host[11] DS[114] WARNING: Result from CMD not valid. Partial Result: ERROR: Community not

I imported the templates and verfied that the perl script is running from the command line.

any ideas how to fix this?

Cacti

Using snmpgetnext vs snmpgetnext (SQL Server 2000 snmp)

Using snmpgetnext vs snmpgetnext (SQL Server 2000 snmp)

oh my bleeding edge

still not working :-(

the daily, weekly, monthly graphs

Who is online