- observium - lists.observium.org

SQL Query
by Andrew Lemin 06 Jul '18

06 Jul '18

Hi Adam, Hope you are well. Just a quick question about the Observium database schema. I need to write a simple query that will return a list of device names and the IP addresses which Observium uses for its polling (we don’t need or want any other addresses). I had a look and found tables ‘devices’ and ‘ipv4_addresses’. And I can see the device_id foreign key etc, so obtaining all the IPs for a device is trivial enough. But I am not sure how to best filter for just the IP which Observium uses for polling. I recently built a DNS zone for our network team using PowerDNS, and I just need to export all the devices and their management IPs from Observium, so I can inject the records into PowerDNS. So nothing fancy, but we have a couple hundred records.. Kind regards, Andy Lemin

2 1

Re: [Observium] Observium Graph issue
by Balaji-NOC Engineer 06 Jul '18

06 Jul '18

Dear Team, After adding 400 devices in our observium pro version we are getting drops in our graph. Kindly help us to resolve this issue. Thanks & Regards…. K.Balaji NOC-Engineer Corporate Address: No:38/11 | Status Quo | 4th floor | Sterling Road | Nungambakkam | PH. 9940570099 |Chennai-600034 | 044 61556666 | Mail: noc_team(a)ficustelecom.in | Web: http://www.ficustelecom.com Note:: For further any services related issue, Kindly reach us on 044 61556666 /9677055555 or noc_team(a)ficustelecom.in /noc(a)ficustelecom.com

2 1

Re: [Observium] SQL Query
by Mike Stupalov 06 Jul '18

06 Jul '18

Hi, devices polling not use tables with *_addresses, only hostnames. Hostnames resolve IP during polling by DNS query (or system hosts file). > Andrew Lemin <mailto:AndrewL@4d-dc.com> > 6 July 2018 at 12:36 > > Hi Adam, > > Hope you are well. > > Just a quick question about the Observium database schema. > > I need to write a simple query that will return a list of device names > and the IP addresses which Observium uses for its polling (we don’t > need or want any other addresses). > > I had a look and found tables ‘devices’ and ‘ipv4_addresses’. > > And I can see the device_id foreign key etc, so obtaining /all/ the > IPs for a device is trivial enough. But I am not sure how to best > filter for just the IP which Observium uses for polling. > > I recently built a DNS zone for our network team using PowerDNS, and I > just need to export all the devices and their management IPs from > Observium, so I can inject the records into PowerDNS. So nothing > fancy, but we have a couple hundred records.. > > Kind regards, Andy Lemin > > > > _______________________________________________ > observium mailing list > observium(a)observium.org > http://postman.memetic.org/cgi-bin/mailman/listinfo/observium -- Mike Stupalov Observium Limited, http://observium.org

2 1

Using professional edition license for testing
by Erdem HAKI 06 Jul '18

06 Jul '18

Hello, I want to migrate Observium professional edition to a new server, my plan is to install everything and testing them on the new box before moving data(rrd, database etc.). I saw "The subscription license is valid for a single production installation and two testing or development installations." on the page so I want to make sure that how should I handle license operation. I only can see one user/pass for my subscription when I logged in. Can I use it on the new box to download another Observium professional edition and test my build before moving data while my production Observium is still operational? Best

2 1

Possibility to disable/enable syslog view for user
by Klimek, Denis 04 Jul '18

04 Jul '18

Hi, what would you think about adding another permission level to disable/enable the possibility to view the syslog entries of a device? We have the situation that some external users must have access to specific devices and graphs, but this also includes syslog entries... and we simply do not want to show them this log entries i.e. cli commands that have been executed. Mit freundlichem Gruß Stadtwerke Norderstedt Denis Klimek Professional Network Engineer IP-Systemtechnik Tel: 040 / 521 04 - 1049 Mobil: 0151 / 652 219 06 dklimek(a)stadtwerke-norderstedt.de<mailto:dklimek@stadtwerke-norderstedt.de> www.stadtwerke-norderstedt.de<http://www.stadtwerke-norderstedt.de/>

