- observium - lists.observium.org

Sensor issues since approx November 1st
by Anthony Somerset 02 Nov '18

02 Nov '18

Hi There I’m running a test bed of observium at home seperately of our main installation - i had previously written a very basic observium agent module that polls current power usage for a home monitoring sensor and outputs it, and then a custom polling module that reads this data and basically graphs it as a power sensor under a device (https://gist.github.com/anthonysomerset/3860b7a3b650d8bbbf53faac2d5eeab5 <https://gist.github.com/anthonysomerset/3860b7a3b650d8bbbf53faac2d5eeab5>) the unix-agent is working same as before but since i updated overnight on 1st november the graph has disappeared and my event log is filled up with sensor added events: also under the device itself the sensor is saying deleted around 5 days ago (2018-10-27 00:01:04) this looks like immediately after it updated on that day (looks like last commit on that day was 9517) any thoughts on how i need to fix? Kind regards, Anthony Somerset Somerset Technical Solutions Ltd. www.somersettechsolutions.co.uk Registered in the UK – Company no. 07738444 VAT Registration No: 140 6916 22 T: +44 (0) 33 0088 2751 E: anthony(a)somersettechsolutions.co.uk PGP: 0x7C892BF5

2 2

Observium Syslog issues
by David Rossi 01 Nov '18

01 Nov '18

I have an installation of Observium that has been up and running perfectly for about 18 months. Last Friday I ran updates and now syslog is no longer working. I have found that prior to the upgrade, rsyslog was version 7, now I am at Version 8. In searching I found that a few configuration file changes, I did those, and still a no go. Has anyone else come across this? I am a novice at Linux, and totally at a loss here. I can do a tcpdump and sure enough the syslog messages are hitting the server, but not displayed within Observium. Any help would be appreciated, but, please keep in mind I am a Centos novice. Dave Rossi.

4 11

Juniper
by Christian Eriksson 01 Nov '18

01 Nov '18

Hi, I have some MX104 routers and now there is a firewall button with some empty graphs. What is the meaning of this? :) [cid:image001.png@01D471D0.1A58CAF0] Regards Christian

2 1

Auto install script
by Scott L. Kaiser 31 Oct '18

31 Oct '18

2 1

New Device AKCP SensorProbe2Plus
by Stefan.Immel＠stroeher.de 31 Oct '18

31 Oct '18

We startet to use a SensorProbe2 Plus from AKCP but unfortunatly it is not yet supported by observium. Anybody out there who uses it too and has it implemented? If not, I'm looking for ways to integrate it but unfortunatly I cannot find the right files to do that. Where are the definitions that contain the mappings from sysObjectID to the right OS and MIBS?

1 0

Support for Dell Storage (Compellent)
by Thomas Stather 31 Oct '18

31 Oct '18

Hi I am using the professional edition of Observium and was wondering, if it supports Dell storage arrays. I am particularly interested in the Dell Compellent series as i have 2 of them in production. I have the official Dell MIBS ()MIB2014.01.29) and im willing to help if not implemented. Thanks in advance :) Best, Thomas -- Thomas Stather IT Services VCP4, VCP6-DCV, VCP6.5-DCV Tel: +49 6221-486 628 Fax: +49 6221-486 561 ------------------------------------------------------------------------ Max Planck Institute for Medical Research (MPImF) Jahnstrasse 29, 69120 Heidelberg Germany

2 1

Re: [Observium] Performance Issue - High CPU with 'mysqld'?
by Gordon Cheng (gocheng) 31 Oct '18

31 Oct '18

