- 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]