So, I’ve had some issues recently that caused me to wipe my Observium install. I drop’d the DB, rm’d the RRDs and followed the install instructions for creating a new DB and getting things going again.
I add a device, run a discovery.php -h new, and everything seems ok… but once I let Observium poll it, or do so manually using poller.php it starts deleting all my interfaces…
I’ve included the output below, with a debug turned on for the poller process.
Thanks for your help.
-Tony
root@netmon:/opt/observium# ./add_device.php ea-core XXXXXXXXX
Observium v0.14.4.5229
Add Device(s)
Try to add ea-core:
Trying v2c community XXXXXXXXX ...
Now discovering ea-core (id = 8)
ea-core 8 generic
Ports : Vl1(1)[730] Vl2(2)[731] Vl3(3)[732] Vl4(4)[733] Vl5(5)[734] Vl6(6)[735] Vl7(7)[736] Vl8(8)[737] Vl9(9)[738] Vl10(10)[739] Vl11(11)[740] Vl13(13)[741] Vl14(14)[742] Vl18(18)[743] Vl19(19)[744] Vl20(20)[745] Vl21(21)[746] Vl22(22)[747] Vl23(23)[748] Vl24(24)[749] Vl32(32)[750] Vl47(47)[751] Vl62(62)[752] Vl63(63)[753] Vl88(88)[754] Vl93(93)[755] Vl94(94)[756] Vl111(111)[757] Vl191(191)[758] Vl193(193)[759] Vl199(199)[760] Vl200(200)[761] Vl248(248)[762] Vl901(901)[763] Vl902(902)[764] Po1(5001)[765] Po2(5002)[766] Po5(5005)[767] Po10(5010)[768] Po11(5011)[769] Po16(5016)[770] Po21(5021)[771] Po22(5022)[772] StackPort1(5179)[773] StackSub-St1-1(5180)[774] StackSub-St1-2(5181)[775] StackPort2(5182)[776] StackSub-St2-1(5183)[777] StackSub-St2-2(5184)[778] StackPort3(5185)[779] StackSub-St3-1(5186)[780] StackSub-St3-2(5187)[781] StackPort4(5188)[782] StackSub-St4-1(5189)[783] StackSub-St4-2(5190)[784] Gi1/0/1(10101)[785] Gi1/0/2(10102)[786] Gi1/0/3(10103)[787] Gi1/0/4(10104)[788] Gi1/0/5(10105)[789] Gi1/0/6(10106)[790] Gi1/0/7(10107)[791] Gi1/0/8(10108)[792] Gi1/0/9(10109)[793] Gi1/0/10(10110)[794] Gi1/0/11(10111)[795] Gi1/0/12(10112)[796] Gi1/0/13(10113)[797] Gi1/0/14(10114)[798] Gi1/0/15(10115)[799] Gi1/0/16(10116)[800] Gi1/0/17(10117)[801] Gi1/0/18(10118)[802] Gi1/0/19(10119)[803] Gi1/0/20(10120)[804] Gi1/0/21(10121)[805] Gi1/0/22(10122)[806] Gi1/0/23(10123)[807] Gi1/0/24(10124)[808] Gi1/0/25(10125)[809] Gi1/0/26(10126)[810] Gi1/0/27(10127)[811] Gi1/0/28(10128)[812] Gi2/0/1(10601)[813] Gi2/0/2(10602)[814] Gi2/0/3(10603)[815] Gi2/0/4(10604)[816] Gi2/0/5(10605)[817] Gi2/0/6(10606)[818] Gi2/0/7(10607)[819] Gi2/0/8(10608)[820] Gi2/0/9(10609)[821] Gi2/0/10(10610)[822] Gi2/0/11(10611)[823] Gi2/0/12(10612)[824] Gi2/0/13(10613)[825] Gi2/0/14(10614)[826] Gi2/0/15(10615)[827] Gi2/0/16(10616)[828] Gi2/0/17(10617)[829] Gi2/0/18(10618)[830] Gi2/0/19(10619)[831] Gi2/0/20(10620)[832] Gi2/0/21(10621)[833] Gi2/0/22(10622)[834] Gi2/0/23(10623)[835] Gi2/0/24(10624)[836] Gi2/0/25(10625)[837] Gi2/0/26(10626)[838] Gi2/0/27(10627)[839] Gi2/0/28(10628)[840] Gi3/0/1(11101)[841] Gi3/0/2(11102)[842] Gi3/0/3(11103)[843] Gi3/0/4(11104)[844] Gi3/0/5(11105)[845] Gi3/0/6(11106)[846] Gi3/0/7(11107)[847] Gi3/0/8(11108)[848] Gi3/0/9(11109)[849] Gi3/0/10(11110)[850] Gi3/0/11(11111)[851] Gi3/0/12(11112)[852] Gi4/0/1(11601)[853] Gi4/0/2(11602)[854] Gi4/0/3(11603)[855] Gi4/0/4(11604)[856] Gi4/0/5(11605)[857] Gi4/0/6(11606)[858] Gi4/0/7(11607)[859] Gi4/0/8(11608)[860] Gi4/0/9(11609)[861] Gi4/0/10(11610)[862] Gi4/0/11(11611)[863] Gi4/0/12(11612)[864] Gi4/0/13(11613)[865] Gi4/0/14(11614)[866] Gi4/0/15(11615)[867] Gi4/0/16(11616)[868] Gi4/0/17(11617)[869] Gi4/0/18(11618)[870] Gi4/0/19(11619)[871] Gi4/0/20(11620)[872] Gi4/0/21(11621)[873] Gi4/0/22(11622)[874] Gi4/0/23(11623)[875] Gi4/0/24(11624)[876] Nu0(14501)[877] Lo0(24567)[878]
Discovered in 4.095 seconds
ea-core 8 generic
IPv4 Addresses :
Discovered in 0.239 seconds
ea-core 8 generic
IPv6 Addresses :
Discovered in 0.236 seconds
Added device ea-core (8).
Devices added: 1.
##############################################
root@netmon:/opt/observium# ./poller.php -h all -d
DEBUG!
Observium v0.14.4.5229
Poller
Starting polling run:
SQL[SELECT `device_id` FROM `devices` WHERE `disabled` = 0 ORDER BY `device_id` ASC]
SQL[SELECT * FROM `devices` WHERE `device_id` = '9']
SQL[SELECT * FROM devices_attribs WHERE `device_id` = '9']
ea-core 9 generic
Created directory : /opt/observium/rrd/ea-core
DEBUG: SNMP Auth options = -v2c -c 'XXXXXX'
/usr/bin/snmpget -v2c -c 'XXXXXX' -Oqtn -m DISMAN-EVENT-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ea-core':'161' .1.3.6.1.2.1.1.3.0
.1.3.6.1.2.1.1.3.0 1260931659
RRD[/usr/bin/rrdtool create /opt/observium/rrd/ea-core/status.rrd DS:status:GAUGE:600:0:1 --step 300 RRA:AVERAGE:0.5:1:2016 RRA:AVERAGE:0.5:6:2976 RRA:AVERAGE:0.5:24:1440 RRA:AVERAGE:0.5:288:1440 RRA:MIN:0.5:6:1440 RRA:MIN:0.5:96:360 RRA:MIN:0.5:288:1440 RRA:MAX:0.5:6:1440 RRA:MAX:0.5:96:360 RRA:MAX:0.5:288:1440 ]
RRD[cmd[update /opt/observium/rrd/ea-core/status.rrd N:1]
stdout[OK u:0.01 s:0.00 r:0.03]
stderr[]]
RRD[/usr/bin/rrdtool create /opt/observium/rrd/ea-core/ping.rrd DS:ping:GAUGE:600:0:65535 --step 300 RRA:AVERAGE:0.5:1:2016 RRA:AVERAGE:0.5:6:2976 RRA:AVERAGE:0.5:24:1440 RRA:AVERAGE:0.5:288:1440 RRA:MIN:0.5:6:1440 RRA:MIN:0.5:96:360 RRA:MIN:0.5:288:1440 RRA:MAX:0.5:6:1440 RRA:MAX:0.5:96:360 RRA:MAX:0.5:288:1440 ]
RRD[cmd[update /opt/observium/rrd/ea-core/ping.rrd N:2.12]
stdout[OK u:0.01 s:0.00 r:0.04]
stderr[]]
RRD[/usr/bin/rrdtool create /opt/observium/rrd/ea-core/ping_snmp.rrd DS:ping_snmp:GAUGE:600:0:65535 --step 300 RRA:AVERAGE:0.5:1:2016 RRA:AVERAGE:0.5:6:2976 RRA:AVERAGE:0.5:24:1440 RRA:AVERAGE:0.5:288:1440 RRA:MIN:0.5:6:1440 RRA:MIN:0.5:96:360 RRA:MIN:0.5:288:1440 RRA:MAX:0.5:6:1440 RRA:MAX:0.5:96:360 RRA:MAX:0.5:288:1440 ]
RRD[cmd[update /opt/observium/rrd/ea-core/ping_snmp.rrd N:13.89]
stdout[OK u:0.01 s:0.00 r:0.05]
stderr[]]
Module [ unix-agent ] disabled globally.
Module [ junose-atm-vp ] excluded for device.
Module [ cisco-ipsec-flow-monitor ] excluded for device.
Module [ cisco-remote-access-monitor ] excluded for device.
Module [ cisco-cef ] excluded for device.
Module [ cisco-sla ] excluded for device.
Module [ arista-software-ip-forwarding ] excluded for device.
Module [ cipsec-tunnels ] excluded for device.
Module [ cisco-ace-loadbalancer ] excluded for device.
Module [ cisco-ace-serverfarms ] excluded for device.
Module [ cisco-cbqos ] excluded for device.
Module [ cisco-eigrp ] excluded for device.
Module [ netscaler-vsvr ] excluded for device.
Module [ aruba-controller ] excluded for device.
Module [ cisco-vpdn ] disabled globally.
Module [ wmi ] disabled globally.
including: includes/polling/system.inc.php
DEBUG: SNMP Auth options = -v2c -c 'XXXXXX'
/usr/bin/snmpget -v2c -c 'XXXXXX' -OQUs -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ea-core':'161' sysUpTime.0 sysLocation.0 sysContact.0 sysName.0
DEBUG: SNMP Auth options = -v2c -c 'XXXXXX'
/usr/bin/snmpget -v2c -c 'XXXXXX' -Oqv -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ea-core':'161' sysDescr.0
DEBUG: SNMP Auth options = -v2c -c 'XXXXXX'
/usr/bin/snmpget -v2c -c 'XXXXXX' -Oqvn -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ea-core':'161' sysObjectID.0
DEBUG: SNMP Auth options = -v2c -c 'XXXXXX'
/usr/bin/snmpget -v2c -c 'XXXXXX' -Ovqn -m SNMP-FRAMEWORK-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ea-core':'161' snmpEngineID.0
DEBUG: SNMP Auth options = -v2c -c 'XXXXXX'
/usr/bin/snmpget -v2c -c 'XXXXXX' -Oqv -m HOST-RESOURCES-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ea-core':'161' hrSystemUptime.0
DEBUG: SNMP Auth options = -v2c -c 'XXXXXX'
/usr/bin/snmpget -v2c -c 'XXXXXX' -OUqv -m SNMP-FRAMEWORK-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ea-core':'161' snmpEngineTime.0
Using SNMP Agent sysUpTime (0 seconds)
RRD[/usr/bin/rrdtool create /opt/observium/rrd/ea-core/uptime.rrd DS:uptime:GAUGE:600:0:U --step 300 RRA:AVERAGE:0.5:1:2016 RRA:AVERAGE:0.5:6:2976 RRA:AVERAGE:0.5:24:1440 RRA:AVERAGE:0.5:288:1440 RRA:MIN:0.5:6:1440 RRA:MIN:0.5:96:360 RRA:MIN:0.5:288:1440 RRA:MAX:0.5:6:1440 RRA:MAX:0.5:96:360 RRA:MAX:0.5:288:1440 ]
RRD[cmd[update /opt/observium/rrd/ea-core/uptime.rrd N:0]
stdout[OK u:0.01 s:0.00 r:0.12]
stderr[]]
Uptime: 0s
GEO-API REQUEST: http://maps.googleapis.com/maps/api/geocode/json?sensor=false&address=
Module time: 0.2669s
including: includes/polling/os.inc.php
I'm Generic :'(
Hardware: Version: Features: Serial: Asset:
Module time: 0.0007s
including: includes/polling/ipmi.inc.php
IPMI:
SQL[SELECT attrib_value FROM devices_attribs WHERE `device_id` = '9' AND `attrib_type` = 'ipmi_hostname']
$vars
=========
null
SQL[SELECT * FROM `sensors` AS S, `devices` AS D WHERE S.`sensor_class` = 'voltage' AND S.`device_id` = D.`device_id` AND D.`device_id` = '9' AND S.`poller_type` = 'ipmi']
SQL[SELECT * FROM `sensors` AS S, `devices` AS D WHERE S.`sensor_class` = 'temperature' AND S.`device_id` = D.`device_id` AND D.`device_id` = '9' AND S.`poller_type` = 'ipmi']
SQL[SELECT * FROM `sensors` AS S, `devices` AS D WHERE S.`sensor_class` = 'fanspeed' AND S.`device_id` = D.`device_id` AND D.`device_id` = '9' AND S.`poller_type` = 'ipmi']
SQL[SELECT * FROM `sensors` AS S, `devices` AS D WHERE S.`sensor_class` = 'power' AND S.`device_id` = D.`device_id` AND D.`device_id` = '9' AND S.`poller_type` = 'ipmi']
SQL[SELECT * FROM `sensors` AS S, `devices` AS D WHERE S.`sensor_class` = 'airflow' AND S.`device_id` = D.`device_id` AND D.`device_id` = '9' AND S.`poller_type` = 'ipmi']
SQL[SELECT * FROM `sensors` AS S, `devices` AS D WHERE S.`sensor_class` = '' AND S.`device_id` = D.`device_id` AND D.`device_id` = '9' AND S.`poller_type` = 'ipmi']
Module time: 0.0117s
including: includes/polling/sensors.inc.php
SQL[SELECT COUNT(*) FROM `sensors` WHERE `device_id` = '9' AND `sensor_deleted` = '0';]
Module time: 0.0009s
including: includes/polling/processors.inc.php
SQL[SELECT `processors`.*, `processors-state`.processor_usage, `processors-state`.processor_polled FROM `processors` LEFT JOIN `processors-state` ON `processors`.processor_id = `processors-state`.processor_id WHERE `device_id` = '9']
Module time: 0.001s
including: includes/polling/mempools.inc.php
SQL[SELECT `version` FROM `dbSchema`]
SQL[SELECT *, `mempools`.mempool_id as mempool_id FROM `mempools` LEFT JOIN `mempools-state` ON `mempools`.mempool_id = `mempools-state`.mempool_id WHERE `device_id` = '9']
Module time: 0.0016s
including: includes/polling/storage.inc.php
SQL[SELECT `version` FROM `dbSchema`]
SQL[SELECT `storage`.*, `storage-state`.storage_polled FROM `storage` LEFT JOIN `storage-state` ON `storage`.storage_id = `storage-state`.storage_id WHERE `device_id` = '9']
Module time: 0.0015s
including: includes/polling/netstats.inc.php
Netstats: DEBUG: SNMP Auth options = -v2c -c 'XXXXXX'
/usr/bin/snmpget -v2c -c 'XXXXXX' -OQUs -m IP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ea-core':'161' ipInReceives.0 ipOutRequests.0
DEBUG: SNMP Auth options = -v2c -c 'XXXXXX'
/usr/bin/snmpbulkwalk -v2c -c 'XXXXXX' -OQUs -m IP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ea-core':'161' icmp
DEBUG: SNMP Auth options = -v2c -c 'XXXXXX'
/usr/bin/snmpget -v2c -c 'XXXXXX' -OQUs -m TCP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ea-core':'161' tcpInSegs.0 tcpOutSegs.0
DEBUG: SNMP Auth options = -v2c -c 'XXXXXX'
/usr/bin/snmpget -v2c -c 'XXXXXX' -OQUs -m UDP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ea-core':'161' udpInDatagrams.0 udpOutDatagrams.0
DEBUG: SNMP Auth options = -v2c -c 'XXXXXX'
/usr/bin/snmpbulkwalk -v2c -c 'XXXXXX' -OQUs -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ea-core':'161' snmp
Module time: 0.0419s
including: includes/polling/hr-mib.inc.php
DEBUG: SNMP Auth options = -v2c -c 'XXXXXX'
/usr/bin/snmpget -v2c -c 'XXXXXX' -OUQs -m HOST-RESOURCES-MIB -M /opt/observium/mibs 'udp':'ea-core':'161' hrSystemProcesses.0 hrSystemNumUsers.0
hrSystemProcesses.0 = No Such Object available on this agent at this OID
hrSystemNumUsers.0 = No Such Object available on this agent at this OID
HR Stats:
Module time: 0.0189s
including: includes/polling/ucd-mib.inc.php
DEBUG: SNMP Auth options = -v2c -c 'XXXXXX'
/usr/bin/snmpbulkwalk -v2c -c 'XXXXXX' -OQUs -m UCD-SNMP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ea-core':'161' systemStats
DEBUG: SNMP Auth options = -v2c -c 'XXXXXX'
/usr/bin/snmpbulkwalk -v2c -c 'XXXXXX' -OQUs -m UCD-SNMP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ea-core':'161' mem
DEBUG: SNMP Auth options = -v2c -c 'XXXXXX'
/usr/bin/snmpbulkwalk -v2c -c 'XXXXXX' -OQUs -m UCD-SNMP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ea-core':'161' laLoadInt
Module time: 0.0274s
including: includes/polling/ipSystemStats.inc.php
Polling IP-MIB ipSystemStats DEBUG: SNMP Auth options = -v2c -c 'XXXXXX'
/usr/bin/snmpbulkwalk -v2c -c 'XXXXXX' -OQUs -m IP-MIB -M /opt/observium/mibs 'udp':'ea-core':'161' ipSystemStats
ipSystemStatsInReceives.ipv6 = 0
ipSystemStatsHCInReceives.ipv6 = 0
ipSystemStatsInOctets.ipv6 = 0
ipSystemStatsHCInOctets.ipv6 = 0
ipSystemStatsInHdrErrors.ipv6 = 0
ipSystemStatsInNoRoutes.ipv6 = 0
ipSystemStatsInAddrErrors.ipv6 = 0
ipSystemStatsInUnknownProtos.ipv6 = 0
ipSystemStatsInTruncatedPkts.ipv6 = 0
ipSystemStatsInForwDatagrams.ipv6 = 0
ipSystemStatsHCInForwDatagrams.ipv6 = 0
ipSystemStatsReasmReqds.ipv6 = 0
ipSystemStatsReasmOKs.ipv6 = 0
ipSystemStatsReasmFails.ipv6 = 0
ipSystemStatsInDiscards.ipv6 = 0
ipSystemStatsInDelivers.ipv6 = 0
ipSystemStatsHCInDelivers.ipv6 = 0
ipSystemStatsOutRequests.ipv6 = 0
ipSystemStatsHCOutRequests.ipv6 = 0
ipSystemStatsOutNoRoutes.ipv6 = 0
ipSystemStatsOutForwDatagrams.ipv6 = 0
ipSystemStatsHCOutForwDatagrams.ipv6 = 0
ipSystemStatsOutDiscards.ipv6 = 0
ipSystemStatsOutFragReqds.ipv6 = 0
ipSystemStatsOutFragOKs.ipv6 = 0
ipSystemStatsOutFragFails.ipv6 = 0
ipSystemStatsOutFragCreates.ipv6 = 0
ipSystemStatsOutTransmits.ipv6 = 0
ipSystemStatsHCOutTransmits.ipv6 = 0
ipSystemStatsOutOctets.ipv6 = 0
ipSystemStatsHCOutOctets.ipv6 = 0
ipSystemStatsInMcastPkts.ipv6 = 0
ipSystemStatsHCInMcastPkts.ipv6 = 0
ipSystemStatsInMcastOctets.ipv6 = 0
ipSystemStatsHCInMcastOctets.ipv6 = 0
ipSystemStatsOutMcastPkts.ipv6 = 0
ipSystemStatsHCOutMcastPkts.ipv6 = 0
ipSystemStatsOutMcastOctets.ipv6 = 0
ipSystemStatsHCOutMcastOctets.ipv6 = 0
ipSystemStatsInBcastPkts.ipv6 = 0
ipSystemStatsHCInBcastPkts.ipv6 = 0
ipSystemStatsOutBcastPkts.ipv6 = 0
ipSystemStatsHCOutBcastPkts.ipv6 = 0
ipSystemStatsDiscontinuityTime.ipv6 = 0:0:00:00.00
ipv6 RRD[/usr/bin/rrdtool create /opt/observium/rrd/ea-core/ipSystemStats-ipv6.rrd DS:InReceives:COUNTER:600:U:100000000000 DS:InHdrErrors:COUNTER:600:U:100000000000 DS:InAddrErrors:COUNTER:600:U:100000000000 DS:InUnknownProtos:COUNTER:600:U:100000000000 DS:InForwDatagrams:COUNTER:600:U:100000000000 DS:ReasmReqds:COUNTER:600:U:100000000000 DS:ReasmOKs:COUNTER:600:U:100000000000 DS:ReasmFails:COUNTER:600:U:100000000000 DS:InDiscards:COUNTER:600:U:100000000000 DS:InDelivers:COUNTER:600:U:100000000000 DS:OutRequests:COUNTER:600:U:100000000000 DS:OutNoRoutes:COUNTER:600:U:100000000000 DS:OutDiscards:COUNTER:600:U:100000000000 DS:OutFragFails:COUNTER:600:U:100000000000 DS:OutFragCreates:COUNTER:600:U:100000000000 DS:OutForwDatagrams:COUNTER:600:U:100000000000 --step 300 RRA:AVERAGE:0.5:1:2016 RRA:AVERAGE:0.5:6:2976 RRA:AVERAGE:0.5:24:1440 RRA:AVERAGE:0.5:288:1440 RRA:MIN:0.5:6:1440 RRA:MIN:0.5:96:360 RRA:MIN:0.5:288:1440 RRA:MAX:0.5:6:1440 RRA:MAX:0.5:96:360 RRA:MAX:0.5:288:1440 ]
RRD[cmd[update /opt/observium/rrd/ea-core/ipSystemStats-ipv6.rrd N:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0]
stdout[OK u:0.01 s:0.00 r:0.56]
stderr[]]
Module time: 0.1316s
including: includes/polling/ports.inc.php
Caching Oids: ifEntry DEBUG: SNMP Auth options = -v2c -c 'XXXXXX'
/usr/bin/snmpbulkwalk -v2c -c 'XXXXXX' -OQUs -m IF-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ea-core':'161' ifEntry
ifXEntry DEBUG: SNMP Auth options = -v2c -c 'XXXXXX'
/usr/bin/snmpbulkwalk -v2c -c 'XXXXXX' -OQUs -m IF-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ea-core':'161' ifXEntry
SQL[SELECT *, I.`port_id` AS `port_id` FROM `ports` AS I LEFT JOIN `ports-state` AS S ON I.`port_id` = S.`port_id` WHERE `device_id` = '9']
Port Vlan1(1) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '1']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','879','interface',NOW(),'Interface was marked as DELETED')]
Port Vlan2(2) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '2']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','880','interface',NOW(),'Interface was marked as DELETED')]
Port Vlan3(3) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '3']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','881','interface',NOW(),'Interface was marked as DELETED')]
Port Vlan4(4) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '4']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','882','interface',NOW(),'Interface was marked as DELETED')]
Port Vlan5(5) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '5']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','883','interface',NOW(),'Interface was marked as DELETED')]
Port Vlan6(6) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '6']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','884','interface',NOW(),'Interface was marked as DELETED')]
Port Vlan7(7) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '7']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','885','interface',NOW(),'Interface was marked as DELETED')]
Port Vlan8(8) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '8']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','886','interface',NOW(),'Interface was marked as DELETED')]
Port Vlan9(9) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '9']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','887','interface',NOW(),'Interface was marked as DELETED')]
Port Vlan10(10) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','888','interface',NOW(),'Interface was marked as DELETED')]
Port Vlan11(11) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '11']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','889','interface',NOW(),'Interface was marked as DELETED')]
Port Vlan13(13) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '13']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','890','interface',NOW(),'Interface was marked as DELETED')]
Port Vlan14(14) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '14']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','891','interface',NOW(),'Interface was marked as DELETED')]
Port Vlan18(18) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '18']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','892','interface',NOW(),'Interface was marked as DELETED')]
Port Vlan19(19) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '19']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','893','interface',NOW(),'Interface was marked as DELETED')]
Port Vlan20(20) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '20']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','894','interface',NOW(),'Interface was marked as DELETED')]
Port Vlan21(21) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '21']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','895','interface',NOW(),'Interface was marked as DELETED')]
Port Vlan22(22) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '22']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','896','interface',NOW(),'Interface was marked as DELETED')]
Port Vlan23(23) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '23']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','897','interface',NOW(),'Interface was marked as DELETED')]
Port Vlan24(24) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '24']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','898','interface',NOW(),'Interface was marked as DELETED')]
Port Vlan32(32) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '32']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','899','interface',NOW(),'Interface was marked as DELETED')]
Port Vlan47(47) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '47']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','900','interface',NOW(),'Interface was marked as DELETED')]
Port Vlan62(62) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '62']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','901','interface',NOW(),'Interface was marked as DELETED')]
Port Vlan63(63) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '63']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','902','interface',NOW(),'Interface was marked as DELETED')]
Port Vlan88(88) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '88']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','903','interface',NOW(),'Interface was marked as DELETED')]
Port Vlan93(93) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '93']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','904','interface',NOW(),'Interface was marked as DELETED')]
Port Vlan94(94) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '94']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','905','interface',NOW(),'Interface was marked as DELETED')]
Port Vlan111(111) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '111']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','906','interface',NOW(),'Interface was marked as DELETED')]
Port Vlan191(191) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '191']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','907','interface',NOW(),'Interface was marked as DELETED')]
Port Vlan193(193) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '193']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','908','interface',NOW(),'Interface was marked as DELETED')]
Port Vlan199(199) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '199']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','909','interface',NOW(),'Interface was marked as DELETED')]
Port Vlan200(200) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '200']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','910','interface',NOW(),'Interface was marked as DELETED')]
Port Vlan248(248) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '248']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','911','interface',NOW(),'Interface was marked as DELETED')]
Port Vlan901(901) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '901']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','912','interface',NOW(),'Interface was marked as DELETED')]
Port Vlan902(902) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '902']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','913','interface',NOW(),'Interface was marked as DELETED')]
Port Port-channel1(5001) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '5001']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','914','interface',NOW(),'Interface was marked as DELETED')]
Port Port-channel2(5002) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '5002']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','915','interface',NOW(),'Interface was marked as DELETED')]
Port Port-channel5(5005) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '5005']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','916','interface',NOW(),'Interface was marked as DELETED')]
Port Port-channel10(5010) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '5010']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','917','interface',NOW(),'Interface was marked as DELETED')]
Port Port-channel11(5011) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '5011']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','918','interface',NOW(),'Interface was marked as DELETED')]
Port Port-channel16(5016) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '5016']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','919','interface',NOW(),'Interface was marked as DELETED')]
Port Port-channel21(5021) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '5021']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','920','interface',NOW(),'Interface was marked as DELETED')]
Port Port-channel22(5022) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '5022']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','921','interface',NOW(),'Interface was marked as DELETED')]
Port StackPort1(5179) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '5179']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','922','interface',NOW(),'Interface was marked as DELETED')]
Port StackSub-St1-1(5180) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '5180']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','923','interface',NOW(),'Interface was marked as DELETED')]
Port StackSub-St1-2(5181) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '5181']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','924','interface',NOW(),'Interface was marked as DELETED')]
Port StackPort2(5182) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '5182']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','925','interface',NOW(),'Interface was marked as DELETED')]
Port StackSub-St2-1(5183) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '5183']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','926','interface',NOW(),'Interface was marked as DELETED')]
Port StackSub-St2-2(5184) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '5184']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','927','interface',NOW(),'Interface was marked as DELETED')]
Port StackPort3(5185) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '5185']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','928','interface',NOW(),'Interface was marked as DELETED')]
Port StackSub-St3-1(5186) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '5186']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','929','interface',NOW(),'Interface was marked as DELETED')]
Port StackSub-St3-2(5187) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '5187']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','930','interface',NOW(),'Interface was marked as DELETED')]
Port StackPort4(5188) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '5188']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','931','interface',NOW(),'Interface was marked as DELETED')]
Port StackSub-St4-1(5189) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '5189']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','932','interface',NOW(),'Interface was marked as DELETED')]
Port StackSub-St4-2(5190) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '5190']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','933','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet1/0/1(10101) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10101']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','934','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet1/0/2(10102) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10102']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','935','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet1/0/3(10103) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10103']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','936','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet1/0/4(10104) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10104']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','937','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet1/0/5(10105) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10105']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','938','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet1/0/6(10106) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10106']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','939','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet1/0/7(10107) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10107']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','940','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet1/0/8(10108) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10108']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','941','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet1/0/9(10109) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10109']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','942','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet1/0/10(10110) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10110']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','943','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet1/0/11(10111) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10111']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','944','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet1/0/12(10112) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10112']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','945','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet1/0/13(10113) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10113']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','946','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet1/0/14(10114) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10114']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','947','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet1/0/15(10115) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10115']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','948','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet1/0/16(10116) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10116']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','949','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet1/0/17(10117) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10117']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','950','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet1/0/18(10118) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10118']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','951','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet1/0/19(10119) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10119']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','952','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet1/0/20(10120) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10120']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','953','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet1/0/21(10121) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10121']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','954','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet1/0/22(10122) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10122']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','955','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet1/0/23(10123) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10123']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','956','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet1/0/24(10124) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10124']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','957','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet1/0/25(10125) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10125']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','958','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet1/0/26(10126) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10126']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','959','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet1/0/27(10127) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10127']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','960','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet1/0/28(10128) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10128']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','961','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet2/0/1(10601) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10601']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','962','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet2/0/2(10602) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10602']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','963','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet2/0/3(10603) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10603']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','964','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet2/0/4(10604) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10604']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','965','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet2/0/5(10605) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10605']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','966','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet2/0/6(10606) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10606']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','967','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet2/0/7(10607) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10607']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','968','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet2/0/8(10608) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10608']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','969','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet2/0/9(10609) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10609']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','970','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet2/0/10(10610) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10610']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','971','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet2/0/11(10611) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10611']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','972','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet2/0/12(10612) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10612']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','973','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet2/0/13(10613) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10613']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','974','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet2/0/14(10614) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10614']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','975','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet2/0/15(10615) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10615']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','976','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet2/0/16(10616) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10616']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','977','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet2/0/17(10617) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10617']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','978','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet2/0/18(10618) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10618']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','979','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet2/0/19(10619) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10619']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','980','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet2/0/20(10620) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10620']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','981','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet2/0/21(10621) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10621']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','982','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet2/0/22(10622) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10622']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','983','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet2/0/23(10623) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10623']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','984','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet2/0/24(10624) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10624']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','985','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet2/0/25(10625) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10625']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','986','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet2/0/26(10626) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10626']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','987','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet2/0/27(10627) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10627']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','988','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet2/0/28(10628) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '10628']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','989','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet3/0/1(11101) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '11101']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','990','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet3/0/2(11102) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '11102']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','991','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet3/0/3(11103) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '11103']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','992','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet3/0/4(11104) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '11104']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','993','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet3/0/5(11105) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '11105']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','994','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet3/0/6(11106) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '11106']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','995','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet3/0/7(11107) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '11107']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','996','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet3/0/8(11108) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '11108']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','997','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet3/0/9(11109) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '11109']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','998','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet3/0/10(11110) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '11110']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','999','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet3/0/11(11111) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '11111']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','1000','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet3/0/12(11112) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '11112']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','1001','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet4/0/1(11601) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '11601']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','1002','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet4/0/2(11602) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '11602']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','1003','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet4/0/3(11603) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '11603']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','1004','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet4/0/4(11604) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '11604']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','1005','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet4/0/5(11605) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '11605']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','1006','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet4/0/6(11606) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '11606']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','1007','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet4/0/7(11607) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '11607']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','1008','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet4/0/8(11608) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '11608']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','1009','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet4/0/9(11609) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '11609']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','1010','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet4/0/10(11610) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '11610']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','1011','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet4/0/11(11611) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '11611']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','1012','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet4/0/12(11612) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '11612']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','1013','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet4/0/13(11613) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '11613']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','1014','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet4/0/14(11614) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '11614']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','1015','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet4/0/15(11615) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '11615']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','1016','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet4/0/16(11616) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '11616']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','1017','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet4/0/17(11617) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '11617']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','1018','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet4/0/18(11618) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '11618']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','1019','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet4/0/19(11619) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '11619']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','1020','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet4/0/20(11620) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '11620']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','1021','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet4/0/21(11621) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '11621']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','1022','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet4/0/22(11622) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '11622']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','1023','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet4/0/23(11623) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '11623']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','1024','interface',NOW(),'Interface was marked as DELETED')]
Port GigabitEthernet4/0/24(11624) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '11624']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','1025','interface',NOW(),'Interface was marked as DELETED')]
Port Null0(14501) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '14501']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','1026','interface',NOW(),'Interface was marked as DELETED')]
Port Loopback0(24567) Port Deleted.
SQL[UPDATE `ports` set `deleted` ='1' WHERE `device_id` = '9' AND `ifIndex` = '24567']
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('9','1027','interface',NOW(),'Interface was marked as DELETED')]
Module time: 5.2942s
including: includes/polling/bgp-peers.inc.php
BGP Peers: DEBUG: SNMP Auth options = -v2c -c 'XXXXXX'
/usr/bin/snmpget -v2c -c 'XXXXXX' -Oqvn -m BGP4-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ea-core':'161' bgpLocalAs.0
SQL[SELECT *, `bgpPeers`.bgpPeer_id as bgpPeer_id FROM `bgpPeers` LEFT JOIN `bgpPeers-state` ON `bgpPeers`.bgpPeer_id = `bgpPeers-state`.bgpPeer_id WHERE `device_id` = '9']
Module time: 0.0068s
including: includes/polling/toner.inc.php
SQL[SELECT * FROM toner WHERE device_id = '9']
Module time: 0.0007s
including: includes/polling/ucd-diskio.inc.php
SQL[SELECT * FROM `ucd_diskio` WHERE `device_id` = '9']
Module time: 0.0006s
including: includes/polling/wifi.inc.php
Module time: 0.0002s
including: includes/polling/ospf.inc.php
OSPF: Processes:
SQL[SELECT * FROM `ospf_instances` WHERE `device_id` = '9']
DEBUG: SNMP Auth options = -v2c -c 'XXXXXX'
/usr/bin/snmpbulkwalk -v2c -c 'XXXXXX' -OQUs -m OSPF-MIB -M /opt/observium/mibs 'udp':'ea-core':'161' OSPF-MIB::ospfGeneralGroup
ospfRouterId.0 = 10.10.1.1
ospfAdminStat.0 = enabled
ospfVersionNumber.0 = version2
ospfAreaBdrRtrStatus.0 = false
ospfASBdrRtrStatus.0 = false
ospfExternLsaCount.0 = 29
ospfExternLsaCksumSum.0 = 956914
ospfTOSSupport.0 = false
ospfOriginateNewLsas.0 = 22
ospfRxNewLsas.0 = 87
ospfExtLsdbLimit.0 = -1
ospfMulticastExtensions.0 = 0
ospfExitOverflowInterval.0 = 0
ospfDemandExtensions.0 = true
DEBUG: SNMP Auth options = -v2c -c 'XXXXXX'
/usr/bin/snmpbulkwalk -v2c -c 'XXXXXX' -OQUs -m OSPF-MIB -M /opt/observium/mibs 'udp':'ea-core':'161' OSPF-MIB::ospfAreaEntry
ospfAreaId.0.0.0.0 = 0.0.0.0
ospfAuthType.0.0.0.0 = md5
ospfImportAsExtern.0.0.0.0 = importExternal
ospfSpfRuns.0.0.0.0 = 16
ospfAreaBdrRtrCount.0.0.0.0 = 0
ospfAsBdrRtrCount.0.0.0.0 = 2
ospfAreaLsaCount.0.0.0.0 = 5
ospfAreaLsaCksumSum.0.0.0.0 = 204337
ospfAreaSummary.0.0.0.0 = sendAreaSummary
ospfAreaStatus.0.0.0.0 = active
DEBUG: SNMP Auth options = -v2c -c 'XXXXXX'
/usr/bin/snmpbulkwalk -v2c -c 'XXXXXX' -OQUs -m OSPF-MIB -M /opt/observium/mibs 'udp':'ea-core':'161' OSPF-MIB::ospfIfEntry
ospfIfIpAddress.10.6.96.1.0 = 10.6.96.1
ospfIfIpAddress.10.6.96.5.0 = 10.6.96.5
ospfAddressLessIf.10.6.96.1.0 = 0
ospfAddressLessIf.10.6.96.5.0 = 0
ospfIfAreaId.10.6.96.1.0 = 0.0.0.0
ospfIfAreaId.10.6.96.5.0 = 0.0.0.0
ospfIfType.10.6.96.1.0 = broadcast
ospfIfType.10.6.96.5.0 = broadcast
ospfIfAdminStat.10.6.96.1.0 = enabled
ospfIfAdminStat.10.6.96.5.0 = enabled
ospfIfRtrPriority.10.6.96.1.0 = 1
ospfIfRtrPriority.10.6.96.5.0 = 1
ospfIfTransitDelay.10.6.96.1.0 = 1
ospfIfTransitDelay.10.6.96.5.0 = 1
ospfIfRetransInterval.10.6.96.1.0 = 5
ospfIfRetransInterval.10.6.96.5.0 = 5
ospfIfHelloInterval.10.6.96.1.0 = 10
ospfIfHelloInterval.10.6.96.5.0 = 10
ospfIfRtrDeadInterval.10.6.96.1.0 = 40
ospfIfRtrDeadInterval.10.6.96.5.0 = 40
ospfIfPollInterval.10.6.96.1.0 = 120
ospfIfPollInterval.10.6.96.5.0 = 120
ospfIfState.10.6.96.1.0 = designatedRouter
ospfIfState.10.6.96.5.0 = designatedRouter
ospfIfDesignatedRouter.10.6.96.1.0 = 10.6.96.1
ospfIfDesignatedRouter.10.6.96.5.0 = 10.6.96.5
ospfIfBackupDesignatedRouter.10.6.96.1.0 = 10.6.96.2
ospfIfBackupDesignatedRouter.10.6.96.5.0 = 10.6.96.6
ospfIfEvents.10.6.96.1.0 = 6
ospfIfEvents.10.6.96.5.0 = 8
ospfIfAuthKey.10.6.96.1.0 = ""
ospfIfAuthKey.10.6.96.5.0 = ""
ospfIfStatus.10.6.96.1.0 = active
ospfIfStatus.10.6.96.5.0 = active
ospfIfMulticastForwarding.10.6.96.1.0 = blocked
ospfIfMulticastForwarding.10.6.96.5.0 = blocked
ospfIfDemand.10.6.96.1.0 = false
ospfIfDemand.10.6.96.5.0 = false
ospfIfAuthType.10.6.96.1.0 = md5
ospfIfAuthType.10.6.96.5.0 = md5
DEBUG: SNMP Auth options = -v2c -c 'XXXXXX'
/usr/bin/snmpbulkwalk -v2c -c 'XXXXXX' -OQUs -m OSPF-MIB -M /opt/observium/mibs 'udp':'ea-core':'161' OSPF-MIB::ospfNbrEntry
ospfNbrIpAddr.10.6.96.2.0 = 10.6.96.2
ospfNbrIpAddr.10.6.96.6.0 = 10.6.96.6
ospfNbrAddressLessIndex.10.6.96.2.0 = 0
ospfNbrAddressLessIndex.10.6.96.6.0 = 0
ospfNbrRtrId.10.6.96.2.0 = 10.8.95.0
ospfNbrRtrId.10.6.96.6.0 = 10.3.95.0
ospfNbrOptions.10.6.96.2.0 = 2
ospfNbrOptions.10.6.96.6.0 = 2
ospfNbrPriority.10.6.96.2.0 = 1
ospfNbrPriority.10.6.96.6.0 = 1
ospfNbrState.10.6.96.2.0 = full
ospfNbrState.10.6.96.6.0 = full
ospfNbrEvents.10.6.96.2.0 = 6
ospfNbrEvents.10.6.96.6.0 = 6
ospfNbrLsRetransQLen.10.6.96.2.0 = 0
ospfNbrLsRetransQLen.10.6.96.6.0 = 0
ospfNbmaNbrStatus.10.6.96.2.0 = active
ospfNbmaNbrStatus.10.6.96.6.0 = active
ospfNbmaNbrPermanence.10.6.96.2.0 = dynamic
ospfNbmaNbrPermanence.10.6.96.6.0 = dynamic
ospfNbrHelloSuppressed.10.6.96.2.0 = false
ospfNbrHelloSuppressed.10.6.96.6.0 = false
SQL[INSERT INTO `ospf_instances` (`device_id`,`ospf_instance_id`) VALUES ('9','0')]
+
SQL[SELECT * FROM `ospf_instances` WHERE `device_id` = '9' AND `ospf_instance_id` = '0']
Polled: Array
(
[0] => Array
(
[ospfRouterId] => 10.10.1.1
[ospfAdminStat] => enabled
[ospfVersionNumber] => version2
[ospfAreaBdrRtrStatus] => false
[ospfASBdrRtrStatus] => false
[ospfExternLsaCount] => 29
[ospfExternLsaCksumSum] => 956914
[ospfTOSSupport] => false
[ospfOriginateNewLsas] => 22
[ospfRxNewLsas] => 87
[ospfExtLsdbLimit] => -1
[ospfMulticastExtensions] => 0
[ospfExitOverflowInterval] => 0
[ospfDemandExtensions] => true
)
)
==
array(
[0] => array(
[ospfRouterId] => string(9) "10.10.1.1"
┗ date ~ -8hr America/New_York (UTC-5)
[ospfAdminStat] => string(7) "enabled"
[ospfVersionNumber] => string(8) "version2"
[ospfAreaBdrRtrStatus] => string(5) "false"
[ospfASBdrRtrStatus] => string(5) "false"
[ospfExternLsaCount] => string(2) "29"
[ospfExternLsaCksumSum] => string(6) "956914"
[ospfTOSSupport] => string(5) "false"
[ospfOriginateNewLsas] => string(2) "22"
[ospfRxNewLsas] => string(2) "87"
[ospfExtLsdbLimit] => string(2) "-1"
[ospfMulticastExtensions] => string(1) "0"
[ospfExitOverflowInterval] => string(1) "0"
[ospfDemandExtensions] => string(4) "true"
)
)
Database: Array
(
[] =>
)
==
array(
[] => null
)
. Areas:
SQL[SELECT * FROM `ospf_areas` WHERE `device_id` = '9']
SQL[INSERT INTO `ospf_areas` (`device_id`,`ospfAreaId`) VALUES ('9','0.0.0.0')]
+
SQL[SELECT * FROM `ospf_areas` WHERE `device_id` = '9' AND `ospfAreaId` = '0.0.0.0']
Polled: Array
(
[0.0.0.0] => Array
(
[ospfAreaId] => 0.0.0.0
[ospfAuthType] => md5
[ospfImportAsExtern] => importExternal
[ospfSpfRuns] => 16
[ospfAreaBdrRtrCount] => 0
[ospfAsBdrRtrCount] => 2
[ospfAreaLsaCount] => 5
[ospfAreaLsaCksumSum] => 204337
[ospfAreaSummary] => sendAreaSummary
[ospfAreaStatus] => active
)
)
==
array(
[0.0.0.0] => array(
[ospfAreaId] => string(7) "0.0.0.0"
┗ date ~ -19hr America/New_York (UTC-5)
[ospfAuthType] => string(3) "md5"
┗ function ~ md5
[ospfImportAsExtern] => string(14) "importExternal"
[ospfSpfRuns] => string(2) "16"
[ospfAreaBdrRtrCount] => string(1) "0"
[ospfAsBdrRtrCount] => string(1) "2"
[ospfAreaLsaCount] => string(1) "5"
[ospfAreaLsaCksumSum] => string(6) "204337"
[ospfAreaSummary] => string(15) "sendAreaSummary"
[ospfAreaStatus] => string(6) "active"
)
)
Database: Array
(
[] => Array
(
[0] => Array
(
[device_id] => 9
[ospfAreaId] => 0.0.0.0
[ospfAuthType] =>
[ospfImportAsExtern] =>
[ospfSpfRuns] => 0
[ospfAreaBdrRtrCount] => 0
[ospfAsBdrRtrCount] => 0
[ospfAreaLsaCount] => 0
[ospfAreaLsaCksumSum] => 0
[ospfAreaSummary] =>
[ospfAreaStatus] =>
)
)
)
==
array(
[] => array(
[0] => array(
[device_id] => string(1) "9"
[ospfAreaId] => string(7) "0.0.0.0"
┗ date ~ -19hr America/New_York (UTC-5)
[ospfAuthType] => string(0) ""
[ospfImportAsExtern] => string(0) ""
[ospfSpfRuns] => string(1) "0"
[ospfAreaBdrRtrCount] => string(1) "0"
[ospfAsBdrRtrCount] => string(1) "0"
[ospfAreaLsaCount] => string(1) "0"
[ospfAreaLsaCksumSum] => string(1) "0"
[ospfAreaSummary] => string(0) ""
[ospfAreaStatus] => string(0) ""
)
)
)
SQL[DELETE FROM `ospf_ports` WHERE `device_id` = '9' AND `ospfAreaId` = '']
Ports:
SQL[SELECT * FROM `ospf_ports` WHERE `device_id` = '9']
SQL[INSERT INTO `ospf_ports` (`device_id`,`ospf_port_id`) VALUES ('9','10.6.96.1.0')]
+
SQL[SELECT * FROM `ospf_ports` WHERE `device_id` = '9' AND `ospf_port_id` = '10.6.96.1.0']
SQL[INSERT INTO `ospf_ports` (`device_id`,`ospf_port_id`) VALUES ('9','10.6.96.5.0')]
+
SQL[SELECT * FROM `ospf_ports` WHERE `device_id` = '9' AND `ospf_port_id` = '10.6.96.5.0']
Polled: Array
(
[10.6.96.1.0] => Array
(
[ospfIfIpAddress] => 10.6.96.1
[ospfAddressLessIf] => 0
[ospfIfAreaId] => 0.0.0.0
[ospfIfType] => broadcast
[ospfIfAdminStat] => enabled
[ospfIfRtrPriority] => 1
[ospfIfTransitDelay] => 1
[ospfIfRetransInterval] => 5
[ospfIfHelloInterval] => 10
[ospfIfRtrDeadInterval] => 40
[ospfIfPollInterval] => 120
[ospfIfState] => designatedRouter
[ospfIfDesignatedRouter] => 10.6.96.1
[ospfIfBackupDesignatedRouter] => 10.6.96.2
[ospfIfEvents] => 6
[ospfIfAuthKey] =>
[ospfIfStatus] => active
[ospfIfMulticastForwarding] => blocked
[ospfIfDemand] => false
[ospfIfAuthType] => md5
)
[10.6.96.5.0] => Array
(
[ospfIfIpAddress] => 10.6.96.5
[ospfAddressLessIf] => 0
[ospfIfAreaId] => 0.0.0.0
[ospfIfType] => broadcast
[ospfIfAdminStat] => enabled
[ospfIfRtrPriority] => 1
[ospfIfTransitDelay] => 1
[ospfIfRetransInterval] => 5
[ospfIfHelloInterval] => 10
[ospfIfRtrDeadInterval] => 40
[ospfIfPollInterval] => 120
[ospfIfState] => designatedRouter
[ospfIfDesignatedRouter] => 10.6.96.5
[ospfIfBackupDesignatedRouter] => 10.6.96.6
[ospfIfEvents] => 8
[ospfIfAuthKey] =>
[ospfIfStatus] => active
[ospfIfMulticastForwarding] => blocked
[ospfIfDemand] => false
[ospfIfAuthType] => md5
)
)
==
array(
[10.6.96.1.0] => array(
[ospfIfIpAddress] => string(9) "10.6.96.1"
[ospfAddressLessIf] => string(1) "0"
[ospfIfAreaId] => string(7) "0.0.0.0"
┗ date ~ -19hr America/New_York (UTC-5)
[ospfIfType] => string(9) "broadcast"
[ospfIfAdminStat] => string(7) "enabled"
[ospfIfRtrPriority] => string(1) "1"
[ospfIfTransitDelay] => string(1) "1"
[ospfIfRetransInterval] => string(1) "5"
[ospfIfHelloInterval] => string(2) "10"
[ospfIfRtrDeadInterval] => string(2) "40"
[ospfIfPollInterval] => string(3) "120"
[ospfIfState] => string(16) "designatedRouter"
[ospfIfDesignatedRouter] => string(9) "10.6.96.1"
[ospfIfBackupDesignatedRouter] => string(9) "10.6.96.2"
[ospfIfEvents] => string(1) "6"
[ospfIfAuthKey] => string(0) ""
[ospfIfStatus] => string(6) "active"
[ospfIfMulticastForwarding] => string(7) "blocked"
[ospfIfDemand] => string(5) "false"
[ospfIfAuthType] => string(3) "md5"
┗ function ~ md5
)
[10.6.96.5.0] => array(
[ospfIfIpAddress] => string(9) "10.6.96.5"
[ospfAddressLessIf] => string(1) "0"
[ospfIfAreaId] => string(7) "0.0.0.0"
┗ date ~ -19hr America/New_York (UTC-5)
[ospfIfType] => string(9) "broadcast"
[ospfIfAdminStat] => string(7) "enabled"
[ospfIfRtrPriority] => string(1) "1"
[ospfIfTransitDelay] => string(1) "1"
[ospfIfRetransInterval] => string(1) "5"
[ospfIfHelloInterval] => string(2) "10"
[ospfIfRtrDeadInterval] => string(2) "40"
[ospfIfPollInterval] => string(3) "120"
[ospfIfState] => string(16) "designatedRouter"
[ospfIfDesignatedRouter] => string(9) "10.6.96.5"
[ospfIfBackupDesignatedRouter] => string(9) "10.6.96.6"
[ospfIfEvents] => string(1) "8"
[ospfIfAuthKey] => string(0) ""
[ospfIfStatus] => string(6) "active"
[ospfIfMulticastForwarding] => string(7) "blocked"
[ospfIfDemand] => string(5) "false"
[ospfIfAuthType] => string(3) "md5"
┗ function ~ md5
)
)
Database: Array
(
[] => Array
(
[device_id] => 9
[port_id] => 0
[ospf_port_id] => 10.6.96.5.0
[ospfIfIpAddress] =>
[ospfAddressLessIf] => 0
[ospfIfAreaId] =>
[ospfIfType] =>
[ospfIfAdminStat] =>
[ospfIfRtrPriority] =>
[ospfIfTransitDelay] =>
[ospfIfRetransInterval] =>
[ospfIfHelloInterval] =>
[ospfIfRtrDeadInterval] =>
[ospfIfPollInterval] =>
[ospfIfState] =>
[ospfIfDesignatedRouter] =>
[ospfIfBackupDesignatedRouter] =>
[ospfIfEvents] =>
[ospfIfAuthKey] =>
[ospfIfStatus] =>
[ospfIfMulticastForwarding] =>
[ospfIfDemand] =>
[ospfIfAuthType] =>
)
)
==
array(
[] => array(
[device_id] => string(1) "9"
[port_id] => string(1) "0"
[ospf_port_id] => string(11) "10.6.96.5.0"
┗ date ~ -18yr America/New_York (UTC-5)
[ospfIfIpAddress] => string(0) ""
[ospfAddressLessIf] => string(1) "0"
[ospfIfAreaId] => string(0) ""
[ospfIfType] => null
[ospfIfAdminStat] => null
[ospfIfRtrPriority] => null
[ospfIfTransitDelay] => null
[ospfIfRetransInterval] => null
[ospfIfHelloInterval] => null
[ospfIfRtrDeadInterval] => null
[ospfIfPollInterval] => null
[ospfIfState] => null
[ospfIfDesignatedRouter] => null
[ospfIfBackupDesignatedRouter] => null
[ospfIfEvents] => null
[ospfIfAuthKey] => null
[ospfIfStatus] => null
[ospfIfMulticastForwarding] => null
[ospfIfDemand] => null
[ospfIfAuthType] => null
)
)
SQL[SELECT A.`port_id` FROM ipv4_addresses AS A, ports AS I WHERE A.ipv4_address = '10.6.96.5' AND I.port_id = A.port_id AND I.device_id = '9']
SQL[UPDATE `ospf_ports` set `ospfIfIpAddress` ='10.6.96.5',`port_id` ='',`ospfIfAreaId` ='0.0.0.0',`ospfIfType` ='broadcast',`ospfIfAdminStat` ='enabled',`ospfIfRtrPriority` ='1',`ospfIfTransitDelay` ='1',`ospfIfRetransInterval` ='5',`ospfIfHelloInterval` ='10',`ospfIfRtrDeadInterval` ='40',`ospfIfPollInterval` ='120',`ospfIfState` ='designatedRouter',`ospfIfDesignatedRouter` ='10.6.96.5',`ospfIfBackupDesignatedRouter` ='10.6.96.6',`ospfIfEvents` ='8',`ospfIfStatus` ='active',`ospfIfMulticastForwarding` ='blocked',`ospfIfDemand` ='false',`ospfIfAuthType` ='md5' WHERE `device_id` = '9' AND `ospf_port_id` = '']
U Neighbours:
SQL[SELECT * FROM `ospf_nbrs` WHERE `device_id` = '9']
SQL[INSERT INTO `ospf_nbrs` (`device_id`,`ospf_nbr_id`) VALUES ('9','10.6.96.2.0')]
+
SQL[SELECT * FROM `ospf_nbrs` WHERE `device_id` = '9' AND `ospf_nbr_id` = '10.6.96.2.0']
SQL[INSERT INTO `ospf_nbrs` (`device_id`,`ospf_nbr_id`) VALUES ('9','10.6.96.6.0')]
+
SQL[SELECT * FROM `ospf_nbrs` WHERE `device_id` = '9' AND `ospf_nbr_id` = '10.6.96.6.0']
Polled: Array
(
[10.6.96.2.0] => Array
(
[ospfNbrIpAddr] => 10.6.96.2
[ospfNbrAddressLessIndex] => 0
[ospfNbrRtrId] => 10.8.95.0
[ospfNbrOptions] => 2
[ospfNbrPriority] => 1
[ospfNbrState] => full
[ospfNbrEvents] => 6
[ospfNbrLsRetransQLen] => 0
[ospfNbmaNbrStatus] => active
[ospfNbmaNbrPermanence] => dynamic
[ospfNbrHelloSuppressed] => false
)
[10.6.96.6.0] => Array
(
[ospfNbrIpAddr] => 10.6.96.6
[ospfNbrAddressLessIndex] => 0
[ospfNbrRtrId] => 10.3.95.0
[ospfNbrOptions] => 2
[ospfNbrPriority] => 1
[ospfNbrState] => full
[ospfNbrEvents] => 6
[ospfNbrLsRetransQLen] => 0
[ospfNbmaNbrStatus] => active
[ospfNbmaNbrPermanence] => dynamic
[ospfNbrHelloSuppressed] => false
)
)
==
array(
[10.6.96.2.0] => array(
[ospfNbrIpAddr] => string(9) "10.6.96.2"
[ospfNbrAddressLessIndex] => string(1) "0"
[ospfNbrRtrId] => string(9) "10.8.95.0"
[ospfNbrOptions] => string(1) "2"
[ospfNbrPriority] => string(1) "1"
[ospfNbrState] => string(4) "full"
[ospfNbrEvents] => string(1) "6"
[ospfNbrLsRetransQLen] => string(1) "0"
[ospfNbmaNbrStatus] => string(6) "active"
[ospfNbmaNbrPermanence] => string(7) "dynamic"
[ospfNbrHelloSuppressed] => string(5) "false"
)
[10.6.96.6.0] => array(
[ospfNbrIpAddr] => string(9) "10.6.96.6"
[ospfNbrAddressLessIndex] => string(1) "0"
[ospfNbrRtrId] => string(9) "10.3.95.0"
[ospfNbrOptions] => string(1) "2"
[ospfNbrPriority] => string(1) "1"
[ospfNbrState] => string(4) "full"
[ospfNbrEvents] => string(1) "6"
[ospfNbrLsRetransQLen] => string(1) "0"
[ospfNbmaNbrStatus] => string(6) "active"
[ospfNbmaNbrPermanence] => string(7) "dynamic"
[ospfNbrHelloSuppressed] => string(5) "false"
)
)
Database: Array
(
[10.6.96.2.0] => Array
(
[device_id] => 9
[port_id] => 0
[ospf_nbr_id] => 10.6.96.2.0
[ospfNbrIpAddr] =>
[ospfNbrAddressLessIndex] => 0
[ospfNbrRtrId] =>
[ospfNbrOptions] => 0
[ospfNbrPriority] => 0
[ospfNbrState] =>
[ospfNbrEvents] => 0
[ospfNbrLsRetransQLen] => 0
[ospfNbmaNbrStatus] =>
[ospfNbmaNbrPermanence] =>
[ospfNbrHelloSuppressed] =>
)
[10.6.96.6.0] => Array
(
[device_id] => 9
[port_id] => 0
[ospf_nbr_id] => 10.6.96.6.0
[ospfNbrIpAddr] =>
[ospfNbrAddressLessIndex] => 0
[ospfNbrRtrId] =>
[ospfNbrOptions] => 0
[ospfNbrPriority] => 0
[ospfNbrState] =>
[ospfNbrEvents] => 0
[ospfNbrLsRetransQLen] => 0
[ospfNbmaNbrStatus] =>
[ospfNbmaNbrPermanence] =>
[ospfNbrHelloSuppressed] =>
)
)
==
array(
[10.6.96.2.0] => array(
[device_id] => string(1) "9"
[port_id] => string(1) "0"
[ospf_nbr_id] => string(11) "10.6.96.2.0"
┗ date ~ -18yr America/New_York (UTC-5)
[ospfNbrIpAddr] => string(0) ""
[ospfNbrAddressLessIndex] => string(1) "0"
[ospfNbrRtrId] => string(0) ""
[ospfNbrOptions] => string(1) "0"
[ospfNbrPriority] => string(1) "0"
[ospfNbrState] => string(0) ""
[ospfNbrEvents] => string(1) "0"
[ospfNbrLsRetransQLen] => string(1) "0"
[ospfNbmaNbrStatus] => string(0) ""
[ospfNbmaNbrPermanence] => string(0) ""
[ospfNbrHelloSuppressed] => string(0) ""
)
[10.6.96.6.0] => array(
[device_id] => string(1) "9"
[port_id] => string(1) "0"
[ospf_nbr_id] => string(11) "10.6.96.6.0"
┗ date ~ -18yr America/New_York (UTC-5)
[ospfNbrIpAddr] => string(0) ""
[ospfNbrAddressLessIndex] => string(1) "0"
[ospfNbrRtrId] => string(0) ""
[ospfNbrOptions] => string(1) "0"
[ospfNbrPriority] => string(1) "0"
[ospfNbrState] => string(0) ""
[ospfNbrEvents] => string(1) "0"
[ospfNbrLsRetransQLen] => string(1) "0"
[ospfNbmaNbrStatus] => string(0) ""
[ospfNbmaNbrPermanence] => string(0) ""
[ospfNbrHelloSuppressed] => string(0) ""
)
)
SQL[SELECT A.`port_id` FROM ipv4_addresses AS A, nbrs AS I WHERE A.ipv4_address = '10.6.96.2' AND I.port_id = A.port_id AND I.device_id = '9']
|10.6.96.2
0|0
|10.8.95.0
0|2
0|1
|full
0|6
0|0
|active
|dynamic
|false
SQL[UPDATE `ospf_nbrs` set `port_id` =NULL,`ospfNbrIpAddr` ='10.6.96.2',`ospfNbrRtrId` ='10.8.95.0',`ospfNbrOptions` ='2',`ospfNbrPriority` ='1',`ospfNbrState` ='full',`ospfNbrEvents` ='6',`ospfNbmaNbrStatus` ='active',`ospfNbmaNbrPermanence` ='dynamic',`ospfNbrHelloSuppressed` ='false' WHERE `device_id` = '9' AND `ospf_nbr_id` = '10.6.96.2.0']
U
SQL[SELECT A.`port_id` FROM ipv4_addresses AS A, nbrs AS I WHERE A.ipv4_address = '10.6.96.6' AND I.port_id = A.port_id AND I.device_id = '9']
|10.6.96.6
0|0
|10.3.95.0
0|2
0|1
|full
0|6
0|0
|active
|dynamic
|false
SQL[UPDATE `ospf_nbrs` set `port_id` =NULL,`ospfNbrIpAddr` ='10.6.96.6',`ospfNbrRtrId` ='10.3.95.0',`ospfNbrOptions` ='2',`ospfNbrPriority` ='1',`ospfNbrState` ='full',`ospfNbrEvents` ='6',`ospfNbmaNbrStatus` ='active',`ospfNbmaNbrPermanence` ='dynamic',`ospfNbrHelloSuppressed` ='false' WHERE `device_id` = '9' AND `ospf_nbr_id` = '10.6.96.6.0']
URRD[/usr/bin/rrdtool create /opt/observium/rrd/ea-core/ospf-statistics.rrd \
DS:instances:GAUGE:600:0:1000000 \
DS:areas:GAUGE:600:0:1000000 \
DS:ports:GAUGE:600:0:1000000 \
DS:neighbours:GAUGE:600:0:1000000 --step 300 RRA:AVERAGE:0.5:1:2016 RRA:AVERAGE:0.5:6:2976 RRA:AVERAGE:0.5:24:1440 RRA:AVERAGE:0.5:288:1440 RRA:MIN:0.5:6:1440 RRA:MIN:0.5:96:360 RRA:MIN:0.5:288:1440 RRA:MAX:0.5:6:1440 RRA:MAX:0.5:96:360 RRA:MAX:0.5:288:1440 ]
RRD[cmd[update /opt/observium/rrd/ea-core/ospf-statistics.rrd N:1:0:1:0]
stdout[OK u:0.01 s:0.00 r:7.41]
stderr[]]
Module time: 1.5389s
including: includes/polling/mac-accounting.inc.php
Mac Accounting: Caching DB...
SQL[SELECT *, `mac_accounting`.`ma_id` as `ma_id` FROM `mac_accounting` LEFT JOIN `mac_accounting-state` ON `mac_accounting`.ma_id = `mac_accounting-state`.ma_id WHERE `device_id` = '9']
==
null
0 entries.
Module time: 0.0017s
including: includes/polling/entity-physical.inc.php
Entity Physical:
SQL[SELECT * FROM `entPhysical-state` WHERE `device_id` = '9']
Module time: 0.0006s
including: includes/polling/applications.inc.php
SELECT * FROM `applications` WHERE `device_id` = '9'
SQL[SELECT * FROM `applications` WHERE `device_id` = '9']
Module time: 0.0004s
including: includes/polling/fdb-table.inc.php
FDB Tables
SQL[SELECT `ifIndex`,`port_id`,`ifDescr` FROM `ports` WHERE `device_id` = '9']
SQL[SELECT * FROM `vlans_fdb` WHERE `device_id` = '9']
DEBUG: SNMP Auth options = -v2c -c 'XXXXXX'
/usr/bin/snmpbulkwalk -v2c -c 'XXXXXX' -OqsX -m Q-BRIDGE-MIB -M /opt/observium/mibs 'udp':'ea-core':'161' dot1qTpFdbEntry
dot1qTpFdbEntry No Such Object available on this agent at this OID
RRD[/usr/bin/rrdtool create /opt/observium/rrd/ea-core/fdb_count.rrd DS:value:GAUGE:600:0:U --step 300 RRA:AVERAGE:0.5:1:2016 RRA:AVERAGE:0.5:6:2976 RRA:AVERAGE:0.5:24:1440 RRA:AVERAGE:0.5:288:1440 RRA:MIN:0.5:6:1440 RRA:MIN:0.5:96:360 RRA:MIN:0.5:288:1440 RRA:MAX:0.5:6:1440 RRA:MAX:0.5:96:360 RRA:MAX:0.5:288:1440 ]
RRD[cmd[update /opt/observium/rrd/ea-core/fdb_count.rrd N:0]
stdout[OK u:0.01 s:0.00 r:7.44]
stderr[]]
Module time: 0.0369s
SQL[SELECT `graph` FROM `device_graphs` WHERE `device_id` = '9']
+
SQL[INSERT INTO `device_graphs` (`device_id`,`graph`) VALUES ('9','ping')]
ping +
SQL[INSERT INTO `device_graphs` (`device_id`,`graph`) VALUES ('9','ping_snmp')]
ping_snmp +
SQL[INSERT INTO `device_graphs` (`device_id`,`graph`) VALUES ('9','uptime')]
uptime +
SQL[INSERT INTO `device_graphs` (`device_id`,`graph`) VALUES ('9','ipsystemstats_ipv6')]
ipsystemstats_ipv6 +
SQL[INSERT INTO `device_graphs` (`device_id`,`graph`) VALUES ('9','ipsystemstats_ipv6_frag')]
ipsystemstats_ipv6_frag +
SQL[INSERT INTO `device_graphs` (`device_id`,`graph`) VALUES ('9','fdb_count')]
fdb_count +
SQL[INSERT INTO `device_graphs` (`device_id`,`graph`) VALUES ('9','poller_perf')]
poller_perf Polled in 7.5217 seconds
SQL[INSERT INTO `devices_perftimes` (`device_id`,`operation`,`start`,`duration`) VALUES ('9','poll','1424131616.8384','7.521665096283')]
RRD[/usr/bin/rrdtool create /opt/observium/rrd/ea-core/perf-poller.rrd DS:val:GAUGE:600:0:38400 --step 300 RRA:AVERAGE:0.5:1:2016 RRA:AVERAGE:0.5:6:2976 RRA:AVERAGE:0.5:24:1440 RRA:AVERAGE:0.5:288:1440 RRA:MIN:0.5:6:1440 RRA:MIN:0.5:96:360 RRA:MIN:0.5:288:1440 RRA:MAX:0.5:6:1440 RRA:MAX:0.5:96:360 RRA:MAX:0.5:288:1440 ]
RRD[cmd[update /opt/observium/rrd/ea-core/perf-poller.rrd N:7.5217]
stdout[OK u:0.01 s:0.00 r:7.53]
stderr[]]
Updating ea-core - Array
(
[uptime] => 0
[location_geoapi] => google
[location_lat] => 41.6855886
[location_lon] => -85.9093094
[location_city] => Unknown
[location_county] => Unknown
[location_state] => Unknown
[location_country] => Unknown
[last_polled] => Array
(
[0] => NOW()
)
[last_polled_timetaken] => 7.5217
[device_state] => a:1:{s:15:"poller_mod_perf";a:21:{s:6:"system";s:6:"0.2669";s:2:"os";s:6:"0.0007";s:4:"ipmi";s:6:"0.0117";s:7:"sensors";s:6:"0.0009";s:10:"processors";s:6:"0.0010";s:8:"mempools";s:6:"0.0016";s:7:"storage";s:6:"0.0015";s:8:"netstats";s:6:"0.0419";s:6:"hr-mib";s:6:"0.0189";s:7:"ucd-mib";s:6:"0.0274";s:13:"ipSystemStats";s:6:"0.1316";s:5:"ports";s:6:"5.2942";s:9:"bgp-peers";s:6:"0.0068";s:5:"toner";s:6:"0.0007";s:10:"ucd-diskio";s:6:"0.0006";s:4:"wifi";s:6:"0.0002";s:4:"ospf";s:6:"1.5389";s:14:"mac-accounting";s:6:"0.0017";s:15:"entity-physical";s:6:"0.0006";s:12:"applications";s:6:"0.0004";s:9:"fdb-table";s:6:"0.0369";}}
)
==
array(
[uptime] => int(0)
[location_geoapi] => string(6) "google"
[location_lat] => string(10) "41.6855886"
[location_lon] => string(11) "-85.9093094"
[location_city] => string(7) "Unknown"
[location_county] => string(7) "Unknown"
[location_state] => string(7) "Unknown"
[location_country] => string(7) "Unknown"
[last_polled] => array(
[0] => string(5) "NOW()"
)
[last_polled_timetaken] => double(7.5217)
[device_state] => string(627) "a:1:{s:15:"poller_mod_perf";a:21:{s:6:"system";s:6:"0.2669";s:2:"os";s:6:"0.0007";s:4:"ipmi";s:6:"0.0117";s:7:"sensors";s:6:"0.0009";s:10:"processors";s:6:"0.0010";s:8:"mempools";s:6:"0.0016";s:7:"storage";s:6:"0.0015";s:8:"netstats";s:6:"0.0419";s:6:"hr-mib";s:6:"0.0189";s:7:"ucd-mib";s:6:"0.0274";s:13:"ipSystemStats";s:6:"0.1316";s:5:"ports";s:6:"5.2942";s:9:"bgp-peers";s:6:"0.0068";s:5:"toner";s:6:"0.0007";s:10:"ucd-diskio";s:6:"0.0006";s:4:"wifi";s:6:"0.0002";s:4:"ospf";s:6:"1.5389";s:14:"mac-accounting";s:6:"0.0017";s:15:"entity-physical";s:6:"0.0006";s:12:"applications";s:6:"0.0004";s:9:"fdb-table";s:6:"0.0369";}}"
┗ serialized ~ array(
[poller_mod_perf] => array(
[system] => string(6) "0.2669"
[os] => string(6) "0.0007"
[ipmi] => string(6) "0.0117"
[sensors] => string(6) "0.0009"
[processors] => string(6) "0.0010"
[mempools] => string(6) "0.0016"
[storage] => string(6) "0.0015"
[netstats] => string(6) "0.0419"
[hr-mib] => string(6) "0.0189"
[ucd-mib] => string(6) "0.0274"
[ipSystemStats] => string(6) "0.1316"
[ports] => string(6) "5.2942"
[bgp-peers] => string(6) "0.0068"
[toner] => string(6) "0.0007"
[ucd-diskio] => string(6) "0.0006"
[wifi] => string(6) "0.0002"
[ospf] => string(6) "1.5389"
[mac-accounting] => string(6) "0.0017"
[entity-physical] => string(6) "0.0006"
[applications] => string(6) "0.0004"
[fdb-table] => string(6) "0.0369"
)
)
)
SQL[UPDATE `devices` set `uptime` ='0',`location_geoapi` ='google',`location_lat` ='41.6855886',`location_lon` ='-85.9093094',`location_city` ='Unknown',`location_county` ='Unknown',`location_state` ='Unknown',`location_country` ='Unknown',`last_polled` =NOW(),`last_polled_timetaken` ='7.5217',`device_state` ='a:1:{s:15:\"poller_mod_perf\";a:21:{s:6:\"system\";s:6:\"0.2669\";s:2:\"os\";s:6:\"0.0007\";s:4:\"ipmi\";s:6:\"0.0117\";s:7:\"sensors\";s:6:\"0.0009\";s:10:\"processors\";s:6:\"0.0010\";s:8:\"mempools\";s:6:\"0.0016\";s:7:\"storage\";s:6:\"0.0015\";s:8:\"netstats\";s:6:\"0.0419\";s:6:\"hr-mib\";s:6:\"0.0189\";s:7:\"ucd-mib\";s:6:\"0.0274\";s:13:\"ipSystemStats\";s:6:\"0.1316\";s:5:\"ports\";s:6:\"5.2942\";s:9:\"bgp-peers\";s:6:\"0.0068\";s:5:\"toner\";s:6:\"0.0007\";s:10:\"ucd-diskio\";s:6:\"0.0006\";s:4:\"wifi\";s:6:\"0.0002\";s:4:\"ospf\";s:6:\"1.5389\";s:14:\"mac-accounting\";s:6:\"0.0017\";s:15:\"entity-physical\";s:6:\"0.0006\";s:12:\"applications\";s:6:\"0.0004\";s:9:\"fdb-table\";s:6:\"0.0369\";}}' WHERE `device_id` = '9']
UPDATED!
SQL[INSERT INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`) VALUES ('poll','all','1424131616.8346','7.570','1')]
./poller.php all February 16, 2015, 19:07 - 1 devices polled in 7.570 secs
MySQL: Cell[3/0s] Row[11/0.01s] Rows[22/0.01s] Column[0/0s] Update[153/2.54s] Insert[164/2.83s] Delete[0/0s]