mstobs@observium:~/observium $ ./discovery.php d --d -m neighbours -h fult-c01d00.ennetwork.mst.edu DEBUG! CMD[/usr/bin/svn info /local/mstobs/observium] CMD EXITCODE[0] CMD RUNTIME[0.0102s] STDOUT[ Path: . Working Copy Root Path: /local/mstobs/observium URL: http://svn.observium.org/svn/observium/trunk Relative URL: ^/observium/trunk Repository Root: http://svn.observium.org/svn Repository UUID: 61d68cd4-352d-0410-923a-c4978735b2b8 Revision: 8915 Node Kind: directory Schedule: normal Last Changed Author: mike Last Changed Rev: 8915 Last Changed Date: 2017-10-18 12:13:41 -0500 (Wed, 18 Oct 2017) ] SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'dbSchema';] SQL RUNTIME[0.00016785s] SQL[SELECT @@SESSION.sql_mode;] SQL RUNTIME[0.00008202s] SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'current_rev';] SQL RUNTIME[0.00010920s] SQL[SELECT * FROM `config`] SQL RUNTIME[0.00016594s] ___ _ _ / _ \ | |__ ___ ___ _ __ __ __(_) _ _ _ __ ___ | | | || '_ \ / __| / _ \| '__|\ \ / /| || | | || '_ ` _ \ | |_| || |_) |\__ \| __/| | \ V / | || |_| || | | | | | \___/ |_.__/ |___/ \___||_| \_/ |_| \__,_||_| |_| |_| Observium Professional 17.10.8915 http://www.observium.org CMD[/local/mstobs/observium/scripts/distro] CMD EXITCODE[0] CMD RUNTIME[0.0448s] STDOUT[ Linux|4.4.0-89-generic|amd64|Ubuntu|16.04|vmware ] CMD[/usr/bin/env python --version 2>&1] CMD EXITCODE[0] CMD RUNTIME[0.0026s] STDOUT[ Python 2.7.12 ] SQL[SELECT version();] SQL RUNTIME[0.01512504s] CMD[/usr/bin/snmpget --version 2>&1] CMD EXITCODE[0] CMD RUNTIME[0.0025s] STDOUT[ NET-SNMP version: 5.7.3 ] CMD[/usr/bin/rrdtool --version | head -n1] CMD EXITCODE[0] CMD RUNTIME[0.0127s] STDOUT[ RRDtool 1.5.5 Copyright by Tobias Oetiker ] CMD[/usr/bin/rrdcached -h | head -n1] CMD EXITCODE[0] CMD RUNTIME[0.006s] STDOUT[ RRDCacheD 1.5.5 ] CMD[/usr/sbin/apache2 -v | awk '/Server version:/ {print $3}'] CMD EXITCODE[0] CMD RUNTIME[0.026s] STDOUT[ Apache/2.4.18 ] CMD[date "+%:z"] CMD EXITCODE[0] CMD RUNTIME[0.0023s] STDOUT[ -05:00 ] SQL[SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP);] SQL RUNTIME[0.00018287s] SQL[SELECT @@SESSION.sql_mode;] SQL RUNTIME[0.00008988s] SQL[SHOW VARIABLES LIKE 'character_set_connection'] SQL RUNTIME[0.09185505s] ##### Software versions ##### o OS Linux 4.4.0-89-generic [amd64] (Ubuntu 16.04) o Apache 2.4.18 o PHP 7.0.22-0ubuntu0.16.04.1 (OPcache: DISABLED) o Python 2.7.12 o MySQL 5.6.36-82.1 (extension: mysqli 5.0.12-dev) o SNMP NET-SNMP 5.7.3 o RRDtool 1.5.5 (rrdcached 1.5.5: unix:/local/mstobs/rrdcache/rrdcached.sock) ##### Memory Limit ##### o PHP Unlimited ##### MySQL mode ##### o MySQL NO_ENGINE_SUBSTITUTION ##### Charset info ##### o PHP UTF-8 o MySQL utf8 ##### Timezones info ##### o Date Thursday, 19-Oct-17 13:24:45 CDT o PHP -05:00 o MySQL -05:00 SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'last_versioncheck';] SQL RUNTIME[0.00015688s] SQL[SELECT COUNT(*) FROM ports] SQL RUNTIME[0.03512812s] SQL[SELECT COUNT(*) FROM devices] SQL RUNTIME[0.00290489s] SQL[SELECT COUNT(*) FROM `sensors`] SQL RUNTIME[0.00496483s] SQL[SELECT COUNT(*) FROM `services`] SQL RUNTIME[0.00395989s] SQL[SELECT COUNT(*) FROM `applications`] SQL RUNTIME[0.00009584s] SQL[SELECT COUNT(*) FROM `bgpPeers`] SQL RUNTIME[0.00009108s] SQL[SELECT COUNT(*) FROM `ospf_ports`] SQL RUNTIME[0.00090384s] SQL[SELECT COUNT(*) FROM `eigrp_ports`] SQL RUNTIME[0.00008297s] SQL[SELECT COUNT(*) FROM `ipsec_tunnels`] SQL RUNTIME[0.00008702s] SQL[SELECT COUNT(*) FROM `munin_plugins`] SQL RUNTIME[0.00007415s] SQL[SELECT COUNT(*) FROM `pseudowires`] SQL RUNTIME[0.00007987s] SQL[SELECT COUNT(*) FROM `vrfs`] SQL RUNTIME[0.00009012s] SQL[SELECT COUNT(*) FROM `vminfo`] SQL RUNTIME[0.00008893s] SQL[SELECT COUNT(*) FROM `users`] SQL RUNTIME[0.01170802s] SQL[SELECT COUNT(*) FROM `bills`] SQL RUNTIME[0.00014591s] SQL[SELECT COUNT(*) FROM `alert_table`] SQL RUNTIME[0.01539183s] SQL[SELECT COUNT(*) FROM `alert_tests`] SQL RUNTIME[0.00013089s] SQL[SELECT COUNT(*) FROM `slas`] SQL RUNTIME[0.00010204s] SQL[SELECT COUNT(*) FROM `status`] SQL RUNTIME[0.00211215s] SQL[SELECT COUNT(*) FROM `groups`] SQL RUNTIME[0.00876498s] SQL[SELECT COUNT(*) FROM `group_table`] SQL RUNTIME[0.00464010s] SQL[SELECT SUM(`last_polled_timetaken`) FROM devices] SQL RUNTIME[0.00130105s] SQL[SELECT SUM(`last_discovered_timetaken`) FROM devices] SQL RUNTIME[0.00142503s] CMD[DISTROFORMAT=export /local/mstobs/observium/scripts/distro] CMD EXITCODE[0] CMD RUNTIME[0.0089s] STDOUT[ OS=Linux KERNEL=4.4.0-89-generic ARCH=amd64 DISTRO=Ubuntu VERSION=16.04 VIRT=vmware SCRIPTVER=1.2.1 ] SQL[SELECT `sysObjectID`, COUNT(*) AS `count` FROM `devices` WHERE `os` = 'generic' GROUP BY `sysObjectID`] SQL RUNTIME[0.00033689s] SQL[SELECT COUNT(*) AS `count`, `os` FROM `devices` GROUP BY `os`] SQL RUNTIME[0.00100517s] SQL[SELECT COUNT(*) AS `count`, `type` FROM `devices` GROUP BY `type`] SQL RUNTIME[0.00193691s] SQL[SELECT COUNT(*) AS `count`, `app_type` FROM `applications` GROUP BY `app_type`] SQL RUNTIME[0.00013685s] SQL[SELECT MAX(LENGTH(`port_label`)) FROM `ports`] SQL RUNTIME[0.07604694s] SQL[SELECT MAX(LENGTH(`port_label_short`)) FROM `ports`] SQL RUNTIME[0.05054116s] SQL[SELECT MAX(LENGTH(`port_label_base`)) FROM `ports`] SQL RUNTIME[0.05174589s] SQL[SELECT MAX(LENGTH(`port_label_num`)) FROM `ports`] SQL RUNTIME[0.04994893s] SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'unique_id';] SQL RUNTIME[0.00041413s] REQUEST[http://www.observium.org/versions.php] REQUEST STATUS[TRUE] REQUEST RUNTIME[0.7452s] RESPONSE CODE[200 OK] SQL[SELECT COUNT(*) FROM `observium_attribs` WHERE `attrib_type` = 'latest_ver';] SQL RUNTIME[0.00015807s] SQL[UPDATE `observium_attribs` set `attrib_value` ='17.10.8918' WHERE `attrib_type` = 'latest_ver'] SQL RUNTIME[0.00020409s] SQL[SELECT COUNT(*) FROM `observium_attribs` WHERE `attrib_type` = 'latest_rev';] SQL RUNTIME[0.00010920s] SQL[UPDATE `observium_attribs` set `attrib_value` ='8918' WHERE `attrib_type` = 'latest_rev'] SQL RUNTIME[0.00015092s] SQL[SELECT COUNT(*) FROM `observium_attribs` WHERE `attrib_type` = 'latest_rev_date';] SQL RUNTIME[0.00012302s] SQL[UPDATE `observium_attribs` set `attrib_value` ='2017-10-19' WHERE `attrib_type` = 'latest_rev_date'] SQL RUNTIME[0.00013709s] SQL[SELECT COUNT(*) FROM `observium_attribs` WHERE `attrib_type` = 'last_versioncheck';] SQL RUNTIME[0.00010300s] SQL[UPDATE `observium_attribs` set `attrib_value` ='1508437486' WHERE `attrib_type` = 'last_versioncheck'] SQL RUNTIME[0.00012207s] SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'latest_rev';] SQL RUNTIME[0.00009513s] SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'latest_ver';] SQL RUNTIME[0.00010204s] SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'latest_rev_date';] SQL RUNTIME[0.00009894s] There is a newer revision of Observium available! Version 17.10.8918 (19th October 2017) is 3 revisions ahead. ##### Starting discovery run at 2017-10-19 13:24:46 ##### SQL[SELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` LIKE 'fult-c01d00.network.mst.edu' AND `status` = '1' ORDER BY `last_discovered_timetaken` ASC] SQL RUNTIME[0.01200604s] CMD[/usr/bin/snmpget -t '3' -v2c -c *** -Pu -OQUst -m SNMPv2-MIB -M /local/mstobs/observium/mibs/rfc:/local/mstobs/observium/mibs/net-snmp 'udp':'fult-c01d00.network.mst.edu':'161' sysObjectID.0 sysUpTime.0] CMD EXITCODE[0] CMD RUNTIME[0.0112s] STDOUT[ sysObjectID.0 = enterprises.9.1.1605 sysUpTime.0 = 398748179 ] SNMP STATUS[TRUE] SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '211'] SQL RUNTIME[0.00030184s] SQL[SELECT * FROM `observium_processes` WHERE `process_name` = 'discovery.php' AND `device_id` = '211'] SQL RUNTIME[0.00014997s] CMD[/bin/ps -ww -o pid,ppid,uid,gid,tty,stat,time,lstart,args -p 12218] CMD EXITCODE[0] CMD RUNTIME[0.0146s] STDOUT[ PID PPID UID GID TT STAT TIME STARTED COMMAND 12218 3256 100072951 100072951 pts/0 S+ 00:00:00 Thu Oct 19 13:24:44 2017 php ./discovery.php -d -m neighbours -h fult-c01d00.network.mst.edu ] SQL[INSERT INTO `observium_processes` (`process_pid`,`process_name`,`process_ppid`,`process_uid`,`process_command`,`process_start`,`device_id`) VALUES ('12218','discovery.php','3256','100072951','php ./discovery.php -d -m neighbours -h fult-c01d00.network.mst.edu','1508437484','211')] SQL RUNTIME[0.00031805s] ##### fult-c01d00.network.mst.edu [211] ##### o OS Type iosxe o OS Group cisco o SNMP Version v2c o Last discovery 2017-10-19 03:38:48 o Last duration 10.43 seconds ##### Module Start: neighbours ##### SQL[SELECT * FROM `observium_attribs`] SQL RUNTIME[0.00018811s] o LLDP-MIB CMD[/usr/bin/snmpbulkwalk -t '3' -v2c -c *** -Pu -OQUs -m LLDP-MIB -M /local/mstobs/observium/mibs/rfc:/local/mstobs/observium/mibs/net-snmp 'udp':'fult-c01d00.network.mst.edu':'161' lldpRemoteSystemsData] CMD EXITCODE[0] CMD RUNTIME[0.0275s] STDOUT[ lldpRemChassisIdSubtype.0.1.3 = macAddress lldpRemChassisIdSubtype.0.15.6 = macAddress lldpRemChassisIdSubtype.0.16.5 = macAddress lldpRemChassisId.0.1.3 = "00 E1 6D 6A 76 80 " lldpRemChassisId.0.15.6 = "CC 4E 24 6F C3 00 " lldpRemChassisId.0.16.5 = "CC 4E 24 6F C3 00 " lldpRemPortIdSubtype.0.1.3 = interfaceName lldpRemPortIdSubtype.0.15.6 = macAddress lldpRemPortIdSubtype.0.16.5 = macAddress lldpRemPortId.0.1.3 = "Te1/0/2" lldpRemPortId.0.15.6 = "CC 4E 24 6F C3 24 " lldpRemPortId.0.16.5 = "60 9C 9F 80 DC A4 " lldpRemPortDesc.0.1.3 = TenGigabitEthernet1/0/2 lldpRemPortDesc.0.15.6 = 10GigabitEthernet1/1/37 lldpRemPortDesc.0.16.5 = 10GigabitEthernet2/1/37 lldpRemSysName.0.1.3 = FULT-C01DA0.network.mst.edu lldpRemSysName.0.15.6 = CR01 lldpRemSysName.0.16.5 = CR01 lldpRemSysDesc.0.1.3 = Cisco IOS Software, C2960X Software (C2960X-UNIVERSALK9-M), Version 15.0(2)EX5, RELEASE SOFTWARE (fc1) Technical Support: http://www.cisco.com/techsupport Copyright (c) 1986-2014 by Cisco Systems, Inc. Compiled Fri 21-Feb-14 05:54 by prod_rel_team lldpRemSysDesc.0.15.6 = lldpRemSysDesc.0.16.5 = lldpRemSysCapSupported.0.1.3 = "28 00 " lldpRemSysCapSupported.0.15.6 = "28 00 " lldpRemSysCapSupported.0.16.5 = "28 00 " lldpRemSysCapEnabled.0.1.3 = "20 00 " lldpRemSysCapEnabled.0.15.6 = "28 00 " lldpRemSysCapEnabled.0.16.5 = "28 00 " lldpRemManAddrIfSubtype.0.1.3.ipV4."..C." = systemPortNumber lldpRemManAddrIfSubtype.0.15.6.ipV4."...N" = ifIndex lldpRemManAddrIfSubtype.0.16.5.ipV4."...N" = ifIndex lldpRemManAddrIfId.0.1.3.ipV4."..C." = 200 lldpRemManAddrIfId.0.15.6.ipV4."...N" = 16777526 lldpRemManAddrIfId.0.16.5.ipV4."...N" = 16777526 lldpRemManAddrOID.0.1.3.ipV4."..C." = zeroDotZero lldpRemManAddrOID.0.15.6.ipV4."...N" = zeroDotZero lldpRemManAddrOID.0.16.5.ipV4."...N" = zeroDotZero ] SNMP STATUS[TRUE] CMD[/usr/bin/snmpbulkwalk -t '3' -v2c -c *** -Pu -OQUs -m BRIDGE-MIB -M /local/mstobs/observium/mibs/rfc:/local/mstobs/observium/mibs/net-snmp 'udp':'fult-c01d00.network.mst.edu':'161' dot1dBasePortIfIndex] CMD EXITCODE[0] CMD RUNTIME[0.0229s] STDOUT[ dot1dBasePortIfIndex.2 = 3 dot1dBasePortIfIndex.3 = 4 dot1dBasePortIfIndex.4 = 5 dot1dBasePortIfIndex.5 = 6 dot1dBasePortIfIndex.6 = 7 dot1dBasePortIfIndex.7 = 8 dot1dBasePortIfIndex.8 = 9 dot1dBasePortIfIndex.9 = 10 dot1dBasePortIfIndex.10 = 11 dot1dBasePortIfIndex.11 = 12 dot1dBasePortIfIndex.12 = 13 dot1dBasePortIfIndex.13 = 14 dot1dBasePortIfIndex.14 = 15 ] SNMP STATUS[TRUE] CMD[/usr/bin/snmpbulkwalk -t '3' -v2c -c *** -Pu -OQUs -m LLDP-MIB -M /local/mstobs/observium/mibs/rfc:/local/mstobs/observium/mibs/net-snmp 'udp':'fult-c01d00.network.mst.edu':'161' lldpLocPortEntry] CMD EXITCODE[0] CMD RUNTIME[0.0243s] STDOUT[ lldpLocPortIdSubtype.1 = interfaceName lldpLocPortIdSubtype.2 = interfaceName lldpLocPortIdSubtype.3 = interfaceName lldpLocPortIdSubtype.4 = interfaceName lldpLocPortIdSubtype.5 = interfaceName lldpLocPortIdSubtype.6 = interfaceName lldpLocPortIdSubtype.7 = interfaceName lldpLocPortIdSubtype.8 = interfaceName lldpLocPortIdSubtype.9 = interfaceName lldpLocPortIdSubtype.10 = interfaceName lldpLocPortIdSubtype.11 = interfaceName lldpLocPortIdSubtype.12 = interfaceName lldpLocPortIdSubtype.13 = interfaceName lldpLocPortIdSubtype.14 = interfaceName lldpLocPortIdSubtype.15 = interfaceName lldpLocPortIdSubtype.16 = interfaceName lldpLocPortId.1 = "Te1/1" lldpLocPortId.2 = "Te1/2" lldpLocPortId.3 = "Te1/3" lldpLocPortId.4 = "Te1/4" lldpLocPortId.5 = "Te1/5" lldpLocPortId.6 = "Te1/6" lldpLocPortId.7 = "Te1/7" lldpLocPortId.8 = "Te1/8" lldpLocPortId.9 = "Te1/9" lldpLocPortId.10 = "Te1/10" lldpLocPortId.11 = "Te1/11" lldpLocPortId.12 = "Te1/12" lldpLocPortId.13 = "Te1/13" lldpLocPortId.14 = "Te1/14" lldpLocPortId.15 = "Te1/15" lldpLocPortId.16 = "Te1/16" lldpLocPortDesc.1 = TenGigabitEthernet1/1 lldpLocPortDesc.2 = TenGigabitEthernet1/2 lldpLocPortDesc.3 = TenGigabitEthernet1/3 lldpLocPortDesc.4 = TenGigabitEthernet1/4 lldpLocPortDesc.5 = TenGigabitEthernet1/5 lldpLocPortDesc.6 = TenGigabitEthernet1/6 lldpLocPortDesc.7 = TenGigabitEthernet1/7 lldpLocPortDesc.8 = TenGigabitEthernet1/8 lldpLocPortDesc.9 = TenGigabitEthernet1/9 lldpLocPortDesc.10 = TenGigabitEthernet1/10 lldpLocPortDesc.11 = TenGigabitEthernet1/11 lldpLocPortDesc.12 = TenGigabitEthernet1/12 lldpLocPortDesc.13 = TenGigabitEthernet1/13 lldpLocPortDesc.14 = TenGigabitEthernet1/14 lldpLocPortDesc.15 = TenGigabitEthernet1/15 lldpLocPortDesc.16 = TenGigabitEthernet1/16 ] SNMP STATUS[TRUE] SQL[SELECT * FROM `ports` WHERE `device_id` = '211' AND `ifIndex` = '1' AND `ifDescr` NOT LIKE 'Vlan%'] SQL RUNTIME[0.00037408s] SQL[SELECT `device_id`, `hostname` FROM `devices` WHERE `sysName` = 'FULT-C01DA0.network.mst.edu' OR `hostname` = 'FULT-C01DA0.network.mst.edu'] SQL RUNTIME[0.00028491s] SQL[SELECT `port_id` FROM `ports` WHERE (`ifName` = 'Te1/0/2' OR `ifDescr` = 'Te1/0/2' OR `port_label_short` = 'Te1/0/2') AND `device_id` = '396'] SQL RUNTIME[0.00029802s] SQL[SELECT * FROM `ports` WHERE `ports`.`port_id` = '13335'] SQL RUNTIME[0.00019383s] SQL[SELECT * FROM `devices` WHERE `device_id` = '211'] SQL RUNTIME[0.00017190s] SQL[SELECT * FROM `device_graphs` WHERE `device_id` = '211'] SQL RUNTIME[0.00020313s] Discover neighbour: 211 -> lldp, 13335, 24744, fult-c01da0.network.mst.edu, Te1/0/2, , Cisco IOS Software, C2960X Software (C2960X-UNIVERSALK9-M), Version 15.0(2)EX5, RELEASE SOFTWARE (fc1) Technical Support: http://www.cisco.com/techsupport Copyright (c) 1986-2014 by Cisco Systems, Inc. Compiled Fri 21-Feb-14 05:54 by prod_rel_team, SQL[SELECT * FROM `neighbours` WHERE `port_id` = '13335' AND `protocol` = 'lldp' AND `remote_hostname` = 'fult-c01da0.network.mst.edu' AND `remote_port` = 'Te1/0/2'] SQL RUNTIME[0.00468683s] SQL[UPDATE `neighbours` set `remote_hostname` ='fult-c01da0.network.mst.edu' WHERE `neighbour_id` = '2657'] SQL RUNTIME[0.00018406s] SQL[SELECT * FROM `ports` WHERE `device_id` = '211' AND `ifIndex` = '15' AND `ifDescr` NOT LIKE 'Vlan%'] SQL RUNTIME[0.00022197s] SQL[SELECT `device_id`, `hostname` FROM `devices` WHERE `sysName` = 'CR01' OR `hostname` = 'CR01'] SQL RUNTIME[0.00020409s] SQL[SELECT `port_id` FROM `ports` WHERE `ifPhysAddress` = 'cc4e246fc324' AND `device_id` = '301'] SQL RUNTIME[0.00157809s] SQL[SELECT `port_id` FROM `ports` WHERE (`ifIndex`= 'CC 4E 24 6F C3 24' OR `ifDescr` = '10GigabitEthernet1/1/37') AND `device_id` = '301'] SQL RUNTIME[0.00129414s] SQL[SELECT * FROM `ports` WHERE `ports`.`port_id` = '13349'] SQL RUNTIME[0.00021601s] Discover neighbour: 211 -> lldp, 13349, 18741, cr01.network.mst.edu, CC 4E 24 6F C3 24, , , SQL[SELECT * FROM `neighbours` WHERE `port_id` = '13349' AND `protocol` = 'lldp' AND `remote_hostname` = 'cr01.network.mst.edu' AND `remote_port` = 'CC 4E 24 6F C3 24'] SQL RUNTIME[0.00476909s] SQL[INSERT INTO `neighbours` (`port_id`,`protocol`,`remote_port_id`,`remote_hostname`,`remote_port`,`remote_platform`,`remote_version`,`remote_address`) VALUES ('13349','lldp','18741','cr01.network.mst.edu','CC 4E 24 6F C3 24',NULL,NULL,NULL)] SQL RUNTIME[0.00587487s] SQL[SELECT * FROM `ports` WHERE `device_id` = '211' AND `ifIndex` = '16' AND `ifDescr` NOT LIKE 'Vlan%'] SQL RUNTIME[0.00028706s] SQL[SELECT `device_id`, `hostname` FROM `devices` WHERE `sysName` = 'CR01' OR `hostname` = 'CR01'] SQL RUNTIME[0.00027800s] SQL[SELECT `port_id` FROM `ports` WHERE `ifPhysAddress` = '609c9f80dca4' AND `device_id` = '301'] SQL RUNTIME[0.00138903s] SQL[SELECT `port_id` FROM `ports` WHERE (`ifIndex`= '60 9C 9F 80 DC A4' OR `ifDescr` = '10GigabitEthernet2/1/37') AND `device_id` = '301'] SQL RUNTIME[0.00129700s] SQL[SELECT * FROM `ports` WHERE `ports`.`port_id` = '13350'] SQL RUNTIME[0.00019407s] Discover neighbour: 211 -> lldp, 13350, 18796, cr01.network.mst.edu, 60 9C 9F 80 DC A4, , , SQL[SELECT * FROM `neighbours` WHERE `port_id` = '13350' AND `protocol` = 'lldp' AND `remote_hostname` = 'cr01.network.mst.edu' AND `remote_port` = '60 9C 9F 80 DC A4'] SQL RUNTIME[0.00017095s] SQL[INSERT INTO `neighbours` (`port_id`,`protocol`,`remote_port_id`,`remote_hostname`,`remote_port`,`remote_platform`,`remote_version`,`remote_address`) VALUES ('13350','lldp','18796','cr01.network.mst.edu','60 9C 9F 80 DC A4',NULL,NULL,NULL)] SQL RUNTIME[0.00016308s] o CISCO-CDP-MIB CMD[/usr/bin/snmpbulkwalk -t '3' -v2c -c *** -Pu -OQUs -m CISCO-CDP-MIB -M /local/mstobs/observium/mibs/rfc:/local/mstobs/observium/mibs/net-snmp:/local/mstobs/observium/mibs/cisco 'udp':'fult-c01d00.network.mst.edu':'161' cdpCache] CMD EXITCODE[0] CMD RUNTIME[0.0335s] STDOUT[ cdpCacheAddressType.2.1 = ip cdpCacheAddress.2.1 = "AC 11 43 88 " cdpCacheVersion.2.1 = Cisco IOS Software, C2960X Software (C2960X-UNIVERSALK9-M), Version 15.0(2)EX5, RELEASE SOFTWARE (fc1) Technical Support: http://www.cisco.com/techsupport Copyright (c) 1986-2014 by Cisco Systems, Inc. Compiled Fri 21-Feb-14 05:54 by prod_rel_team cdpCacheDeviceId.2.1 = FULT-C01DA0.network.mst.edu cdpCacheDevicePort.2.1 = TenGigabitEthernet1/0/2 cdpCachePlatform.2.1 = cisco WS-C2960X-48FPD-L cdpCacheCapabilities.2.1 = "00 00 00 28 " cdpCacheVTPMgmtDomain.2.1 = cdpCacheNativeVLAN.2.1 = 1 cdpCacheDuplex.2.1 = fullduplex cdpCacheLastChange.2.1 = 461:12:39:33.68 ] SNMP STATUS[TRUE] SQL[SELECT * FROM `ports` WHERE `device_id` = '211' AND `ifIndex` = '2'] SQL RUNTIME[0.00033903s] SQL[SELECT `device_id` FROM `devices` WHERE `sysName` = 'FULT-C01DA0.network.mst.edu' OR `hostname` = 'FULT-C01DA0.network.mst.edu'] SQL RUNTIME[0.00026011s] SQL[SELECT `port_id` FROM `ports` WHERE (`ifDescr` = 'TenGigabitEthernet1/0/2' OR `ifName` = 'TenGigabitEthernet1/0/2') AND `device_id` = '396'] SQL RUNTIME[0.00031900s] SQL[SELECT * FROM `ports` WHERE `ports`.`port_id` = '13336'] SQL RUNTIME[0.00021386s] Discover neighbour: 211 -> cdp, 13336, 24744, FULT-C01DA0.network.mst.edu, TenGigabitEthernet1/0/2, cisco WS-C2960X-48FPD-L, Cisco IOS Software, C2960X Software (C2960X-UNIVERSALK9-M), Version 15.0(2)EX5, RELEASE SOFTWARE (fc1), 172.17.67.136 SQL[SELECT * FROM `neighbours` WHERE `port_id` = '13336' AND `protocol` = 'cdp' AND `remote_hostname` = 'FULT-C01DA0.network.mst.edu' AND `remote_port` = 'TenGigabitEthernet1/0/2'] SQL RUNTIME[0.00018811s] o OSPF-MIB SQL[SELECT * FROM `neighbours` LEFT JOIN `ports` USING(`port_id`) WHERE `device_id` = '211'] SQL RUNTIME[0.00089288s] 13335 -> fult-c01da0.network.mst.edu -> Te1/0/2 SQL[SELECT * FROM `ports` WHERE `ports`.`port_id` = '24744'] SQL RUNTIME[0.00022101s] SQL[SELECT * FROM `devices` WHERE `device_id` = '396'] SQL RUNTIME[0.00019407s] SQL[SELECT * FROM `device_graphs` WHERE `device_id` = '396'] SQL RUNTIME[0.00025296s] 13336 -> FULT-C01DA0.network.mst.edu -> TenGigabitEthernet1/0/2 13349 -> CR01 -> CC 4E 24 6F C3 24 SQL[DELETE FROM `neighbours` WHERE `neighbour_id` = '8358'] SQL RUNTIME[0.00017405s] 13349 -> cr01.network.mst.edu -> CC 4E 24 6F C3 24 SQL[SELECT * FROM `ports` WHERE `ports`.`port_id` = '18741'] SQL RUNTIME[0.00020790s] SQL[SELECT * FROM `devices` WHERE `device_id` = '301'] SQL RUNTIME[0.00015998s] SQL[SELECT * FROM `device_graphs` WHERE `device_id` = '301'] SQL RUNTIME[0.00028205s] 13350 -> CR01 -> 60 9C 9F 80 DC A4 SQL[DELETE FROM `neighbours` WHERE `neighbour_id` = '8359'] SQL RUNTIME[0.00023818s] 13350 -> cr01.network.mst.edu -> 60 9C 9F 80 DC A4 SQL[SELECT * FROM `ports` WHERE `ports`.`port_id` = '18796'] SQL RUNTIME[0.00025511s] +----------+----------------------+----------------------+----------------------+----------------------+----------------------+ | Protocol | ifName | Remote: hostname | port | platform | version | +----------+----------------------+----------------------+----------------------+----------------------+----------------------+ | LLDP | FastEthernet1 | fult-c01da0.network. | TenGigabitEthernet1/ | ... | Cisco IOS Software, | | | | mst.edu | 0/2 | | C2960X Software (... | | CDP | TenGigabitEthernet1/ | FULT-C01DA0.network. | TenGigabitEthernet1/ | cisco WS-C2960X-4... | Cisco IOS Software, | | | 1 | mst.edu | 0/2 | | C2960X Software (... | | LLDP | TenGigabitEthernet1/ | cr01.network.mst.edu | 10GigabitEthernet1/1 | ... | ... | | | 14 | | /37 | | | | LLDP | TenGigabitEthernet1/ | cr01.network.mst.edu | 10GigabitEthernet2/1 | ... | ... | | | 15 | | /37 | | | +----------+----------------------+----------------------+----------------------+----------------------+----------------------+ > $valid[$module] /local/mstobs/observium/includes/discovery/neighbours.inc.php:54 array( [13335] => array( [fult-c01da0.network.mst.edu] => array( [Te1/0/2] => int(1) ) ) [13349] => array( [cr01.network.mst.edu] => array( [CC 4E 24 6F C3 24] => int(1) ) ) [13350] => array( [cr01.network.mst.edu] => array( [60 9C 9F 80 DC A4] => int(1) ) ) [13336] => array( [FULT-C01DA0.network.mst.edu] => array( [TenGigabitEthernet1/0/2] => int(1) ) ) ) o Changes 2 added, 1 updated, 2 deleted, 1 unchanged o Duration 0.2192s SQL[INSERT INTO `eventlog` (`device_id`,`entity_id`,`entity_type`,`timestamp`,`severity`,`message`) VALUES ('211','211','device',NOW(),'6','Neighbours: 2 added, 1 updated, 2 deleted, 1 unchanged.')] SQL RUNTIME[0.00525093s] SQL[UPDATE `devices` set `last_discovered` =NOW(),`type` ='network',`last_discovered_timetaken` ='0.241',`force_discovery` ='0' WHERE `device_id` = '211'] SQL RUNTIME[0.00027800s] SQL[INSERT INTO `devices_perftimes` (`device_id`,`operation`,`start`,`duration`) VALUES ('211','discover','1508437486.3682','0.24190592765808')] SQL RUNTIME[0.00013089s] ##### fult-c01d00.network.mst.edu [211] completed discovery modules at 2017-10-19 13:24:46 ##### o Discovery time 0.241 seconds SQL[DELETE FROM `observium_processes` WHERE `process_pid` = '12218' AND `process_name` = 'discovery.php' AND `device_id` = '211'] SQL RUNTIME[0.00016904s] ##### Finished discovery run at 2017-10-19 13:24:46 ##### SQL[INSERT INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`) VALUES ('discover','fult-c01d00.network.mst.edu','1508437485.0348','1.576','1')] SQL RUNTIME[0.00647306s] ./discovery.php: fult-c01d00.network.mst.edu - 1 devices discovered in 1.576 secs SQL[SELECT * FROM `observium_processes` WHERE `process_start` < '1508423085'] SQL RUNTIME[0.00019598s] NOTE, $config['snmp']['hide_auth'] is set to TRUE, snmp community and snmp v3 auth hidden from debug output. o Devices Discovered 1 o Discovery Time 1.576 secs o Memory usage 12MB (peak: 14MB) o MySQL Usage Cell[42/0.349s] Row[28/0.018s] Rows[15/0.112s] Column[0/0s] Update[6/0.002s] Insert[6/0.019s] Delete[3/0.001s] o RRDTool Usage mstobs@observium:~/observium $ logout Connection to observium closed. [netstat]netconf $logout