DEBUG! CMD[[0;33m/usr/bin/svn info /opt/observium[0m] [0m CMD EXITCODE[[0;32m0[0m] CMD RUNTIME[[0;32m0.0115s[0m][0m STDOUT[ Path: . Working Copy Root Path: /opt/observium URL: http://svn.observium.org/svn/observium/trunk Repository Root: http://svn.observium.org/svn Repository UUID: 61d68cd4-352d-0410-923a-c4978735b2b8 Revision: 10377 Node Kind: directory Schedule: normal Last Changed Author: mike Last Changed Rev: 10377 Last Changed Date: 2020-04-16 16:38:29 +0200 (Thu, 16 Apr 2020) ] SQL[[0;33mSELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'dbSchema';[0m][0m SQL RUNTIME[[0;32m0.00015116s[0m][0m SQL[[0;33mSELECT @@SESSION.sql_mode;[0m][0m SQL RUNTIME[[0;32m0.00006199s[0m][0m SQL[[0;33mSET SESSION `sql_mode` = 'NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'[0m][0m SQL RUNTIME[[0;32m0.00004506s[0m][0m DB mode(s) disabled: STRICT_TRANS_TABLES, ERROR_FOR_DIVISION_BY_ZERO SQL[[0;33mSELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'current_rev';[0m][0m SQL RUNTIME[[0;32m0.00010300s[0m][0m SQL[[0;33mSELECT * FROM `config`[0m][0m SQL RUNTIME[[0;32m0.00013518s[0m][0m [1;37m ___ _ _ / _ \ | |__ ___ ___ _ __ __ __(_) _ _ _ __ ___ | | | || '_ \ / __| / _ \| '__|\ \ / /| || | | || '_ ` _ \ | |_| || |_) |\__ \| __/| | \ V / | || |_| || | | | | | \___/ |_.__/ |___/ \___||_| \_/ |_| \__,_||_| |_| |_|[0;36m Observium Professional 20.4.10377 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.00014997s[0m][0m SQL[[0;33mSELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'latest_rev';[0m][0m SQL RUNTIME[[0;32m0.00008082s[0m][0m SQL[[0;33mSELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'latest_rev_date';[0m][0m SQL RUNTIME[[0;32m0.00007105s[0m][0m CMD[[0;33m/opt/observium/scripts/distro[0m] [0m CMD EXITCODE[[0;32m0[0m] CMD RUNTIME[[0;32m0.0119s[0m][0m STDOUT[ Linux|3.10.0-1062.18.1.el7.x86_64|amd64|CentOS|7|vmware| ] CMD[[0;33m/usr/bin/env python --version 2>&1[0m] [0m CMD EXITCODE[[0;32m0[0m] CMD RUNTIME[[0;32m0.0026s[0m][0m STDOUT[ Python 2.7.5 ] SQL[[0;33mSELECT version();[0m][0m SQL RUNTIME[[0;32m0.00013900s[0m][0m CMD[[0;33m/usr/bin/snmpget --version 2>&1[0m] [0m CMD EXITCODE[[0;32m0[0m] CMD RUNTIME[[0;32m0.0046s[0m][0m STDOUT[ NET-SNMP version: 5.7.2 ] CMD[[0;33m/usr/bin/rrdtool --version | head -n1[0m] [0m CMD EXITCODE[[0;32m0[0m] CMD RUNTIME[[0;32m0.0054s[0m][0m STDOUT[ RRDtool 1.4.8 Copyright 1997-2013 by Tobias Oetiker <tobi@oetiker.ch> ] CMD[[0;33m/usr/sbin/fping -v 2>&1[0m] [0m CMD EXITCODE[[0;32m0[0m] CMD RUNTIME[[0;32m0.0019s[0m][0m CMD EXITDELAY[[0;31m10ms[0m][0m STDOUT[ /usr/sbin/fping: Version 3.10 /usr/sbin/fping: comments to david@schweikert.ch ] CMD[[0;33m/usr/bin/env apache2 -v | awk '/Server version:/ {print $3}'[0m] [0m CMD EXITCODE[[0;32m0[0m] CMD RUNTIME[[0;32m0.0025s[0m][0m STDOUT[ ] CMD[[0;33m/usr/sbin/httpd -v | awk '/Server version:/ {print $3}'[0m] [0m CMD EXITCODE[[0;32m0[0m] CMD RUNTIME[[0;32m0.025s[0m][0m STDOUT[ Apache/2.4.6 ] CMD[[0;33mdate "+%:z"[0m] [0m CMD EXITCODE[[0;32m0[0m] CMD RUNTIME[[0;32m0.0021s[0m][0m CMD EXITDELAY[[0;31m10ms[0m][0m STDOUT[ +02:00 ] SQL[[0;33mSELECT TIMEDIFF(NOW(), UTC_TIMESTAMP);[0m][0m SQL RUNTIME[[0;32m0.00014710s[0m][0m SQL[[0;33mSELECT @@SESSION.sql_mode;[0m][0m SQL RUNTIME[[0;32m0.00006890s[0m][0m SQL[[0;33mSHOW VARIABLES LIKE 'character_set_connection'[0m][0m SQL RUNTIME[[0;32m0.00046396s[0m][0m [0;36m##### [1;37mSoftware versions[0;36m #####[0m [0m [0;36m o [1;37mOS [0m Linux 3.10.0-1062.18.1.el7.x86_64 [amd64] (CentOS 7) [0;36m o [1;37mApache [0m 2.4.6 [0;36m o [1;37mPHP [0m 7.3.16 [0;36m o [1;37mPython [0m 2.7.5 [0;36m o [1;37mMySQL [0m 10.3.21-MariaDB-log (extension: mysqli 5.0.12-dev) [0;36m o [1;37mSNMP [0m NET-SNMP 5.7.2 [0;36m o [1;37mRRDtool [0m 1.4.8 [0;36m o [1;37mFping [0m 3.10 (IPv4 only) [0;35m##### [1;37mMemory Limit[0;35m #####[0m [0m [0;35m o [1;37mPHP [0m 512MB [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 Monday, 20-Apr-20 13:34:04 CEST [0;35m o [1;37mPHP [0m +02:00 [0;35m o [1;37mMySQL [0m +02:00 SQL[[0;33mSELECT * FROM `alerts_maint` WHERE `maint_start` < '1587382444' AND `maint_end` > '1587382444'[0m][0m SQL RUNTIME[[0;32m0.00019002s[0m][0m [1;37m##### [1;37m[1;37mStarting polling run at 2020-04-20 13:34:04[1;37m #####[0m [0m SQL[[0;33mSELECT `device_id` FROM `devices` WHERE `disabled` = 0 AND `hostname` LIKE 'ipcam-wlan-master.fqdn.net' AND `poller_id` = '0' ORDER BY `device_id` ASC[0m][0m SQL RUNTIME[[0;32m0.00028396s[0m][0m SQL[[0;33mSELECT * FROM `devices` WHERE `device_id` = '1839'[0m][0m SQL RUNTIME[[0;32m0.00023603s[0m][0m SQL[[0;33mSELECT * FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '1839'[0m][0m SQL RUNTIME[[0;32m0.00016403s[0m][0m SQL[[0;33mSELECT * FROM `observium_processes` WHERE `process_name` = 'poller.php' AND `device_id` = '1839'[0m][0m SQL RUNTIME[[0;32m0.00013304s[0m][0m SQL[[0;33mINSERT INTO `observium_processes` (`process_pid`,`process_name`,`process_ppid`,`process_uid`,`process_command`,`process_start`,`device_id`) VALUES ('12469','poller.php','7753','0','php ./poller.php -h ipcam-wlan-master.fqdn.net -m os -d','1587382444','1839')[0m][0m SQL RUNTIME[[0;32m0.00134015s[0m][0m SQL[[0;33mSELECT * FROM `alert_tests` WHERE 1[0m][0m SQL RUNTIME[[0;32m0.00019407s[0m][0m Cached 2 alert rules. SQL[[0;33mSELECT * FROM `alert_table` WHERE `device_id` = '1839'[0m][0m SQL RUNTIME[[0;32m0.00016499s[0m][0m [0;32m##### [1;37mipcam-wlan-master.fqdn.net [1839][0;32m #####[0m [0m [0;32m o [1;37mOS [0m unifi [0;32m o [1;37mLast poll duration [0m 0.39 seconds [0;32m o [1;37mLast Polled [0m 2020-04-20 13:33:35 [0;32m o [1;37mSNMP Version [0m v2c CMD[[0;33m/usr/sbin/fping -t 2000 -c 1 -q 10.10.23.90 2>&1[0m] [0m CMD EXITCODE[[0;32m0[0m] CMD RUNTIME[[0;32m0.0323s[0m][0m CMD EXITDELAY[[0;31m10ms[0m][0m STDOUT[ 10.10.23.90 : xmt/rcv/%loss = 1/1/0%, min/avg/max = 29.9/29.9/29.9 ] CMD[[0;33m/usr/bin/snmpget -t '20' -v2c -c *** -Pud -OQUs -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ipcam-wlan-master.fqdn.net':'161' sysObjectID.0 sysUpTime.0[0m] [0m CMD EXITCODE[[0;32m0[0m] CMD RUNTIME[[0;32m0.0329s[0m][0m STDOUT[ sysObjectID.0 = enterprises.8072.3.2.10 sysUpTime.0 = 32:0:22:12.49 ] SNMP STATUS[[0;32mTRUE[0m][0m [0;32m o [1;37mDevice status [0m Device is reachable by PING (29.9ms) and SNMP (32.95ms) RRD /opt/observium/rrd/ipcam-wlan-master.fqdn.net/status.rrd already exists - no need to create. RRD CMD[[0;33mupdate /opt/observium/rrd/ipcam-wlan-master.fqdn.net/status.rrd N:1[0m][0m RRD RUNTIME[[0;32m0.0011s[0m] RRD STDOUT[[0;32mOK u:0.00 s:0.00 r:0.08[0m] RRD_STATUS[[0;32mTRUE[0m] [0m RRD /opt/observium/rrd/ipcam-wlan-master.fqdn.net/ping.rrd already exists - no need to create. RRD CMD[[0;33mupdate /opt/observium/rrd/ipcam-wlan-master.fqdn.net/ping.rrd N:29.9[0m][0m RRD RUNTIME[[0;32m0.0011s[0m] RRD STDOUT[[0;32mOK u:0.00 s:0.00 r:0.08[0m] RRD_STATUS[[0;32mTRUE[0m] [0m RRD /opt/observium/rrd/ipcam-wlan-master.fqdn.net/ping_snmp.rrd already exists - no need to create. RRD CMD[[0;33mupdate /opt/observium/rrd/ipcam-wlan-master.fqdn.net/ping_snmp.rrd N:32.95[0m][0m RRD RUNTIME[[0;32m0.0011s[0m] RRD STDOUT[[0;32mOK u:0.00 s:0.00 r:0.08[0m] RRD_STATUS[[0;32mTRUE[0m] [0m SQL[[0;33mSELECT * FROM `device_graphs` WHERE `device_id` = '1839'[0m][0m SQL RUNTIME[[0;32m0.00023103s[0m][0m including: includes/polling/system.inc.php [0;36m##### [1;37mModule Start: [1;31msystem[0;36m #####[0m [0m SQL[[0;33mSELECT `mib` FROM `devices_mibs` WHERE `device_id` = '1839' AND `use` = 'mib' AND `disabled` = '1'[0m][0m SQL RUNTIME[[0;32m0.00020909s[0m][0m [0;36m o [1;37mSNMPv2-MIB [0m CMD[[0;33m/usr/bin/snmpget -t '20' -v2c -c *** -Pud -OQUs -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ipcam-wlan-master.fqdn.net':'161' sysUpTime.0 sysLocation.0 sysContact.0 sysName.0[0m] [0m CMD EXITCODE[[0;32m0[0m] CMD RUNTIME[[0;32m0.0329s[0m][0m STDOUT[ sysUpTime.0 = 32:0:22:12.53 sysLocation.0 = Unknown sysContact.0 = root@localhost sysName.0 = APMesh-PRO ] SNMP STATUS[[0;32mTRUE[0m][0m Timeticks converted 32:0:22:12.53 -> 2766132 CMD[[0;33m/usr/bin/snmpget -t '20' -v2c -c *** -Pud -OQUv -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ipcam-wlan-master.fqdn.net':'161' sysDescr.0[0m] [0m CMD EXITCODE[[0;32m0[0m] CMD RUNTIME[[0;32m0.0325s[0m][0m STDOUT[ UAP-AC-Mesh-Pro 4.0.80.10875 ] SNMP STATUS[[0;32mTRUE[0m][0m CMD[[0;33m/usr/bin/snmpget -t '20' -v2c -c *** -Pud -OQUvn -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ipcam-wlan-master.fqdn.net':'161' sysObjectID.0[0m] [0m CMD EXITCODE[[0;32m0[0m] CMD RUNTIME[[0;32m0.0324s[0m][0m STDOUT[ .1.3.6.1.4.1.8072.3.2.10 ] SNMP STATUS[[0;32mTRUE[0m][0m CMD[[0;33m/usr/bin/snmpget -t '20' -v2c -c *** -Pud -OQUv -m SNMP-FRAMEWORK-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ipcam-wlan-master.fqdn.net':'161' snmpEngineID.0[0m] [0m CMD EXITCODE[[0;32m0[0m] CMD RUNTIME[[0;32m0.0323s[0m][0m STDOUT[ "80 00 1F 88 80 39 FD 6D 87 5E 6D 01 98 " ] SNMP STATUS[[0;32mTRUE[0m][0m CMD[[0;33m/usr/bin/snmpget -t '20' -v2c -c *** -Pud -OQUv -m UBNT-UniFi-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/ubiquiti 'udp':'ipcam-wlan-master.fqdn.net':'161' unifiApSystemUptime.0[0m] [0m CMD EXITCODE[[0;32m0[0m] CMD RUNTIME[[0;32m0.0336s[0m][0m STDOUT[ 2766169 ] SNMP STATUS[[0;32mTRUE[0m][0m Added System Uptime from SNMP definition walk: 'device_uptime' = '2766169' Using device MIB poller sysUpTime: UBNT-UniFi-MIB::unifiApSystemUptime.0 (2766169 sec. => 32 days, 22m 49s) RRD /opt/observium/rrd/ipcam-wlan-master.fqdn.net/uptime.rrd already exists - no need to create. RRD CMD[[0;33mupdate /opt/observium/rrd/ipcam-wlan-master.fqdn.net/uptime.rrd N:2766169[0m][0m RRD RUNTIME[[0;32m0.0011s[0m] RRD STDOUT[[0;32mOK u:0.00 s:0.00 r:0.25[0m] RRD_STATUS[[0;32mTRUE[0m] [0m [0;36m o [1;37mUptime [0m 32 days, 22m 49s [0;36m o [1;37mLast reboot [0m 2020-03-19 13:11:52 [1;44;96m [0m[44;36m /opt/observium/includes/polling/system.inc.php:314 [0m array( [use] => string(13) "device_uptime" [sysUpTime] => int(2766132) [message] => string(72) "Using device MIB poller sysUpTime: UBNT-UniFi-MIB::unifiApSystemUptime.0" [device_uptime] => double(2766169) [uptime] => double(2766169) [formatted] => string(16) "32 days, 22m 49s" [previous] => string(7) "2766140" [diff] => double(-29) [last_rebooted] => string(10) "1584616312" [rebooted] => int(0) ) CMD[[0;33m/usr/bin/snmpget -t '20' -v2c -c *** -Pud -OQUsn -m UCD-SNMP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ipcam-wlan-master.fqdn.net':'161' .1.3.6.1.4.1.2021.10.1.5.1 .1.3.6.1.4.1.2021.10.1.5.2 .1.3.6.1.4.1.2021.10.1.5.3[0m] [0m CMD EXITCODE[[0;32m0[0m] CMD RUNTIME[[0;32m0.0337s[0m][0m STDOUT[ .1.3.6.1.4.1.2021.10.1.5.1 = 11 .1.3.6.1.4.1.2021.10.1.5.2 = 15 .1.3.6.1.4.1.2021.10.1.5.3 = 13 ] SNMP STATUS[[0;32mTRUE[0m][0m RRD old file not found: '/opt/observium/rrd/ipcam-wlan-master.fqdn.net/ucd_load.rrd' RRD /opt/observium/rrd/ipcam-wlan-master.fqdn.net/la.rrd already exists - no need to create. RRD CMD[[0;33mupdate /opt/observium/rrd/ipcam-wlan-master.fqdn.net/la.rrd N:11:15:13[0m][0m RRD RUNTIME[[0;32m0.0011s[0m] RRD STDOUT[[0;32mOK u:0.00 s:0.00 r:0.29[0m] RRD_STATUS[[0;32mTRUE[0m] [0m [0;36m o [1;37mLoad average [0m 0.11, 0.15, 0.13 [0;36m o [1;37msysObjectID [0m .1.3.6.1.4.1.8072.3.2.10 [0;36m o [1;37msnmpEngineID [0m 80001F888039FD6D875E6D0198 [0;36m o [1;37msysDescr [0m UAP-AC-Mesh-Pro 4.0.80.10875 [0;36m o [1;37msysName [0m APMesh-PRO [0;36m o [1;37mLocation [0m Unknown SQL[[0;33mSELECT * FROM `devices_locations` WHERE `device_id` = '1839'[0m][0m SQL RUNTIME[[0;32m0.00020099s[0m][0m [0;36m o [1;37mModule time [0m 0.2090s including: includes/polling/os.inc.php [0;36m##### [1;37mModule Start: [1;31mos[0;36m #####[0m [0m CMD[[0;33m/usr/bin/snmpget -t '20' -v2c -c *** -Pud -OQUv -m UBNT-UniFi-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/ubiquiti 'udp':'ipcam-wlan-master.fqdn.net':'161' unifiApSystemVersion.0[0m] [0m CMD EXITCODE[[0;32m0[0m] CMD RUNTIME[[0;32m0.0337s[0m][0m STDOUT[ 4.0.80.10875 ] SNMP STATUS[[0;32mTRUE[0m][0m Added OS param from SNMP definition walk: 'version' = '4.0.80.10875' CMD[[0;33m/usr/bin/snmpget -t '20' -v2c -c *** -Pud -OQUv -m UBNT-UniFi-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/ubiquiti 'udp':'ipcam-wlan-master.fqdn.net':'161' unifiApSystemModel.0[0m] [0m CMD EXITCODE[[0;32m0[0m] CMD RUNTIME[[0;32m0.0341s[0m][0m STDOUT[ UAP-AC-Mesh-Pro ] SNMP STATUS[[0;32mTRUE[0m][0m String 'UAP-AC-Mesh-Pro' transformed by action [regex_replace] to: 'UniFi AP-AC-Mesh-Pro' Added OS param from SNMP definition walk: 'hardware' = 'UniFi AP-AC-Mesh-Pro' [0;36m o [1;37mOS Poller [0m OS [0;36m o [1;37mVendor [0m Ubiquiti [0;36m o [1;37mHardware [0m UniFi AP-AC-Mesh-Pro [0;36m o [1;37mVersion [0m 4.0.80.10875 [0;36m o [1;37mFeatures [0m [0;34m<empty>[0m [0;36m o [1;37mSerial [0m [0;34m<empty>[0m [0;36m o [1;37mAsset [0m [0;34m<empty>[0m [0;36m o [1;37mModule time [0m 0.0712s [0;32m##### [1;37mipcam-wlan-master.fqdn.net [1839] completed poller modules at 2020-04-20 13:34:04[0;32m #####[0m [0m [0;32m o [1;37mGraphs [checked] [0m availability, ping, ping_snmp, uptime, la [0;32m o [1;37mPoller time [0m 0.3655 seconds Updating ipcam-wlan-master.fqdn.net - [1;44;96m > $update_array[0m[44;36m /opt/observium/includes/polling/functions.inc.php:468 [0m array( [uptime] => double(2766169) [last_polled] => array( [0] => string(5) "NOW()" ) [last_polled_timetaken] => double(0.3655) ) SQL[[0;33mUPDATE `devices` set `uptime` ='2766169',`last_polled` =NOW(),`last_polled_timetaken` ='0.3655' WHERE `device_id` = '1839'[0m][0m SQL RUNTIME[[0;32m0.00180101s[0m][0m [0;32m o [1;37mUpdated Data [0m uptime, last_polled, last_polled_timetaken SQL[[0;33mUPDATE `alert_table` set `state` ='{\"metrics\":{\"device_status\":\"1\"}}',`count` ='0',`alert_status` ='1',`last_message` ='Checks OK',`last_checked` ='1587382444',`last_ok` ='1587382444' WHERE `alert_table_id` = '465923'[0m][0m SQL RUNTIME[[0;32m0.00132012s[0m][0m RRD /opt/observium/rrd/ipcam-wlan-master.fqdn.net/alert-465923.rrd already exists - no need to create. RRD CMD[[0;33mupdate /opt/observium/rrd/ipcam-wlan-master.fqdn.net/alert-465923.rrd N:1:1[0m][0m RRD RUNTIME[[0;32m0.0011s[0m] RRD STDOUT[[0;32mOK u:0.00 s:0.00 r:0.36[0m] RRD_STATUS[[0;32mTRUE[0m] [0m SQL[[0;33mDELETE FROM `observium_processes` WHERE `process_pid` = '12469' AND `process_name` = 'poller.php' AND `device_id` = '1839'[0m][0m SQL RUNTIME[[0;32m0.00120902s[0m][0m ./poller.php: ipcam-wlan-master.fqdn.net - 1 devices polled in 0.459 secs [1;37m##### [1;37m[1;37mCompleted polling run at 2020-04-20 13:34:04[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.459 secs [1;37m o [1;37mMemory usage [0m 16MB (peak: 16MB) [1;37m o [1;37mMySQL Usage [0m Insert[1/0.001s] Update[2/0.003s] Delete[1/0.001s] Cell[4/0.001s] Row[7/0.001s] Rows[10/0.003s] Col[1/0s] (0.011s 2.459%) [1;37m o [1;37mRRDTool Usage [0m update[6/0.006s] (0.006s 1.411%) [1;37m o [1;37mSNMP Usage [0m snmpget[9/0.298s] (0.298s 64.957%)