[prev in list] [next in list] [prev in thread] [next in thread] 

List:       opennms-devel
Subject:    [opennms-devel] Re: [opennms-discuss] IPINTERFACE table - Duplicated rows with same nodeid
From:       aitor_goiri () ieci ! es
Date:       2005-09-14 12:54:40
Message-ID: OF7426BD26.03092A64-ONC125707C.0046AD73-C125707C.0046DF27 () ieci ! es
[Download RAW message or body]

I post in devel-list before creating a bug in bugzilla........

|------------------------------------------------|


On Sep 12, 2005, at 17:52, aitor_goiri@ieci.es wrote:

      Hello ...

      Some days ago i saw something strange in the "Choose SNMP Interfaces
for Data Collection" page (http://x.x.x.x/opennms/admin/snmpGetInterfaces)
... there are duplicated rows with the same "nodeid" and "ifindex".
      I cleaned the table of those duplicated rows and i created the
following constraint ....

ALTER TABLE ipinterface ADD CONSTRAINT ipinterface_clave_unica
UNIQUE (nodeid, ifindex);

.... but i got multiple ERRORs in capsd.log. It seems like Capsd doesn't
update those old rows when the SNMP test runs over the nodes....

      i have this problem in many nodes but i didn't care about this until
a rutinary customization task...

      I add two screenshots about a router with this problem:
            1º pic - about the the "Choose SNMP Interfaces for Data
Collection" page
            2º pic - about the data view of the ipinterface table with
pgAdmin

(See attached file: snmpGetInterfaces_onms.jpg)(See attached file:
ipinterface_table.jpg)

      The data about the that router is:
            - SYSOID: enterprises.9.1.209
            - IPADDRTABLE:
                  IP-MIB::ipAdEntAddr.3.10.0.1 = IpAddress: 3.10.0.1
                  IP-MIB::ipAdEntAddr.10.0.200.8 = IpAddress: 10.0.200.8
                  IP-MIB::ipAdEntAddr.14.1.1.106 = IpAddress: 14.1.1.106
                  IP-MIB::ipAdEntAddr.172.16.54.202 = IpAddress:
172.16.54.202
                  IP-MIB::ipAdEntAddr.172.19.1.5 = IpAddress: 172.19.1.5
                  IP-MIB::ipAdEntAddr.192.168.150.1 = IpAddress:
192.168.150.1
                  IP-MIB::ipAdEntAddr.192.168.200.122 = IpAddress:
192.168.200.122
                  IP-MIB::ipAdEntAddr.210.210.3.1 = IpAddress: 210.210.3.1
                  IP-MIB::ipAdEntAddr.210.210.5.1 = IpAddress: 210.210.5.1
                  IP-MIB::ipAdEntAddr.210.210.5.5 = IpAddress: 210.210.5.5
                  IP-MIB::ipAdEntAddr.210.210.5.9 = IpAddress: 210.210.5.9
                  IP-MIB::ipAdEntAddr.210.210.5.17 = IpAddress:
210.210.5.17
                  IP-MIB::ipAdEntIfIndex.3.10.0.1 = INTEGER: 39
                  IP-MIB::ipAdEntIfIndex.10.0.200.8 = INTEGER: 76
                  IP-MIB::ipAdEntIfIndex.14.1.1.106 = INTEGER: 1
                  IP-MIB::ipAdEntIfIndex.172.16.54.202 = INTEGER: 18
                  IP-MIB::ipAdEntIfIndex.172.19.1.5 = INTEGER: 36
                  IP-MIB::ipAdEntIfIndex.192.168.150.1 = INTEGER: 3
                  IP-MIB::ipAdEntIfIndex.192.168.200.122 = INTEGER: 33
                  IP-MIB::ipAdEntIfIndex.210.210.3.1 = INTEGER: 35
                  IP-MIB::ipAdEntIfIndex.210.210.5.1 = INTEGER: 4
                  IP-MIB::ipAdEntIfIndex.210.210.5.5 = INTEGER: 81
                  IP-MIB::ipAdEntIfIndex.210.210.5.9 = INTEGER: 80
                  IP-MIB::ipAdEntIfIndex.210.210.5.17 = INTEGER: 6
            - IFTABLE:
                  IF-MIB::ifIndex.1 = INTEGER: 1
                  IF-MIB::ifIndex.2 = INTEGER: 2
                  IF-MIB::ifIndex.3 = INTEGER: 3
                  IF-MIB::ifIndex.4 = INTEGER: 4
                  IF-MIB::ifIndex.5 = INTEGER: 5
                  IF-MIB::ifIndex.6 = INTEGER: 6
                        . . . . . .
                  IF-MIB::ifIndex.81 = INTEGER: 81

      I didn't create a bug in Bugzilla yet, because i don't know if it's a
problem about the cfg files....(See attached file:
snmpGetInterfaces_onms.jpg)(See attached file: ipinterface_table.jpg)
["=?ISO-8859-1?Q?snmpGetInterfaces=5Fonms=2Ejpg?=" (image/jpeg)]
["=?ISO-8859-1?Q?ipinterface=5Ftable=2Ejpg?=" (image/jpeg)]
-------------------------------------------------------
SF.Net email is sponsored by:
Tame your development challenges with Apache's Geronimo App Server. 
Download it for free - -and be entered to win a 42" plasma tv or your very
own Sony(tm)PSP.  Click here to play: http://sourceforge.net/geronimo.php
_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/wiki/index.php?page=MailingListFaq

opennms-devel mailing list

To *unsubscribe* or change your subscription options, see the bottom of this page:
https://lists.sourceforge.net/lists/listinfo/opennms-devel

[prev in list] [next in list] [prev in thread] [next in thread]