Poller seems to be deleting my interfaces.....
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= 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]
because output for IF-MIB::ifEntry and IF-MIB::ifXEntry empty:
/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
/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
hrm, also as all other snmp queries. Seems as snmp view limited on device.
On 17.02.2015 03:11, Tony Mattke wrote:
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]
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
Thank you for pointing me in the right direction... my problems were all related to the mibs changing between versions... I just needed to re-index them!
-Tony
One day, this stupid bug will go away. It's not about re-indexing, it's net-snmp corrupting .index files, why, we do not know!
Perhaps if we see the error message for this, we should notify it in the UI or delete all of the .index files.
adam. On 17/02/2015 14:13:19, Anthony Mattke tony@mattke.net wrote: Thank you for pointing me in the right direction... my problems were all related to the mibs changing between versions... I just needed to re-index them!
-Tony
_______________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
participants (4)
-
Adam Armstrong -
Anthony Mattke -
Mike Stupalov -
Tony Mattke