- observium - lists.observium.org

Forcing location based on IP
by Pieter De Wit 27 May '19

27 May '19

Hi Guys, I would like to insert location data based on the IP address, but I want to write a script that will auto update this into the DB. We are adding 100s of devices over the next few months, some on them doesn't support SNMP Location (yeah, I know....) We have decided to just override the location in Observium for all systems, even if they support it or not. By the looks of it, the data goes into devices_locations ? Thanks ! Pieter De Wit

1 0

Geolocation - API Endpoints missing in MySQL config table
by Chris Macneill 26 May '19

26 May '19

Oh no, not me again!! In my recent post I alluded to an issue I was having with Geolocation. After installing Observium CE v2018.9, I couldn't get Geolocation to work with the default setup, so I changed to Google as I already had an API Key setup for other purposes. However, Geolocation still failed to do anything. After looking in Jira, there seem to be a number of posts on this subject, all closed off with no resolution. For anyone out there that still has an issue with Google Geolocation, then I've found what the problem is. This may also solve the issue for other Geolocation APIs too. By the way, before I get started on the solution, I've opened a new bug in Jira (OBS-3022), so hopefully this will get fixed. So, digging into the PHP code, I finally worked out that the API Endpoint URLs are stored in MySQL "config" table. Except, they weren't, "direct_url" and "reverse_url" were missing from the "config" table. I would think that if you select Google as the API provider in the GUI, that the "config" table should be populated with the correct URLs. Nothing in any documentation states that config.php needs anything added manually to cause MySQL to be populated. There may actually be an easier way to achieve this by entering values in config.php, however I've only been digging around in the PHP code for less than 2 days and I haven't fully got my head around how Observium does things yet. So my solution involves getting your hands dirty with MySQL / SQL. To fix the problem manually for Google and potentially other API providers, do the following:- 1. SSH to your Observium host or login to the CLI if you're local. 2. I'm a bit naughty I tend to do everything in a "root" shell, so if you login as non-root you'll probably need to su or sudo to user observium or the owner of the MySQL database first. 3. Connect to MySQL using - mysql observium (don't include the " - ", that just to separate the description from the command) 4. Check the current contents of "config" table - select * from config; (for those of you unfamiliar with SQL the ";" is absolutely required) 5. For the Google Geolocation APIs to work there should be two entries as below:- | geocoding|direct_url | s:49:"https://maps.googleapis.com/maps/api/geocode/json"; | | geocoding|reverse_url | s:49:"https://maps.googleapis.com/maps/api/geocode/json"; | 6. If these are missing or different, then Google API will fail. At this point you either need to insert/update the Google API Endpoint URLs in the table or URLs that are appropriate to the API you want to use. 7. If missing, to enter for Google, do the following in MySQL. You can copy and paste, both lines are required:- insert into config (config_key,config_value) values ('geocoding|direct_url','s:49:"https://maps.googleapis.com/maps/api/geocode/json";'); insert into config (config_key,config_value) values ('geocoding|reverse_url','s:49:"https://maps.googleapis.com/maps/api/geocode/json";'); 8. If entries are there, but wrong urls, do:- update config set config_value = 's:49:"https://maps.googleapis.com/maps/api/geocode/json"' where config_key = 'geocoding|direct_url' or config_key = 'geocoding|reverse_url'; 9. To enter different URLs you will likely have to change the s:49 value at the beginning. The value 49 is the count of characters in the URL between the double quotes, do not include the double quotes in the count. 10. If the URLs for the Geolocation API you want to use are different for direct and reverse lookups, then you will need a slightly different update statement in step 8. 11. I'm not going to tell you how to delete the entries, as this is a bit dangerous if you don't know what you're doing. So you either know anyway or go read up about MySQL and practice on a dummy table first. In any case there should be no reason to delete anything, unless the table is really in a mess. 12. To close MySQL CLI, enter quit or exit or press CTRL-C. 13. Lastly, don't panic if things don't seem to work immediately, for some reason it seemed to take a while for poller.php to start using the new config and this wasn't just the 5 minute delay of the crontab timings. 14. I actually purged all records from the "devices_locations" table to force all locations to be regenerated, but this is not a good idea if you've added manual lat/long coordinates. If your SNMP sysLocation cannot be converted by the Geolocation API and you've purged the locations table, all your "flags" will end up at the default lat/long, assuming you've configured one. Regards Chris Macneill Web: www.cmit.nz

