lists.netmrg.net

rkogels

Hi all,

Does netMRG store the retrieved SNMP data in an SQL db? Eg, are the internal RRDTool databases not used?

Thanks,
Rene

silfreed · Posted: Tue Dec 23, 2003 5:03 pm Post subject:

We store all gathered data in RRD files that RRDTOOL produces. We do store the last gathered value in the database, which we've found useful for hooking NetMRG to other programs. Anything specific you're trying to accomplish?

-Doug

rkogels · Posted: Tue Dec 23, 2003 8:37 pm Post subject:

Hi Doug,

Thanks for your answer. I wondered if all the SNMP data was stored in an SQL db so you could run some queries on it, like finding out when you had some peak values etc. This is a bit more problematic when you try to get it out od the RRD db.

Rene

silfreed · Posted: Tue Dec 23, 2003 8:44 pm Post subject:

Yes, it does make it more difficult in cases where you want to do what you're suggesting; but it does make it much nicer for us since we don't have to maintain the round robin database ourselves (and generate the graphs - *shudder*). It sounds like you've dealt with this in the past, so you probably already know about RRDTool's 'fetch' command - if not, that's the place to look.

-Doug

rkogels · Posted: Tue Dec 23, 2003 9:06 pm Post subject:

What is this "event" feature of netMRG? Does it send out events when some values are seen in the RRD db? So no use of the SQL db as you mentioned before?

Rene

silfreed · Posted: Tue Dec 23, 2003 9:22 pm Post subject:

The 'event' feature allows NetMRG take an action when some condition is met. For example, say when your router CPU hits 90% you'd like to page someone. This would require you to setup a 'Notification' to have someone paged. It just uses the last value it saved in the SQL table and compares it to the current value it just got.
The only value we store in the database is the last captured value (and the rate of change for Counters). This allows us to do simple comparisons like above.

-Doug

wulff · Beginner Joined: 30 Mar 2005 Posts: 4

as a continuation of the origional question, I am curious... how different would the data being stored by netmrg into RRD be that what mrtg-rrd creates in its rrd files?

The reason I am asking is because we are putting together OPNet's VNE Server and SPGuru on our network, and one of the items they request to make things "optimal" is flows, and while they support common things like CiscoWorks, etc, they also support MRTG, in normal or RRD format. My problem is probably the same as anyone using netmrg or any of the other "better" open source monitoring tools, MRTG is a bear. I quit using it almost 2-3 years ago. I have been using Zabbix, and I think in long term, its going to be a wonderful application, but I believe for my current needs that netmrg is much better solution.

on a side note, silfreed, can you send me an im or e-mail if you get a chance, I was curious about comparing notes on a few development things as an ISP (i looked over your resume). I'm the xaethios that IM'd you while you were away.

thanks

wulff

balleman · Site Admin Joined: 20 Jan 2003 Posts: 282

With respect to RRD files, NetMRG and MRTG-RRD would use different names for the data sources stored in the RRDs, would likely have different geometries (more or less data points over each time period), and may have a different number of data sources per file. If the app your using supports 'generic' RRDs, then you should be fine, but if it depends on MRTG-RRD's particular use of RRDs, you'll have to do some (ok, probably lots) of conversion by dumping RRDs, mangling them, and restoring them into other RRDs.

wulff · Beginner Joined: 30 Mar 2005 Posts: 4

that is what I was afraid of... but i think I'm going to approach them with the concept that if they can import RRD files, they should make the import definable.

thanks

billn · Beginner Joined: 23 Mar 2005 Posts: 3 Location: Tempe, AZ

silfreed · Posted: Wed Apr 13, 2005 1:10 am Post subject:

The last value is already inserted into the database along with getting updated in the .rrd files.

-Doug

marcioq · Beginner Joined: 28 Sep 2004 Posts: 8 Location: Brazil

Hi,

just one quick question. When you say the netmrg store the last value it is the "delta_val" on the monitors table ? it is diference between the current reading ("last_val" on monitors table) and the Last ? Could i use it to monitor if the traffic is to high ?

Thank´s

silfreed · Posted: Thu Apr 21, 2005 1:11 am Post subject:

Yep.

-Doug