match port_id with rrd graphs
Hi,
I would like to do some rrdtool fetch against the raw rrd files observium generated to get some reports. But I couldn’t figure out how to match the portid or device_id from observium tables to get the correct path to match to the rrd files.
Rrd files location seemed to be at ~observium/rrd/devicenames. But the rrd file name like port-123.rrd, 123 seems not to be the port_id in the ports table. Rather it’s device specific.
Thank you very much for your help.
—Zhenhui
That value is the ports IfIndex as reported by IF-MIB and is kept in `ifIndex` in the ports table.
Cheers, Dave
On Mon, Mar 30, 2015 at 11:19 AM, Zhenhui Liang ZhenhuiLiang@eharmony.com wrote:
Hi,
I would like to do some rrdtool fetch against the raw rrd files observium generated to get some reports. But I couldn’t figure out how to match the portid or device_id from observium tables to get the correct path to match to the rrd files.
Rrd files location seemed to be at ~observium/rrd/devicenames. But the rrd file name like port-123.rrd, 123 seems not to be the port_id in the ports table. Rather it’s device specific.
Thank you very much for your help.
—Zhenhui _______________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
Excellent. Thank you very much!
From: Dave Lindon <observium@davelindon.memailto:observium@davelindon.me> Reply-To: Observium Network Observation System <observium@observium.orgmailto:observium@observium.org> Date: Monday, March 30, 2015 at 11:27 AM To: Observium Network Observation System <observium@observium.orgmailto:observium@observium.org> Subject: Re: [Observium] match port_id with rrd graphs
That value is the ports IfIndex as reported by IF-MIB and is kept in `ifIndex` in the ports table.
Cheers, Dave
On Mon, Mar 30, 2015 at 11:19 AM, Zhenhui Liang <ZhenhuiLiang@eharmony.commailto:ZhenhuiLiang@eharmony.com> wrote: Hi,
I would like to do some rrdtool fetch against the raw rrd files observium generated to get some reports. But I couldn’t figure out how to match the portid or device_id from observium tables to get the correct path to match to the rrd files.
Rrd files location seemed to be at ~observium/rrd/devicenames. But the rrd file name like port-123.rrd, 123 seems not to be the port_id in the ports table. Rather it’s device specific.
Thank you very much for your help.
—Zhenhui _______________________________________________ observium mailing list observium@observium.orgmailto:observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
Negative, It's an auto-incrementing number.
mysql> DESCRIBE `ports` `port_id`; +---------+---------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------+---------+------+-----+---------+----------------+ | port_id | int(11) | NO | PRI | NULL | auto_increment | +---------+---------+------+-----+---------+----------------+ 1 row in set (0.01 sec)
Regards,
SG
On 3/30/2015 12:27 PM, Dave Lindon wrote:
That value is the ports IfIndex as reported by IF-MIB and is kept in `ifIndex` in the ports table.
Cheers, Dave
On Mon, Mar 30, 2015 at 11:19 AM, Zhenhui Liang <ZhenhuiLiang@eharmony.com mailto:ZhenhuiLiang@eharmony.com> wrote:
Hi, I would like to do some rrdtool fetch against the raw rrd files observium generated to get some reports. But I couldn’t figure out how to match the portid or device_id from observium tables to get the correct path to match to the rrd files. Rrd files location seemed to be at ~observium/rrd/devicenames. But the rrd file name like port-123.rrd, 123 seems not to be the port_id in the ports table. Rather it’s device specific. Thank you very much for your help. —Zhenhui _______________________________________________ observium mailing list observium@observium.org <mailto:observium@observium.org> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
Misread that, disregard.
Negative, It's an auto-incrementing number.
mysql> DESCRIBE `ports` `port_id`; +---------+---------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------+---------+------+-----+---------+----------------+ | port_id | int(11) | NO | PRI | NULL | auto_increment | +---------+---------+------+-----+---------+----------------+ 1 row in set (0.01 sec)
Regards,
SG
On 3/30/2015 12:27 PM, Dave Lindon wrote:
That value is the ports IfIndex as reported by IF-MIB and is kept in `ifIndex` in the ports table.
Cheers, Dave
On Mon, Mar 30, 2015 at 11:19 AM, Zhenhui Liang <ZhenhuiLiang@eharmony.com mailto:ZhenhuiLiang@eharmony.com> wrote:
Hi, I would like to do some rrdtool fetch against the raw rrd files observium generated to get some reports. But I couldnt figure out how to match the portid or device_id from observium tables to get the correct path to match to the rrd files. Rrd files location seemed to be at ~observium/rrd/devicenames. But the rrd file name like port-123.rrd, 123 seems not to be the port_id in the ports table. Rather its device specific. Thank you very much for your help. Zhenhui _______________________________________________ observium mailing list observium@observium.org <mailto:observium@observium.org> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
But the rrd file name to match port_id is ~/rrd/devicetable.hostname/port-ifindex.rrd
On 3/30/15, 11:36 AM, "Spencer Gaw" spencerg@frii.net wrote:
Negative, It's an auto-incrementing number.
mysql> DESCRIBE `ports` `port_id`; +---------+---------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------+---------+------+-----+---------+----------------+ | port_id | int(11) | NO | PRI | NULL | auto_increment | +---------+---------+------+-----+---------+----------------+ 1 row in set (0.01 sec)
Regards,
SG
On 3/30/2015 12:27 PM, Dave Lindon wrote:
That value is the ports IfIndex as reported by IF-MIB and is kept in `ifIndex` in the ports table.
Cheers, Dave
On Mon, Mar 30, 2015 at 11:19 AM, Zhenhui Liang <ZhenhuiLiang@eharmony.com mailto:ZhenhuiLiang@eharmony.com> wrote:
Hi, I would like to do some rrdtool fetch against the raw rrd files observium generated to get some reports. But I couldn¹t figure out how to match the portid or device_id from observium tables to get the correct path to match to the rrd files. Rrd files location seemed to be at ~observium/rrd/devicenames. But the rrd file name like port-123.rrd, 123 seems not to be the port_id in the ports table. Rather it¹s device specific. Thank you very much for your help. ‹Zhenhui _______________________________________________ observium mailing list observium@observium.org <mailto:observium@observium.org> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
participants (4)
-
Dave Lindon -
Spencer Gaw -
spencerg＠frii.net
-
Zhenhui Liang