[ixpmanager] update-l2database.pl not updating database

Barry O'Donovan barry.odonovan at inex.ie
Wed Sep 25 10:45:51 IST 2013



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





More information about the ixpmanager mailing list