Thanks all. Yes, it's a new set up and a lot of new devices were added about 4 weeks ago. An update here. We just have the number of Cores increased from 4 to 16, and looks like there has been improvement in terms of performance now. But there is a new issue observed. Quite frequently (~1 out of 4 times), Observium is responding HTTP response code 500 with blank page when logging in, or when clicking around after login. Any thoughts or suggestions on this? Here are the logs when it happens: /opt/observium/logs/access_log: 171.68.241.12 - - [30/Oct/2018:21:29:53 -0700] "GET / HTTP/1.1" 500 1728 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10.13; rv:63.0) Gecko/20100101 Firefox/63.0" /opt/observium/logs/error_log: [Tue Oct 30 21:29:54.329931 2018] [:error] [pid 21511] [client 171.68.241.12:54771] PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 135168 bytes) in /opt/observium/includes/db/mysqli.inc.php on line 316 [cid:image001.png@01D47099.AD6D0FA0] Thanks. - Gordon From: observium <observium-bounces(a)observium.org> on behalf of Mike Stupalov via observium <observium(a)observium.org> Reply-To: Observium <observium(a)observium.org> Date: Sunday, October 28, 2018 at 4:09 AM To: Observium <observium(a)observium.org> Cc: Mike Stupalov <mike(a)observium.org> Subject: Re: [Observium] Performance Issue - High CPU with 'mysqld'? Simon Mousey Smith via observium wrote on 27/10/2018 23:55: Hi Gordon I think from what I can see from the pics, the 3rd graph along, bottom row It looks like about 3-4 weeks ago its JUMPED UP in the wrapper processing times which means its taking too long to execute on each device or the main server As I see, 4 weeks ago added many new devices. It's not should be big trouble, but seems as need more optimizations, like: - use rrdcached - switch to SSD disks for such number of devices - RRDs and DB must use faster disks, SSD is mandatory for you. Did you change any configs then? Any updates to hardware, software, etc? Have u also tried the latest stable ? 9472 Have u also tried doing /opt/observium/poller.php -h gz-core01 -dd to see where it might be getting stuck? Regards Simon On 26 Oct 2018, at 03:15, Gordon Cheng (gocheng) via observium <observium(a)observium.org<mailto:observium@observium.org>> wrote: Thanks Adam. Our pollerlog pages are below. Should we still try to disable fdb-table as suggested? If so, any docs we can follow to disable it? Any other thoughts or suggestions? Thanks. - Gordon <image001.png> <image002.png> <image003.png> From: observium <observium-bounces(a)observium.org<mailto:observium-bounces@observium.org>> on behalf of Adam Armstrong via observium <observium(a)observium.org<mailto:observium@observium.org>> Reply-To: Observium <observium(a)observium.org<mailto:observium@observium.org>> Date: Tuesday, October 23, 2018 at 12:50 PM To: Chris Neam via observium <observium(a)observium.org<mailto:observium@observium.org>> Cc: Adam Armstrong <adama(a)memetic.org<mailto:adama@memetic.org>> Subject: Re: [Observium] Performance Issue - High CPU with 'mysqld'? Hi, You probably (definitely) need more cores and/or more I/O throughput capacity. It's likely that you have multiple overlapping poller_wrapper processes running because they can't finish quickly enough. what do the graphs on this page look like? http://dev.observium.org/pollerlog/ and what are the slowest devices on this : http://dev.observium.org/pollerlog/view=devices/ You may be able to disable a module or two you don't care about that's taking time : http://dev.observium.org/pollerlog/view=modules/ fdb-table is usually a good candidate. adam. On 2018-10-23 19:54:32, Gordon Cheng (gocheng) via observium <observium(a)observium.org<mailto:observium@observium.org>> wrote: Hi all, I have a new Observium setup (verion 18.9.9428 (9th September 2018)) with the following VM spec: Cores 4 Memory 64GB HD 500GB CentOS 7 PHP 7.0.31 MySQL 5.5.60-MariaDB and with the following network devices to be monitored: Devices - 634 (total), 597 (up), 37 (down) Ports - 58,032 (total), 27,664 (up), 19,967 (down) Sensors - 47,639 (total), 43,243 (ok), 4,396 (down) Statuses - 5,880 (total), 5,854 (ok), 10 (alert) --- Issue is that we are frequently seeing the following error when connecting on GUI/CLI, with slow response time on GUI/CLI: DB Error 1040: Too many connections And we are seeing gaps (broken graphs) like the following: [cid:image001.png@01D46AC5.2F7A6900] We have tried to bump up the number of 'max_connections' from original 151 to 500 and then 200, but it didn't help: sjc-observium-1:/etc# grep max_conn my.cnf max_connections=200 sjc-observium-1:/etc# And it's observed that the CPU load is heavy with 'mysqld': top - 09:36:17 up 35 days, 18:54, 2 users, load average: 74.18, 89.49, 82.67 Tasks: 665 total, 79 running, 586 sleeping, 0 stopped, 0 zombie %Cpu(s): 62.9 us, 36.9 sy, 0.0 ni, 0.0 id, 0.0 wa, 0.0 hi, 0.2 si, 0.0 st KiB Mem : 65810376 total, 2511836 free, 5989292 used, 57309248 buff/cache KiB Swap: 4193020 total, 4141016 free, 52004 used. 59172312 avail Mem PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 5152 mysql 20 0 2749132 664216<tel:0%202749132%20664216> 9164 S 20.7 1.0 4058:17 mysqld 31879 root 20 0 419676 27564 8264 R 4.2 0.0 0:00.13 php 31769 root 20 0 417212 25532 8336 S 3.6 0.0 0:00.12 php 31933 root 20 0 416868 25116 8148 S 3.2 0.0 0:00.10 php 31935 root 20 0 416736 24700 7832 S 3.2 0.0 0:00.10 php <snip> My 'config.php' is pretty much with default values. --- I'm new to Observium. It'd be greatly appreciated if someone can shed some light how it can be resolved. Thanks. - Gordon _______________________________________________ observium mailing list observium(a)observium.org<mailto:observium@observium.org> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium _______________________________________________ observium mailing list observium(a)observium.org<mailto:observium@observium.org> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium -- Mike Stupalov Observium Limited, http://observium.org

