DEBUG!

CMD[[0;33m/usr/bin/svn info /opt/observium[0m]
[0m
CMD EXITCODE[[0;32m0[0m]
CMD RUNTIME[[0;32m0.0219s[0m][0m
STDOUT[
Path: .
Working Copy Root Path: /opt/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: 9059
Node Kind: directory
Schedule: normal
Last Changed Author: adama
Last Changed Rev: 9059
Last Changed Date: 2018-02-14 18:23:55 +0000 (Wed, 14 Feb 2018)

][0m

SQL[[0;33mSELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'dbSchema';[0m][0m
SQL RUNTIME[[0;32m0.00025797s[0m][0m

SQL[[0;33mSELECT @@SESSION.sql_mode;[0m][0m
SQL RUNTIME[[0;32m0.00026917s[0m][0m

SQL[[0;33mSELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'current_rev';[0m][0m
SQL RUNTIME[[0;32m0.00022793s[0m][0m

SQL[[0;33mSELECT * FROM `config`[0m][0m
SQL RUNTIME[[0;32m0.00037408s[0m][0m

CMD[[0;33m/bin/hostname -f[0m]
[0m
CMD EXITCODE[[0;32m0[0m]
CMD RUNTIME[[0;32m0.0032s[0m][0m
STDOUT[
bsplin709.bsp.ox.ac.uk
][0m
[1;37m
  ___   _                              _
 / _ \ | |__   ___   ___  _ __ __   __(_) _   _  _ __ ___
| | | || '_ \ / __| / _ \| '__|\ \ / /| || | | || '_ ` _ \
| |_| || |_) |\__ \|  __/| |    \ V / | || |_| || | | | | |
 \___/ |_.__/ |___/ \___||_|     \_/  |_| \__,_||_| |_| |_|[0;36m
                           Observium Professional 18.2.9059
                                   http://www.observium.org[0m
[0m

CMD[[0;33m/opt/observium/scripts/distro[0m]
[0m
CMD EXITCODE[[0;32m0[0m]
CMD RUNTIME[[0;32m0.0583s[0m][0m
STDOUT[
Linux|3.16.0-5-amd64|amd64|Debian|8.10|vmware
][0m

CMD[[0;33m/usr/bin/env python --version 2>&1[0m]
[0m
CMD EXITCODE[[0;32m0[0m]
CMD RUNTIME[[0;32m0.0038s[0m][0m
STDOUT[
Python 2.7.9
][0m

SQL[[0;33mSELECT version();[0m][0m
SQL RUNTIME[[0;32m0.00054216s[0m][0m

CMD[[0;33m/usr/bin/snmpget --version 2>&1[0m]
[0m
CMD EXITCODE[[0;32m0[0m]
CMD RUNTIME[[0;32m0.004s[0m][0m
STDOUT[
NET-SNMP version: 5.7.2.1
][0m

CMD[[0;33m/usr/bin/rrdtool --version | head -n1[0m]
[0m
CMD EXITCODE[[0;32m0[0m]
CMD RUNTIME[[0;32m0.0084s[0m][0m
STDOUT[
RRDtool 1.4.8  Copyright 1997-2013 by Tobias Oetiker <tobi@oetiker.ch>
][0m

CMD[[0;33m/usr/bin/rrdcached -h | head -n1[0m]
[0m
CMD EXITCODE[[0;32m0[0m]
CMD RUNTIME[[0;32m0.01s[0m][0m
STDOUT[
RRDCacheD 1.4.8
][0m

CMD[[0;33m/usr/sbin/apache2 -v | awk '/Server version:/ {print $3}'[0m]
[0m
CMD EXITCODE[[0;32m0[0m]
CMD RUNTIME[[0;32m0.0619s[0m][0m
STDOUT[
Apache/2.4.23
][0m

CMD[[0;33mdate "+%:z"[0m]
[0m
CMD EXITCODE[[0;32m0[0m]
CMD RUNTIME[[0;32m0.0023s[0m][0m
STDOUT[
+00:00
][0m

SQL[[0;33mSELECT TIMEDIFF(NOW(), UTC_TIMESTAMP);[0m][0m
SQL RUNTIME[[0;32m0.00056386s[0m][0m

SQL[[0;33mSELECT @@SESSION.sql_mode;[0m][0m
SQL RUNTIME[[0;32m0.00025797s[0m][0m

SQL[[0;33mSHOW VARIABLES LIKE 'character_set_connection'[0m][0m
SQL RUNTIME[[0;32m0.00077701s[0m][0m

[0;36m#####  [1;37mSoftware versions[0;36m  #####[0m
[0m
[0;36m o [1;37mOS                  [0m Linux 3.16.0-5-amd64 [amd64] (Debian 8.10)
[0;36m o [1;37mApache              [0m 2.4.23
[0;36m o [1;37mPHP                 [0m 7.0.16-1~dotdeb+8.1 (OPcache: ENABLED)
[0;36m o [1;37mPython              [0m 2.7.9
[0;36m o [1;37mMySQL               [0m 10.1.26-MariaDB-0+deb9u1 (extension: mysqli 5.0.12-dev)
[0;36m o [1;37mSNMP                [0m NET-SNMP 5.7.2.1
[0;36m o [1;37mRRDtool             [0m 1.4.8 (rrdcached 1.4.8: unix:/var/run/rrdcached.sock)

[0;35m#####  [1;37mMemory Limit[0;35m  #####[0m
[0m
[0;35m o [1;37mPHP                 [0m Unlimited

[0;35m#####  [1;37mMySQL mode[0;35m  #####[0m
[0m
[0;35m o [1;37mMySQL               [0m NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

[0;35m#####  [1;37mCharset info[0;35m  #####[0m
[0m
[0;35m o [1;37mPHP                 [0m UTF-8
[0;35m o [1;37mMySQL               [0m utf8

[0;35m#####  [1;37mTimezones info[0;35m  #####[0m
[0m
[0;35m o [1;37mDate                [0m Wednesday, 14-Feb-18 19:04:52 GMT
[0;35m o [1;37mPHP                 [0m +00:00
[0;35m o [1;37mMySQL               [0m +00:00


SQL[[0;33mSELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'last_versioncheck';[0m][0m
SQL RUNTIME[[0;32m0.00024605s[0m][0m

SQL[[0;33mSELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'latest_rev';[0m][0m
SQL RUNTIME[[0;32m0.00022292s[0m][0m
[1;37m#####  [1;37m[1;37mStarting discovery run at 2018-02-14 19:04:52[1;37m  #####[0m
[0m

SQL[[0;33mSELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` LIKE 'bspups02' AND `status` = '1' ORDER BY `last_discovered_timetaken` ASC[0m][0m
SQL RUNTIME[[0;32m0.00084186s[0m][0m

CMD[[0;33m/usr/bin/snmpget -t '3' -r '5' -v2c -c *** -Pu -OQUst -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'bspups02':'161' sysObjectID.0 sysUpTime.0[0m]
[0m
CMD EXITCODE[[0;32m0[0m]
CMD RUNTIME[[0;32m0.0178s[0m][0m
STDOUT[
sysObjectID.0 = enterprises.705.1
sysUpTime.0 = 2846546233
][0m
SNMP STATUS[[0;32mTRUE[0m][0m

SQL[[0;33mSELECT * FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '72'[0m][0m
SQL RUNTIME[[0;32m0.00036812s[0m][0m

SQL[[0;33mSELECT * FROM `observium_processes` WHERE `process_name` = 'discovery.php' AND `device_id` = '72'[0m][0m
SQL RUNTIME[[0;32m0.00049996s[0m][0m

CMD[[0;33m/bin/ps -ww -o pid,ppid,uid,gid,tty,stat,time,lstart,args -p 24042[0m]
[0m
CMD EXITCODE[[0;32m0[0m]
CMD RUNTIME[[0;32m0.0248s[0m][0m
STDOUT[
  PID  PPID   UID   GID TT       STAT     TIME                  STARTED COMMAND
24042 31320     0     0 pts/0    S+   00:00:00 Wed Feb 14 19:04:51 2018 php ./discovery.php -h bspups02 -m sensors -d
][0m

SQL[[0;33mINSERT INTO `observium_processes` (`process_pid`,`process_name`,`process_ppid`,`process_uid`,`process_command`,`process_start`,`device_id`)  VALUES ('24042','discovery.php','31320','0','php ./discovery.php -h bspups02 -m sensors -d','1518635091','72')[0m][0m
SQL RUNTIME[[0;32m0.00148582s[0m][0m
[0;32m#####  [1;37mbspups02 [72][0;32m  #####[0m
[0m
[0;32m o [1;37mOS Type             [0m mgeups
[0;32m o [1;37mOS Group            [0m ups
[0;32m o [1;37mSNMP Version        [0m v2c
[0;32m o [1;37mLast discovery      [0m 2018-02-14 19:03:52
[0;32m o [1;37mLast duration       [0m 0.74 seconds

[0;36m#####  [1;37mModule Start: [1;31msensors[0;36m  #####[0m
[0m

SQL[[0;33mSELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '72' AND `attrib_type` = 'sysORID'[0m][0m
SQL RUNTIME[[0;32m0.00027514s[0m][0m

SQL[[0;33mSELECT * FROM `observium_attribs`[0m][0m
SQL RUNTIME[[0;32m0.00027895s[0m][0m
[0;36m o [1;37mMG-SNMP-UPS-MIB     [0m 
CMD[[0;33m/usr/bin/snmpbulkwalk -t '3' -r '5' -v2c -c *** -Pu -OQUs -m MG-SNMP-UPS-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/eaton 'udp':'bspups02':'161' upsmgInputPhaseTable[0m]
[0m
CMD EXITCODE[[0;32m0[0m]
CMD RUNTIME[[0;32m0.0446s[0m][0m
STDOUT[
mginputVoltage.1.0 = 2350
mginputVoltage.2.0 = 0
mginputVoltage.3.0 = 0
mginputFrequency.1.0 = 500
mginputFrequency.2.0 = 0
mginputFrequency.3.0 = 0
mginputMinimumVoltage.0 = 500
mginputMaximumVoltage.0 = 0
mginputCurrent.1.0 = 9
mginputCurrent.2.0 = 0
mginputCurrent.3.0 = 0
][0m
SNMP STATUS[[0;32mTRUE[0m][0m

CMD[[0;33m/usr/bin/snmpget -t '3' -r '5' -v2c -c *** -Pu -Oqv -m MG-SNMP-UPS-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/eaton 'udp':'bspups02':'161' upsmgInputPhaseNum.0[0m]
[0m
CMD EXITCODE[[0;32m0[0m]
CMD RUNTIME[[0;32m0.0218s[0m][0m
STDOUT[
1
][0m
SNMP STATUS[[0;32mTRUE[0m][0m
Discover sensor: voltage, bspups02, .1.3.6.1.4.1.705.1.6.2.1.2.1.0, 101, mge-ups, Input, SCALE: 0.1, LIMITS: (, , , ), CURRENT: 235, snmp, , 

SQL[[0;33mSELECT COUNT(`sensor_id`) FROM `sensors`[0m
[0;33m                   WHERE `poller_type`= 'snmp' AND `sensor_class` = 'voltage' AND `device_id` = '72' AND `sensor_type` = 'mge-ups' AND `sensor_index` = '101'[0m][0m
SQL RUNTIME[[0;32m0.00034404s[0m][0m

SQL[[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'voltage' AND `device_id` = '72' AND `sensor_type` = 'mge-ups' AND `sensor_index` = '101'[0m][0m
SQL RUNTIME[[0;32m0.00028181s[0m][0m

SQL[[0;33mSELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'sensor' AND `entity_id` = '3856' AND `attrib_type` = 'sensor_addition'[0m][0m
SQL RUNTIME[[0;32m0.00020909s[0m][0m
.Discover sensor: current, bspups02, .1.3.6.1.4.1.705.1.6.2.1.6.1.0, 101, mge-ups, Input, SCALE: 0.1, LIMITS: (, , , ), CURRENT: 0.9, snmp, , 

SQL[[0;33mSELECT COUNT(`sensor_id`) FROM `sensors`[0m
[0;33m                   WHERE `poller_type`= 'snmp' AND `sensor_class` = 'current' AND `device_id` = '72' AND `sensor_type` = 'mge-ups' AND `sensor_index` = '101'[0m][0m
SQL RUNTIME[[0;32m0.00021505s[0m][0m

SQL[[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'current' AND `device_id` = '72' AND `sensor_type` = 'mge-ups' AND `sensor_index` = '101'[0m][0m
SQL RUNTIME[[0;32m0.00025296s[0m][0m

SQL[[0;33mSELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'sensor' AND `entity_id` = '30227' AND `attrib_type` = 'sensor_addition'[0m][0m
SQL RUNTIME[[0;32m0.00023007s[0m][0m
.Discover sensor: frequency, bspups02, .1.3.6.1.4.1.705.1.6.2.1.3.1.0, 101, mge-ups, Input, SCALE: 0.1, LIMITS: (, , , ), CURRENT: 50, snmp, , 

SQL[[0;33mSELECT COUNT(`sensor_id`) FROM `sensors`[0m
[0;33m                   WHERE `poller_type`= 'snmp' AND `sensor_class` = 'frequency' AND `device_id` = '72' AND `sensor_type` = 'mge-ups' AND `sensor_index` = '101'[0m][0m
SQL RUNTIME[[0;32m0.00021791s[0m][0m

SQL[[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'frequency' AND `device_id` = '72' AND `sensor_type` = 'mge-ups' AND `sensor_index` = '101'[0m][0m
SQL RUNTIME[[0;32m0.00025892s[0m][0m

SQL[[0;33mSELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'sensor' AND `entity_id` = '3858' AND `attrib_type` = 'sensor_addition'[0m][0m
SQL RUNTIME[[0;32m0.00022197s[0m][0m
.
CMD[[0;33m/usr/bin/snmpbulkwalk -t '3' -r '5' -v2c -c *** -Pu -OQUs -m MG-SNMP-UPS-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/eaton 'udp':'bspups02':'161' upsmgOutput[0m]
[0m
CMD EXITCODE[[0;32m0[0m]
CMD RUNTIME[[0;32m0.0558s[0m][0m
STDOUT[
upsmgOutputPhaseNum.0 = 1
mgoutputPhaseIndex.1 = 1
mgoutputPhaseIndex.2 = 2
mgoutputPhaseIndex.3 = 3
mgoutputVoltage.1 = 2390
mgoutputVoltage.2 = 2390
mgoutputVoltage.3 = 2390
mgoutputFrequency.1 = 500
mgoutputFrequency.2 = 500
mgoutputFrequency.3 = 500
mgoutputLoadPerPhase.1 = 52
mgoutputLoadPerPhase.2 = 52
mgoutputLoadPerPhase.3 = 52
mgoutputCurrent.1 = 90
mgoutputCurrent.2 = 90
mgoutputCurrent.3 = 90
upsmgOutputOnBattery.0 = no
upsmgOutputOnByPass.0 = no
upsmgOutputUtilityOff.0 = no
upsmgOutputInverterOff.0 = no
upsmgOutputOverLoad.0 = no
upsmgOutputOverTemp.0 = no
][0m
SNMP STATUS[[0;32mTRUE[0m][0m
Discover status: bspups02, .1.3.6.1.4.1.705.1.7.3.0, upsmgOutputOnBattery.0, mge-status-state, On Battery, 2, snmp, , battery

SQL[[0;33mSELECT COUNT(*) FROM `status` WHERE `device_id` = '72' AND `status_type` = 'mge-status-state' AND `status_index` = 'upsmgOutputOnBattery.0' AND `poller_type`= 'snmp'[0m][0m
SQL RUNTIME[[0;32m0.00034022s[0m][0m

SQL[[0;33mSELECT * FROM `status` WHERE `device_id` = '72' AND `status_type` = 'mge-status-state' AND `status_index` = 'upsmgOutputOnBattery.0' AND `poller_type`= 'snmp'[0m][0m
SQL RUNTIME[[0;32m0.00028610s[0m][0m
.Discover status: bspups02, .1.3.6.1.4.1.705.1.7.4.0, upsmgOutputOnByPass.0, mge-status-state, On Bypass, 2, snmp, , battery

SQL[[0;33mSELECT COUNT(*) FROM `status` WHERE `device_id` = '72' AND `status_type` = 'mge-status-state' AND `status_index` = 'upsmgOutputOnByPass.0' AND `poller_type`= 'snmp'[0m][0m
SQL RUNTIME[[0;32m0.00018787s[0m][0m

SQL[[0;33mSELECT * FROM `status` WHERE `device_id` = '72' AND `status_type` = 'mge-status-state' AND `status_index` = 'upsmgOutputOnByPass.0' AND `poller_type`= 'snmp'[0m][0m
SQL RUNTIME[[0;32m0.00025797s[0m][0m
.Discover status: bspups02, .1.3.6.1.4.1.705.1.7.7.0, upsmgOutputUtilityOff.0, mge-status-state, Utility Off, 2, snmp, , other

SQL[[0;33mSELECT COUNT(*) FROM `status` WHERE `device_id` = '72' AND `status_type` = 'mge-status-state' AND `status_index` = 'upsmgOutputUtilityOff.0' AND `poller_type`= 'snmp'[0m][0m
SQL RUNTIME[[0;32m0.00019217s[0m][0m

SQL[[0;33mSELECT * FROM `status` WHERE `device_id` = '72' AND `status_type` = 'mge-status-state' AND `status_index` = 'upsmgOutputUtilityOff.0' AND `poller_type`= 'snmp'[0m][0m
SQL RUNTIME[[0;32m0.00027394s[0m][0m
.
CMD[[0;33m/usr/bin/snmpget -t '3' -r '5' -v2c -c *** -Pu -Oqv -m MG-SNMP-UPS-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/eaton 'udp':'bspups02':'161' upsmgIdentFamilyName.0[0m]
[0m
CMD EXITCODE[[0;32m0[0m]
CMD RUNTIME[[0;32m0.0208s[0m][0m
STDOUT[
"9135"
][0m
SNMP STATUS[[0;32mTRUE[0m][0m
Discover status: bspups02, .1.3.6.1.4.1.705.1.7.9.0, upsmgOutputInverterOff.0, mge-status-inverter, Inverter Off, 2, snmp, , other

SQL[[0;33mSELECT COUNT(*) FROM `status` WHERE `device_id` = '72' AND `status_type` = 'mge-status-inverter' AND `status_index` = 'upsmgOutputInverterOff.0' AND `poller_type`= 'snmp'[0m][0m
SQL RUNTIME[[0;32m0.00028300s[0m][0m

SQL[[0;33mSELECT * FROM `status` WHERE `device_id` = '72' AND `status_type` = 'mge-status-inverter' AND `status_index` = 'upsmgOutputInverterOff.0' AND `poller_type`= 'snmp'[0m][0m
SQL RUNTIME[[0;32m0.00026488s[0m][0m
.Discover status: bspups02, .1.3.6.1.4.1.705.1.7.10.0, upsmgOutputOverLoad.0, mge-status-state, Over Load, 2, snmp, , other

SQL[[0;33mSELECT COUNT(*) FROM `status` WHERE `device_id` = '72' AND `status_type` = 'mge-status-state' AND `status_index` = 'upsmgOutputOverLoad.0' AND `poller_type`= 'snmp'[0m][0m
SQL RUNTIME[[0;32m0.00021911s[0m][0m

SQL[[0;33mSELECT * FROM `status` WHERE `device_id` = '72' AND `status_type` = 'mge-status-state' AND `status_index` = 'upsmgOutputOverLoad.0' AND `poller_type`= 'snmp'[0m][0m
SQL RUNTIME[[0;32m0.00027108s[0m][0m
.Discover status: bspups02, .1.3.6.1.4.1.705.1.7.11.0, upsmgOutputOverTemp.0, mge-status-state, Over Temperature, 2, snmp, , other

SQL[[0;33mSELECT COUNT(*) FROM `status` WHERE `device_id` = '72' AND `status_type` = 'mge-status-state' AND `status_index` = 'upsmgOutputOverTemp.0' AND `poller_type`= 'snmp'[0m][0m
SQL RUNTIME[[0;32m0.00024796s[0m][0m

SQL[[0;33mSELECT * FROM `status` WHERE `device_id` = '72' AND `status_type` = 'mge-status-state' AND `status_index` = 'upsmgOutputOverTemp.0' AND `poller_type`= 'snmp'[0m][0m
SQL RUNTIME[[0;32m0.00023293s[0m][0m
.
CMD[[0;33m/usr/bin/snmpbulkwalk -t '3' -r '5' -v2c -c *** -Pu -OQUs -m MG-SNMP-UPS-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/eaton 'udp':'bspups02':'161' upsmgOutputPhaseTable[0m]
[0m
CMD EXITCODE[[0;32m0[0m]
CMD RUNTIME[[0;32m0.0433s[0m][0m
STDOUT[
mgoutputPhaseIndex.1 = 1
mgoutputPhaseIndex.2 = 2
mgoutputPhaseIndex.3 = 3
mgoutputVoltage.1 = 2390
mgoutputVoltage.2 = 2390
mgoutputVoltage.3 = 2390
mgoutputFrequency.1 = 500
mgoutputFrequency.2 = 500
mgoutputFrequency.3 = 500
mgoutputLoadPerPhase.1 = 52
mgoutputLoadPerPhase.2 = 52
mgoutputLoadPerPhase.3 = 52
mgoutputCurrent.1 = 90
mgoutputCurrent.2 = 90
mgoutputCurrent.3 = 90
][0m
SNMP STATUS[[0;32mTRUE[0m][0m

CMD[[0;33m/usr/bin/snmpget -t '3' -r '5' -v2c -c *** -Pu -Oqv -m MG-SNMP-UPS-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/eaton 'udp':'bspups02':'161' upsmgOutputPhaseNum.0[0m]
[0m
CMD EXITCODE[[0;32m0[0m]
CMD RUNTIME[[0;32m0.0216s[0m][0m
STDOUT[
1
][0m
SNMP STATUS[[0;32mTRUE[0m][0m
Discover sensor: load, bspups02, .1.3.6.1.4.1.705.1.7.2.1.4.1, mgoutputLoadPerPhase.1, mge-ups, Output Load, SCALE: 1, LIMITS: (, , 70, 85), CURRENT: 52, snmp, , 

SQL[[0;33mSELECT COUNT(`sensor_id`) FROM `sensors`[0m
[0;33m                   WHERE `poller_type`= 'snmp' AND `sensor_class` = 'load' AND `device_id` = '72' AND `sensor_type` = 'mge-ups' AND `sensor_index` = 'mgoutputLoadPerPhase.1'[0m][0m
SQL RUNTIME[[0;32m0.00038004s[0m][0m

SQL[[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'load' AND `device_id` = '72' AND `sensor_type` = 'mge-ups' AND `sensor_index` = 'mgoutputLoadPerPhase.1'[0m][0m
SQL RUNTIME[[0;32m0.00031590s[0m][0m

SQL[[0;33mSELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'sensor' AND `entity_id` = '28704' AND `attrib_type` = 'sensor_addition'[0m][0m
SQL RUNTIME[[0;32m0.00022507s[0m][0m
.Discover sensor: voltage, bspups02, .1.3.6.1.4.1.705.1.7.2.1.2.1, 1, mge-ups, Output, SCALE: 0.1, LIMITS: (, , , ), CURRENT: 239, snmp, , 

SQL[[0;33mSELECT COUNT(`sensor_id`) FROM `sensors`[0m
[0;33m                   WHERE `poller_type`= 'snmp' AND `sensor_class` = 'voltage' AND `device_id` = '72' AND `sensor_type` = 'mge-ups' AND `sensor_index` = '1'[0m][0m
SQL RUNTIME[[0;32m0.00021195s[0m][0m

SQL[[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'voltage' AND `device_id` = '72' AND `sensor_type` = 'mge-ups' AND `sensor_index` = '1'[0m][0m
SQL RUNTIME[[0;32m0.00027299s[0m][0m

SQL[[0;33mSELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'sensor' AND `entity_id` = '3860' AND `attrib_type` = 'sensor_addition'[0m][0m
SQL RUNTIME[[0;32m0.00021410s[0m][0m
.Discover sensor: current, bspups02, .1.3.6.1.4.1.705.1.7.2.1.5.1, 1, mge-ups, Output, SCALE: 0.1, LIMITS: (, , , ), CURRENT: 9, snmp, , 

SQL[[0;33mSELECT COUNT(`sensor_id`) FROM `sensors`[0m
[0;33m                   WHERE `poller_type`= 'snmp' AND `sensor_class` = 'current' AND `device_id` = '72' AND `sensor_type` = 'mge-ups' AND `sensor_index` = '1'[0m][0m
SQL RUNTIME[[0;32m0.00020790s[0m][0m

SQL[[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'current' AND `device_id` = '72' AND `sensor_type` = 'mge-ups' AND `sensor_index` = '1'[0m][0m
SQL RUNTIME[[0;32m0.00025988s[0m][0m

SQL[[0;33mSELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'sensor' AND `entity_id` = '3861' AND `attrib_type` = 'sensor_addition'[0m][0m
SQL RUNTIME[[0;32m0.00021005s[0m][0m
.Discover sensor: frequency, bspups02, .1.3.6.1.4.1.705.1.7.2.1.3.1, 1, mge-ups, Output, SCALE: 0.1, LIMITS: (, , , ), CURRENT: 50, snmp, , 

SQL[[0;33mSELECT COUNT(`sensor_id`) FROM `sensors`[0m
[0;33m                   WHERE `poller_type`= 'snmp' AND `sensor_class` = 'frequency' AND `device_id` = '72' AND `sensor_type` = 'mge-ups' AND `sensor_index` = '1'[0m][0m
SQL RUNTIME[[0;32m0.00026107s[0m][0m

SQL[[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'frequency' AND `device_id` = '72' AND `sensor_type` = 'mge-ups' AND `sensor_index` = '1'[0m][0m
SQL RUNTIME[[0;32m0.00027609s[0m][0m

SQL[[0;33mSELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'sensor' AND `entity_id` = '3862' AND `attrib_type` = 'sensor_addition'[0m][0m
SQL RUNTIME[[0;32m0.00023794s[0m][0m
. upsmgBattery 
CMD[[0;33m/usr/bin/snmpbulkwalk -t '3' -r '5' -v2c -c *** -Pu -OQUsb -m MG-SNMP-UPS-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/eaton 'udp':'bspups02':'161' upsmgBattery[0m]
[0m
CMD EXITCODE[[0;32m0[0m]
CMD RUNTIME[[0;32m0.0264s[0m][0m
STDOUT[
upsmgBatteryRemainingTime.0 = 2331
upsmgBatteryLevel.0 = 100
upsmgBatteryVoltage.0 = 2080
upsmgBatteryCurrent.0 = 0
upsmgBatteryFaultBattery.0 = no
upsmgBatteryReplacement.0 = no
upsmgBatteryLowBattery.0 = no
upsmgBatteryChargerFault.0 = no
upsmgBatteryLowCondition.0 = no
][0m
SNMP STATUS[[0;32mTRUE[0m][0m
Discover sensor: voltage, bspups02, .1.3.6.1.4.1.705.1.5.5.0, upsmgBatteryVoltage.0, mge, Battery, SCALE: 0.1, LIMITS: (, , , ), CURRENT: 208, snmp, , 

SQL[[0;33mSELECT COUNT(`sensor_id`) FROM `sensors`[0m
[0;33m                   WHERE `poller_type`= 'snmp' AND `sensor_class` = 'voltage' AND `device_id` = '72' AND `sensor_type` = 'mge' AND `sensor_index` = 'upsmgBatteryVoltage.0'[0m][0m
SQL RUNTIME[[0;32m0.00040197s[0m][0m

SQL[[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'voltage' AND `device_id` = '72' AND `sensor_type` = 'mge' AND `sensor_index` = 'upsmgBatteryVoltage.0'[0m][0m
SQL RUNTIME[[0;32m0.00033188s[0m][0m

SQL[[0;33mSELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'sensor' AND `entity_id` = '3863' AND `attrib_type` = 'sensor_addition'[0m][0m
SQL RUNTIME[[0;32m0.00020409s[0m][0m
.
CMD[[0;33m/usr/bin/snmpget -t '3' -r '5' -v2c -c *** -Pu -Oqv -m MG-SNMP-UPS-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/eaton 'udp':'bspups02':'161' upsmgConfigLowBatteryLevel.0[0m]
[0m
CMD EXITCODE[[0;32m0[0m]
CMD RUNTIME[[0;32m0.0207s[0m][0m
STDOUT[
20
][0m
SNMP STATUS[[0;32mTRUE[0m][0m
Discover sensor: capacity, bspups02, .1.3.6.1.4.1.705.1.5.2.0, upsmgBatteryLevel.0, mge, Battery Capacity, SCALE: 1, LIMITS: (20, , , ), CURRENT: 100, snmp, , 

SQL[[0;33mSELECT COUNT(`sensor_id`) FROM `sensors`[0m
[0;33m                   WHERE `poller_type`= 'snmp' AND `sensor_class` = 'capacity' AND `device_id` = '72' AND `sensor_type` = 'mge' AND `sensor_index` = 'upsmgBatteryLevel.0'[0m][0m
SQL RUNTIME[[0;32m0.00039411s[0m][0m

SQL[[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'capacity' AND `device_id` = '72' AND `sensor_type` = 'mge' AND `sensor_index` = 'upsmgBatteryLevel.0'[0m][0m
SQL RUNTIME[[0;32m0.00028706s[0m][0m

SQL[[0;33mSELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'sensor' AND `entity_id` = '3865' AND `attrib_type` = 'sensor_addition'[0m][0m
SQL RUNTIME[[0;32m0.00023818s[0m][0m
.
CMD[[0;33m/usr/bin/snmpget -t '3' -r '5' -v2c -c *** -Pu -Oqv -m MG-SNMP-UPS-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/eaton 'udp':'bspups02':'161' upsmgConfigLowBatteryTime.0[0m]
[0m
CMD EXITCODE[[0;32m0[0m]
CMD RUNTIME[[0;32m0.0222s[0m][0m
STDOUT[
180
][0m
SNMP STATUS[[0;32mTRUE[0m][0m
Discover sensor: runtime, bspups02, .1.3.6.1.4.1.705.1.5.1.0, upsmgBatteryRemainingTime.0, mge, Battery Runtime Remaining, SCALE: 0.016666666666667, LIMITS: (, , , ), CURRENT: 38.85, snmp, , 

SQL[[0;33mSELECT COUNT(`sensor_id`) FROM `sensors`[0m
[0;33m                   WHERE `poller_type`= 'snmp' AND `sensor_class` = 'runtime' AND `device_id` = '72' AND `sensor_type` = 'mge' AND `sensor_index` = 'upsmgBatteryRemainingTime.0'[0m][0m
SQL RUNTIME[[0;32m0.00033903s[0m][0m

SQL[[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'runtime' AND `device_id` = '72' AND `sensor_type` = 'mge' AND `sensor_index` = 'upsmgBatteryRemainingTime.0'[0m][0m
SQL RUNTIME[[0;32m0.00031614s[0m][0m

SQL[[0;33mSELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'sensor' AND `entity_id` = '3866' AND `attrib_type` = 'sensor_addition'[0m][0m
SQL RUNTIME[[0;32m0.00021791s[0m][0m
.Discover status: bspups02, .1.3.6.1.4.1.705.1.5.9.0, upsmgBatteryFaultBattery.0, mge-status-state, Battery Fault, 2, snmp, , battery

SQL[[0;33mSELECT COUNT(*) FROM `status` WHERE `device_id` = '72' AND `status_type` = 'mge-status-state' AND `status_index` = 'upsmgBatteryFaultBattery.0' AND `poller_type`= 'snmp'[0m][0m
SQL RUNTIME[[0;32m0.00020909s[0m][0m

SQL[[0;33mSELECT * FROM `status` WHERE `device_id` = '72' AND `status_type` = 'mge-status-state' AND `status_index` = 'upsmgBatteryFaultBattery.0' AND `poller_type`= 'snmp'[0m][0m
SQL RUNTIME[[0;32m0.00025105s[0m][0m
.Redirecting call to discover_status().
Discover status: bspups02, .1.3.6.1.4.1.705.1.5.15.0, upsmgBatteryChargerFault.0, mge-status-state, Charger Fault, 2, snmp, , battery

SQL[[0;33mSELECT COUNT(*) FROM `status` WHERE `device_id` = '72' AND `status_type` = 'mge-status-state' AND `status_index` = 'upsmgBatteryChargerFault.0' AND `poller_type`= 'snmp'[0m][0m
SQL RUNTIME[[0;32m0.00021911s[0m][0m

SQL[[0;33mSELECT * FROM `status` WHERE `device_id` = '72' AND `status_type` = 'mge-status-state' AND `status_index` = 'upsmgBatteryChargerFault.0' AND `poller_type`= 'snmp'[0m][0m
SQL RUNTIME[[0;32m0.00026393s[0m][0m
.Redirecting call to discover_status().
Discover status: bspups02, .1.3.6.1.4.1.705.1.5.16.0, upsmgBatteryLowCondition.0, mge-status-state, Battery Low, 2, snmp, , battery

SQL[[0;33mSELECT COUNT(*) FROM `status` WHERE `device_id` = '72' AND `status_type` = 'mge-status-state' AND `status_index` = 'upsmgBatteryLowCondition.0' AND `poller_type`= 'snmp'[0m][0m
SQL RUNTIME[[0;32m0.00021005s[0m][0m

SQL[[0;33mSELECT * FROM `status` WHERE `device_id` = '72' AND `status_type` = 'mge-status-state' AND `status_index` = 'upsmgBatteryLowCondition.0' AND `poller_type`= 'snmp'[0m][0m
SQL RUNTIME[[0;32m0.00025415s[0m][0m
.Redirecting call to discover_status().
Discover status: bspups02, .1.3.6.1.4.1.705.1.5.11.0, upsmgBatteryReplacement.0, mge-status-state, Battery Replacement Needed, 2, snmp, , battery

SQL[[0;33mSELECT COUNT(*) FROM `status` WHERE `device_id` = '72' AND `status_type` = 'mge-status-state' AND `status_index` = 'upsmgBatteryReplacement.0' AND `poller_type`= 'snmp'[0m][0m
SQL RUNTIME[[0;32m0.00020504s[0m][0m

SQL[[0;33mSELECT * FROM `status` WHERE `device_id` = '72' AND `status_type` = 'mge-status-state' AND `status_index` = 'upsmgBatteryReplacement.0' AND `poller_type`= 'snmp'[0m][0m
SQL RUNTIME[[0;32m0.00025105s[0m][0m
. 
CMD[[0;33m/usr/bin/snmpbulkwalk -t '3' -r '5' -v2c -c *** -Pu -OQUsb -m MG-SNMP-UPS-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/eaton 'udp':'bspups02':'161' upsmgEnviron[0m]
[0m
CMD EXITCODE[[0;32m0[0m]
CMD RUNTIME[[0;32m0.0483s[0m][0m
STDOUT[
upsmgEnvironAmbientTemp.0 = 0
upsmgEnvironAmbientHumidity.0 = 0
upsmgEnvironmentNum.0 = 1
upsmgEnvironmentIndex.1 = 1
upsmgEnvironmentComFailure.1 = yes
upsmgEnvironmentTemperature.1 = 0
upsmgEnvironmentTemperatureLow.1 = no
upsmgEnvironmentTemperatureHigh.1 = no
upsmgEnvironmentHumidity.1 = 0
upsmgEnvironmentHumidityLow.1 = no
upsmgEnvironmentHumidityHigh.1 = no
upsmgEnvironmentInput1State.1 = open
upsmgEnvironmentInput2State.1 = open
][0m
SNMP STATUS[[0;32mTRUE[0m][0m
upsmgConfigEnvironmentTable 
CMD[[0;33m/usr/bin/snmpbulkwalk -t '3' -r '5' -v2c -c *** -Pu -OQUsb -m MG-SNMP-UPS-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/eaton 'udp':'bspups02':'161' upsmgConfigEnvironmentTable[0m]
[0m
CMD EXITCODE[[0;32m0[0m]
CMD RUNTIME[[0;32m0.047s[0m][0m
STDOUT[
upsmgConfigSensorIndex.1 = 1
upsmgConfigSensorName.1 = "Environment sensor"
upsmgConfigTemperatureLow.1 = 5
upsmgConfigTemperatureHigh.1 = 40
upsmgConfigTemperatureHysteresis.1 = 2
upsmgConfigHumidityLow.1 = 5
upsmgConfigHumidityHigh.1 = 90
upsmgConfigHumidityHysteresis.1 = 5
upsmgConfigInput1Name.1 = "Input #1"
upsmgConfigInput1ClosedLabel.1 = "closed"
upsmgConfigInput1OpenLabel.1 = "open"
upsmgConfigInput2Name.1 = "Input #2"
upsmgConfigInput2ClosedLabel.1 = "closed"
upsmgConfigInput2OpenLabel.1 = "open"
][0m
SNMP STATUS[[0;32mTRUE[0m][0m
upsmgEnvironmentSensorTable 
CMD[[0;33m/usr/bin/snmpbulkwalk -t '3' -r '5' -v2c -c *** -Pu -OQUsb -m MG-SNMP-UPS-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/eaton 'udp':'bspups02':'161' upsmgEnvironmentSensorTable[0m]
[0m
CMD EXITCODE[[0;32m0[0m]
CMD RUNTIME[[0;32m0.0484s[0m][0m
STDOUT[
upsmgEnvironmentIndex.1 = 1
upsmgEnvironmentComFailure.1 = yes
upsmgEnvironmentTemperature.1 = 0
upsmgEnvironmentTemperatureLow.1 = no
upsmgEnvironmentTemperatureHigh.1 = no
upsmgEnvironmentHumidity.1 = 0
upsmgEnvironmentHumidityLow.1 = no
upsmgEnvironmentHumidityHigh.1 = no
upsmgEnvironmentInput1State.1 = open
upsmgEnvironmentInput2State.1 = open
][0m
SNMP STATUS[[0;32mTRUE[0m][0m

[0;36m o [1;37mXUPS-MIB            [0m 
CMD[[0;33m/usr/bin/snmpbulkwalk -t '3' -r '5' -v2c -c *** -Pu -OQUs -m XUPS-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/eaton 'udp':'bspups02':'161' xupsInput[0m]
[0m
CMD EXITCODE[[0;32m0[0m]
CMD RUNTIME[[0;32m0.0289s[0m][0m
STDOUT[
xupsInput = No Such Object available on this agent at this OID
][0m
SNMP STATUS[[0;31mFALSE[0m][0m
SNMP ERROR[[0;31m#1000 - Failed response[0m][0m

CMD[[0;33m/usr/bin/snmpbulkwalk -t '3' -r '5' -v2c -c *** -Pu -OQUs -m XUPS-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/eaton 'udp':'bspups02':'161' xupsOutput[0m]
[0m
CMD EXITCODE[[0;32m0[0m]
CMD RUNTIME[[0;32m0.0298s[0m][0m
STDOUT[
xupsOutput = No Such Object available on this agent at this OID
][0m
SNMP STATUS[[0;31mFALSE[0m][0m
SNMP ERROR[[0;31m#1000 - Failed response[0m][0m

CMD[[0;33m/usr/bin/snmpbulkwalk -t '3' -r '5' -v2c -c *** -Pu -OQUs -m XUPS-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/eaton 'udp':'bspups02':'161' xupsBypass[0m]
[0m
CMD EXITCODE[[0;32m0[0m]
CMD RUNTIME[[0;32m0.0306s[0m][0m
STDOUT[
xupsBypass = No Such Object available on this agent at this OID
][0m
SNMP STATUS[[0;31mFALSE[0m][0m
SNMP ERROR[[0;31m#1000 - Failed response[0m][0m
Skipped by unknown state value: , Input Source 
Skipped by unknown state value: , Output Source 

CMD[[0;33m/usr/bin/snmpbulkwalk -t '3' -r '5' -v2c -c *** -Pu -OQUs -m XUPS-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/eaton 'udp':'bspups02':'161' xupsBattery[0m]
[0m
CMD EXITCODE[[0;32m0[0m]
CMD RUNTIME[[0;32m0.0296s[0m][0m
STDOUT[
xupsBattery = No Such Object available on this agent at this OID
][0m
SNMP STATUS[[0;31mFALSE[0m][0m
SNMP ERROR[[0;31m#1000 - Failed response[0m][0m

CMD[[0;33m/usr/bin/snmpbulkwalk -t '3' -r '5' -v2c -c *** -Pu -OQUs -m XUPS-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/eaton 'udp':'bspups02':'161' xupsEnvironment[0m]
[0m
CMD EXITCODE[[0;32m0[0m]
CMD RUNTIME[[0;32m0.0307s[0m][0m
STDOUT[
xupsEnvironment = No Such Object available on this agent at this OID
][0m
SNMP STATUS[[0;31mFALSE[0m][0m
SNMP ERROR[[0;31m#1000 - Failed response[0m][0m
Skipped by unknown state value: , Battery Status 

[0;36m o [1;37mENTITY-SENSOR-MIB   [0m 
CMD[[0;33m/usr/bin/snmpbulkwalk -t '3' -r '5' -v2c -c *** -Pu -OQUs -m ENTITY-MIB:ENTITY-SENSOR-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'bspups02':'161' entPhySensorValue[0m]
[0m
CMD EXITCODE[[0;32m0[0m]
CMD RUNTIME[[0;32m0.0284s[0m][0m
STDOUT[
entPhySensorValue = No Such Object available on this agent at this OID
][0m
SNMP STATUS[[0;31mFALSE[0m][0m
SNMP ERROR[[0;31m#1000 - Failed response[0m][0m


SQL[[0;33mSELECT * FROM `sensors` WHERE `device_id` = '72' AND `sensor_class` = 'temperature' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'[0m][0m
SQL RUNTIME[[0;32m0.00045395s[0m][0m

SQL[[0;33mSELECT * FROM `sensors` WHERE `device_id` = '72' AND `sensor_class` = 'humidity' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'[0m][0m
SQL RUNTIME[[0;32m0.00026917s[0m][0m

SQL[[0;33mSELECT * FROM `sensors` WHERE `device_id` = '72' AND `sensor_class` = 'fanspeed' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'[0m][0m
SQL RUNTIME[[0;32m0.00030303s[0m][0m

SQL[[0;33mSELECT * FROM `sensors` WHERE `device_id` = '72' AND `sensor_class` = 'dewpoint' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'[0m][0m
SQL RUNTIME[[0;32m0.00025916s[0m][0m

SQL[[0;33mSELECT * FROM `sensors` WHERE `device_id` = '72' AND `sensor_class` = 'airflow' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'[0m][0m
SQL RUNTIME[[0;32m0.00024295s[0m][0m

SQL[[0;33mSELECT * FROM `sensors` WHERE `device_id` = '72' AND `sensor_class` = 'voltage' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'[0m][0m
SQL RUNTIME[[0;32m0.00025582s[0m][0m

SQL[[0;33mSELECT * FROM `sensors` WHERE `device_id` = '72' AND `sensor_class` = 'current' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'[0m][0m
SQL RUNTIME[[0;32m0.00026488s[0m][0m

SQL[[0;33mSELECT * FROM `sensors` WHERE `device_id` = '72' AND `sensor_class` = 'power' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'[0m][0m
SQL RUNTIME[[0;32m0.00025105s[0m][0m

SQL[[0;33mSELECT * FROM `sensors` WHERE `device_id` = '72' AND `sensor_class` = 'apower' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'[0m][0m
SQL RUNTIME[[0;32m0.00028396s[0m][0m

SQL[[0;33mSELECT * FROM `sensors` WHERE `device_id` = '72' AND `sensor_class` = 'rpower' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'[0m][0m
SQL RUNTIME[[0;32m0.00025105s[0m][0m

SQL[[0;33mSELECT * FROM `sensors` WHERE `device_id` = '72' AND `sensor_class` = 'crestfactor' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'[0m][0m
SQL RUNTIME[[0;32m0.00024199s[0m][0m

SQL[[0;33mSELECT * FROM `sensors` WHERE `device_id` = '72' AND `sensor_class` = 'powerfactor' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'[0m][0m
SQL RUNTIME[[0;32m0.00024819s[0m][0m

SQL[[0;33mSELECT * FROM `sensors` WHERE `device_id` = '72' AND `sensor_class` = 'impedance' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'[0m][0m
SQL RUNTIME[[0;32m0.00025606s[0m][0m

SQL[[0;33mSELECT * FROM `sensors` WHERE `device_id` = '72' AND `sensor_class` = 'resistance' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'[0m][0m
SQL RUNTIME[[0;32m0.00026178s[0m][0m

SQL[[0;33mSELECT * FROM `sensors` WHERE `device_id` = '72' AND `sensor_class` = 'frequency' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'[0m][0m
SQL RUNTIME[[0;32m0.00027204s[0m][0m

SQL[[0;33mSELECT * FROM `sensors` WHERE `device_id` = '72' AND `sensor_class` = 'dbm' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'[0m][0m
SQL RUNTIME[[0;32m0.00025392s[0m][0m

SQL[[0;33mSELECT * FROM `sensors` WHERE `device_id` = '72' AND `sensor_class` = 'snr' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'[0m][0m
SQL RUNTIME[[0;32m0.00026798s[0m][0m

SQL[[0;33mSELECT * FROM `sensors` WHERE `device_id` = '72' AND `sensor_class` = 'dust' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'[0m][0m
SQL RUNTIME[[0;32m0.00026417s[0m][0m

SQL[[0;33mSELECT * FROM `sensors` WHERE `device_id` = '72' AND `sensor_class` = 'sound' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'[0m][0m
SQL RUNTIME[[0;32m0.00024199s[0m][0m

SQL[[0;33mSELECT * FROM `sensors` WHERE `device_id` = '72' AND `sensor_class` = 'capacity' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'[0m][0m
SQL RUNTIME[[0;32m0.00026393s[0m][0m

SQL[[0;33mSELECT * FROM `sensors` WHERE `device_id` = '72' AND `sensor_class` = 'load' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'[0m][0m
SQL RUNTIME[[0;32m0.00026608s[0m][0m

SQL[[0;33mSELECT * FROM `sensors` WHERE `device_id` = '72' AND `sensor_class` = 'runtime' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'[0m][0m
SQL RUNTIME[[0;32m0.00024509s[0m][0m

SQL[[0;33mSELECT * FROM `sensors` WHERE `device_id` = '72' AND `sensor_class` = 'volume' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'[0m][0m
SQL RUNTIME[[0;32m0.00024915s[0m][0m

SQL[[0;33mSELECT * FROM `sensors` WHERE `device_id` = '72' AND `sensor_class` = 'waterflow' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'[0m][0m
SQL RUNTIME[[0;32m0.00024104s[0m][0m

SQL[[0;33mSELECT * FROM `sensors` WHERE `device_id` = '72' AND `sensor_class` = 'pressure' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'[0m][0m
SQL RUNTIME[[0;32m0.00025082s[0m][0m

SQL[[0;33mSELECT * FROM `sensors` WHERE `device_id` = '72' AND `sensor_class` = 'velocity' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'[0m][0m
SQL RUNTIME[[0;32m0.00026989s[0m][0m

SQL[[0;33mSELECT * FROM `sensors` WHERE `device_id` = '72' AND `sensor_class` = 'illuminance' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'[0m][0m
SQL RUNTIME[[0;32m0.00026917s[0m][0m

SQL[[0;33mSELECT * FROM `sensors` WHERE `device_id` = '72' AND `sensor_class` = 'counter' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'[0m][0m
SQL RUNTIME[[0;32m0.00025010s[0m][0m

SQL[[0;33mSELECT * FROM `status` WHERE `device_id` = '72' AND `poller_type` = 'snmp' AND `status_deleted` = '0'[0m][0m
SQL RUNTIME[[0;32m0.00026798s[0m][0m


[0;36m o [1;37mDuration            [0m 0.6824s


SQL[[0;33mUPDATE `devices` set `last_discovered` =NOW(),`type` ='power',`last_discovered_timetaken` ='0.7129',`force_discovery` ='0' WHERE `device_id` = '72'[0m][0m
SQL RUNTIME[[0;32m0.00164986s[0m][0m
[0;32m#####  [1;37mbspups02 [72] completed discovery modules at 2018-02-14 19:04:53[0;32m  #####[0m
[0m
[0;32m o [1;37mDiscovery time      [0m 0.7129 seconds


SQL[[0;33mDELETE FROM `observium_processes` WHERE `process_pid` = '24042' AND `process_name` = 'discovery.php' AND `device_id` = '72'[0m][0m
SQL RUNTIME[[0;32m0.00120115s[0m][0m
[1;37m#####  [1;37m[1;37mFinished discovery run at 2018-02-14 19:04:53[1;37m  #####[0m
[0m
./discovery.php: bspups02 - 1 devices discovered in 0.907 secs

SQL[[0;33mSELECT * FROM `observium_processes` WHERE `process_start` < '1518620692'[0m][0m
SQL RUNTIME[[0;32m0.00035882s[0m][0m
NOTE, $config['snmp']['hide_auth'] is set to TRUE, snmp community and snmp v3 auth hidden from debug output.
[1;37m o [1;37mDevices Discovered  [0m 1
[1;37m o [1;37mDiscovery Time      [0m 0.907 secs
[1;37m o [1;37mMemory usage        [0m 8MB (peak: 12MB)
[1;37m o [1;37mMySQL Usage         [0m Cell[24/0.012s] Row[35/0.016s] Rows[36/0.018s] Column[0/0s] Update[1/0.002s] Insert[1/0.002s] Delete[1/0.001s] 
[1;37m o [1;37mRRDTool Usage       [0m