LibreNMS Discovery SQL[[1;33mselect `version` from `dbSchema` order by `version` desc limit 1 [0;33m[][0m 0.38ms] SQL[[1;33mSELECT version() [0;33m[][0m 0.26ms] =================================== Version info: Commit SHA: 29f8a8d4a31897832027358a36ad335a0df3fc19 Commit Date: 1547319112 DB Schema: 281 PHP: 7.0.32-0ubuntu0.16.04.1 MySQL: 10.0.36-MariaDB-0ubuntu0.16.04.1 RRDTool: 1.5.5 SNMP: NET-SNMP 5.7.3 ==================================DEBUG! Updating os_def.cache... Done Override discovery modules: ports SQL[[1;33mSELECT * FROM `devices` WHERE disabled = 0 AND snmp_disable = 0 AND `hostname` LIKE '10.100.50.1' ORDER BY device_id DESC [0;33m[][0m 0.9ms] SQL[[1;33mSELECT * FROM devices_attribs WHERE `device_id` = ? [0;33m[7][0m 0.27ms] 10.100.50.1 7 pfsense [FPING] /usr/bin/fping -e -q -c 3 -p 500 -t 500 10.100.50.1 Array ( [xmt] => 3 [rcv] => 3 [loss] => 0 [min] => 1.59 [max] => 2.29 [avg] => 1.89 [exitcode] => 0 ) SQL[[1;33mINSERT IGNORE INTO `device_perf` (`xmt`,`rcv`,`loss`,`min`,`max`,`avg`,`device_id`,`timestamp`,`debug`) VALUES (:xmt,:rcv,:loss,:min,:max,:avg,:device_id,NOW(),:debug) [0;33m{"xmt":"3","rcv":"3","loss":"0","min":"1.59","max":"2.29","avg":"1.89","device_id":7,"debug":"[]"}[0m 24.89ms] SNMP Check response code: 0 SQL[[1;33mSELECT attrib_value FROM devices_attribs WHERE `device_id` = ? AND `attrib_type` = ? [0;33m[7,"poll_mib"][0m 0.38ms] Attempting to initialize OS: pfsense Attempting to initialize OS: unix OS initilized as Generic Modules status: Global+ OS Device #### Load disco module core #### SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY '-OUQn' '-m' 'SNMPv2-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/pfsense' 'udp:HOSTNAME:161' 'sysName.0' 'sysObjectID.0' 'sysDescr.0'[0m] .*.*.0 = router.wickidmachines.com .*.*.0 = .*.4.1.123*.1.1 .*.*.0 = pfSense 2.4.4-RELEASE pfSense FreeBSD 11.2-RELEASE-p3 amd64 >> Runtime for discovery module 'core': 0.0070 seconds with 1072 bytes >> SNMP: [2/0.02s] MySQL: [4/0.03s] RRD: [0/0.00s] #### Unload disco module core #### Modules status: Global+ OS+ Device #### Load disco module ports #### SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY '-OQUs' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/pfsense' 'udp:HOSTNAME:161' 'ifDescr'[0m] ifDescr.1 = igb0 ifDescr.2 = igb1 ifDescr.3 = igb2 ifDescr.4 = igb3 ifDescr.5 = igb4 ifDescr.6 = igb5 ifDescr.7 = igb6 ifDescr.8 = igb7 ifDescr.9 = enc0 ifDescr.10 = lo0 ifDescr.11 = pflog0 ifDescr.12 = pfsync0 ifDescr.13 = ovpns2 ifDescr.14 = ovpns3 ifDescr.15 = ovpns5 ifDescr.16 = ovpnc1 SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY '-OQUs' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/pfsense' 'udp:HOSTNAME:161' 'ifName'[0m] ifName.1 = igb0 ifName.2 = igb1 ifName.3 = igb2 ifName.4 = igb3 ifName.5 = igb4 ifName.6 = igb5 ifName.7 = igb6 ifName.8 = igb7 ifName.9 = enc0 ifName.10 = lo0 ifName.11 = pflog0 ifName.12 = pfsync0 ifName.13 = ovpns2 ifName.14 = ovpns3 ifName.15 = ovpns5 ifName.16 = ovpnc1 SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY '-OQUs' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/pfsense' 'udp:HOSTNAME:161' 'ifAlias'[0m] ifAlias.1 = ifAlias.2 = ifAlias.3 = ifAlias.4 = ifAlias.5 = ifAlias.6 = ifAlias.7 = ifAlias.8 = ifAlias.9 = ifAlias.10 = ifAlias.11 = ifAlias.12 = ifAlias.13 = ifAlias.14 = ifAlias.15 = ifAlias.16 = SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY '-OQUs' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/pfsense' 'udp:HOSTNAME:161' 'ifType'[0m] ifType.1 = ethernetCsmacd ifType.2 = ethernetCsmacd ifType.3 = ethernetCsmacd ifType.4 = ethernetCsmacd ifType.5 = ethernetCsmacd ifType.6 = ethernetCsmacd ifType.7 = ethernetCsmacd ifType.8 = ethernetCsmacd ifType.9 = wwanPP2 ifType.10 = softwareLoopback ifType.11 = ifPwType ifType.12 = ilan ifType.13 = ppp ifType.14 = ppp ifType.15 = ppp ifType.16 = ppp Array ( [1] => Array ( [ifDescr] => igb0 [ifName] => igb0 [ifAlias] => [ifType] => ethernetCsmacd ) [2] => Array ( [ifDescr] => igb1 [ifName] => igb1 [ifAlias] => [ifType] => ethernetCsmacd ) [3] => Array ( [ifDescr] => igb2 [ifName] => igb2 [ifAlias] => [ifType] => ethernetCsmacd ) [4] => Array ( [ifDescr] => igb3 [ifName] => igb3 [ifAlias] => [ifType] => ethernetCsmacd ) [5] => Array ( [ifDescr] => igb4 [ifName] => igb4 [ifAlias] => [ifType] => ethernetCsmacd ) [6] => Array ( [ifDescr] => igb5 [ifName] => igb5 [ifAlias] => [ifType] => ethernetCsmacd ) [7] => Array ( [ifDescr] => igb6 [ifName] => igb6 [ifAlias] => [ifType] => ethernetCsmacd ) [8] => Array ( [ifDescr] => igb7 [ifName] => igb7 [ifAlias] => [ifType] => ethernetCsmacd ) [9] => Array ( [ifDescr] => enc0 [ifName] => enc0 [ifAlias] => [ifType] => wwanPP2 ) [10] => Array ( [ifDescr] => lo0 [ifName] => lo0 [ifAlias] => [ifType] => softwareLoopback ) [11] => Array ( [ifDescr] => pflog0 [ifName] => pflog0 [ifAlias] => [ifType] => ifPwType ) [12] => Array ( [ifDescr] => pfsync0 [ifName] => pfsync0 [ifAlias] => [ifType] => ilan ) [13] => Array ( [ifDescr] => ovpns2 [ifName] => ovpns2 [ifAlias] => [ifType] => ppp ) [14] => Array ( [ifDescr] => ovpns3 [ifName] => ovpns3 [ifAlias] => [ifType] => ppp ) [15] => Array ( [ifDescr] => ovpns5 [ifName] => ovpns5 [ifAlias] => [ifType] => ppp ) [16] => Array ( [ifDescr] => ovpnc1 [ifName] => ovpnc1 [ifAlias] => [ifType] => ppp ) ) SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? ORDER BY port_id [0;33m[7][0m 1.18ms] SQL[[1;33mUPDATE `ports` set `ifType`=?,`ifName`=?,`ifAlias`=?,`ifDescr`=? WHERE `port_id` = ? [0;33m["ethernetCsmacd","igb0","igb0","igb0",39][0m 26.48ms] .SQL[[1;33mUPDATE `ports` set `ifType`=?,`ifName`=?,`ifAlias`=?,`ifDescr`=? WHERE `port_id` = ? [0;33m["ethernetCsmacd","igb1","igb1","igb1",40][0m 33.14ms] .SQL[[1;33mUPDATE `ports` set `ifType`=?,`ifName`=?,`ifAlias`=?,`ifDescr`=? WHERE `port_id` = ? [0;33m["ethernetCsmacd","igb2","igb2","igb2",41][0m 33.19ms] .SQL[[1;33mUPDATE `ports` set `ifType`=?,`ifName`=?,`ifAlias`=?,`ifDescr`=? WHERE `port_id` = ? [0;33m["ethernetCsmacd","igb3","igb3","igb3",42][0m 33.22ms] .SQL[[1;33mUPDATE `ports` set `ifType`=?,`ifName`=?,`ifAlias`=?,`ifDescr`=? WHERE `port_id` = ? [0;33m["ethernetCsmacd","igb4","igb4","igb4",43][0m 33.2ms] .SQL[[1;33mUPDATE `ports` set `ifType`=?,`ifName`=?,`ifAlias`=?,`ifDescr`=? WHERE `port_id` = ? [0;33m["ethernetCsmacd","igb5","igb5","igb5",44][0m 33.18ms] .SQL[[1;33mUPDATE `ports` set `ifType`=?,`ifName`=?,`ifAlias`=?,`ifDescr`=? WHERE `port_id` = ? [0;33m["ethernetCsmacd","igb6","igb6","igb6",45][0m 33.22ms] .SQL[[1;33mUPDATE `ports` set `ifType`=?,`ifName`=?,`ifAlias`=?,`ifDescr`=? WHERE `port_id` = ? [0;33m["ethernetCsmacd","igb7","igb7","igb7",46][0m 33.06ms] .SQL[[1;33mUPDATE `ports` set `ifType`=?,`ifName`=?,`ifAlias`=?,`ifDescr`=? WHERE `port_id` = ? [0;33m["wwanPP2","enc0","enc0","enc0",47][0m 33.23ms] .SQL[[1;33mUPDATE `ports` set `ifType`=?,`ifName`=?,`ifAlias`=?,`ifDescr`=? WHERE `port_id` = ? [0;33m["softwareLoopback","lo0","lo0","lo0",48][0m 33.18ms] .SQL[[1;33mUPDATE `ports` set `ifType`=?,`ifName`=?,`ifAlias`=?,`ifDescr`=? WHERE `port_id` = ? [0;33m["ifPwType","pflog0","pflog0","pflog0",49][0m 33.22ms] .SQL[[1;33mUPDATE `ports` set `ifType`=?,`ifName`=?,`ifAlias`=?,`ifDescr`=? WHERE `port_id` = ? [0;33m["ilan","pfsync0","pfsync0","pfsync0",50][0m 277.79ms] .SQL[[1;33mUPDATE `ports` set `ifType`=?,`ifName`=?,`ifAlias`=?,`ifDescr`=? WHERE `port_id` = ? [0;33m["ppp","ovpns2","ovpns2","ovpns2",51][0m 80.05ms] .SQL[[1;33mUPDATE `ports` set `ifType`=?,`ifName`=?,`ifAlias`=?,`ifDescr`=? WHERE `port_id` = ? [0;33m["ppp","ovpns3","ovpns3","ovpns3",52][0m 24.9ms] .SQL[[1;33mUPDATE `ports` set `ifType`=?,`ifName`=?,`ifAlias`=?,`ifDescr`=? WHERE `port_id` = ? [0;33m["ppp","ovpns5","ovpns5","ovpns5",53][0m 24.83ms] .SQL[[1;33mUPDATE `ports` set `ifType`=?,`ifName`=?,`ifAlias`=?,`ifDescr`=? WHERE `port_id` = ? [0;33m["ppp","ovpnc1","ovpnc1","ovpnc1",54][0m 24.85ms] . >> Runtime for discovery module 'ports': 0.8430 seconds with 4312 bytes >> SNMP: [4/0.04s] MySQL: [17/0.80s] RRD: [0/0.00s] #### Unload disco module ports #### SQL[[1;33mSELECT attrib_value FROM devices_attribs WHERE `device_id` = ? AND `attrib_type` = ? [0;33m[7,"poll_mib"][0m 0.37ms] SQL[[1;33mUPDATE `devices` set `last_discovered`=NOW(),`last_discovered_timetaken`=? WHERE `device_id` = ? [0;33m[1.904,7][0m 24.38ms] Discovered in 1.904 seconds SQL[[1;33mINSERT IGNORE INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`,`poller`) VALUES (:type,:doing,:start,:duration,:devices,:poller) [0;33m{"type":"discover","doing":"10.100.50.1","start":1547414290.8983,"duration":"2.133","devices":1,"poller":"tlnms"}[0m 24.88ms] ./discovery.php 10.100.50.1 2019-01-13 13:18:13 - 1 devices discovered in 2.133 secs SNMP [6/0.06s]: Get[2/0.02s] Getnext[0/0.00s] Walk[4/0.04s] MySQL [24/0.87s]: Cell[1/0.00s] Row[1/0.00s] Rows[3/0.00s] Column[0/0.00s] Update[17/0.82s] Insert[2/0.05s] Delete[0/0.00s] RRD [0/0.00s]: Update[0/0.00s] Create [0/0.00s] Other[0/0.00s]