2 1

Observium PRO - Last Update
by Serghei Golipad 30 Oct '18

30 Oct '18

Guys, has anyone updated to latest rolling? Now getting the following: Internal Server Error The server encountered an internal error or misconfiguration and was unable to complete your request. Please contact the server administrator at [no address given] to inform them of the time this error occurred, and the actions you performed just before this error. More information about this error may be available in the server error log. PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS EMAIL. CDW Limited is a Company registered in England and Wales. This email is sent for and on behalf of CDW Finance Holdings Limited. CDW Finance Holdings Limited is the UK holding company for CDW Limited trading as CDW. The registered office for CDW Finance Holdings Limited (Company Number 05872067) and its UK group undertakings is 10 Fleet Place, London, EC4M 7RB. VAT Registration 902 1949 39. Confidentiality: This e-mail contains proprietary information, some or all of which may be confidential and/or legally privileged. It is for the intended recipient only. If an addressing or transmission error has misdirected this e-mail, please notify the author by replying to this e-mail and then delete the original. If you are not the intended recipient you may not use, disclose, distribute, copy, print or rely on any information contained in this e-mail. You must not inform any other person other than CDW or the sender of its existence. For more information about CDW please visit www.uk.cdw.com

2 1

Performance Issue - High CPU with 'mysqld'?
by Gordon Cheng (gocheng) 26 Oct '18

26 Oct '18

