DEBUG! SQL[[0;33mSELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'dbSchema';[0m][0m SQL RUNTIME[[0;32m0.00007606s[0m][0m SQL[[0;33mSELECT @@SESSION.sql_mode;[0m][0m SQL RUNTIME[[0;32m0.00008106s[0m][0m SQL[[0;33mSELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'current_rev';[0m][0m SQL RUNTIME[[0;32m0.00005388s[0m][0m SQL[[0;33mSELECT * FROM `config`[0m][0m SQL RUNTIME[[0;32m0.00005293s[0m][0m CMD[[0;33m/bin/hostname -f[0m] [0m CMD EXITCODE[[0;32m0[0m] CMD RUNTIME[[0;32m0.0032s[0m][0m STDOUT[ observium.partnersandsimons.com ][0m [1;37m ___ _ _ / _ \ | |__ ___ ___ _ __ __ __(_) _ _ _ __ ___ | | | || '_ \ / __| / _ \| '__|\ \ / /| || | | || '_ ` _ \ | |_| || |_) |\__ \| __/| | \ V / | || |_| || | | | | | \___/ |_.__/ |___/ \___||_| \_/ |_| \__,_||_| |_| |_|[0;36m Observium Professional 0.16.4.7767 http://www.observium.org[0m [0m SQL[[0;33mSELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'latest_ver';[0m][0m SQL RUNTIME[[0;32m0.00012898s[0m][0m SQL[[0;33mSELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'latest_rev';[0m][0m SQL RUNTIME[[0;32m0.00005698s[0m][0m SQL[[0;33mSELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'latest_rev_date';[0m][0m SQL RUNTIME[[0;32m0.00005698s[0m][0m CMD[[0;33m/opt/observium/scripts/distro[0m] [0m CMD EXITCODE[[0;32m0[0m] CMD RUNTIME[[0;32m0.028s[0m][0m STDOUT[ Linux|3.16.0-4-amd64|amd64|Debian|8.4 ][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.00015807s[0m][0m CMD[[0;33m/usr/bin/snmpget --version 2>&1[0m] [0m CMD EXITCODE[[0;32m0[0m] CMD RUNTIME[[0;32m0.0042s[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.0065s[0m][0m STDOUT[ RRDtool 1.4.8 Copyright 1997-2013 by Tobias Oetiker <tobi@oetiker.ch> ][0m CMD[[0;33mdate "+%:z"[0m] [0m CMD EXITCODE[[0;32m0[0m] CMD RUNTIME[[0;32m0.0028s[0m][0m STDOUT[ -04:00 ][0m SQL[[0;33mSELECT TIMEDIFF(NOW(), UTC_TIMESTAMP);[0m][0m SQL RUNTIME[[0;32m0.00018311s[0m][0m CMD[[0;33m/usr/bin/env apache2 -v | awk '/Server version:/ {print $3}'[0m] [0m CMD EXITCODE[[0;32m0[0m] CMD RUNTIME[[0;32m0.0342s[0m][0m STDOUT[ Apache/2.4.10 ][0m SQL[[0;33mSELECT @@SESSION.sql_mode;[0m][0m SQL RUNTIME[[0;32m0.00017095s[0m][0m SQL[[0;33mSHOW VARIABLES LIKE 'character_set_connection'[0m][0m SQL RUNTIME[[0;32m0.00027800s[0m][0m [0;36m##### [1;37mSoftware versions[0;36m #####[0m [0m [0;36m o [1;37mOS [0m Linux 3.16.0-4-amd64 [amd64] (Debian 8.4) [0;36m o [1;37mApache [0m 2.4.10 [0;36m o [1;37mPHP [0m 5.6.19-0+deb8u1 (OPcache: DISABLED) [0;36m o [1;37mPython [0m 2.7.9 [0;36m o [1;37mMySQL [0m 5.5.47-0+deb8u1 (extension: mysqli 5.5.47) [0;36m o [1;37mSNMP [0m NET-SNMP 5.7.2.1 [0;36m o [1;37mRRDtool [0m 1.4.8 [0;35m##### [1;37mMySQL mode[0;35m #####[0m [0m [0;35m o [1;37mMySQL [0m [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 Friday, 22-Apr-16 10:18:45 EDT [0;35m o [1;37mPHP [0m -04:00 [0;35m o [1;37mMySQL [0m -04:00 SQL[[0;33mSELECT * FROM `alerts_maint` WHERE `maint_start` < '1461334725' AND `maint_end` > '1461334725'[0m][0m SQL RUNTIME[[0;32m0.00020599s[0m][0m [1;37m##### [1;37m[1;37mStarting polling run at 2016-04-22 10:18:45[1;37m #####[0m [0m SQL[[0;33mSELECT `device_id` FROM `devices` WHERE `disabled` = 0 AND `hostname` LIKE 'pdu.partnersandsimons.com' ORDER BY `device_id` ASC[0m][0m SQL RUNTIME[[0;32m0.00047112s[0m][0m SQL[[0;33mSELECT * FROM `devices` WHERE `device_id` = '21'[0m][0m SQL RUNTIME[[0;32m0.00022101s[0m][0m SQL[[0;33mSELECT * FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '21'[0m][0m SQL RUNTIME[[0;32m0.00007200s[0m][0m SQL[[0;33mSELECT * FROM `observium_processes` WHERE `process_name` = 'poller.php' AND `device_id` = '21'[0m][0m SQL RUNTIME[[0;32m0.00017500s[0m][0m CMD[[0;33m/bin/ps -ww -o pid,ppid,uid,gid,tty,stat,time,lstart,args -p 24471[0m] [0m CMD EXITCODE[[0;32m0[0m] CMD RUNTIME[[0;32m0.0112s[0m][0m STDOUT[ PID PPID UID GID TT STAT TIME STARTED COMMAND 24471 15696 0 0 pts/0 S+ 00:00:00 Fri Apr 22 10:18:44 2016 php ./poller.php -d -m sensors -h pdu.partnersandsimons.com ][0m CMD[[0;33m/bin/ps -ww -o pid,ppid,uid,gid,tty,stat,time,lstart,args -p 15696[0m] [0m CMD EXITCODE[[0;32m0[0m] CMD RUNTIME[[0;32m0.0105s[0m][0m STDOUT[ PID PPID UID GID TT STAT TIME STARTED COMMAND 15696 15688 0 0 pts/0 Ss 00:00:00 Fri Apr 22 10:12:45 2016 -bash ][0m SQL[[0;33mINSERT INTO `observium_processes` (`process_pid`,`process_name`,`process_ppid`,`process_uid`,`process_command`,`process_start`,`device_id`) VALUES ('24471','poller.php','15696','0','php ./poller.php -d -m sensors -h pdu.partnersandsimons.com','1461334724','21')[0m][0m SQL RUNTIME[[0;32m0.00173187s[0m][0m SQL[[0;33mSELECT * FROM `alert_tests` WHERE 1[0m][0m SQL RUNTIME[[0;32m0.00010991s[0m][0m Cached 20 alert rules. SQL[[0;33mSELECT * FROM `alert_table` WHERE `device_id` = '21'[0m][0m SQL RUNTIME[[0;32m0.00022984s[0m][0m [0;32m##### [1;37mpdu.partnersandsimons.com [21][0;32m #####[0m [0m [0;32m o [1;37mOS [0m poweralert [0;32m o [1;37mLast poll duration [0m 3.72 seconds [0;32m o [1;37mLast Polled [0m 2016-04-22 10:18:17 [0;32m o [1;37mSNMP Version [0m v1 CMD[[0;33m/usr/bin/fping -t 500 -c 1 -q 192.168.3.20 2>&1[0m] [0m CMD EXITCODE[[0;32m0[0m] CMD RUNTIME[[0;32m0.0041s[0m][0m STDOUT[ 192.168.3.20 : xmt/rcv/%loss = 1/1/0%, min/avg/max = 0.93/0.93/0.93 ][0m CMD[[0;33m/usr/bin/snmpget -v1 -c *** -Pu -OQUst -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'pdu.partnersandsimons.com':'161' sysObjectID.0 sysUpTime.0[0m] [0m CMD EXITCODE[[0;32m0[0m] CMD RUNTIME[[0;32m0.0106s[0m][0m STDOUT[ sysObjectID.0 = enterprises.850.1 sysUpTime.0 = 36882 ][0m SNMP STATUS[[0;32mTRUE[0m][0m [0;32m o [1;37mDevice status [0m Device is reachable by PING (0.93ms) and SNMP (10.61ms) RRD /opt/observium/rrd/pdu.partnersandsimons.com/status.rrd already exists - no need to create. RRD CMD[[0;33mupdate /opt/observium/rrd/pdu.partnersandsimons.com/status.rrd N:1[0m][0m RRD RUNTIME[[0;32m0.0011s[0m] RRD STDOUT[[0;32mOK u:0.00 s:0.00 r:0.06[0m] RRD_STATUS[[0;32mTRUE[0m] [0m RRD /opt/observium/rrd/pdu.partnersandsimons.com/ping.rrd already exists - no need to create. RRD CMD[[0;33mupdate /opt/observium/rrd/pdu.partnersandsimons.com/ping.rrd N:0.93[0m][0m RRD RUNTIME[[0;32m0.0011s[0m] RRD STDOUT[[0;32mOK u:0.00 s:0.00 r:0.06[0m] RRD_STATUS[[0;32mTRUE[0m] [0m RRD /opt/observium/rrd/pdu.partnersandsimons.com/ping_snmp.rrd already exists - no need to create. RRD CMD[[0;33mupdate /opt/observium/rrd/pdu.partnersandsimons.com/ping_snmp.rrd N:10.61[0m][0m RRD RUNTIME[[0;32m0.0011s[0m] RRD STDOUT[[0;32mOK u:0.00 s:0.00 r:0.06[0m] RRD_STATUS[[0;32mTRUE[0m] [0m SQL[[0;33mSELECT * FROM `device_graphs` WHERE `device_id` = '21'[0m][0m SQL RUNTIME[[0;32m0.00012302s[0m][0m [0;32m o [1;37mModules Enabled [0m system, os, sensors including: includes/polling/system.inc.php [0;36m##### [1;37mModule Start: [1;31msystem[0;36m #####[0m [0m CMD[[0;33m/usr/bin/snmpget -v1 -c *** -Pu -OQUs -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'pdu.partnersandsimons.com':'161' sysUpTime.0 sysLocation.0 sysContact.0 sysName.0[0m] [0m CMD EXITCODE[[0;32m0[0m] CMD RUNTIME[[0;32m0.0133s[0m][0m STDOUT[ sysUpTime.0 = 0:0:06:08.84 sysLocation.0 = 1111 W. 35th St., Chicago, IL 60609 sysContact.0 = www.tripplite.com sysName.0 = pdu.partnersandsimons.com ][0m SNMP STATUS[[0;32mTRUE[0m][0m CMD[[0;33m/usr/bin/snmpget -v1 -c *** -Pu -Oqv -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'pdu.partnersandsimons.com':'161' sysDescr.0[0m] [0m CMD EXITCODE[[0;32m0[0m] CMD RUNTIME[[0;32m0.0099s[0m][0m STDOUT[ POWERALERT 12 ][0m SNMP STATUS[[0;32mTRUE[0m][0m CMD[[0;33m/usr/bin/snmpget -v1 -c *** -Pu -Oqvn -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'pdu.partnersandsimons.com':'161' sysObjectID.0[0m] [0m CMD EXITCODE[[0;32m0[0m] CMD RUNTIME[[0;32m0.0096s[0m][0m STDOUT[ .1.3.6.1.4.1.850.1 ][0m SNMP STATUS[[0;32mTRUE[0m][0m Using SNMP Agent sysUpTime (368 sec. => 6m 8s) RRD /opt/observium/rrd/pdu.partnersandsimons.com/uptime.rrd already exists - no need to create. RRD CMD[[0;33mupdate /opt/observium/rrd/pdu.partnersandsimons.com/uptime.rrd N:368[0m][0m RRD RUNTIME[[0;32m0.0011s[0m] RRD STDOUT[[0;32mOK u:0.00 s:0.00 r:0.11[0m] RRD_STATUS[[0;32mTRUE[0m] [0m [0;36m o [1;37mUptime [0m 6m 8s > $uptimes - /opt/observium/poller.php:163 /opt/observium/includes/polling/system.inc.php:188 =============================================== array( [sysUpTime] => int(368) [use] => string(9) "sysUpTime" [uptime] => int(368) [formatted] => string(5) "6m 8s" [message] => string(26) "Using SNMP Agent sysUpTime" [previous] => string(3) "337" [diff] => int(-31) [rebooted] => int(0) ) sysLocation rewritten from '1111 W. 35th St., Chicago, IL 60609' to '25 Drydock Ave Boston MA 02210' by DB override. [0;36m o [1;37msysObjectID [0m .1.3.6.1.4.1.850.1 [0;36m o [1;37msnmpEngineID [0m [0;36m o [1;37msysDescr [0m POWERALERT 12 [0;36m o [1;37msysName [0m pdu.partnersandsimons.com [0;36m o [1;37mLocation [0m 25 Drydock Ave Boston MA 02210 SQL[[0;33mSELECT * FROM `devices_locations` WHERE `device_id` = '21'[0m][0m SQL RUNTIME[[0;32m0.00013900s[0m][0m [0;36m o [1;37mModule time [0m 0.0519s including: includes/polling/os.inc.php [0;36m##### [1;37mModule Start: [1;31mos[0;36m #####[0m [0m SQL[[0;33mSELECT * FROM `observium_attribs`[0m][0m SQL RUNTIME[[0;32m0.00006795s[0m][0m [0;36m o [1;37mOS Poller [0m OS CMD[[0;33m/usr/bin/snmpget -v1 -c *** -Pu -Ovq -m UPS-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'pdu.partnersandsimons.com':'161' upsIdentModel.0[0m] [0m CMD EXITCODE[[0;32m0[0m] CMD RUNTIME[[0;32m0.0693s[0m][0m STDOUT[ PDUMV15NET ][0m SNMP STATUS[[0;32mTRUE[0m][0m CMD[[0;33m/usr/bin/snmpget -v1 -c *** -Pu -Ovq -m TRIPPLITE-MIB -M /opt/observium/mibs 'udp':'pdu.partnersandsimons.com':'161' .1.3.6.1.4.1.850.10.2.2.1.12.1[0m] [0m CMD EXITCODE[[0;32m0[0m] CMD RUNTIME[[0;32m0.0684s[0m][0m STDOUT[ "" ][0m SNMP STATUS[[0;31mFALSE[0m][0m SNMP ERROR[[0;31m#999 - Unknown[0m][0m CMD[[0;33m/usr/bin/snmpget -v1 -c *** -Pu -Ovq -m TRIPPLITE-MIB -M /opt/observium/mibs 'udp':'pdu.partnersandsimons.com':'161' .1.3.6.1.2.1.33.1.1.5.0[0m] [0m CMD EXITCODE[[0;32m0[0m] CMD RUNTIME[[0;32m0.0677s[0m][0m STDOUT[ Device 1 ][0m SNMP STATUS[[0;32mTRUE[0m][0m CMD[[0;33m/usr/bin/snmpget -v1 -c *** -Pu -Ovq -m TRIPPLITE-MIB -M /opt/observium/mibs 'udp':'pdu.partnersandsimons.com':'161' .1.3.6.1.4.1.850.100.1.1.4.0[0m] [0m CMD EXITCODE[[0;32m0[0m] CMD RUNTIME[[0;32m0.0137s[0m][0m STDOUT[ 2349AY016745600207 ][0m SNMP STATUS[[0;32mTRUE[0m][0m CMD[[0;33m/usr/bin/snmpget -v1 -c *** -Pu -Ovq -m UPS-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'pdu.partnersandsimons.com':'161' upsIdentAgentSoftwareVersion.0[0m] [0m CMD EXITCODE[[0;32m0[0m] CMD RUNTIME[[0;32m0.0648s[0m][0m STDOUT[ 12.06.0061 ][0m SNMP STATUS[[0;32mTRUE[0m][0m [0;36m o [1;37mHardware [0m [0;34m<empty>[0m [0;36m o [1;37mVersion [0m 12.06.0061 [0;36m o [1;37mFeatures [0m [0;34m<empty>[0m [0;36m o [1;37mSerial [0m 2349AY016745600207 [0;36m o [1;37mAsset [0m [0;34m<empty>[0m [0;36m o [1;37mModule time [0m 0.3103s including: includes/polling/sensors.inc.php [0;36m##### [1;37mModule Start: [1;31msensors[0;36m #####[0m [0m SQL[[0;33mSELECT COUNT(*) FROM `sensors` WHERE `device_id` = '21' AND `sensor_deleted` = '0';[0m][0m SQL RUNTIME[[0;32m0.00014591s[0m][0m [0;36m o [1;37mSensor Count [0m 3 SQL[[0;33mSELECT `sensor_type` FROM `sensors` WHERE `device_id` = '21' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0' GROUP BY `sensor_type`[0m][0m SQL RUNTIME[[0;32m0.00007391s[0m][0m SQL[[0;33mSELECT * FROM `sensors` LEFT JOIN `sensors-state` USING(`sensor_id`) WHERE `sensor_class` = 'temperature' AND `device_id` = '21'[0m][0m SQL RUNTIME[[0;32m0.00030303s[0m][0m SQL[[0;33mSELECT * FROM `sensors` LEFT JOIN `sensors-state` USING(`sensor_id`) WHERE `sensor_class` = 'humidity' AND `device_id` = '21'[0m][0m SQL RUNTIME[[0;32m0.00016999s[0m][0m SQL[[0;33mSELECT * FROM `sensors` LEFT JOIN `sensors-state` USING(`sensor_id`) WHERE `sensor_class` = 'fanspeed' AND `device_id` = '21'[0m][0m SQL RUNTIME[[0;32m0.00020909s[0m][0m SQL[[0;33mSELECT * FROM `sensors` LEFT JOIN `sensors-state` USING(`sensor_id`) WHERE `sensor_class` = 'airflow' AND `device_id` = '21'[0m][0m SQL RUNTIME[[0;32m0.00017405s[0m][0m SQL[[0;33mSELECT * FROM `sensors` LEFT JOIN `sensors-state` USING(`sensor_id`) WHERE `sensor_class` = 'voltage' AND `device_id` = '21'[0m][0m SQL RUNTIME[[0;32m0.00021291s[0m][0m Checking (snmp) voltage Input Array ( [sensor_id] => 180 [sensor_deleted] => 0 [sensor_class] => voltage [device_id] => 21 [poller_type] => snmp [sensor_oid] => .1.3.6.1.2.1.33.1.3.3.1.3.1 [sensor_mib] => [sensor_object] => [sensor_index] => upsInputEntry.1 [sensor_type] => ups-mib [sensor_descr] => Input [sensor_unit] => [sensor_multiplier] => 1 [sensor_limit] => 1260.4 [sensor_limit_warn] => [sensor_limit_low] => 931.6 [sensor_limit_low_warn] => [sensor_custom_limit] => 0 [entPhysicalIndex] => [entPhysicalClass] => [entPhysicalIndex_measured] => [measured_class] => [measured_entity] => [sensor_ignore] => 0 [sensor_disable] => 0 [sensor_value] => 1095.00000 [sensor_event] => ok [sensor_status] => [sensor_polled] => 1461334695 [sensor_last_change] => 1461334610 ) CMD[[0;33m/usr/bin/snmpget -v1 -c *** -Pu -OUqnv -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'pdu.partnersandsimons.com':'161' .1.3.6.1.2.1.33.1.3.3.1.3.1[0m] [0m CMD EXITCODE[[0;32m0[0m] CMD RUNTIME[[0;32m0.1253s[0m][0m STDOUT[ 1095 ][0m SNMP STATUS[[0;32mTRUE[0m][0m Array ( [sensor_value] => 1095 ) RRD CMD[[0;33mupdate /opt/observium/rrd/pdu.partnersandsimons.com/sensor-voltage-ups-mib-upsInputEntry.1.rrd N:1095[0m][0m RRD RUNTIME[[0;32m0.0011s[0m] RRD STDOUT[[0;32mOK u:0.00 s:0.00 r:0.56[0m] RRD_STATUS[[0;32mTRUE[0m] [0m > $data - /opt/observium/includes/polling/sensors.inc.php:47 /opt/observium/includes/alerts.inc.php:57 ==================================================== array( [sensor_value] => int(1095) [sensor_event] => string(2) "ok" [sensor_event_uptime] => int(115) [sensor_status] => string(0) "" ) SQL[[0;33mUPDATE `sensors-state` set `sensor_value` ='1095',`sensor_event` ='ok',`sensor_status` ='',`sensor_last_change` ='1461334610',`sensor_polled` ='1461334725' WHERE `sensor_id` = '180'[0m][0m SQL RUNTIME[[0;32m0.00025201s[0m][0m SQL[[0;33mSELECT * FROM `sensors` LEFT JOIN `sensors-state` USING(`sensor_id`) WHERE `sensor_class` = 'current' AND `device_id` = '21'[0m][0m SQL RUNTIME[[0;32m0.00032592s[0m][0m Checking (snmp) current Output Array ( [sensor_id] => 182 [sensor_deleted] => 0 [sensor_class] => current [device_id] => 21 [poller_type] => snmp [sensor_oid] => .1.3.6.1.2.1.33.1.4.4.1.3.1 [sensor_mib] => [sensor_object] => [sensor_index] => upsOutputEntry.1 [sensor_type] => ups-mib [sensor_descr] => Output [sensor_unit] => [sensor_multiplier] => 0.1 [sensor_limit] => 0 [sensor_limit_warn] => [sensor_limit_low] => [sensor_limit_low_warn] => [sensor_custom_limit] => 0 [entPhysicalIndex] => [entPhysicalClass] => [entPhysicalIndex_measured] => [measured_class] => [measured_entity] => [sensor_ignore] => 0 [sensor_disable] => 0 [sensor_value] => 0.00000 [sensor_event] => ok [sensor_status] => [sensor_polled] => 1461334696 [sensor_last_change] => 1461334610 ) CMD[[0;33m/usr/bin/snmpget -v1 -c *** -Pu -OUqnv -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'pdu.partnersandsimons.com':'161' .1.3.6.1.2.1.33.1.4.4.1.3.1[0m] [0m CMD EXITCODE[[0;32m0[0m] CMD RUNTIME[[0;32m0.118s[0m][0m STDOUT[ 0 ][0m SNMP STATUS[[0;32mTRUE[0m][0m Array ( [sensor_value] => 0 ) RRD CMD[[0;33mupdate /opt/observium/rrd/pdu.partnersandsimons.com/sensor-current-ups-mib-upsOutputEntry.1.rrd N:0[0m][0m RRD RUNTIME[[0;32m0.0011s[0m] RRD STDOUT[[0;32mOK u:0.00 s:0.00 r:0.69[0m] RRD_STATUS[[0;32mTRUE[0m] [0m - /opt/observium/includes/polling/sensors.inc.php:47 /opt/observium/includes/alerts.inc.php:57 ================================================ array( [sensor_value] => double(0) [sensor_event] => string(2) "ok" [sensor_event_uptime] => int(115) [sensor_status] => string(0) "" ) SQL[[0;33mUPDATE `sensors-state` set `sensor_value` ='0',`sensor_event` ='ok',`sensor_status` ='',`sensor_last_change` ='1461334610',`sensor_polled` ='1461334725' WHERE `sensor_id` = '182'[0m][0m SQL RUNTIME[[0;32m0.00021887s[0m][0m SQL[[0;33mSELECT * FROM `sensors` LEFT JOIN `sensors-state` USING(`sensor_id`) WHERE `sensor_class` = 'power' AND `device_id` = '21'[0m][0m SQL RUNTIME[[0;32m0.00027800s[0m][0m SQL[[0;33mSELECT * FROM `sensors` LEFT JOIN `sensors-state` USING(`sensor_id`) WHERE `sensor_class` = 'apower' AND `device_id` = '21'[0m][0m SQL RUNTIME[[0;32m0.00016499s[0m][0m SQL[[0;33mSELECT * FROM `sensors` LEFT JOIN `sensors-state` USING(`sensor_id`) WHERE `sensor_class` = 'rpower' AND `device_id` = '21'[0m][0m SQL RUNTIME[[0;32m0.00019884s[0m][0m SQL[[0;33mSELECT * FROM `sensors` LEFT JOIN `sensors-state` USING(`sensor_id`) WHERE `sensor_class` = 'impedance' AND `device_id` = '21'[0m][0m SQL RUNTIME[[0;32m0.00016189s[0m][0m SQL[[0;33mSELECT * FROM `sensors` LEFT JOIN `sensors-state` USING(`sensor_id`) WHERE `sensor_class` = 'resistance' AND `device_id` = '21'[0m][0m SQL RUNTIME[[0;32m0.00021005s[0m][0m SQL[[0;33mSELECT * FROM `sensors` LEFT JOIN `sensors-state` USING(`sensor_id`) WHERE `sensor_class` = 'frequency' AND `device_id` = '21'[0m][0m SQL RUNTIME[[0;32m0.00022006s[0m][0m Checking (snmp) frequency Input Array ( [sensor_id] => 181 [sensor_deleted] => 0 [sensor_class] => frequency [device_id] => 21 [poller_type] => snmp [sensor_oid] => .1.3.6.1.2.1.33.1.3.3.1.2.1 [sensor_mib] => [sensor_object] => [sensor_index] => upsInputEntry.1 [sensor_type] => ups-mib [sensor_descr] => Input [sensor_unit] => [sensor_multiplier] => 0.1 [sensor_limit] => 628.95 [sensor_limit_warn] => [sensor_limit_low] => 569.05 [sensor_limit_low_warn] => [sensor_custom_limit] => 0 [entPhysicalIndex] => [entPhysicalClass] => [entPhysicalIndex_measured] => [measured_class] => [measured_entity] => [sensor_ignore] => 0 [sensor_disable] => 0 [sensor_value] => 599.00000 [sensor_event] => ok [sensor_status] => [sensor_polled] => 1461334696 [sensor_last_change] => 1461334611 ) CMD[[0;33m/usr/bin/snmpget -v1 -c *** -Pu -OUqnv -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'pdu.partnersandsimons.com':'161' .1.3.6.1.2.1.33.1.3.3.1.2.1[0m] [0m CMD EXITCODE[[0;32m0[0m] CMD RUNTIME[[0;32m0.0906s[0m][0m STDOUT[ 5990 ][0m SNMP STATUS[[0;32mTRUE[0m][0m Array ( [sensor_value] => 5990 ) RRD CMD[[0;33mupdate /opt/observium/rrd/pdu.partnersandsimons.com/sensor-frequency-ups-mib-upsInputEntry.1.rrd N:599[0m][0m RRD RUNTIME[[0;32m0.0011s[0m] RRD STDOUT[[0;32mOK u:0.00 s:0.00 r:0.79[0m] RRD_STATUS[[0;32mTRUE[0m] [0m - /opt/observium/includes/polling/sensors.inc.php:47 /opt/observium/includes/alerts.inc.php:57 ================================================ array( [sensor_value] => double(599) [sensor_event] => string(2) "ok" [sensor_event_uptime] => int(115) [sensor_status] => string(0) "" ) SQL[[0;33mUPDATE `sensors-state` set `sensor_value` ='599',`sensor_event` ='ok',`sensor_status` ='',`sensor_last_change` ='1461334611',`sensor_polled` ='1461334726' WHERE `sensor_id` = '181'[0m][0m SQL RUNTIME[[0;32m0.00025201s[0m][0m SQL[[0;33mSELECT * FROM `sensors` LEFT JOIN `sensors-state` USING(`sensor_id`) WHERE `sensor_class` = 'dbm' AND `device_id` = '21'[0m][0m SQL RUNTIME[[0;32m0.00026488s[0m][0m SQL[[0;33mSELECT * FROM `sensors` LEFT JOIN `sensors-state` USING(`sensor_id`) WHERE `sensor_class` = 'snr' AND `device_id` = '21'[0m][0m SQL RUNTIME[[0;32m0.00019503s[0m][0m SQL[[0;33mSELECT * FROM `sensors` LEFT JOIN `sensors-state` USING(`sensor_id`) WHERE `sensor_class` = 'capacity' AND `device_id` = '21'[0m][0m SQL RUNTIME[[0;32m0.00020289s[0m][0m SQL[[0;33mSELECT * FROM `sensors` LEFT JOIN `sensors-state` USING(`sensor_id`) WHERE `sensor_class` = 'load' AND `device_id` = '21'[0m][0m SQL RUNTIME[[0;32m0.00015306s[0m][0m SQL[[0;33mSELECT * FROM `sensors` LEFT JOIN `sensors-state` USING(`sensor_id`) WHERE `sensor_class` = 'runtime' AND `device_id` = '21'[0m][0m SQL RUNTIME[[0;32m0.00021911s[0m][0m SQL[[0;33mSELECT * FROM `sensors` LEFT JOIN `sensors-state` USING(`sensor_id`) WHERE `sensor_class` = 'state' AND `device_id` = '21'[0m][0m SQL RUNTIME[[0;32m0.00014901s[0m][0m SQL[[0;33mSELECT * FROM `sensors` LEFT JOIN `sensors-state` USING(`sensor_id`) WHERE `sensor_class` = 'waterflow' AND `device_id` = '21'[0m][0m SQL RUNTIME[[0;32m0.00015092s[0m][0m SQL[[0;33mSELECT * FROM `sensors` LEFT JOIN `sensors-state` USING(`sensor_id`) WHERE `sensor_class` = 'counter' AND `device_id` = '21'[0m][0m SQL RUNTIME[[0;32m0.00017500s[0m][0m Descr Class Type Origin Value Event Last Changed Input voltage ups-mib snmp 1095V ok 2016-04-22 10:16:50 Output current ups-mib snmp 0A ok 2016-04-22 10:16:50 Input frequency ups-mib snmp 599Hz ok 2016-04-22 10:16:51 [0;36m o [1;37mModule time [0m 0.3750s [0;32m##### [1;37mpdu.partnersandsimons.com [21] completed poller modules at 2016-04-22 10:18:46[0;32m #####[0m [0m [0;32m o [1;37mGraphs [checked] [0m ping, ping_snmp, uptime, voltage, current, frequency [0;32m o [1;37mPoller time [0m 0.7712 seconds Updating pdu.partnersandsimons.com - > $update_array ======== array( [uptime] => int(368) [last_polled] => array( [0] => string(5) "NOW()" ) [last_polled_timetaken] => double(0.7712) [device_state] => string(124) "a:1:{s:15:"poller_mod_perf";a:3:{s:6:"system";d:0.051900000000000002;s:2:"os";d:0.31030000000000002;s:7:"sensors";d:0.375;}}" â”— serialized ~ array( [poller_mod_perf] => array( [system] => double(0.0519) [os] => double(0.3103) [sensors] => double(0.375) ) ) ) SQL[[0;33mUPDATE `devices` set `uptime` ='368',`last_polled` =NOW(),`last_polled_timetaken` ='0.7712',`device_state` ='a:1:{s:15:\"poller_mod_perf\";a:3:{s:6:\"system\";d:0.051900000000000002;s:2:\"os\";d:0.31030000000000002;s:7:\"sensors\";d:0.375;}}' WHERE `device_id` = '21'[0m][0m SQL RUNTIME[[0;32m0.01161003s[0m][0m [0;32m o [1;37mUpdated Data [0m uptime, last_polled, last_polled_timetaken, device_state - /opt/observium/poller.php:163 /opt/observium/includes/alerts.inc.php:57 ====================================== array( [device_status] => string(1) "1" [device_status_type] => string(0) "" [device_ping] => string(4) "0.93" [device_snmp] => string(5) "10.61" [device_uptime] => string(3) "337" [device_rebooted] => int(0) [device_duration_poll] => string(4) "3.72" ) SQL[[0;33mUPDATE `alert_table` set `state` ='{\"metrics\":{\"device_status\":\"1\"}}',`count` ='0',`alert_status` ='1',`last_message` ='Checks OK',`last_checked` ='1461334726',`last_ok` ='1461334726' WHERE `alert_table_id` = '216'[0m][0m SQL RUNTIME[[0;32m0.00166512s[0m][0m RRD CMD[[0;33mupdate /opt/observium/rrd/pdu.partnersandsimons.com/alert-216.rrd N:1:1[0m][0m RRD RUNTIME[[0;32m0.0011s[0m] RRD STDOUT[[0;32mOK u:0.00 s:0.00 r:0.82[0m] RRD_STATUS[[0;32mTRUE[0m] [0m SQL[[0;33mDELETE FROM `observium_processes` WHERE `process_pid` = '24471' AND `process_name` = 'poller.php' AND `device_id` = '21'[0m][0m SQL RUNTIME[[0;32m0.00111389s[0m][0m SQL[[0;33mINSERT INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`) VALUES ('poll','pdu.partnersandsimons.com','1461334725.165','0.947','1')[0m][0m SQL RUNTIME[[0;32m0.00292301s[0m][0m ./poller.php: pdu.partnersandsimons.com - 1 devices polled in 0.947 secs [1;37m##### [1;37m[1;37mCompleted polling run at 2016-04-22 10:18:46[1;37m #####[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 Polled [0m 1 [1;37m o [1;37mPoller Time [0m 0.947 secs [1;37m o [1;37mMemory usage [0m 8.25MB (peak: 8.25MB) [1;37m o [1;37mMySQL Usage [0m Cell[5/0.002s] Row[7/0.003s] Rows[31/0.013s] Column[0/0s] Update[5/0.015s] Insert[2/0.005s] Delete[1/0.001s] [1;37m o [1;37mRRDTool Usage [0m update[8/0.009s]