- observium - lists.observium.org

Backup options for the MySQL database
by Michael Kelly 02 Mar '21

02 Mar '21

Hi Everybody, I recently started a new role at a company that uses Observium to monitor a fairly large estate. Observium (Professional edition) was originally installed on an EC2 instance running Debian 8 and MySQL 5.5 by someone who has long since departed the company. My task is to bring it all up to date and document it. I've created a new instance running Ubuntu 20.04 LTS and MySQL 8.0.23 and testing the migration process hasn't thrown up any problems. One of the things my predecessor didn't do was to set up any backup regime for the database. As it happens, /var/lib/mysql is a logical volume and I've been looking at using lvm snapshots as part of a backup process. The basic idea would be to: Connect to the mysql daemon and issue a 'FLUSH TABLES WITH READ LOCK' command. Create the LVM snapshot. Connect to the daemon and issue a 'UNLOCK TABLES' command. Do something with the snapshot. My questions are: Is this a good idea? Will it give me a consistent backup? Is there a better way? Thanks in advance, Michael.

3 2

Port usage monitoring
by Simon Smith 24 Feb '21

24 Feb '21

Hi All, I wondered if anybody has been able to setup alerts for port usage? I would like to monitor a machines network port, and if it goes above say 20GB worth of upload in like 3 weeks then alert me? I think I might need the billing part of observium setup for this but im not sure? Kindest Regards Simon - Hestor Ltd

2 3

Graphs not displaying recent traffic
by Luis Londoño 23 Feb '21

23 Feb '21

Hello, For some reason, none of my graphs are showing any recent information. The last graphs being shown are from a few weeks ago. This is happening on all my devices I have in Observium. I just updated to r 21.2.11038 and still seeing the same thing. I am on rrdtool v1.7.2 [cid:image001.jpg@01D709C5.16A61770] How do I get my graphs to come back?

2 1

jquery.js
by Mark Rowlands 23 Feb '21

23 Feb '21

/opt/observium/html/js/Jsquery-min.js /*! jQuery v2.2.4 | (c) jQuery Foundation | jquery.org/license */ Any chance you could bump this to 3.5 ? , The security people are complaining about EOL unsupported software. ☹ ( i.e https://snyk.io/vuln/SNYK-JS-JQUERY-565129 )

3 4

Observium + gradaba
by Luis Olavarrieta 20 Feb '21

20 Feb '21

Has anyone interfaced observium with ágrafa a to create a dashboard? Which tables should be read for it? Enviado desde mi iPhone

1 0

Interface utilization metrics
by Kania, Piotr 20 Feb '21

20 Feb '21

Hello Everyone, I want to pull interface utilization metrics from mysql DB and make it a daily report. Got bunch devices I am interested in, each of them has got few interfaces I would like to get metrics for. Graphs are showing all the info I would like to get from DB like max, min and avg values for In and Out octets. Where in DB I can find historical data for device XXX, interface YYY, date ZZZ. So far I was able to run something like below, but that doesn't give me any option to select historical data. I must say that I was browsing through whole DB table by table and I couldn't find anything related to previous dates. My query: select dev.sysName, dev.device_id, prt.port_id, prt.ifSpeed, prt.ifInOctets, prt.ifInOctets_rate, prt.ifInOctets_perc, prt.ifOutOctets, prt.ifOutOctets_rate, prt.ifOutOctets_perc from observium.devices as dev inner join observium.ports as prt on dev.device_id = prt.device_id where dev.sysName = 'XXX' and prt.port_label = 'Eth2' Any help hips, guides are more than appreciated. Regards, Piotr Kania CREDIT SUISSE (POLAND) SP. Z O.O. Credit Suisse CoE OPS Wroclaw | Monitoring & Instrumentation Solutions, MBHJ 711 Atrium 2 | Warsaw 00-849 | EMEA Phone +48 22 359 8668 piotr.kania(a)credit-suisse.com<mailto:piotr.kania@credit-suisse.com> | www.credit-suisse.com<http://www.credit-suisse.com> =============================================================================== Please access the attached hyperlink for an important electronic communications disclaimer: http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html ===============================================================================

3 2

OSPF discovery & CISCO-VPC-MIB
by Marian Rychtecky 18 Feb '21

18 Feb '21

Hi Adam and all Observium enthusiasts, I have two questions. First - is there any trick to find out why OSPF discovery is working on one router and not the other? I have the global setting enabled, and the OSPF module is enabled too, but only 1 router is being discovered as OSPF enabled. Am I missing something? Second - any plans integrating CISCO-VPC-MIB for vPC pairs of Cisco Nexus switches? Thank you very much for any response, Marian -- Marian Rychtecký mr(a)nix.cz Phone +420 724 397 441 NIX.CZ z.s.p.o. Americká 23, Praha 2 130 52 Czech Republic http://www.nix.cz

1 0

Need Explain about Legend Details on DiskIO Graph
by Aulia Rahman 11 Feb '21

11 Feb '21

Dear All, Can someone explain me the details of legend on Disk IO page refers to ? Health > Disk I/O: First graph with legend bps "<" & ">" (blue and green graph) What does k, M, none suffix mean ? Second graph with legend Operations/sec "Rx" & "Tx" (red & orange graph) What does m, u, none suffix mean ?

2 1

best practices regarding interface switching and historical data
by Arne Van Theemsche 10 Feb '21

10 Feb '21

Hi, I was wondering how you guys tackle the problem of changing the port of (e.g. your transit uplink) to another physical port & historical data. Since rrd's are stored under "port-<snmpid>" format, this event causes you by default to loose your historical data. Or even worse, you have to change your routing engine with a more recent version, and after replacing it seems all your snmp id's are changed. this is certainly of importance for our interfaces which have a label that automatically creates aggregates graphs. How I do this until now is copying the rrd file to the new location, but this seems so... dirty kind regards Arene

4 3

emails alerts stopped working
by Pieter Meyer 09 Feb '21

09 Feb '21

Hi, Seems Email alerts stopped working, we are currently using Observium 21.2.10990 email.inc.php ./test_alert.php -c 3 Observium 21.2.10990 Test Alert Notification o Notifying [email] Default alert email: {"email":"cvtvoice(a)convergedgroup.net"}PHP Parse error: syntax error, unexpected '=' in /opt/observium/includes/alerting/email.inc.php on line 131 Regards Pieter Meyer Converged Group | Licensed ISP 0258/IECNS/JAN/09 75 Witkoppen Rd, North Riding, Gauteng, 2162 Office: +27 10 591 4600 | Mobile: +27 83 233 6614

3 5