[root@observium observium]# ./discovery.php -d -m sensors -h kon-kes-smartpack DEBUG! CMD[/usr/bin/svn info /opt/observium] CMD EXITCODE[0] CMD RUNTIME[0.0208s] STDOUT[ Path: . Working Copy Root Path: /opt/observium URL: http://svn.observium.org/svn/observium/branches/stable Repository Root: http://svn.observium.org/svn Repository UUID: 61d68cd4-352d-0410-923a-c4978735b2b8 Revision: 10205 Node Kind: directory Schedule: normal Last Changed Author: adama Last Changed Rev: 10200 Last Changed Date: 2019-12-16 15:24:32 +0200 (Mon, 16 Dec 2019) ] SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'dbSchema';] SQL RUNTIME[0.00019002s] SQL[SELECT @@SESSION.sql_mode;] SQL RUNTIME[0.00005007s] SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'current_rev';] SQL RUNTIME[0.00006890s] SQL[SELECT * FROM `config`] SQL RUNTIME[0.00011778s] CMD[/bin/hostname -f] CMD EXITCODE[0] CMD RUNTIME[0.0026s] STDOUT[ observium ] ___ _ _ / _ \ | |__ ___ ___ _ __ __ __(_) _ _ _ __ ___ | | | || '_ \ / __| / _ \| '__|\ \ / /| || | | || '_ ` _ \ | |_| || |_) |\__ \| __/| | \ V / | || |_| || | | | | | \___/ |_.__/ |___/ \___||_| \_/ |_| \__,_||_| |_| |_| Observium Professional 19.12.10200 http://www.observium.org CMD[/opt/observium/scripts/distro] CMD EXITCODE[0] CMD RUNTIME[0.0306s] STDOUT[ Linux|3.10.0-693.el7.x86_64|amd64|CentOS|7|| ] CMD[/usr/bin/env python --version 2>&1] CMD EXITCODE[0] CMD RUNTIME[0.0032s] STDOUT[ Python 2.7.5 ] SQL[SELECT version();] SQL RUNTIME[0.00030899s] CMD[/usr/bin/snmpget --version 2>&1] CMD EXITCODE[0] CMD RUNTIME[0.0065s] STDOUT[ NET-SNMP version: 5.7.2 ] CMD[/usr/bin/rrdtool --version | head -n1] CMD EXITCODE[0] CMD RUNTIME[0.005s] STDOUT[ RRDtool 1.6.0 Copyright by Tobias Oetiker ] CMD[/usr/sbin/fping -v 2>&1] CMD EXITCODE[0] CMD RUNTIME[0.0019s] CMD EXITDELAY[10ms] STDOUT[ /usr/sbin/fping: Version 3.10 /usr/sbin/fping: comments to david@schweikert.ch ] CMD[/usr/bin/env apache2 -v | awk '/Server version:/ {print $3}'] CMD EXITCODE[0] CMD RUNTIME[0.0028s] STDOUT[ ] CMD[/usr/sbin/httpd -v | awk '/Server version:/ {print $3}'] CMD EXITCODE[0] CMD RUNTIME[0.0258s] STDOUT[ Apache/2.4.6 ] CMD[date "+%:z"] CMD EXITCODE[0] CMD RUNTIME[0.0022s] CMD EXITDELAY[10ms] STDOUT[ +02:00 ] SQL[SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP);] SQL RUNTIME[0.00014710s] SQL[SELECT @@SESSION.sql_mode;] SQL RUNTIME[0.00011396s] SQL[SHOW VARIABLES LIKE 'character_set_connection'] SQL RUNTIME[0.00125813s] ##### Software versions ##### o OS Linux 3.10.0-693.el7.x86_64 [amd64] (CentOS 7) o Apache 2.4.6 o PHP 7.0.27 (OPcache: DISABLED) o Python 2.7.5 o MySQL 5.5.56-MariaDB (extension: mysqli 5.5.56-MariaDB) o SNMP NET-SNMP 5.7.2 o RRDtool 1.6.0 o Fping 3.10 (IPv4 only) ##### Memory Limit ##### o PHP 128MB ##### MySQL mode ##### o MySQL ##### Charset info ##### o PHP UTF-8 o MySQL utf8 ##### Timezones info ##### o Date Friday, 20-Dec-19 09:10:25 UTC o PHP +00:00 o MySQL +02:00 SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'last_versioncheck';] SQL RUNTIME[0.00020790s] REQUEST[http://www.observium.org/versions.php] REQUEST STATUS[TRUE] REQUEST RUNTIME[0.4139s] RESPONSE CODE[200 OK] SQL[SELECT EXISTS (SELECT 1 FROM `observium_attribs` WHERE `attrib_type` = 'latest_ver')] SQL RUNTIME[0.00022101s] SQL[UPDATE `observium_attribs` set `attrib_value` ='19.9.10036' WHERE `attrib_type` = 'latest_ver'] SQL RUNTIME[0.00031400s] SQL[SELECT EXISTS (SELECT 1 FROM `observium_attribs` WHERE `attrib_type` = 'latest_rev')] SQL RUNTIME[0.00019312s] SQL[UPDATE `observium_attribs` set `attrib_value` ='10036' WHERE `attrib_type` = 'latest_rev'] SQL RUNTIME[0.00026202s] SQL[SELECT EXISTS (SELECT 1 FROM `observium_attribs` WHERE `attrib_type` = 'latest_rev_date')] SQL RUNTIME[0.00017095s] SQL[UPDATE `observium_attribs` set `attrib_value` ='2019-09-23' WHERE `attrib_type` = 'latest_rev_date'] SQL RUNTIME[0.00025320s] SQL[SELECT EXISTS (SELECT 1 FROM `observium_attribs` WHERE `attrib_type` = 'last_versioncheck')] SQL RUNTIME[0.00017095s] SQL[UPDATE `observium_attribs` set `attrib_value` ='1576833026' WHERE `attrib_type` = 'last_versioncheck'] SQL RUNTIME[0.00027084s] SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'latest_rev';] SQL RUNTIME[0.00016189s] ##### Starting discovery run at 2019-12-20 09:10:26 ##### SQL[SELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` LIKE 'kon-kes-smartpack' AND `status` = '1' AND `poller_id` = '0' ORDER BY `last_discovered_timetaken` ASC] SQL RUNTIME[0.00063419s] CMD[/usr/bin/snmpget -t '2' -v2c -c *** -Pud -OQUs -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'kon-kes-smartpack':'161' sysObjectID.0 sysUpTime.0] CMD EXITCODE[0] CMD RUNTIME[0.0156s] STDOUT[ sysObjectID.0 = enterprises.12148.9 sysUpTime.0 = 24:19:45:41.86 ] SNMP STATUS[TRUE] SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '126'] SQL RUNTIME[0.00028419s] SQL[SELECT * FROM `observium_processes` WHERE `process_name` = 'discovery.php' AND `device_id` = '126'] SQL RUNTIME[0.00021291s] SQL[INSERT INTO `observium_processes` (`process_pid`,`process_name`,`process_ppid`,`process_uid`,`process_command`,`process_start`,`device_id`) VALUES ('109229','discovery.php','188056','0','php ./discovery.php -d -m sensors -h kon-kes-smartpack','1576833026','126')] SQL RUNTIME[0.00025487s] ##### kon-kes-smartpack [126] ##### o OS Type eltek o SNMP Version v2c o Last discovery 2019-12-20 09:50:26 o Last duration 25.01 seconds ##### Module Start: sensors ##### SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '126' AND `attrib_type` = 'sysORID'] SQL RUNTIME[0.00023389s] SQL[SELECT `mib` FROM `devices_mibs` WHERE `device_id` = '126' AND `use` = 'mib' AND `disabled` = '1'] SQL RUNTIME[0.00019598s] o ELTEK-DISTRIBUTED-MIB CMD[/usr/bin/snmpget -t '2' -v2c -c *** -Pud -OQUv -m ELTEK-DISTRIBUTED-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/eltek 'udp':'kon-kes-smartpack':'161' .1.3.6.1.4.1.12148.9.6.1.0] CMD EXITCODE[0] CMD RUNTIME[0.077s] STDOUT[ 228 ] SNMP STATUS[TRUE] Discover sensor: [class: voltage, device: kon-kes-smartpack, oid: .1.3.6.1.4.1.12148.9.6.1.0, index: 1, type: eltek-distributed-mib_acVoltage, descr: AC Voltage 1, scale: 1, limits: (, , , ), CURRENT: 228, , SQL[SELECT EXISTS (SELECT 1 FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'voltage' AND `device_id` = '126' AND `sensor_type` = 'eltek-distributed-mib_acVoltage' AND `sensor_index` = '1')] SQL RUNTIME[0.00051785s] SQL[SELECT * FROM `sensors` WHERE `sensor_class` = 'voltage' AND `device_id` = '126' AND `sensor_type` = 'eltek-distributed-mib_acVoltage' AND `sensor_index` = '1'] SQL RUNTIME[0.00052810s] SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'sensor' AND `entity_id` = '1707' AND `attrib_type` = 'sensor_addition'] SQL RUNTIME[0.00024390s] . CMD[/usr/bin/snmpget -t '2' -v2c -c *** -Pud -OQUv -m ELTEK-DISTRIBUTED-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/eltek 'udp':'kon-kes-smartpack':'161' .1.3.6.1.4.1.12148.9.6.2.0] CMD EXITCODE[0] CMD RUNTIME[0.0864s] STDOUT[ 230 ] SNMP STATUS[TRUE] Discover sensor: [class: voltage, device: kon-kes-smartpack, oid: .1.3.6.1.4.1.12148.9.6.2.0, index: 2, type: eltek-distributed-mib_acVoltage, descr: AC Voltage 2, scale: 1, limits: (, , , ), CURRENT: 230, , SQL[SELECT EXISTS (SELECT 1 FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'voltage' AND `device_id` = '126' AND `sensor_type` = 'eltek-distributed-mib_acVoltage' AND `sensor_index` = '2')] SQL RUNTIME[0.00052881s] SQL[SELECT * FROM `sensors` WHERE `sensor_class` = 'voltage' AND `device_id` = '126' AND `sensor_type` = 'eltek-distributed-mib_acVoltage' AND `sensor_index` = '2'] SQL RUNTIME[0.00058603s] SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'sensor' AND `entity_id` = '1708' AND `attrib_type` = 'sensor_addition'] SQL RUNTIME[0.00024199s] . CMD[/usr/bin/snmpget -t '2' -v2c -c *** -Pud -OQUv -m ELTEK-DISTRIBUTED-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/eltek 'udp':'kon-kes-smartpack':'161' .1.3.6.1.4.1.12148.9.6.3.0] CMD EXITCODE[0] CMD RUNTIME[0.1466s] STDOUT[ 0 ] SNMP STATUS[TRUE] Discover sensor: [class: voltage, device: kon-kes-smartpack, oid: .1.3.6.1.4.1.12148.9.6.3.0, index: 3, type: eltek-distributed-mib_acVoltage, descr: AC Voltage 3, scale: 1, limits: (, , , ), CURRENT: 0, , SQL[SELECT EXISTS (SELECT 1 FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'voltage' AND `device_id` = '126' AND `sensor_type` = 'eltek-distributed-mib_acVoltage' AND `sensor_index` = '3')] SQL RUNTIME[0.00053596s] SQL[SELECT * FROM `sensors` WHERE `sensor_class` = 'voltage' AND `device_id` = '126' AND `sensor_type` = 'eltek-distributed-mib_acVoltage' AND `sensor_index` = '3'] SQL RUNTIME[0.00058794s] SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'sensor' AND `entity_id` = '1709' AND `attrib_type` = 'sensor_addition'] SQL RUNTIME[0.00025892s] . CMD[/usr/bin/snmpwalk -t '2' -v2c -c *** -Pud -OQUs -m ELTEK-DISTRIBUTED-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/eltek 'udp':'kon-kes-smartpack':'161' rectifierStatusTable] CMD EXITCODE[0] CMD RUNTIME[16.3373s] STDOUT[ rectifierStatusID.0 = 1 rectifierStatusID.1 = 2 rectifierStatusID.2 = 3 rectifierStatusID.3 = 4 rectifierStatusID.4 = 5 rectifierStatusID.5 = 6 rectifierStatusID.6 = 7 rectifierStatusID.7 = 8 rectifierStatusID.8 = 9 rectifierStatusID.9 = 10 rectifierStatusID.10 = 11 rectifierStatusID.11 = 12 rectifierStatusID.12 = 13 rectifierStatusID.13 = 14 rectifierStatusID.14 = 15 rectifierStatusID.15 = 16 rectifierStatusID.16 = 17 rectifierStatusID.17 = 18 rectifierStatusID.18 = 19 rectifierStatusID.19 = 20 rectifierStatusStatus.0 = normal rectifierStatusStatus.1 = normal rectifierStatusStatus.2 = notPresent rectifierStatusStatus.3 = notPresent rectifierStatusStatus.4 = notPresent rectifierStatusStatus.5 = notPresent rectifierStatusStatus.6 = notPresent rectifierStatusStatus.7 = notPresent rectifierStatusStatus.8 = notPresent rectifierStatusStatus.9 = notPresent rectifierStatusStatus.10 = notPresent rectifierStatusStatus.11 = notPresent rectifierStatusStatus.12 = notPresent rectifierStatusStatus.13 = notPresent rectifierStatusStatus.14 = notPresent rectifierStatusStatus.15 = notPresent rectifierStatusStatus.16 = notPresent rectifierStatusStatus.17 = notPresent rectifierStatusStatus.18 = notPresent rectifierStatusStatus.19 = notPresent rectifierStatusOutputCurrent.0 = 16 rectifierStatusOutputCurrent.1 = 19 rectifierStatusOutputCurrent.2 = 0 rectifierStatusOutputCurrent.3 = 0 rectifierStatusOutputCurrent.4 = 0 rectifierStatusOutputCurrent.5 = 0 rectifierStatusOutputCurrent.6 = 0 rectifierStatusOutputCurrent.7 = 0 rectifierStatusOutputCurrent.8 = 0 rectifierStatusOutputCurrent.9 = 0 rectifierStatusOutputCurrent.10 = 0 rectifierStatusOutputCurrent.11 = 0 rectifierStatusOutputCurrent.12 = 0 rectifierStatusOutputCurrent.13 = 0 rectifierStatusOutputCurrent.14 = 0 rectifierStatusOutputCurrent.15 = 0 rectifierStatusOutputCurrent.16 = 0 rectifierStatusOutputCurrent.17 = 0 rectifierStatusOutputCurrent.18 = 0 rectifierStatusOutputCurrent.19 = 0 rectifierStatusOutputVoltage.0 = 5442 rectifierStatusOutputVoltage.1 = 5434 rectifierStatusOutputVoltage.2 = 0 rectifierStatusOutputVoltage.3 = 0 rectifierStatusOutputVoltage.4 = 0 rectifierStatusOutputVoltage.5 = 0 rectifierStatusOutputVoltage.6 = 0 rectifierStatusOutputVoltage.7 = 0 rectifierStatusOutputVoltage.8 = 0 rectifierStatusOutputVoltage.9 = 0 rectifierStatusOutputVoltage.10 = 0 rectifierStatusOutputVoltage.11 = 0 rectifierStatusOutputVoltage.12 = 0 rectifierStatusOutputVoltage.13 = 0 rectifierStatusOutputVoltage.14 = 0 rectifierStatusOutputVoltage.15 = 0 rectifierStatusOutputVoltage.16 = 0 rectifierStatusOutputVoltage.17 = 0 rectifierStatusOutputVoltage.18 = 0 rectifierStatusOutputVoltage.19 = 0 rectifierStatusTemp.0 = 33 rectifierStatusTemp.1 = 33 rectifierStatusTemp.2 = 0 rectifierStatusTemp.3 = 0 rectifierStatusTemp.4 = 0 rectifierStatusTemp.5 = 0 rectifierStatusTemp.6 = 0 rectifierStatusTemp.7 = 0 rectifierStatusTemp.8 = 0 rectifierStatusTemp.9 = 0 rectifierStatusTemp.10 = 0 rectifierStatusTemp.11 = 0 rectifierStatusTemp.12 = 0 rectifierStatusTemp.13 = 0 rectifierStatusTemp.14 = 0 rectifierStatusTemp.15 = 0 rectifierStatusTemp.16 = 0 rectifierStatusTemp.17 = 0 rectifierStatusTemp.18 = 0 rectifierStatusTemp.19 = 0 rectifierStatusType.0 = FLATPACK2 48/2000 HE rectifierStatusType.1 = FLATPACK2 48/2000 HE rectifierStatusType.2 = - rectifierStatusType.3 = - rectifierStatusType.4 = - rectifierStatusType.5 = - rectifierStatusType.6 = - rectifierStatusType.7 = - rectifierStatusType.8 = - rectifierStatusType.9 = - rectifierStatusType.10 = - rectifierStatusType.11 = - rectifierStatusType.12 = - rectifierStatusType.13 = - rectifierStatusType.14 = - rectifierStatusType.15 = - rectifierStatusType.16 = - rectifierStatusType.17 = - rectifierStatusType.18 = - rectifierStatusType.19 = - rectifierStatusSKU.0 = 241115.105 rectifierStatusSKU.1 = 241115.105 rectifierStatusSKU.2 = - rectifierStatusSKU.3 = - rectifierStatusSKU.4 = - rectifierStatusSKU.5 = - rectifierStatusSKU.6 = - rectifierStatusSKU.7 = - rectifierStatusSKU.8 = - rectifierStatusSKU.9 = - rectifierStatusSKU.10 = - rectifierStatusSKU.11 = - rectifierStatusSKU.12 = - rectifierStatusSKU.13 = - rectifierStatusSKU.14 = - rectifierStatusSKU.15 = - rectifierStatusSKU.16 = - rectifierStatusSKU.17 = - rectifierStatusSKU.18 = - rectifierStatusSKU.19 = - rectifierStatusSerialNo.0 = 143772005705 rectifierStatusSerialNo.1 = 143772005057 rectifierStatusSerialNo.2 = - rectifierStatusSerialNo.3 = - rectifierStatusSerialNo.4 = - rectifierStatusSerialNo.5 = - rectifierStatusSerialNo.6 = - rectifierStatusSerialNo.7 = - rectifierStatusSerialNo.8 = - rectifierStatusSerialNo.9 = - rectifierStatusSerialNo.10 = - rectifierStatusSerialNo.11 = - rectifierStatusSerialNo.12 = - rectifierStatusSerialNo.13 = - rectifierStatusSerialNo.14 = - rectifierStatusSerialNo.15 = - rectifierStatusSerialNo.16 = - rectifierStatusSerialNo.17 = - rectifierStatusSerialNo.18 = - rectifierStatusSerialNo.19 = - rectifierStatusRevisionLevel.0 = 4 rectifierStatusRevisionLevel.1 = 4 rectifierStatusRevisionLevel.2 = - rectifierStatusRevisionLevel.3 = - rectifierStatusRevisionLevel.4 = - rectifierStatusRevisionLevel.5 = - rectifierStatusRevisionLevel.6 = - rectifierStatusRevisionLevel.7 = - rectifierStatusRevisionLevel.8 = - rectifierStatusRevisionLevel.9 = - rectifierStatusRevisionLevel.10 = - rectifierStatusRevisionLevel.11 = - rectifierStatusRevisionLevel.12 = - rectifierStatusRevisionLevel.13 = - rectifierStatusRevisionLevel.14 = - rectifierStatusRevisionLevel.15 = - rectifierStatusRevisionLevel.16 = - rectifierStatusRevisionLevel.17 = - rectifierStatusRevisionLevel.18 = - rectifierStatusRevisionLevel.19 = - ] SNMP STATUS[TRUE] Discover sensor: [class: voltage, device: kon-kes-smartpack, oid: .1.3.6.1.4.1.12148.9.5.5.2.1.4.0, index: 0, type: eltek-distributed-mib_rectifierStatusOutputVoltage, descr: Rectifier 1 (FLATPACK2 48/2000 HE), scale: 0.01, limits: (, , , ), CURRENT: 54.42, , SQL[SELECT EXISTS (SELECT 1 FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'voltage' AND `device_id` = '126' AND `sensor_type` = 'eltek-distributed-mib_rectifierStatusOutputVoltage' AND `sensor_index` = '0')] SQL RUNTIME[0.00067711s] SQL[SELECT * FROM `sensors` WHERE `sensor_class` = 'voltage' AND `device_id` = '126' AND `sensor_type` = 'eltek-distributed-mib_rectifierStatusOutputVoltage' AND `sensor_index` = '0'] SQL RUNTIME[0.00056505s] SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'sensor' AND `entity_id` = '1710' AND `attrib_type` = 'sensor_addition'] SQL RUNTIME[0.00023413s] .Discover sensor: [class: current, device: kon-kes-smartpack, oid: .1.3.6.1.4.1.12148.9.5.5.2.1.3.0, index: 0, type: eltek-distributed-mib_rectifierStatusOutputCurrent, descr: Rectifier 1 (FLATPACK2 48/2000 HE), scale: 0.1, limits: (, , , ), CURRENT: 1.6, , SQL[SELECT EXISTS (SELECT 1 FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'current' AND `device_id` = '126' AND `sensor_type` = 'eltek-distributed-mib_rectifierStatusOutputCurrent' AND `sensor_index` = '0')] SQL RUNTIME[0.00050402s] SQL[SELECT * FROM `sensors` WHERE `sensor_class` = 'current' AND `device_id` = '126' AND `sensor_type` = 'eltek-distributed-mib_rectifierStatusOutputCurrent' AND `sensor_index` = '0'] SQL RUNTIME[0.00057292s] LCurrent sensor value: "1.6", scale: "0.1" limit_high: "3.3" -> "2.4" limit_high_warn: "" -> "" limit_low: "" -> "" limit_low_warn: "" -> "" SQL[INSERT INTO `eventlog` (`device_id`,`entity_id`,`entity_type`,`timestamp`,`severity`,`message`) VALUES ('126','1711','sensor',NOW(),'6','Sensor updated (limits): limit_high -> \"2.4\"')] SQL RUNTIME[0.00039506s] SQL[UPDATE `sensors` set `sensor_limit` ='2.4' WHERE `sensor_id` = '1711'] SQL RUNTIME[0.00025105s] SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'sensor' AND `entity_id` = '1711' AND `attrib_type` = 'sensor_addition'] SQL RUNTIME[0.00020599s] .Discover sensor: [class: temperature, device: kon-kes-smartpack, oid: .1.3.6.1.4.1.12148.9.5.5.2.1.5.0, index: 0, type: eltek-distributed-mib_rectifierStatusTemp, descr: Rectifier 1 (FLATPACK2 48/2000 HE), scale: 1, limits: (, , , ), CURRENT: 33, , SQL[SELECT EXISTS (SELECT 1 FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'temperature' AND `device_id` = '126' AND `sensor_type` = 'eltek-distributed-mib_rectifierStatusTemp' AND `sensor_index` = '0')] SQL RUNTIME[0.00052500s] SQL[SELECT * FROM `sensors` WHERE `sensor_class` = 'temperature' AND `device_id` = '126' AND `sensor_type` = 'eltek-distributed-mib_rectifierStatusTemp' AND `sensor_index` = '0'] SQL RUNTIME[0.00053191s] SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'sensor' AND `entity_id` = '1712' AND `attrib_type` = 'sensor_addition'] SQL RUNTIME[0.00018907s] .Discover status: [device: kon-kes-smartpack, oid: .1.3.6.1.4.1.12148.9.5.5.2.1.2.0, index: rectifierStatusStatus.0, type: eltek-distributed-mib_rectifierStatusStatus, descr: Rectifier 1 (FLATPACK2 48/2000 HE), CURRENT: 1, , ] SQL[SELECT EXISTS (SELECT 1 FROM `status` WHERE `device_id` = '126' AND `status_type` = 'eltek-distributed-mib_rectifierStatusStatus' AND `status_index` = 'rectifierStatusStatus.0' AND `poller_type`= 'snmp')] SQL RUNTIME[0.00026703s] SQL[SELECT * FROM `status` WHERE `device_id` = '126' AND `status_type` = 'eltek-distributed-mib_rectifierStatusStatus' AND `status_index` = 'rectifierStatusStatus.0' AND `poller_type`= 'snmp'] SQL RUNTIME[0.00027108s] .Discover sensor: [class: voltage, device: kon-kes-smartpack, oid: .1.3.6.1.4.1.12148.9.5.5.2.1.4.1, index: 1, type: eltek-distributed-mib_rectifierStatusOutputVoltage, descr: Rectifier 2 (FLATPACK2 48/2000 HE), scale: 0.01, limits: (, , , ), CURRENT: 54.34, , SQL[SELECT EXISTS (SELECT 1 FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'voltage' AND `device_id` = '126' AND `sensor_type` = 'eltek-distributed-mib_rectifierStatusOutputVoltage' AND `sensor_index` = '1')] SQL RUNTIME[0.00048494s] SQL[SELECT * FROM `sensors` WHERE `sensor_class` = 'voltage' AND `device_id` = '126' AND `sensor_type` = 'eltek-distributed-mib_rectifierStatusOutputVoltage' AND `sensor_index` = '1'] SQL RUNTIME[0.00049901s] SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'sensor' AND `entity_id` = '1713' AND `attrib_type` = 'sensor_addition'] SQL RUNTIME[0.00017786s] .Discover sensor: [class: current, device: kon-kes-smartpack, oid: .1.3.6.1.4.1.12148.9.5.5.2.1.3.1, index: 1, type: eltek-distributed-mib_rectifierStatusOutputCurrent, descr: Rectifier 2 (FLATPACK2 48/2000 HE), scale: 0.1, limits: (, , , ), CURRENT: 1.9, , SQL[SELECT EXISTS (SELECT 1 FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'current' AND `device_id` = '126' AND `sensor_type` = 'eltek-distributed-mib_rectifierStatusOutputCurrent' AND `sensor_index` = '1')] SQL RUNTIME[0.00042701s] SQL[SELECT * FROM `sensors` WHERE `sensor_class` = 'current' AND `device_id` = '126' AND `sensor_type` = 'eltek-distributed-mib_rectifierStatusOutputCurrent' AND `sensor_index` = '1'] SQL RUNTIME[0.00048518s] LCurrent sensor value: "1.9", scale: "0.1" limit_high: "1.8" -> "2.85" limit_high_warn: "" -> "" limit_low: "" -> "" limit_low_warn: "" -> "" SQL[INSERT INTO `eventlog` (`device_id`,`entity_id`,`entity_type`,`timestamp`,`severity`,`message`) VALUES ('126','1714','sensor',NOW(),'6','Sensor updated (limits): limit_high -> \"2.85\"')] SQL RUNTIME[0.00026178s] SQL[UPDATE `sensors` set `sensor_limit` ='2.85' WHERE `sensor_id` = '1714'] SQL RUNTIME[0.00023198s] SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'sensor' AND `entity_id` = '1714' AND `attrib_type` = 'sensor_addition'] SQL RUNTIME[0.00020003s] .Discover sensor: [class: temperature, device: kon-kes-smartpack, oid: .1.3.6.1.4.1.12148.9.5.5.2.1.5.1, index: 1, type: eltek-distributed-mib_rectifierStatusTemp, descr: Rectifier 2 (FLATPACK2 48/2000 HE), scale: 1, limits: (, , , ), CURRENT: 33, , SQL[SELECT EXISTS (SELECT 1 FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'temperature' AND `device_id` = '126' AND `sensor_type` = 'eltek-distributed-mib_rectifierStatusTemp' AND `sensor_index` = '1')] SQL RUNTIME[0.00041413s] SQL[SELECT * FROM `sensors` WHERE `sensor_class` = 'temperature' AND `device_id` = '126' AND `sensor_type` = 'eltek-distributed-mib_rectifierStatusTemp' AND `sensor_index` = '1'] SQL RUNTIME[0.00047898s] SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'sensor' AND `entity_id` = '1715' AND `attrib_type` = 'sensor_addition'] SQL RUNTIME[0.00016308s] .Discover status: [device: kon-kes-smartpack, oid: .1.3.6.1.4.1.12148.9.5.5.2.1.2.1, index: rectifierStatusStatus.1, type: eltek-distributed-mib_rectifierStatusStatus, descr: Rectifier 2 (FLATPACK2 48/2000 HE), CURRENT: 1, , ] SQL[SELECT EXISTS (SELECT 1 FROM `status` WHERE `device_id` = '126' AND `status_type` = 'eltek-distributed-mib_rectifierStatusStatus' AND `status_index` = 'rectifierStatusStatus.1' AND `poller_type`= 'snmp')] SQL RUNTIME[0.00022006s] SQL[SELECT * FROM `status` WHERE `device_id` = '126' AND `status_type` = 'eltek-distributed-mib_rectifierStatusStatus' AND `status_index` = 'rectifierStatusStatus.1' AND `poller_type`= 'snmp'] SQL RUNTIME[0.00024700s] . CMD[/usr/bin/snmpget -t '2' -v2c -c *** -Pud -OQUv -m ELTEK-DISTRIBUTED-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/eltek 'udp':'kon-kes-smartpack':'161' batteryChargeCurrentLimitValue.0] CMD EXITCODE[0] CMD RUNTIME[0.1014s] STDOUT[ 100 ] SNMP STATUS[TRUE] CMD[/usr/bin/snmpget -t '2' -v2c -c *** -Pud -OQUv -m ELTEK-DISTRIBUTED-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/eltek 'udp':'kon-kes-smartpack':'161' batteryCurrent.0] CMD EXITCODE[0] CMD RUNTIME[0.1188s] STDOUT[ 0 ] SNMP STATUS[TRUE] Discover sensor: [class: current, device: kon-kes-smartpack, oid: .1.3.6.1.4.1.12148.9.3.3.0, index: 0, type: ELTEK-DISTRIBUTED-MIB-batteryCurrent, descr: Battery Current, scale: 1, limits: (, , , 100), CURRENT: 0, , SQL[SELECT EXISTS (SELECT 1 FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'current' AND `device_id` = '126' AND `sensor_type` = 'ELTEK-DISTRIBUTED-MIB-batteryCurrent' AND `sensor_index` = '0')] SQL RUNTIME[0.00051498s] SQL[SELECT * FROM `sensors` WHERE `sensor_class` = 'current' AND `device_id` = '126' AND `sensor_type` = 'ELTEK-DISTRIBUTED-MIB-batteryCurrent' AND `sensor_index` = '0'] SQL RUNTIME[0.00048900s] SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'sensor' AND `entity_id` = '1716' AND `attrib_type` = 'sensor_addition'] SQL RUNTIME[0.00021195s] . o ELTEK-DISTRIBUTED-MIB batteryVoltage [ CMD[/usr/bin/snmpwalk -t '2' -v2c -c *** -Pud -Ih -OQUsb -m ELTEK-DISTRIBUTED-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/eltek 'udp':'kon-kes-smartpack':'161' batteryVoltage] CMD EXITCODE[0] CMD RUNTIME[0.2355s] STDOUT[ batteryVoltage.0 = 5466 ] SNMP STATUS[TRUE] Store in cache Table OID: ELTEK-DISTRIBUTED-MIB::batteryVoltage CMD[/usr/bin/snmpwalk -t '2' -v2c -c *** -Pud -Ih -OQUsb -m ELTEK-DISTRIBUTED-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/eltek 'udp':'kon-kes-smartpack':'161' batteryLowMajorAlarmVoltageConfig] CMD EXITCODE[0] CMD RUNTIME[0.1889s] STDOUT[ batteryLowMajorAlarmVoltageConfig.0 = 4630 ] SNMP STATUS[TRUE] Store in cache Table OID: ELTEK-DISTRIBUTED-MIB::batteryLowMajorAlarmVoltageConfig CMD[/usr/bin/snmpwalk -t '2' -v2c -c *** -Pud -Ih -OQUsb -m ELTEK-DISTRIBUTED-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/eltek 'udp':'kon-kes-smartpack':'161' batteryHighMajorAlarmVoltageConfig] CMD EXITCODE[0] CMD RUNTIME[0.1987s] STDOUT[ batteryHighMajorAlarmVoltageConfig.0 = 5700 ] SNMP STATUS[TRUE] Store in cache Table OID: ELTEK-DISTRIBUTED-MIB::batteryHighMajorAlarmVoltageConfig Discover sensor: [class: voltage, device: kon-kes-smartpack, oid: .1.3.6.1.4.1.12148.9.3.2.0, index: 0, type: ELTEK-DISTRIBUTED-MIB-batteryVoltage, descr: Battery Voltage, scale: 0.01, limits: (46.3, , , 57), CURRENT: 54.66, , SQL[SELECT EXISTS (SELECT 1 FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'voltage' AND `device_id` = '126' AND `sensor_type` = 'ELTEK-DISTRIBUTED-MIB-batteryVoltage' AND `sensor_index` = '0')] SQL RUNTIME[0.00051594s] SQL[SELECT * FROM `sensors` WHERE `sensor_class` = 'voltage' AND `device_id` = '126' AND `sensor_type` = 'ELTEK-DISTRIBUTED-MIB-batteryVoltage' AND `sensor_index` = '0'] SQL RUNTIME[0.00046706s] SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'sensor' AND `entity_id` = '1717' AND `attrib_type` = 'sensor_addition'] SQL RUNTIME[0.00020099s] .] o ELTEK-DISTRIBUTED-MIB batteryBreakerStatus [ CMD[/usr/bin/snmpwalk -t '2' -v2c -c *** -Pud -Ih -OQUsb -m ELTEK-DISTRIBUTED-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/eltek 'udp':'kon-kes-smartpack':'161' batteryBreakerStatus] CMD EXITCODE[0] CMD RUNTIME[0.1966s] STDOUT[ batteryBreakerStatus.0 = normal ] SNMP STATUS[TRUE] Store in cache Table OID: ELTEK-DISTRIBUTED-MIB::batteryBreakerStatus Discover status: [device: kon-kes-smartpack, oid: .1.3.6.1.4.1.12148.9.3.5.0, index: 0, type: batteryBreakerStatus, descr: Battery Breaker Status, CURRENT: 0, , battery] SQL[SELECT EXISTS (SELECT 1 FROM `status` WHERE `device_id` = '126' AND `status_mib` = 'ELTEK-DISTRIBUTED-MIB' AND `status_object` = 'batteryBreakerStatus' AND `status_type` = 'batteryBreakerStatus' AND `status_index` = '0' AND `poller_type`= 'snmp')] SQL RUNTIME[0.00039983s] SQL[SELECT * FROM `status` WHERE `device_id` = '126' AND `status_mib` = 'ELTEK-DISTRIBUTED-MIB' AND `status_object` = 'batteryBreakerStatus' AND `status_type` = 'batteryBreakerStatus' AND `status_index` = '0' AND `poller_type`= 'snmp'] SQL RUNTIME[0.00037289s] .] SQL[SELECT * FROM `sensors` WHERE `device_id` = '126' AND `sensor_class` = 'temperature' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00089097s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '126' AND `sensor_class` = 'humidity' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00028300s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '126' AND `sensor_class` = 'fanspeed' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00040603s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '126' AND `sensor_class` = 'dewpoint' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00024891s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '126' AND `sensor_class` = 'airflow' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00025010s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '126' AND `sensor_class` = 'voltage' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00071692s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '126' AND `sensor_class` = 'current' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00059605s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '126' AND `sensor_class` = 'power' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00032282s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '126' AND `sensor_class` = 'apower' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00024199s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '126' AND `sensor_class` = 'rpower' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00024009s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '126' AND `sensor_class` = 'crestfactor' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00022888s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '126' AND `sensor_class` = 'powerfactor' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00022793s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '126' AND `sensor_class` = 'impedance' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00023508s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '126' AND `sensor_class` = 'resistance' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00022411s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '126' AND `sensor_class` = 'frequency' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00032401s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '126' AND `sensor_class` = 'dbm' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00030684s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '126' AND `sensor_class` = 'snr' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00023007s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '126' AND `sensor_class` = 'dust' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00024295s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '126' AND `sensor_class` = 'sound' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00022793s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '126' AND `sensor_class` = 'capacity' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00024796s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '126' AND `sensor_class` = 'load' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00020695s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '126' AND `sensor_class` = 'runtime' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00020409s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '126' AND `sensor_class` = 'volume' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00022388s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '126' AND `sensor_class` = 'waterflow' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00021219s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '126' AND `sensor_class` = 'pressure' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00020599s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '126' AND `sensor_class` = 'velocity' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00020909s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '126' AND `sensor_class` = 'illuminance' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00021195s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '126' AND `sensor_class` = 'wavelength' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00044298s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '126' AND `sensor_class` = 'gauge' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00021791s] SQL[SELECT * FROM `status` WHERE `device_id` = '126' AND `poller_type` = 'snmp' AND `status_deleted` = '0'] SQL RUNTIME[0.00021386s] SQL[SELECT * FROM `counters` WHERE `device_id` = '126' AND `poller_type` = 'snmp' AND `counter_deleted` = '0'] SQL RUNTIME[0.00021195s] o Duration 17.7464s SQL[SELECT `device_state` FROM `devices` WHERE `device_id` = '126';] SQL RUNTIME[0.00014305s] SQL[UPDATE `devices` set `last_discovered` =NOW(),`type` ='power',`last_discovered_timetaken` ='17.7483',`force_discovery` ='0',`device_state` ='a:5:{s:15:\"poller_mod_perf\";a:28:{s:6:\"system\";d:0.1174;s:2:\"os\";d:0.13600000000000001;s:7:\"sensors\";d:1.1476;s:6:\"status\";d:0.27410000000000001;s:7:\"counter\";d:0.00040000000000000002;s:10:\"processors\";d:0.00069999999999999999;s:8:\"mempools\";d:0.00069999999999999999;s:7:\"storage\";d:0.00069999999999999999;s:8:\"netstats\";d:0.2238;s:7:\"ucd-mib\";d:0.14879999999999999;s:13:\"ipSystemStats\";d:0.019800000000000002;s:5:\"ports\";d:0.9879;s:9:\"bgp-peers\";d:0.0012999999999999999;s:15:\"printersupplies\";d:0.00050000000000000001;s:10:\"ucd-diskio\";d:0.00029999999999999997;s:4:\"wifi\";d:0.00020000000000000001;s:10:\"p2p-radios\";d:0.00050000000000000001;s:4:\"ospf\";d:0.00069999999999999999;s:3:\"sla\";d:0.00069999999999999999;s:11:\"pseudowires\";d:0.00059999999999999995;s:14:\"mac-accounting\";d:0.00080000000000000004;s:12:\"loadbalancer\";d:0.00029999999999999997;s:15:\"entity-physical\";d:0.00020000000000000001;s:12:\"applications\";d:0.00050000000000000001;s:9:\"fdb-table\";d:0.42499999999999999;s:6:\"graphs\";d:0.056000000000000001;s:4:\"oids\";d:0.00050000000000000001;s:6:\"probes\";d:0.00050000000000000001;}s:17:\"poller_ports_perf\";a:1:{s:4:\"vlan\";d:0.67958498001098633;}s:14:\"poller_history\";a:17:{i:1576833009;d:3.6101999999999999;i:1576832711;d:3.5032999999999999;i:1576832410;d:3.0973000000000002;i:1576832107;d:3.2172999999999998;i:1576831809;d:3.7067000000000001;i:1576831509;d:3.3649;i:1576831209;d:3.4540000000000002;i:1576830910;d:3.4735999999999998;i:1576830609;d:3.1516999999999999;i:1576830309;d:3.4121000000000001;i:1576830009;d:3.3302;i:1576829709;d:3.4424999999999999;i:1576829409;d:3.4767999999999999;i:1576829109;d:3.294;i:1576828808;d:3.3334000000000001;i:1576828502;d:3.5948000000000002;i:1576828215;d:8.8567;}s:17:\"discovery_history\";a:2:{i:1576833026;d:17.7483;i:1576828201;d:25.0136;}s:18:\"discovery_mod_perf\";a:1:{s:7:\"sensors\";d:17.746400000000001;}}' WHERE `device_id` = '126'] SQL RUNTIME[0.00047708s] ##### kon-kes-smartpack [126] completed discovery modules at 2019-12-20 09:10:44 ##### o Discovery time 17.7483 seconds SQL[DELETE FROM `observium_processes` WHERE `process_pid` = '109229' AND `process_name` = 'discovery.php' AND `device_id` = '126'] SQL RUNTIME[0.00025916s] ##### Finished discovery run at 2019-12-20 09:10:44 ##### ./discovery.php: kon-kes-smartpack - 1 devices discovered in 18.30 secs SQL[SELECT * FROM `observium_processes` WHERE `process_start` < '1576818625'] SQL RUNTIME[0.00016499s] 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 18.30 secs o Memory usage 14MB (peak: 14MB) o MySQL Usage Cell[23/0.012s] Row[30/0.016s] Rows[38/0.018s] Column[1/0s] Update[7/0.003s] Insert[3/0.002s] Delete[1/0s] o RRDTool Usage [root@observium observium]#