Hi all, I have a new Observium setup (verion 18.9.9428 (9th September 2018)) with the following VM spec: Cores 4 Memory 64GB HD 500GB CentOS 7 PHP 7.0.31 MySQL 5.5.60-MariaDB and with the following network devices to be monitored: Devices - 634 (total), 597 (up), 37 (down) Ports - 58,032 (total), 27,664 (up), 19,967 (down) Sensors - 47,639 (total), 43,243 (ok), 4,396 (down) Statuses - 5,880 (total), 5,854 (ok), 10 (alert) --- Issue is that we are frequently seeing the following error when connecting on GUI/CLI, with slow response time on GUI/CLI: DB Error 1040: Too many connections And we are seeing gaps (broken graphs) like the following: [cid:image001.png@01D46AC5.2F7A6900] We have tried to bump up the number of 'max_connections' from original 151 to 500 and then 200, but it didn't help: sjc-observium-1:/etc# grep max_conn my.cnf max_connections=200 sjc-observium-1:/etc# And it's observed that the CPU load is heavy with 'mysqld': top - 09:36:17 up 35 days, 18:54, 2 users, load average: 74.18, 89.49, 82.67 Tasks: 665 total, 79 running, 586 sleeping, 0 stopped, 0 zombie %Cpu(s): 62.9 us, 36.9 sy, 0.0 ni, 0.0 id, 0.0 wa, 0.0 hi, 0.2 si, 0.0 st KiB Mem : 65810376 total, 2511836 free, 5989292 used, 57309248 buff/cache KiB Swap: 4193020 total, 4141016 free, 52004 used. 59172312 avail Mem PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 5152 mysql 20 0 2749132 664216 9164 S 20.7 1.0 4058:17 mysqld 31879 root 20 0 419676 27564 8264 R 4.2 0.0 0:00.13 php 31769 root 20 0 417212 25532 8336 S 3.6 0.0 0:00.12 php 31933 root 20 0 416868 25116 8148 S 3.2 0.0 0:00.10 php 31935 root 20 0 416736 24700 7832 S 3.2 0.0 0:00.10 php <snip> My 'config.php' is pretty much with default values. --- I'm new to Observium. It'd be greatly appreciated if someone can shed some light how it can be resolved. Thanks. - Gordon

2 2

DB and Polling issues after upgrading to r9505
by Christopher Smith 25 Oct '18

25 Oct '18

We had many devices not set to the correct location due to https://jira.observium.org/browse/OBS-2767 Updated to r9505 and after doing so we reset the geo location via web interface (device properties -> Geolocation -> Reset GEO location) On any device that this was done to it seems like they do not exist to the poller any longer, none have been polled since the above action was taken. I based this info from the Per Device stats in the Pollerlog section (all of the devices that had their geo location reset were last polled 5+ hours ago, everything else that was not touched are being polled as expected every 5 minutes) I see these errors in the db.log file, they appear to have shown up when the Reset GEO location operation was done on each device: [2018/10/24 14:48:43 -0400] index.php(4115): Failed dbQuery (#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE `location_id` = ?' at line 1), Query: UPDATE `devices_locations` set WHERE `location_id` = ? [2018/10/24 14:49:44 -0400] index.php(9439): Failed dbQuery (#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE `location_id` = ?' at line 1), Query: UPDATE `devices_locations` set WHERE `location_id` = ? [2018/10/24 14:50:23 -0400] index.php(9439): Failed dbQuery (#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE `location_id` = ?' at line 1), Query: UPDATE `devices_locations` set WHERE `location_id` = ? [2018/10/24 14:50:57 -0400] index.php(44932): Failed dbQuery (#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE `location_id` = ?' at line 1), Query: UPDATE `devices_locations` set WHERE `location_id` = ? [2018/10/24 14:51:28 -0400] index.php(25685): Failed dbQuery (#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE `location_id` = ?' at line 1), Query: UPDATE `devices_locations` set WHERE `location_id` = ? [2018/10/24 14:52:29 -0400] index.php(25888): Failed dbQuery (#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE `location_id` = ?' at line 1), Query: UPDATE `devices_locations` set WHERE `location_id` = ? Observium system info: Observium 18.10.9505 (24th October 2018) OS Linux 3.10.0-862.3.3.el7.x86_64 [amd64] (CentOS 7) Apache 2.4.6 (CentOS) OpenSSL/1.0.2k-fips PHP/7.0.31 PHP 7.0.31 (OPcache: ENABLED) Python 2.7.5 MySQL 5.5.56-MariaDB (extension: mysqli 5.5.56-MariaDB) SNMP NET-SNMP 5.7.2 RRDtool 1.6.0 Fping 3.10 (IPv4 only)

2 2