DEBUG! SQL[ [0;33mSELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'dbSchema'; [0m] [0m SQL RUNTIME[ [0;32m0.00012302s [0m] [0m SQL[ [0;33mSELECT @@SESSION.sql_mode; [0m] [0m SQL RUNTIME[ [0;32m0.00039983s [0m] [0m SQL[ [0;33mSELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'current_rev'; [0m] [0m SQL RUNTIME[ [0;32m0.00007010s [0m] [0m SQL[ [0;33mSELECT * FROM `config` [0m] [0m SQL RUNTIME[ [0;32m0.00007415s [0m] [0m CMD[ [0;33m/bin/hostname -f [0m] [0m CMD EXITCODE[ [0;32m0 [0m] CMD RUNTIME[ [0;32m0.0043s [0m] [0m STDOUT[ cplanning.telecel.net.py ] [0m [1;37m ___ _ _ / _ \ | |__ ___ ___ _ __ __ __(_) _ _ _ __ ___ | | | || '_ \ / __| / _ \| '__|\ \ / /| || | | || '_ ` _ \ | |_| || |_) |\__ \| __/| | \ V / | || |_| || | | | | | \___/ |_.__/ |___/ \___||_| \_/ |_| \__,_||_| |_| |_| [0;36m Observium Professional 0.16.8.8068 http://www.observium.org [0m [0m CMD[ [0;33m/opt/observium-it/scripts/distro [0m] [0m CMD EXITCODE[ [0;32m0 [0m] CMD RUNTIME[ [0;32m0.053s [0m] [0m STDOUT[ Linux|3.0.101-0.7.17-default|amd64|SUSE LINUX|11 ] [0m CMD[ [0;33m/usr/bin/env python --version 2>&1 [0m] [0m CMD EXITCODE[ [0;32m0 [0m] CMD RUNTIME[ [0;32m0.0057s [0m] [0m STDOUT[ Python 2.6.9 ] [0m SQL[ [0;33mSELECT version(); [0m] [0m SQL RUNTIME[ [0;32m0.00017595s [0m] [0m CMD[ [0;33m/usr/bin/snmpget --version 2>&1 [0m] [0m CMD EXITCODE[ [0;32m0 [0m] CMD RUNTIME[ [0;32m0.0028s [0m] [0m STDOUT[ NET-SNMP version: 5.4.2.1 ] [0m CMD[ [0;33m/usr/bin/rrdtool --version | head -n1 [0m] [0m CMD EXITCODE[ [0;32m0 [0m] CMD RUNTIME[ [0;32m0.0068s [0m] [0m STDOUT[ RRDtool 1.4.7 Copyright 1997-2012 by Tobias Oetiker ] [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.0037s [0m] [0m STDOUT[ ] [0m CMD[ [0;33m/usr/bin/env httpd -v | awk '/Server version:/ {print $3}' [0m] [0m CMD EXITCODE[ [0;32m0 [0m] CMD RUNTIME[ [0;32m0.0036s [0m] [0m STDOUT[ ] [0m CMD[ [0;33mdate "+%:z" [0m] [0m CMD EXITCODE[ [0;32m0 [0m] CMD RUNTIME[ [0;32m0.003s [0m] [0m CMD EXITDELAY[ [0;31m10ms [0m] [0m STDOUT[ -04:00 ] [0m SQL[ [0;33mSELECT TIMEDIFF(NOW(), UTC_TIMESTAMP); [0m] [0m SQL RUNTIME[ [0;32m0.00027299s [0m] [0m SQL[ [0;33mSELECT @@SESSION.sql_mode; [0m] [0m SQL RUNTIME[ [0;32m0.00035810s [0m] [0m SQL[ [0;33mSHOW VARIABLES LIKE 'character_set_connection' [0m] [0m SQL RUNTIME[ [0;32m0.00074220s [0m] [0m [0;36m##### [1;37mSoftware versions [0;36m ##### [0m [0m [0;36m o [1;37mOS [0m Linux 3.0.101-0.7.17-default [amd64] (SUSE LINUX 11) [0;36m o [1;37mApache [0m not found [0;36m o [1;37mPHP [0m 5.6.9 (OPcache: DISABLED) [0;36m o [1;37mPython [0m 2.6.9 [0;36m o [1;37mMySQL [0m 5.6.27-log (extension: mysqli 5.0.11-dev) [0;36m o [1;37mSNMP [0m NET-SNMP 5.4.2.1 [0;36m o [1;37mRRDtool [0m 1.4.7 [0;35m##### [1;37mMySQL mode [0;35m ##### [0m [0m [0;35m o [1;37mMySQL [0m 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 Friday, 23-Sep-16 10:26:25 PYT [0;35m o [1;37mPHP [0m -04:00 [0;35m o [1;37mMySQL [0m -04:00 SQL[ [0;33mSELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'last_versioncheck'; [0m] [0m SQL RUNTIME[ [0;32m0.00011206s [0m] [0m SQL[ [0;33mSELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'latest_rev'; [0m] [0m SQL RUNTIME[ [0;32m0.00008297s [0m] [0m SQL[ [0;33mSELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'latest_ver'; [0m] [0m SQL RUNTIME[ [0;32m0.00007701s [0m] [0m SQL[ [0;33mSELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'latest_rev_date'; [0m] [0m SQL RUNTIME[ [0;32m0.00007486s [0m] [0m [1;32mThere is a newer revision of Observium available! [0m [0m [1;32mVersion [0;31m0.16.9.8086 [1;32m (23rd September 2016) is [0;31m18 [1;32m revisions ahead. [0m [0m [1;37m##### [1;37m [1;37mStarting discovery run at 2016-09-23 10:26:25 [1;37m ##### [0m [0m SQL[ [0;33mSELECT * FROM `devices` WHERE `status` = 1 AND `disabled` = 0 AND `device_id` = '2003' ORDER BY `last_discovered_timetaken` ASC [0m] [0m SQL RUNTIME[ [0;32m0.00056100s [0m] [0m CMD[ [0;33m/usr/bin/snmpget -v2c -c *** -Pu -OQUst -m SNMPv2-MIB -M /opt/observium-it/mibs/rfc:/opt/observium-it/mibs/net-snmp 'udp':'py-4m-rbt-test-1.telecel.net.py':'161' sysObjectID.0 sysUpTime.0 [0m] [0m CMD EXITCODE[ [0;32m0 [0m] CMD RUNTIME[ [0;32m0.0197s [0m] [0m CMD EXITDELAY[ [0;31m10ms [0m] [0m STDOUT[ sysObjectID.0 = enterprises.8072.3.2.10 sysUpTime.0 = 3652034032 ] [0m SNMP STATUS[ [0;32mTRUE [0m] [0m SQL[ [0;33mSELECT * FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '2003' [0m] [0m SQL RUNTIME[ [0;32m0.00059795s [0m] [0m SQL[ [0;33mSELECT * FROM `observium_processes` WHERE `process_name` = 'discovery.php' AND `device_id` = '2003' [0m] [0m SQL RUNTIME[ [0;32m0.00072217s [0m] [0m CMD[ [0;33m/bin/ps -ww -o pid,ppid,uid,gid,tty,stat,time,lstart,args -p 26697 [0m] [0m CMD EXITCODE[ [0;32m0 [0m] CMD RUNTIME[ [0;32m0.0905s [0m] [0m CMD EXITDELAY[ [0;31m10ms [0m] [0m STDOUT[ PID PPID UID GID TT STAT TIME STARTED COMMAND 26697 17983 30 8 pts/4 S+ 00:00:00 Fri Sep 23 10:26:24 2016 php /opt/observium-it/discovery.php -h 2003 -m storage -d ] [0m SQL[ [0;33mINSERT INTO `observium_processes` (`process_pid`,`process_name`,`process_ppid`,`process_uid`,`process_command`,`process_start`,`device_id`) VALUES ('26697','discovery.php','17983','30','php /opt/observium-it/discovery.php -h 2003 -m storage -d','1474640784','2003') [0m] [0m SQL RUNTIME[ [0;32m0.00039697s [0m] [0m [0;32m##### [1;37mpy-4m-rbt-test-1.telecel.net.py [2003] [0;32m ##### [0m [0m [0;32m o [1;37mOS Type [0m linux [0;32m o [1;37mOS Group [0m unix [0;32m o [1;37mSNMP Version [0m v2c [0;32m o [1;37mLast discovery [0m 2016-09-23 10:25:47 [0;32m o [1;37mLast duration [0m 0.24 seconds [0;36m##### [1;37mModule Start: [1;31mstorage [0;36m ##### [0m [0m Storage : SQL[ [0;33mSELECT * FROM `observium_attribs` [0m] [0m SQL RUNTIME[ [0;32m0.00018811s [0m] [0m UCD-SNMP-MIB CMD[ [0;33m/usr/bin/snmpbulkwalk -v2c -c *** -Pu -OQUs -m UCD-SNMP-MIB -M /opt/observium-it/mibs/rfc:/opt/observium-it/mibs/net-snmp 'udp':'py-4m-rbt-test-1.telecel.net.py':'161' dskEntry [0m] [0m CMD EXITCODE[ [0;32m0 [0m] CMD RUNTIME[ [0;32m0.0616s [0m] [0m STDOUT[ dskIndex.1 = 0 dskPath.1 = / dskDevice.1 = /dev/mapper/VolGroup00-LogVol00 dskMinimum.1 = 100000 dskMinPercent.1 = -1 dskTotal.1 = 549641952 dskAvail.1 = 473473312 dskUsed.1 = 47798108 dskPercent.1 = 9 dskPercentNode.1 = 0 dskTotalLow.1 = 549641952 dskTotalHigh.1 = 0 dskAvailLow.1 = 473473312 dskAvailHigh.1 = 0 dskUsedLow.1 = 47798108 dskUsedHigh.1 = 0 dskErrorFlag.1 = noError dskErrorMsg.1 = ] [0m SNMP STATUS[ [0;32mTRUE [0m] [0m HOST-RESOURCES-MIB CMD[ [0;33m/usr/bin/snmpbulkwalk -v2c -c *** -Pu -OQUs -m HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES -M /opt/observium-it/mibs/rfc:/opt/observium-it/mibs/net-snmp 'udp':'py-4m-rbt-test-1.telecel.net.py':'161' hrStorageEntry [0m] [0m CMD EXITCODE[ [0;32m0 [0m] CMD RUNTIME[ [0;32m0.0299s [0m] [0m CMD EXITDELAY[ [0;31m10ms [0m] [0m STDOUT[ hrStorageIndex.1 = 1 hrStorageIndex.3 = 3 hrStorageIndex.6 = 6 hrStorageIndex.7 = 7 hrStorageIndex.10 = 10 hrStorageIndex.31 = 31 hrStorageIndex.35 = 35 hrStorageIndex.36 = 36 hrStorageIndex.41 = 41 hrStorageType.1 = hrStorageRam hrStorageType.3 = hrStorageVirtualMemory hrStorageType.6 = hrStorageOther hrStorageType.7 = hrStorageOther hrStorageType.10 = hrStorageVirtualMemory hrStorageType.31 = hrStorageNetworkDisk hrStorageType.35 = hrStorageFixedDisk hrStorageType.36 = hrStorageFixedDisk hrStorageType.41 = hrStorageNetworkDisk hrStorageDescr.1 = Physical memory hrStorageDescr.3 = Virtual memory hrStorageDescr.6 = Memory buffers hrStorageDescr.7 = Cached memory hrStorageDescr.10 = Swap space hrStorageDescr.31 = / hrStorageDescr.35 = /boot hrStorageDescr.36 = /dev/shm hrStorageDescr.41 = /audios/voicemails hrStorageAllocationUnits.1 = 1024 hrStorageAllocationUnits.3 = 1024 hrStorageAllocationUnits.6 = 1024 hrStorageAllocationUnits.7 = 1024 hrStorageAllocationUnits.10 = 1024 hrStorageAllocationUnits.31 = 4096 hrStorageAllocationUnits.35 = 1024 hrStorageAllocationUnits.36 = 4096 hrStorageAllocationUnits.41 = 32768 hrStorageSize.1 = 16436564 hrStorageSize.3 = 34917708 hrStorageSize.6 = 16436564 hrStorageSize.7 = 12781728 hrStorageSize.10 = 18481144 hrStorageSize.31 = 137410488 hrStorageSize.35 = 101086 hrStorageSize.36 = 2054570 hrStorageSize.41 = 17176311 hrStorageUsed.1 = 16374696 hrStorageUsed.3 = 16374984 hrStorageUsed.6 = 266316 hrStorageUsed.7 = 12781728 hrStorageUsed.10 = 288 hrStorageUsed.31 = 11949527 hrStorageUsed.35 = 12518 hrStorageUsed.36 = 0 hrStorageUsed.41 = 10660240 ] [0m SNMP STATUS[ [0;32mTRUE [0m] [0m > $cache_discovery['host-resources-mib'] - > /opt/observium-it/includes/discovery/storage.inc.php:19 /opt/observium-it/includes/discovery/storage/host-resources-mib.inc.php:21 ======================================================================================= array( [1] => array( [hrStorageIndex] => string(1) "1" [hrStorageType] => string(12) "hrStorageRam" [hrStorageDescr] => string(15) "Physical memory" [hrStorageAllocationUnits] => string(4) "1024" [hrStorageSize] => string(8) "16436564" [hrStorageUsed] => string(8) "16374696" ) [3] => array( [hrStorageIndex] => string(1) "3" [hrStorageType] => string(22) "hrStorageVirtualMemory" [hrStorageDescr] => string(14) "Virtual memory" [hrStorageAllocationUnits] => string(4) "1024" [hrStorageSize] => string(8) "34917708" [hrStorageUsed] => string(8) "16374984" ) [6] => array( [hrStorageIndex] => string(1) "6" [hrStorageType] => string(14) "hrStorageOther" [hrStorageDescr] => string(14) "Memory buffers" [hrStorageAllocationUnits] => string(4) "1024" [hrStorageSize] => string(8) "16436564" [hrStorageUsed] => string(6) "266316" ) [7] => array( [hrStorageIndex] => string(1) "7" [hrStorageType] => string(14) "hrStorageOther" [hrStorageDescr] => string(13) "Cached memory" [hrStorageAllocationUnits] => string(4) "1024" [hrStorageSize] => string(8) "12781728" [hrStorageUsed] => string(8) "12781728" ) [10] => array( [hrStorageIndex] => string(2) "10" [hrStorageType] => string(22) "hrStorageVirtualMemory" [hrStorageDescr] => string(10) "Swap space" [hrStorageAllocationUnits] => string(4) "1024" [hrStorageSize] => string(8) "18481144" [hrStorageUsed] => string(3) "288" ) [31] => array( [hrStorageIndex] => string(2) "31" [hrStorageType] => string(20) "hrStorageNetworkDisk" [hrStorageDescr] => string(1) "/" [hrStorageAllocationUnits] => string(4) "4096" [hrStorageSize] => string(9) "137410488" [hrStorageUsed] => string(8) "11949527" ) [35] => array( [hrStorageIndex] => string(2) "35" [hrStorageType] => string(18) "hrStorageFixedDisk" [hrStorageDescr] => string(5) "/boot" [hrStorageAllocationUnits] => string(4) "1024" [hrStorageSize] => string(6) "101086" [hrStorageUsed] => string(5) "12518" ) [36] => array( [hrStorageIndex] => string(2) "36" [hrStorageType] => string(18) "hrStorageFixedDisk" [hrStorageDescr] => string(8) "/dev/shm" [hrStorageAllocationUnits] => string(4) "4096" [hrStorageSize] => string(7) "2054570" [hrStorageUsed] => string(1) "0" ) [41] => array( [hrStorageIndex] => string(2) "41" [hrStorageType] => string(20) "hrStorageNetworkDisk" [hrStorageDescr] => string(18) "/audios/voicemails" [hrStorageAllocationUnits] => string(5) "32768" [hrStorageSize] => string(8) "17176311" [hrStorageUsed] => string(8) "10660240" ) ) skip(network) 2003 -> 35, hrStorageFixedDisk, HOST-RESOURCES-MIB, /boot, 1024, 103512064, 12818432, 0 SQL[ [0;33mSELECT * FROM `storage` WHERE `device_id` = '2003' AND `storage_index` = '35' AND `storage_mib` = 'host-resources-mib' [0m] [0m SQL RUNTIME[ [0;32m0.00016594s [0m] [0m .2003 -> 36, hrStorageFixedDisk, HOST-RESOURCES-MIB, /dev/shm, 4096, 8415518720, 0, 0 SQL[ [0;33mSELECT * FROM `storage` WHERE `device_id` = '2003' AND `storage_index` = '36' AND `storage_mib` = 'host-resources-mib' [0m] [0m SQL RUNTIME[ [0;32m0.00009298s [0m] [0m .skip(network) - /opt/observium-it/discovery.php:183 /opt/observium-it/includes/discovery/storage.inc.php:21 ================================================ array( [host-resources-mib] => array( [35] => string(5) "/boot" [36] => string(8) "/dev/shm" ) ) SQL[ [0;33mSELECT * FROM `storage` WHERE `device_id` = '2003' [0m] [0m SQL RUNTIME[ [0;32m0.00010490s [0m] [0m 35 -> host-resources-mib 36 -> host-resources-mib [0;36m o [1;37mDuration [0m 0.118s SQL[ [0;33mUPDATE `devices` set `last_discovered` =NOW(),`type` ='server',`last_discovered_timetaken` ='0.227',`force_discovery` ='0' WHERE `device_id` = '2003' [0m] [0m SQL RUNTIME[ [0;32m0.00067520s [0m] [0m SQL[ [0;33mINSERT INTO `devices_perftimes` (`device_id`,`operation`,`start`,`duration`) VALUES ('2003','discover','1474640785.2589','0.22737598419189') [0m] [0m SQL RUNTIME[ [0;32m0.00044203s [0m] [0m [0;32m##### [1;37mpy-4m-rbt-test-1.telecel.net.py [2003] completed discovery modules at 2016-09-23 10:26:25 [0;32m ##### [0m [0m [0;32m o [1;37mDiscovery time [0m 0.227 seconds SQL[ [0;33mDELETE FROM `observium_processes` WHERE `process_pid` = '26697' AND `process_name` = 'discovery.php' AND `device_id` = '2003' [0m] [0m SQL RUNTIME[ [0;32m0.00040221s [0m] [0m [1;37m##### [1;37m [1;37mFinished discovery run at 2016-09-23 10:26:25 [1;37m ##### [0m [0m SQL[ [0;33mINSERT INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`) VALUES ('discover','2003','1474640785.106','0.385','1') [0m] [0m SQL RUNTIME[ [0;32m0.00019908s [0m] [0m /opt/observium-it/discovery.php: py-4m-rbt-test-1.telecel.net.py - 1 devices discovered in 0.385 secs 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.385 secs [1;37m o [1;37mMemory usage [0m 9.25MB (peak: 9.25MB) [1;37m o [1;37mMySQL Usage [0m Cell[4/0.003s] Row[8/0.005s] Rows[7/0.006s] Column[0/0s] Update[1/0.001s] Insert[3/0.002s] Delete[1/0.002s] [1;37m o [1;37mRRDTool Usage [0m