2 4

System Uptime (sysUpTime) OID incorrect for some systems
by Chris Macneill 26 May '19

26 May '19

I'm observing a problem with some systems being reported as having rebooted at odd times, which are completely unrelated to reality. The GUI claims the system uptime is derived from the OID sysUpTime, however I can't find this OID in any MIB, maybe an internal label in Observium? In actuality Observium seems to be using the 1st OID below, but as can be seen from the 2nd OID the two seem totally unrelated. In the case of this particular system, the 2nd OID value is when it was rebooted, the 1st one seems to have no correlation to the reboot time. DISMAN-EVENT-MIB::sysUpTimeInstance = Timeticks: (376806) 1:02:48.06 HOST-RESOURCES-MIB::hrSystemUptime.0 = Timeticks: (13560578) 1 day, 13:40:05.78 Is there anyway to change the OID on a per device basis that is used to display and monitor System Uptime? Observium CE 18.9.9420 (5th September 2018) OS Linux 4.9.0-8-amd64 [amd64] (Debian 9 (stretch)) Apache 2.4.25 (Debian) PHP 7.0.33-0+deb9u3 (OPcache: ENABLED) Python 2.7.13 MySQL 10.1.37-MariaDB-0+deb9u1 (extension: mysqli 5.0.12-dev) SNMP NET-SNMP 5.7.3 RRDtool 1.6.0 Fping 3.15 (IPv4 and IPv6) Regards Chris Macneill Web: www.cmit.nz

3 11

Maillist Archive Link Broken
by Chris Macneill 24 May '19

24 May '19

The link to the maillist archive on the setup page is currently broken, thus no way to check if something has been asked before. Regards Chris Macneill Web: www.cmit.nz

1 0

PDU current alert problem
by Laszlo Nemeth 22 May '19

22 May '19

Hi all, I am on the latest 9906 version. I have an alarm witch check the PDU's load. The aim is if the load is over 7 (amper) and the bank name is not "Bank total" i would like to get an alarm. I set up this: [cid:part1.62B9BA30.A1603765@emarsys.com] The checked device is an APC 7922: [cid:part2.6337A692.66074698@emarsys.com] And the alert is not alarm me but the load in BANK2 is over the 7 value: [cid:part3.64448580.5E894299@emarsys.com] What i did wrong? Just for a test i did an another alert where is a condiition is the sensor_desc is not contain the Bank part but all listed sensors has a Bank text: [cid:part4.81956E86.52888D2A@emarsys.com] Thanks Laszlo

3 3

Deleting devices and rrd removal
by Joelly, Alexander 21 May '19

21 May '19

Hello, When deleting a device, should the rdd's from that device also be deleted immediately or is this done from housekeeping ? Removed devices yesterday and wondering that the rrd files are still there. Thanks, Alex

2 1

Sorting group results
by Pieter De Wit 21 May '19

21 May '19

Hi, Would it be possible to sort the group display on device name like the main display please ? *Kind Regards,* *Pieter De Wit*

1 0

GUI and Locations listing
by Joelly, Alexander 20 May '19

20 May '19

Hello, In the web gui - devices - locations the entries are sorted by country. The list is longer that can be displayed and some entries cannot be accessed from here - is it possible to make that scrollable? Thanks, Alex

2 1

AUTO DISCOVERY
by HARESH KHANNA 19 May '19

19 May '19

Please guide for auto discovery process from web . Regards Haresh

3 3

Auto Discovery
by HARESH KHANNA 17 May '19

17 May '19

Kindly guide through Auto Discovery via web UI Regards, Haresh Khanna

1 0