[ixpmanager] update-l2database.pl not updating database
Barry O'Donovan
barry.odonovan at inex.ie
Wed Sep 25 20:12:24 IST 2013
On 25/09/13 20:01, Brian Thompson wrote:
> Doesn't ifname in the switchport table have to match the snmp poll of
> l2database script to insert in to the macaddress table?
I think Nick is keying off the 'name' field in switchport (which is
ifDescription), but yes, in general the above is right.
But, unless I misunderstood your email, you were throwing
switchport.ifPhysAddress into the mix which is the red herring I
referred to - ifPhysAddress has nothing to do with anything.
- Barry
>
>
>
> *Brian Thompson*
> Senior Infrastructure Engineer // Senior Second Guesser
>
> Direct: 503.943.6779
> Mobile: 503.707.9018 // Twitter: iovation
> *www.iovation.com <http://www.iovation.com/>*
>
>
>
> On Wed, Sep 25, 2013 at 11:44 AM, Barry O'Donovan
> <barry.odonovan at inex.ie <mailto:barry.odonovan at inex.ie>> wrote:
>
>
>
> On 25/09/13 19:05, Brian Thompson wrote:
>
> This definitely seems to be the issue.
>
>
> No, this is a red herring.
>
> The switchport database contains the physical MAC address of the
> switch port - we don't use it for anything (yet, if ever).
>
> This has nothing what so ever to do with the l2database.pl
> <http://l2database.pl> script.
>
> - Barry
>
>
> The /bin/ixptool.php -a switch-cli.snmp-poll script is loading the
> database with layer 2 interface. (i.e. with out the .0 in the
> name) and
> The bin/update-l2database-test.pl
> <http://update-l2database-test.pl>
> <http://update-l2database-__test.pl
> <http://update-l2database-test.pl>>
>
> --debug --vlan 998 script is showing the macaddresses on the layer 3
> interfaces.
>
> root at portal:~# perl /usr/local/bin/update-__l2database-test.pl
> <http://update-l2database-test.pl>
> <http://update-l2database-__test.pl
> <http://update-l2database-test.pl>> --debug --vlan 998
>
> DEBUG: processing ex4500
> DEBUG: attempting to retrieve dot1qVlanFdbId mapping
> (.1.3.6.1.2.1.17.7.1.4.2.1.3) on ex4500
> DEBUG: that didn't work. let's try Juniper EX jnxExVlanTag mapping
> instead (.1.3.6.1.4.1.2636.3.40.1.5.1.__5.1.5) on ex4500
> DEBUG: attempting Q-BRIDGE-MIB (.1.3.6.1.2.1.17.7.1.2.2.1.2.__2)
> on ex4500
> $l2mapping = {
> 'ex4500' => {
> 'ge-0/0/39.0' => [
> '00d02b194100'
> ],
> 'ge-0/0/19.0' => [
> '00500b38b419'
> ],
> 'ge-0/0/2.0' => [
> '5c5eabdc7e79'
> ],
> 'ge-0/1/1.0' => [
> '5c5eabd24278'
> and
>
> $ports = {
> 'ex4500' => {
> 'xe-0/0/26' => {
> 'switchportid' => '10',
> 'infrastructure' => '1',
> 'status' => '1',
> 'switch' => 'ex4500',
> 'switchport' =>
> 'xe-0/0/26',
> 'spifname' =>
> 'xe-0/0/26',
> 'id' => '25'
> },
> 'ge-0/0/25' => {
> 'switchportid' => '21',
> 'infrastructure' => '1',
> 'status' => '1',
> 'switch' => 'ex4500',
> 'switchport' =>
> 'ge-0/0/25',
> 'spifname' =>
> 'ge-0/0/25',
> 'id' => '24'
> },
> 'xe-0/0/0' => {
> 'switchportid' => '5',
> 'infrastructure' => '1',
> 'status' => '1',
> 'switch' => 'ex4500',
> 'switchport' =>
> 'xe-0/0/0',
> 'spifname' => 'xe-0/0/0',
> 'id' => '2'
> },
>
>
> mysql> desc switchport;
> +---------------+-------------__-+------+-----+---------+-----__-----------+
> | Field | Type | Null | Key | Default | Extra
> |
> +---------------+-------------__-+------+-----+---------+-----__-----------+
> | id | int(11) | NO | PRI | NULL |
> auto_increment |
> | switchid | int(11) | YES | MUL | NULL |
> |
> | type | int(11) | YES | | NULL |
> |
> | name | varchar(255) | YES | | NULL |
> |
> | active | tinyint(1) | NO | | NULL |
> |
> | ifIndex | int(11) | YES | | NULL |
> |
> | ifName | varchar(255) | YES | | NULL |
> |
> | ifAlias | varchar(255) | YES | | NULL |
> |
> | ifHighSpeed | int(11) | YES | | NULL |
> |
> | ifMtu | int(11) | YES | | NULL |
> |
> | ifPhysAddress | varchar(17) | YES | | NULL |
> |
> | ifAdminStatus | int(11) | YES | | NULL |
> |
> | ifOperStatus | int(11) | YES | | NULL |
> |
> | ifLastChange | int(11) | YES | | NULL |
> |
> | lastSnmpPoll | datetime | YES | | NULL |
> |
> | lagIfIndex | int(11) | YES | | NULL |
> |
> +---------------+-------------__-+------+-----+---------+-----__-----------+
> 16 rows in set (0.03 sec)
>
>
> +----+----------+------+------__-----+--------+---------+-----__------+-----------------------__----------------------+-------__------+-------+---------------__+---------------+-------------__-+--------------+-------------__--------+------------+
> | id | switchid | type | name | active | ifIndex | ifName |
> ifAlias | ifHighSpeed | ifMtu |
> ifPhysAddress | ifAdminStatus | ifOperStatus | ifLastChange |
> lastSnmpPoll | lagIfIndex |
> +----+----------+------+------__-----+--------+---------+-----__------+-----------------------__----------------------+-------__------+-------+---------------__+---------------+-------------__-+--------------+-------------__--------+------------+
> | 1 | 1 | 0 | me0 | 1 | 33 | me0 |
> | 1000 | 1514 |
> 50C58DA83582 | 1 | 1 | 1378257361 |
> 2013-09-25
> 18:51:24 | NULL |
> | 2 | 1 | 0 | vme | 1 | 35 | vme |
> | 1000 | 1518 |
> 50C58DA83582 | 1 | 1 | 1378257361 |
> 2013-09-25
> 18:51:24 | NULL |
> | 3 | 1 | 0 | bme0 | 1 | 37 | bme0 |
> | 0 | 1576 |
> 000BCAFE0000 | 1 | 1 | 0 |
> 2013-09-25
> 18:51:24 | NULL |
> | 4 | 1 | 0 | vlan | 1 | 503 | vlan |
> | 1000 | 1518 |
> 50C58DA83581 | 1 | 1 | 0 |
> 2013-09-25
> 18:51:24 | NULL |
> | 5 | 1 | 1 | xe-0/0/0 | 1 | 504 | xe-0/0/0 |
> xxxxx xe-0/3/0 | 10000 | 1518 |
> 50C58DA83583 | 1 | 1 | 1377849038 |
> 2013-09-25
> 18:51:25 | NULL |
> | 6 | 1 | 1 | ge-0/1/3 | 1 | 508 | ge-0/1/3 |
> xxxxxxxxxxx | 1000 | 1514 |
> 50C58DA835AE |
> 1 | 2 | 1378256790 | 2013-09-25
> 18:51:25 |
> NULL |
> | 7 | 1 | 1 | xe-0/0/4 | 1 | 512 | xe-0/0/4 |
> xxxxxxxxxxxx | 10000 | 1514 |
> 50C58DA83587
> | 1 | 1 | 1377849039 | 2013-09-25
> 18:51:25 |
> NULL |
> | 8 | 1 | 1 | xe-0/0/16 | 1 | 536 | xe-0/0/16 |
> xxxxxxxxxxxx | 10000 | 1514 |
> 50C58DA83593
> | 1 |
>
> *Brian Thompson*
>
> Senior Infrastructure Engineer // Senior Second Guesser
>
> Direct: 503.943.6779 <tel:503.943.6779>
> Mobile: 503.707.9018 <tel:503.707.9018> // Twitter: iovation
> *www.iovation.com <http://www.iovation.com>
> <http://www.iovation.com/>*
>
>
>
>
> On Wed, Sep 25, 2013 at 2:45 AM, Barry O'Donovan
> <barry.odonovan at inex.ie <mailto:barry.odonovan at inex.ie>
> <mailto:barry.odonovan at inex.ie
> <mailto:barry.odonovan at inex.ie>__>> wrote:
>
>
>
> On 25/09/13 10:43, Barry O'Donovan wrote:
>
> Note that the database now also records the ifIndex of
> ports
> (and other
> additional info - see below)
>
>
> Opps... quoted the wrong table. Here's switchport:
>
> MariaDB [inex]> desc switchport;
> +---------------+-------------____-+
> | Field | Type |
> +---------------+-------------____-+
>
> | id | int(11) |
> | switchid | int(11) |
> | type | int(11) |
> | name | varchar(255) |
> | ifName | varchar(255) |
> | ifAlias | varchar(255) |
> | ifHighSpeed | int(11) |
> | ifMtu | int(11) |
> | ifPhysAddress | varchar(17) |
> | ifAdminStatus | int(11) |
> | ifOperStatus | int(11) |
> | ifLastChange | int(11) |
> | lastSnmpPoll | datetime |
> | ifIndex | int(11) |
> | active | tinyint(1) |
> | lagIfIndex | int(11) |
> +---------------+-------------____-+
>
> 16 rows in set (0.00 sec)
>
>
> - Barry
>
>
>
> ___________________________________________________
>
> INEX IXP Manager mailing list
> ixpmanager at inex.ie <mailto:ixpmanager at inex.ie>
> <mailto:ixpmanager at inex.ie <mailto:ixpmanager at inex.ie>>
> https://www.inex.ie/mailman/____listinfo/ixpmanager
> <https://www.inex.ie/mailman/__listinfo/ixpmanager>
> <https://www.inex.ie/mailman/__listinfo/ixpmanager
> <https://www.inex.ie/mailman/listinfo/ixpmanager>>
>
>
>
>
>
> _________________________________________________
> INEX IXP Manager mailing list
> ixpmanager at inex.ie <mailto:ixpmanager at inex.ie>
> https://www.inex.ie/mailman/__listinfo/ixpmanager
> <https://www.inex.ie/mailman/listinfo/ixpmanager>
>
>
> --
>
>
> Kind regards,
> Barry O'Donovan
> INEX Operations
>
> We're IPv6 Ready. Are you? http://www.ipv6ready.ie/
>
> Mob: +353 86 801 7669 <tel:%2B353%2086%20801%207669>
> Tel: +353 1 685 4220 <tel:%2B353%20%201%20685%204220>
> SIP: barry at opensolutions.ie <mailto:barry at opensolutions.ie>
> Fax: +353 1 685 4263 <tel:%2B353%20%201%20685%204263>
>
> +-----------------------------__--+---------------------------__----------+
> | Open Source Solutions Ltd. | INEX Operations Team |
> | Lynx House Old Church Road, | Internet Neutral Exchange |
> | Lower Kilmacud Road, | Association, 4027 Kingswood Road, |
> | Stillorgan, Co Dublin. | Citywest Business Campus, Dublin 24 |
> | http://www.opensolutions.ie/ | http://www.inex.ie/ |
> +-----------------------------__--+---------------------------__----------+
>
>
>
> _________________________________________________
> INEX IXP Manager mailing list
> ixpmanager at inex.ie <mailto:ixpmanager at inex.ie>
> https://www.inex.ie/mailman/__listinfo/ixpmanager
> <https://www.inex.ie/mailman/listinfo/ixpmanager>
>
>
>
>
> _______________________________________________
> INEX IXP Manager mailing list
> ixpmanager at inex.ie
> https://www.inex.ie/mailman/listinfo/ixpmanager
>
--
Kind regards,
Barry O'Donovan
INEX Operations
We're IPv6 Ready. Are you? http://www.ipv6ready.ie/
Mob: +353 86 801 7669
Tel: +353 1 685 4220
SIP: barry at opensolutions.ie
Fax: +353 1 685 4263
+-------------------------------+-------------------------------------+
| Open Source Solutions Ltd. | INEX Operations Team |
| Lynx House Old Church Road, | Internet Neutral Exchange |
| Lower Kilmacud Road, | Association, 4027 Kingswood Road, |
| Stillorgan, Co Dublin. | Citywest Business Campus, Dublin 24 |
| http://www.opensolutions.ie/ | http://www.inex.ie/ |
+-------------------------------+-------------------------------------+
More information about the ixpmanager
mailing list