1 0

average trend line to the aggregate storage graphs
by Richard Wigzell 04 Jul '18

04 Jul '18

Hi, is it possible to add an average trend line to the aggregate storage graphs? Similar to what is on the standard usage Graph. We are looking for a way to do some simple and rough storage growth prediction for an number of volumes as an aggregate. If this is something we could do natively with Observium that would be great but if anyone has done something similar with the RRDs and can share that would also be good. [cid:image001.png@01D41347.5FD8B370] [cid:image002.png@01D41347.C1A5EEB0] Regards [cid:image001.jpg@01CE9215.D39244B0]<https://www.it.ox.ac.uk/> Richard Wigzell Technical Lead, Storage Platforms IT Services | University of Oxford 13 Banbury Road, Oxford OX2 6NN T: 01865 616282 www.it.ox.ac.uk<https://www.it.ox.ac.uk/>

1 0

Cisco ADSL port only shows one speed
by Tim Bates 03 Jul '18

03 Jul '18

Hello experts.... I have 2 Cisco routers with ADSL ports. Observium is showing the low (outbound) speed on these ports, however I am more interested in the higher (inbound) speed. When we have line problems, the outbound speed generally doesn't change much (maybe by a few kbps), but the inbound can drop from ~7mbps to under 1mbps. This drastic inbound speed change is what I'd like to monitor, graph and get alerts on... Is there a way to get the other speed to show instead (or in addition)? I can see the Cisco ADSL MIB listed, and enabled, but this is obviously not enough. I can't see any other obvious settings, and Google was not my friend on this one. TB

2 2

Graphs for Juniper SRX Showing incorrect speed spike
by TAN Lists 03 Jul '18

03 Jul '18

Hey All, I have a weird issue with some interface graphs for a SRX240H where it will show the speed spiking to 10+GB/s on a 1GB/s port and for the life of me, I can't figure out why. https://pasteboard.co/Hss2xMm.png Observium I think is polling the 32 bit OIDs, but the webUI says it is 64bit Polling with Cacti shows correct traffic on both 32 and 64 bit OIDs - https://pasteboard.co/Hss2agw.png I also see a similar issue with a SRX110H where the VDSL interface (which is hard capped to 12MB/s) is showing 50+MB/s which is not possible. https://pasteboard.co/Hss2kcf.png Not sure how else to debug this, I have a feeling that this might be an issue within Observium, but advice appreciated. Devices are: Juniper SRX240H JunOS 12.1X46-D72.2 (Internet Router) Juniper SRX110H2-VA JunOS 12.3X48-D55.4 (Internet Router) Version Information *Observium CE* 17.9.0 (25th September 2017) *OS* Linux 3.10.0-862.3.2.el7.x86_64 [amd64] (CentOS 7) *Apache* 2.4.6 (CentOS) OpenSSL/1.0.2k-fips mod_fcgid/2.3.9 PHP/5.6.36 *PHP* 5.6.36 *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 Thoughts on fixing / troubleshooting appreciated Have tried deleting devices and re-adding, beyond that, not sure what else to do.

2 2

Re: [Observium] Cisco ADSL port only shows one speed
by ron＠rjr-services.com 02 Jul '18

02 Jul '18

1 0

9304 issues
by Joey Stanford 01 Jul '18

01 Jul '18

Hi, Overnight the update script brought us to 9304 and the schema up to 378. Immediately after, all of our devices when down and alerts went out. The problem was that the poller script SQL call was failing because it was looking for status = 1 and all of our boxes were in status = 0. poller couldn’t find the host even though the hostname matched hostname in devices. I did an “ update devices set status=1 where `disabled`=0; “ and poller started again but I’m sure something else it at play here. Joey

3 12