- observium - lists.observium.org

Activate alarms for a group of Nodes - Customized Dashboard
by Farah Ameri Mahabadian (famerima) 11 Mar '20

11 Mar '20

Hello Team, I have created a customized dashboard included of 150 ports ( graph ) : I want to activate two below alerts just for 150 nodes not all of the nodes in observium , what is the easiest way by GUI ? Could you please guide me about it? 1. Traffic abnormal, 0 or full bandwidth 2. Physical port down Thanks Farah

2 1

Strange display (20.3.10311)
by luca＠sasdelli.it 08 Mar '20

08 Mar '20

With two HP switches I get this display about SFP modules status: of course SFP modules are equal. Any thought? Best Luca

3 5

Creating check on sensors which only have measured up state
by Previder Network 06 Mar '20

06 Mar '20

Hi Observium Community, Hopefully someone can help me here. I'm using Observium Professional Edition. I'm struggling creating a check on sensors of type dBm which only has measured up state. When i go to Health -> dBm i see al my ports power levels. I can filter there on sensor event "critical". Then i'm getting a nice overview of ports which are below threshold. But most of these ports are down. So many of them are false positives and i'm not interested in them. Then we have the option "Measured State". Over there i can select "Measured Up" and then i'm getting the exact list i want. So i would like to create a check based on this. But when creating a check and assigning associations i'm not able to match based on the "Measured UP" state. In the groups section i'm also having this limitation. Am i overlooking something or is this not possible of hopefully i need to do this another way. Many thanks! Kind Regards, Nick Derksen, Previder B.V

1 0

Customizing description of each port after creating a dashboard
by Farah Ameri Mahabadian (famerima) 05 Mar '20

05 Mar '20

Dear Observium Team, Could you please advise, how Can I customize description of each port after creating a dashboard ,by GUI interface ? Please , see below examples : ( I would like to updated each port description by the name of the customer, Circuit ID .. ) , but as you can see below description is not clear . [cid:image002.jpg@01D5F1AB.E95AC7C0] Regards Farah

6 13

Disk space being full
by Gordon Cheng (gocheng) 05 Mar '20

05 Mar '20

Hi all, Disk space is full on our Observium and we lost the GUI access (only CLI). I’m trying to use “housekeeping.php -a” to clean up the space, and use “delete_device.php” to delete a few offending devices using up lots of space. But it didn’t help much yet. For example, even if I tried to delete a device “phx-nx5596-04”: sjc-observium-1:/opt/observium# ./delete_device.php phx-nx5596-04 Observium 19.5.9872 Remove Device CACHE CLEAR SET. Cache clear set. * Deleted interfaces: id=13437 (mgmt0), id=13438 (Vlan1), id=13439 (Vlan2283), id=13440 (port-channel1), id=13441 (port-channel2), id=13442 (port-channel5), id=13443 (port-channel6), id=13444 (port-channel7), id=13445 (port-channel8), id=13446 (port-channel10), id=13447 (port-channel12), id=13448 (port-channel13), id=13449 (port-channel14), id=13450 (port-channel15), <snip> 64898 (), id=64899 (), id=64900 () * Deleted common entity entries linked to device: device * Deleted device entries from tables: devices_locations, device_graphs, entPhysical * Deleted device: phx-nx5596-04 Device phx-nx5596-04 removed. sjc-observium-1:/opt/observium# It’s still showing up undeleted and using a lot of disk space: sjc-observium-1:/opt/observium/rrd# du -sk * | sort -nr | head 2276640 phx-core03 2256244 phx-core04 2203544 sjc-core03 2199116 phx-spider01 2196748 sjc-core04 2169864 sjc-spider01-old 1885692 phx-spider02 1873348 phx-spider01-new 1862500 sjc-spider01 1452708 phx-nx5596-04 sjc-observium-1:/opt/observium/rrd# sjc-observium-1:/opt/observium/rrd# df -h Filesystem Size Used Avail Use% Mounted on /dev/vda3 378G 359G 0 100% / devtmpfs 32G 0 32G 0% /dev tmpfs 32G 0 32G 0% /dev/shm tmpfs 32G 8.7M 32G 1% /run tmpfs 32G 0 32G 0% /sys/fs/cgroup /dev/vda1 488M 189M 264M 42% /boot tmpfs 6.3G 0 6.3G 0% /run/user/15115 tmpfs 6.3G 0 6.3G 0% /run/user/0 sjc-observium-1:/opt/observium/rrd# Any suggestions how we can fix and restore it? Thanks. - Gordon

2 1

Dashboard Graph Start Date Weird
by Brian Weeks 05 Mar '20

05 Mar '20

I have a weird problem with graphs that are on the dashboard show correct data but if I click on one the date start is 1969-12-30 but if I choose the device from the device menus and go to the same graph the start date is correct for 24 hours. I have check the date and time on the server and it is also correct I recreated the dashboard graphs from scratch and it still does it. I apologize if this has been asked before but I could not find an answer. -- Brian Weeks Network Engineer Brenham ISD CCNA, MCSE, ACMT, A+, Network+, Security+ 1301 Niebuhr St. Brenham, TX 7783 Office: (979) 277-3760 ext. 2249 Email: bweeks(a)brenhamk-12.net Website: http://www.brenhamisd.net --

1 0

Sensors missing of Dell Equallogic arrays
by Wouter de Man 03 Mar '20

03 Mar '20

Since the last stable upgrade (Professional edition), we have lost all the sensors (and the harddisk status) of our Dell Equallogic PS arrays (3 different types, different firmware levels). Any idea what happened? This worked fine on the previous stable release...

5 13

Datasource maximum not updating
by Milton Ngan 03 Mar '20

03 Mar '20

We discovered some RRD’s for LACP bundles had not updated the DS Max value after an upgrade. So this meant when we exceeded the previous DS Max value, we started getting “gaps” (NaN values) in the graph. I had to manually go in and “tune” the RRD to have a more appropriate DS Max value. Is this something that Observium is maintaining? If so, what would trigger this to happen? In the graph below the LACP Bundle was a 10G LAG, then upgraded to a 20G LAG. Now every time we got above 10G, we get gaps in the graph. [https://netmon.mgmt.valve.net/v/dashboard/port/5306762/bg2-sto2.nm.valve.ne…]

1 0

rrdtool (1.4.8-1.2+deb8u1) Error Drawing Graph?
by Sananikone, Athideth 02 Mar '20

02 Mar '20

Hi there, anyone else experiencing "Error Drawing Graph" after last nights apt-get-run updaten RRD to 14.8.-1.2? Athi [cid:tangro_logo_rgb57-176-201_201x97_c39e0fcc-3cb6-4676-b737-ecb5f27f9294.gif] Athideth Sananikone Leitung IT Infrastruktur atsa(a)tangro.de<mailto:atsa@tangro.de> Fon +49 6221 1333 625 www.tangro.de<http://www.tangro.de> [cid:tangro_newsletter_icon_IN_rgb57-176-201_46x42_10395825-8428-4d89-9c27-9617de1dca04.gif] <https://www.linkedin.com/company/3731516/> [cid:tangro_newsletter_icon_X_rgb57-176-201_70x42_fa96ea45-c16c-4377-b5af-b500d6c2d2fe.gif] <https://www.xing.com/companies/tangrosoftwarecomponentsgmbh> [cid:Youtube_Favicon_ee3d2635-aa5a-40f7-92d1-35d68dd1f1d3.png] <https://www.youtube.com/channel/UCsxrvLKxYpQ-KYK8uGQ8tVQ> [cid:tangro_newsletter_icon_rgb57-176-201_139x42_7758a315-d1ec-4829-adce-36eea7130bda.gif] <https://www.tangro.de/newsletter/> tangro software components gmbh, Speyerer Stra?e 4, 69115 Heidelberg Gesch?ftsf?hrer: Andreas Schumann, Registergericht: Mannheim, HRB 336064 (Sitz: Heidelberg) Besuchen Sie uns an Stand 9 und h?ren Sie unseren Partnervortrag am 25.03.2020! [cid:ELS-2020_600x200px_73179588-b89d-422e-83d2-28d7d77748a9.jpg]<https://www.tangro.de/bme-eloesungstage-2020/><https://www.tangro.de/ueber-uns/events/detail/news/xe-rechnung-muehelos-mei…>

3 2

Unix agent alerting on Postfix mail queue size
by Attila Nagy 02 Mar '20

02 Mar '20

Hi Adam, Tom! We are currently facing the problem of having to alert on Postfix mail queue size coming from the Unix agent (thanks to "careful" users who let their e-mail passwords repeatedly stolen). As I've been trying to read about this in the archives, I see that this is a somewhat frequently upcoming but still unresolved topic. May I ask about the current status of this request?! Best regards, Attila

1 0

Supress Sensor Updated in Eventlog
by Klimek, Denis 02 Mar '20

02 Mar '20

Hi all, is there any method to supress the generation of "Sensor updated"-Eventlog entries if Observium is dynamicly changing the limit_low/high value? Our eventlog contains shitloads of entries for this kind of logs and they are not really useful from my opinion. So we would like to keep the sensors quiet. Currently we are running an external scripts triggered by cronjob to filter out those messages, but if we would supress the creation itself it would be much better Cheers, Denis Mit freundlichem Gruß Stadtwerke Norderstedt Denis Klimek Carrier Manager & Professional Network Engineer IP-Systemtechnik Tel: +49 (0) 40 / 521 04 - 1049 dklimek(a)stadtwerke-norderstedt.de<mailto:dklimek@stadtwerke-norderstedt.de> www.stadtwerke-norderstedt.de<http://www.stadtwerke-norderstedt.de/>

2 4

creating custom probe
by cody＠mail-server.cc 02 Mar '20

02 Mar '20

Hi, I wanted to create a custom probe to read two values from Cisco devices which aren't available via their SNMP agents. How do i get my probe included and What to i need to present the two values (current value, max value) in a graph and trigger an alert when the current value reaches 90% of the max value? Thanks, Cody

1 0

Re: [Observium] How to exclude "virtual Memory" from an alert checker (but keep all other memory metrics)?
by Thomas Stather 28 Feb '20

28 Feb '20

Hi I set the following Device Match / Entity Match: (device.type in server AND (mempool.mempool_descr notmatch *cache* OR mempool.mempool_descr notmatch *Virtual*)) However, the alert is still displayed (which is true since the virtual memory of one of our VMs is stil labove 80%). How can i reset the alert to test that the condition now works as expected? Best, Thomas Am 12.07.19 um 16:30 schrieb Hamilton, Kent: > Here is what I use for the "Entity Match": > mempool_descr notmatch *cache* > mempool_descr notmatch *Physical* > mempool descr notmatch *Virtual* > mempool desc notmatch *virtual* > mempool desc notmatch *Shared Real* > > > > > -----Original Message----- > From: observium <observium-bounces(a)observium.org> On Behalf Of Thomas Stather via observium > Sent: Thursday, July 4, 2019 9:57 AM > To: 'Observium' <observium(a)observium.org> > Cc: Thomas Stather <tstather(a)mr.mpg.de> > Subject: [Observium] How to exclude "virtual Memory" from an alert checker (but keep all other memory metrics)? > > Exegy Email Security > > WARNING This email originated from outside of Exegy. DO NOT CLICK links or attachments unless you recognize the sender and know the content is safe. > Remember Exegy ITS will never ask for user ID information via email communication. > > > > Hi > > > We are using Observium Professional: 19.6.9946 (rolling) > > > I have set up an alert check to check our servers for fully occupied memory ("mempool_perc greater 80"). > > I want to include the metrics "Memory buffers", "Physical Memory", "Swap space" but i want to exclude "Virtual memory". > > > Is there a way of doing so and if so, how? > > > > Best, > > Thomas > > > -- > Thomas Stather > IT Services > > VCP4, VCP6-DCV, VCP6.5-DCV > > Tel: +49 6221 486 628 > Fax: +49 6221 486 561 > > _______________________________________________ > observium mailing list > observium(a)observium.org > http://postman.memetic.org/cgi-bin/mailman/listinfo/observium > > ________________________________ > > This e-mail and any documents accompanying it may contain legally privileged and/or confidential information belonging to Exegy, Inc. Such information may be protected from disclosure by law. The information is intended for use by only the addressee. If you are not the intended recipient, you are hereby notified that any disclosure or use of the information is strictly prohibited. If you have received this e-mail in error, please immediately contact the sender by e-mail or phone regarding instructions for return or destruction and do not use or disclose the content to others. -- Thomas Stather IT Services VCP4, VCP6-DCV, VCP6.5-DCV Tel: +49 6221 486 628 Fax: +49 6221 486 561

2 4

Re: [Observium] Port Description Parsing - Cust Graphs "Error Drawing Graph"
by Chris Macneill 27 Feb '20

27 Feb '20

Hi Adam, OK, read that page and here's what happens when I try to switch from stable to rolling as per documentation:- root@obs:/opt/observium# svn up Updating '.': At revision 10304. root@obs:/opt/observium# svn switch https://svn.observium.org/svn/observium/trunk svn: E155025: 'svn switch' does not support switching a working copy to a different repository svn: E155025: 'http://svn.observium.org/svn/observium/branches/stable' is not the same repository as 'https://svn.observium.org/svn' Regards Chris Macneill Zelan Ltd From: "observium" <observium(a)observium.org> To: "observium" <observium(a)observium.org> Cc: "Adam Armstrong" <adama(a)memetic.org> Sent: Thursday, 27 February, 2020 15:22:50 Subject: Re: [Observium] Port Description Parsing - Cust Graphs "Error Drawing Graph" Read that entire page. Sent from [ http://www.bluemail.me/r?b=15818 | BlueMail ] On 27 Feb 2020, at 02:06, Chris Macneill < [ mailto:cmacneill@zelan.co.nz | cmacneill(a)zelan.co.nz ] > wrote: Hi Adam, "svn update" is what I assumed I was supposed to use and it said successfully updated to 10304. Webpage says v20.2.10302 (stable) after update. I don't see any doucmentation in [ https://docs.observium.org/updating/#upgrading-the-subscription-edition-to-… | https://docs.observium.org/updating/#upgrading-the-subscription-edition-to-… ] that references any difference between latest "stable" and latest "rolling". How do I upgrade to "rolling" 10304? Why does "svn update" tell me it's updated to 10304 when it seemingly hasn't? Regards Chris Macneill Zelan Ltd From: "observium" <observium(a)observium.org> To: "observium" <observium(a)observium.org> Cc: "Adam Armstrong" <adama(a)memetic.org> Sent: Thursday, 27 February, 2020 14:51:35 Subject: Re: [Observium] Port Description Parsing - Cust Graphs "Error Drawing Graph" Is this, perchance, stable, and not rolling? Adam. Sent from [ http://www.bluemail.me/r?b=15818 | BlueMail ] On 27 Feb 2020, at 01:45, Chris Macneill via observium < [ mailto:observium@observium.org | observium(a)observium.org ] > wrote: BQ_BEGIN Hi Mike, Sorry, 20.2.10304 doesn't fix it. Fields still split on commas for port_descr_type = 'cust' and debug results exactly the same as previous:- SELECT * FROM `ports` AS I , `devices` AS D WHERE `port_descr_type` = 'cust' AND `port_descr_descr` = 'GDC Westland Recreation Centre' , ' 83 High St' , ' Greymouth' AND D . device_id = I . device_id Also, a new bug added, software version number at bottom of screen is now out of step with "svn update". Update said successfully updated to 10304, but webpage says 20.2.10302 I've had a hack at the code in html/includes/graphs/customer/bits.inc.php and put the following workaround in place:- Line 16 (Original v20.2.10304 Code) foreach (dbFetchRows("SELECT * FROM `ports` AS I, `devices` AS D WHERE `port_descr_type` = 'cust' AND `port_descr_descr` = ? AND D.device_id = I.device_id", array($vars['id'])) as $port) Replaced with:- // Copy id array directly for case where port_descr_descr was NOT previosuly split/exploded on commas. $pddstr = $vars['id']; if ( count($vars['id']) > 1 ) { // Impode id array addng commas where array size > 1, i.e. original id contained commas and WAS split/exploded. $pddstr = implode(",", $vars['id']); } foreach (dbFetchRows("SELECT * FROM `ports` AS I, `devices` AS D WHERE `port_descr_type` = 'cust' AND `port_descr_descr` = ? AND D.device_id = I.device_id", array($pddstr)) as $port) $vars['id'] is the result of splitting or exploding port_descr_descr string value somewhere earlier, but I can't locate that in the code and as Adam mentioned, changing this elsewhere might have undesirable consequences. The problem only happens for port_descr_type = "cust", for other port types, e.g. core, peering, transit, port_descr_descr isn't split or exploded despite containing commas, but I can't find the locaiton in the code where this conditional behaviour occurs. Regards Chris Macneill Zelan Ltd From: "Mike Stupalov" <mike(a)observium.org> To: "observium" <observium(a)observium.org>, "observium" <observium(a)observium.org> Cc: "Chris Macneill" <cmacneill(a)cmit.nz> Sent: Thursday, 27 February, 2020 12:59:52 Subject: Re: [Observium] Port Description Parsing - Cust Graphs "Error Drawing Graph" Hi Chris, try with latest revision (r10304, trunk). Issue should be fixed. Chris Macneill via observium wrote on 26.02.2020 20:25: BQ_BEGIN Hi Adam, Looks like data is being split on commas and causing an SQL syntax error. Debug for:- Cust: GDC Westland Recreation Centre, 83 High St, Greymouth [100Mbit] {Chorus CVID.113} returns:- Error in query: (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 '' 83 High St',' Greymouth' AND D.device_id = I.device_id' at line 1) 1064 I can obviously fix this short-term by removing commas from the Port Descriptions, but would be good to be able to support use of commas and other punctuation in the longer term or at least update the Help page to list characters to avoid. I had a quick look earlier at the Regex that was parsing the description data, but wasn't immediately obvious commas were an issue. At least I know where the problem lies and I'll take another look later. I guess semi-colons might work if commas don't. Regards Chris Macneill Zelan Ltd From: "observium" [ mailto:observium@observium.org | <observium(a)observium.org> ] To: "observium" [ mailto:observium@observium.org | <observium(a)observium.org> ] Cc: "adama" [ mailto:adama@observium.org | <adama(a)observium.org> ] Sent: Thursday, 27 February, 2020 04:50:22 Subject: Re: [Observium] Port Description Parsing - Cust Graphs "Error Drawing Graph" Do you get anything useful from showing rrd command on the graph browser page? (click on the graph) Do you get anything useful from adding &debug=1 on the end of the graph image url? Can you arrange ssh/http access to the install if those two things don’t show us what the problem is? Adam. From: observium [ mailto:observium-bounces@observium.org | <observium-bounces(a)observium.org> ] On Behalf Of Chris Macneill via observium Sent: 26 February 2020 05:22 To: observium [ mailto:observium@observium.org | <observium(a)observium.org> ] Cc: Chris Macneill [ mailto:cmacneill@cmit.nz | <cmacneill(a)cmit.nz> ] Subject: [Observium] Port Description Parsing - Cust Graphs "Error Drawing Graph" Hi, We're currently using Observium v20.1.10233 and have a problem with "Error Drawing Graph" for all ports with a "Cust" prefix. Ports with "Core", "Peer" or "Transit" prefix correctly show graphs. The ports we're monitoring are VLANs, the Peer/Transit are simple 802.1q VLANs, the Core/Customer VLANs are QinQ, i.e. two layers of 802.1q headers. All port types are correctly detected by SNMP and listed against the Router. Given that "Core" displays graphs correctly, this doesn't seem to be related to QinQ, but specifically to the "Cust" prefix. Examples that correctly show graphs, 1st is 802.1q, 2nd is QinQ:- Peering: Datacom CHC<->Chorus [10Gbit] {Chorus SVID.100} Core: Zelan Workshop, 50 Palmerston St, Westport [1Gbit] {Chorus CVID.100} Example (QinQ) that gives "Error Drawing Graph":- Cust: GDC Westland Recreation Centre, 83 High St, Greymouth [100Mbit] {Chorus CVID.113} All our routers are MikroTik, so can't determine if this is a router OS/hardware specific issue. Regards Chris Macneill Zelan Ltd. _______________________________________________ observium mailing list [ mailto:observium@observium.org | observium(a)observium.org ] [ http://postman.memetic.org/cgi-bin/mailman/listinfo/observium | http://postman.memetic.org/cgi-bin/mailman/listinfo/observium ] _______________________________________________ observium mailing list [ mailto:observium@observium.org | observium(a)observium.org ] [ http://postman.memetic.org/cgi-bin/mailman/listinfo/observium | http://postman.memetic.org/cgi-bin/mailman/listinfo/observium ] -- Mike Stupalov Observium Limited, [ http://observium.org/ | http://observium.org ] observium mailing list observium(a)observium.org [ http://postman.memetic.org/cgi-bin/mailman/listinfo/observium | http://postman.memetic.org/cgi-bin/mailman/listinfo/observium ] BQ_END _______________________________________________ observium mailing list observium(a)observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium BQ_END _______________________________________________ observium mailing list observium(a)observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium

2 1

Re: [Observium] Port Description Parsing - Cust Graphs "Error Drawing Graph"
by Adam Armstrong 27 Feb '20

27 Feb '20

Read that entire page. ⁣Sent from BlueMail On 27 Feb 2020, 02:06, at 02:06, Chris Macneill <cmacneill(a)zelan.co.nz> wrote: >Hi Adam, > >"svn update" is what I assumed I was supposed to use and it said >successfully updated to 10304. > >Webpage says v20.2.10302 (stable) after update. > >I don't see any doucmentation in [ >https://docs.observium.org/updating/#upgrading-the-subscription-edition-to-… >| >https://docs.observium.org/updating/#upgrading-the-subscription-edition-to-… >] that references any difference between latest "stable" and latest >"rolling". > >How do I upgrade to "rolling" 10304? > >Why does "svn update" tell me it's updated to 10304 when it seemingly >hasn't? > >Regards > >Chris Macneill >Zelan Ltd > >From: "observium" <observium(a)observium.org> >To: "observium" <observium(a)observium.org> >Cc: "Adam Armstrong" <adama(a)memetic.org> >Sent: Thursday, 27 February, 2020 14:51:35 >Subject: Re: [Observium] Port Description Parsing - Cust Graphs "Error >Drawing Graph" > >Is this, perchance, stable, and not rolling? > >Adam. > >Sent from [ http://www.bluemail.me/r?b=15818 | BlueMail ] >On 27 Feb 2020, at 01:45, Chris Macneill via observium < [ >mailto:observium@observium.org | observium(a)observium.org ] > wrote: > > >Hi Mike, > >Sorry, 20.2.10304 doesn't fix it. Fields still split on commas for >port_descr_type = 'cust' and debug results exactly the same as >previous:- > >SELECT * FROM `ports` AS I , `devices` AS D WHERE `port_descr_type` = >'cust' AND `port_descr_descr` = 'GDC Westland Recreation Centre' , ' 83 >High St' , ' Greymouth' AND D . device_id = I . device_id > >Also, a new bug added, software version number at bottom of screen is >now out of step with "svn update". Update said successfully updated to >10304, but webpage says 20.2.10302 > >I've had a hack at the code in >html/includes/graphs/customer/bits.inc.php and put the following >workaround in place:- > >Line 16 (Original v20.2.10304 Code) >foreach (dbFetchRows("SELECT * FROM `ports` AS I, `devices` AS D WHERE >`port_descr_type` = 'cust' AND `port_descr_descr` = ? AND D.device_id = >I.device_id", array($vars['id'])) as $port) > >Replaced with:- > >// Copy id array directly for case where port_descr_descr was NOT >previosuly split/exploded on commas. >$pddstr = $vars['id']; >if ( count($vars['id']) > 1 ) { >// Impode id array addng commas where array size > 1, i.e. original id >contained commas and WAS split/exploded. >$pddstr = implode(",", $vars['id']); >} >foreach (dbFetchRows("SELECT * FROM `ports` AS I, `devices` AS D WHERE >`port_descr_type` = 'cust' AND `port_descr_descr` = ? AND D.device_id = >I.device_id", array($pddstr)) as $port) > >$vars['id'] is the result of splitting or exploding port_descr_descr >string value somewhere earlier, but I can't locate that in the code and >as Adam mentioned, changing this elsewhere might have undesirable >consequences. > >The problem only happens for port_descr_type = "cust", for other port >types, e.g. core, peering, transit, port_descr_descr isn't split or >exploded despite containing commas, but I can't find the locaiton in >the code where this conditional behaviour occurs. > >Regards > >Chris Macneill >Zelan Ltd > >From: "Mike Stupalov" <mike(a)observium.org> >To: "observium" <observium(a)observium.org>, "observium" ><observium(a)observium.org> >Cc: "Chris Macneill" <cmacneill(a)cmit.nz> >Sent: Thursday, 27 February, 2020 12:59:52 >Subject: Re: [Observium] Port Description Parsing - Cust Graphs "Error >Drawing Graph" > >Hi Chris, > >try with latest revision (r10304, trunk). > >Issue should be fixed. > >Chris Macneill via observium wrote on 26.02.2020 20:25: > >BQ_BEGIN > >Hi Adam, > >Looks like data is being split on commas and causing an SQL syntax >error. Debug for:- > >Cust: GDC Westland Recreation Centre, 83 High St, Greymouth [100Mbit] >{Chorus CVID.113} > >returns:- > >Error in query: (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 '' 83 High St',' Greymouth' AND D.device_id = I.device_id' at >line 1) 1064 > >I can obviously fix this short-term by removing commas from the Port >Descriptions, but would be good to be able to support use of commas and >other punctuation in the longer term or at least update the Help page >to list characters to avoid. > >I had a quick look earlier at the Regex that was parsing the >description data, but wasn't immediately obvious commas were an issue. >At least I know where the problem lies and I'll take another look >later. I guess semi-colons might work if commas don't. > >Regards > >Chris Macneill >Zelan Ltd > > >From: "observium" [ mailto:observium@observium.org | ><observium(a)observium.org> ] >To: "observium" [ mailto:observium@observium.org | ><observium(a)observium.org> ] >Cc: "adama" [ mailto:adama@observium.org | <adama(a)observium.org> ] >Sent: Thursday, 27 February, 2020 04:50:22 >Subject: Re: [Observium] Port Description Parsing - Cust Graphs "Error >Drawing Graph" > > > >Do you get anything useful from showing rrd command on the graph >browser page? (click on the graph) > > > >Do you get anything useful from adding &debug=1 on the end of the graph >image url? > > > >Can you arrange ssh/http access to the install if those two things >don’t show us what the problem is? > > > >Adam. > > > > >From: observium [ mailto:observium-bounces@observium.org | ><observium-bounces(a)observium.org> ] On Behalf Of Chris Macneill via >observium >Sent: 26 February 2020 05:22 >To: observium [ mailto:observium@observium.org | ><observium(a)observium.org> ] >Cc: Chris Macneill [ mailto:cmacneill@cmit.nz | <cmacneill(a)cmit.nz> ] >Subject: [Observium] Port Description Parsing - Cust Graphs "Error >Drawing Graph" > > > > > >Hi, > > > > > >We're currently using Observium v20.1.10233 and have a problem with >"Error Drawing Graph" for all ports with a "Cust" prefix. Ports with >"Core", "Peer" or "Transit" prefix correctly show graphs. > > > > > >The ports we're monitoring are VLANs, the Peer/Transit are simple >802.1q VLANs, the Core/Customer VLANs are QinQ, i.e. two layers of >802.1q headers. > > > > > >All port types are correctly detected by SNMP and listed against the >Router. Given that "Core" displays graphs correctly, this doesn't seem >to be related to QinQ, but specifically to the "Cust" prefix. > > > > > >Examples that correctly show graphs, 1st is 802.1q, 2nd is QinQ:- > > > > > >Peering: Datacom CHC<->Chorus [10Gbit] {Chorus SVID.100} > > >Core: Zelan Workshop, 50 Palmerston St, Westport [1Gbit] {Chorus >CVID.100} > > > > > >Example (QinQ) that gives "Error Drawing Graph":- > > > > > >Cust: GDC Westland Recreation Centre, 83 High St, Greymouth [100Mbit] >{Chorus CVID.113} > > > > > >All our routers are MikroTik, so can't determine if this is a router >OS/hardware specific issue. > > > > > >Regards > >Chris Macneill >Zelan Ltd. > > > > >_______________________________________________ >observium mailing list >[ mailto:observium@observium.org | observium(a)observium.org ] >[ http://postman.memetic.org/cgi-bin/mailman/listinfo/observium | >http://postman.memetic.org/cgi-bin/mailman/listinfo/observium ] > > > >_______________________________________________ >observium mailing list [ mailto:observium@observium.org | >observium(a)observium.org ] [ >http://postman.memetic.org/cgi-bin/mailman/listinfo/observium | >http://postman.memetic.org/cgi-bin/mailman/listinfo/observium ] > > > >-- >Mike Stupalov >Observium Limited, [ http://observium.org/ | http://observium.org ] > > > > >observium mailing list >observium(a)observium.org >[ http://postman.memetic.org/cgi-bin/mailman/listinfo/observium | >http://postman.memetic.org/cgi-bin/mailman/listinfo/observium ] > >BQ_END > > >_______________________________________________ >observium mailing list >observium(a)observium.org >http://postman.memetic.org/cgi-bin/mailman/listinfo/observium

1 0

Re: [Observium] Port Description Parsing - Cust Graphs "Error Drawing Graph"
by Chris Macneill 27 Feb '20

27 Feb '20

Hi Adam, Looks like data is being split on commas and causing an SQL syntax error. Debug for:- Cust: GDC Westland Recreation Centre, 83 High St, Greymouth [100Mbit] {Chorus CVID.113} returns:- Error in query: (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 '' 83 High St',' Greymouth' AND D.device_id = I.device_id' at line 1) 1064 I can obviously fix this short-term by removing commas from the Port Descriptions, but would be good to be able to support use of commas and other punctuation in the longer term or at least update the Help page to list characters to avoid. I had a quick look earlier at the Regex that was parsing the description data, but wasn't immediately obvious commas were an issue. At least I know where the problem lies and I'll take another look later. I guess semi-colons might work if commas don't. Regards Chris Macneill Zelan Ltd From: "observium" <observium(a)observium.org> To: "observium" <observium(a)observium.org> Cc: "adama" <adama(a)observium.org> Sent: Thursday, 27 February, 2020 04:50:22 Subject: Re: [Observium] Port Description Parsing - Cust Graphs "Error Drawing Graph" Do you get anything useful from showing rrd command on the graph browser page? (click on the graph) Do you get anything useful from adding &debug=1 on the end of the graph image url? Can you arrange ssh/http access to the install if those two things don’t show us what the problem is? Adam. From: observium <observium-bounces(a)observium.org> On Behalf Of Chris Macneill via observium Sent: 26 February 2020 05:22 To: observium <observium(a)observium.org> Cc: Chris Macneill <cmacneill(a)cmit.nz> Subject: [Observium] Port Description Parsing - Cust Graphs "Error Drawing Graph" Hi, We're currently using Observium v20.1.10233 and have a problem with "Error Drawing Graph" for all ports with a "Cust" prefix. Ports with "Core", "Peer" or "Transit" prefix correctly show graphs. The ports we're monitoring are VLANs, the Peer/Transit are simple 802.1q VLANs, the Core/Customer VLANs are QinQ, i.e. two layers of 802.1q headers. All port types are correctly detected by SNMP and listed against the Router. Given that "Core" displays graphs correctly, this doesn't seem to be related to QinQ, but specifically to the "Cust" prefix. Examples that correctly show graphs, 1st is 802.1q, 2nd is QinQ:- Peering: Datacom CHC<->Chorus [10Gbit] {Chorus SVID.100} Core: Zelan Workshop, 50 Palmerston St, Westport [1Gbit] {Chorus CVID.100} Example (QinQ) that gives "Error Drawing Graph":- Cust: GDC Westland Recreation Centre, 83 High St, Greymouth [100Mbit] {Chorus CVID.113} All our routers are MikroTik, so can't determine if this is a router OS/hardware specific issue. Regards Chris Macneill Zelan Ltd. _______________________________________________ observium mailing list observium(a)observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium

3 3

smokeping integration
by cody＠mail-server.cc 26 Feb '20

26 Feb '20

I installed smokeping, generated the targets file with the script and smokeping is running and updating the rrd's. I set the smokeping directory in the gui but i do not get the smokeping tab on the devices. Is there anything else to do? I'm not seeing something wrong - how do i troubleshoot/identify why the smokeping tab doesn't appear? thanks

2 2

Re: [Observium] Port Description Parsing - Cust Graphs "Error Drawing Graph"
by adama＠observium.org 26 Feb '20

26 Feb '20

Aha, I see what it’s doing. You missed out the actual query, which makes it more obvious what’s happening /graph.php?type=customer_bits&id=herp,derp&debug=1 Generates: SELECT * FROM `ports` AS I, `devices` AS D WHERE `port_descr_type` = 'cust' AND `port_descr_descr` = 'herp','derp' AND D.device_id = I.device_id We have a bit of code in the URL parser that expands any argument with a comma into an array of arguments, it’s used when you put in a list of port_ids for example. It’s expanding this here, and we’re passing an array of values to the SQL query builder. I’m not sure how much would need to be changed to suppress this behaviour in this instance, so I’d recommend just not putting commas in port descriptions! Thanks, Adam. From: Chris Macneill <cmacneill(a)zelan.co.nz> Sent: 26 February 2020 17:22 To: observium <observium(a)observium.org> Cc: adama <adama(a)observium.org> Subject: Re: [Observium] Port Description Parsing - Cust Graphs "Error Drawing Graph" Hi Adam, Looks like data is being split on commas and causing an SQL syntax error. Debug for:- Cust: GDC Westland Recreation Centre, 83 High St, Greymouth [100Mbit] {Chorus CVID.113} returns:- Error in query: (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 '' 83 High St',' Greymouth' AND D.device_id = I.device_id' at line 1) 1064 I can obviously fix this short-term by removing commas from the Port Descriptions, but would be good to be able to support use of commas and other punctuation in the longer term or at least update the Help page to list characters to avoid. I had a quick look earlier at the Regex that was parsing the description data, but wasn't immediately obvious commas were an issue. At least I know where the problem lies and I'll take another look later. I guess semi-colons might work if commas don't. Regards Chris Macneill Zelan Ltd _____ From: "observium" <observium(a)observium.org <mailto:observium@observium.org> > To: "observium" <observium(a)observium.org <mailto:observium@observium.org> > Cc: "adama" <adama(a)observium.org <mailto:adama@observium.org> > Sent: Thursday, 27 February, 2020 04:50:22 Subject: Re: [Observium] Port Description Parsing - Cust Graphs "Error Drawing Graph" Do you get anything useful from showing rrd command on the graph browser page? (click on the graph) Do you get anything useful from adding &debug=1 on the end of the graph image url? Can you arrange ssh/http access to the install if those two things don’t show us what the problem is? Adam. From: observium <observium-bounces(a)observium.org <mailto:observium-bounces@observium.org> > On Behalf Of Chris Macneill via observium Sent: 26 February 2020 05:22 To: observium <observium(a)observium.org <mailto:observium@observium.org> > Cc: Chris Macneill <cmacneill(a)cmit.nz <mailto:cmacneill@cmit.nz> > Subject: [Observium] Port Description Parsing - Cust Graphs "Error Drawing Graph" Hi, We're currently using Observium v20.1.10233 and have a problem with "Error Drawing Graph" for all ports with a "Cust" prefix. Ports with "Core", "Peer" or "Transit" prefix correctly show graphs. The ports we're monitoring are VLANs, the Peer/Transit are simple 802.1q VLANs, the Core/Customer VLANs are QinQ, i.e. two layers of 802.1q headers. All port types are correctly detected by SNMP and listed against the Router. Given that "Core" displays graphs correctly, this doesn't seem to be related to QinQ, but specifically to the "Cust" prefix. Examples that correctly show graphs, 1st is 802.1q, 2nd is QinQ:- Peering: Datacom CHC<->Chorus [10Gbit] {Chorus SVID.100} Core: Zelan Workshop, 50 Palmerston St, Westport [1Gbit] {Chorus CVID.100} Example (QinQ) that gives "Error Drawing Graph":- Cust: GDC Westland Recreation Centre, 83 High St, Greymouth [100Mbit] {Chorus CVID.113} All our routers are MikroTik, so can't determine if this is a router OS/hardware specific issue. Regards Chris Macneill Zelan Ltd. _______________________________________________ observium mailing list observium(a)observium.org <mailto:observium@observium.org> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium

1 0

Port Description Parsing - Cust Graphs "Error Drawing Graph"
by Chris Macneill 26 Feb '20

26 Feb '20

Hi, We're currently using Observium v20.1.10233 and have a problem with "Error Drawing Graph" for all ports with a "Cust" prefix. Ports with "Core", "Peer" or "Transit" prefix correctly show graphs. The ports we're monitoring are VLANs, the Peer/Transit are simple 802.1q VLANs, the Core/Customer VLANs are QinQ, i.e. two layers of 802.1q headers. All port types are correctly detected by SNMP and listed against the Router. Given that "Core" displays graphs correctly, this doesn't seem to be related to QinQ, but specifically to the "Cust" prefix. Examples that correctly show graphs, 1st is 802.1q, 2nd is QinQ:- Peering: Datacom CHC<->Chorus [10Gbit] {Chorus SVID.100} Core: Zelan Workshop, 50 Palmerston St, Westport [1Gbit] {Chorus CVID.100} Example (QinQ) that gives "Error Drawing Graph":- Cust: GDC Westland Recreation Centre, 83 High St, Greymouth [100Mbit] {Chorus CVID.113} All our routers are MikroTik, so can't determine if this is a router OS/hardware specific issue. Regards Chris Macneill Zelan Ltd.

2 1

Re: [Observium] Port Description Parsing - Cust Graphs "Error Drawing Graph"
by Manish Shringarpure 26 Feb '20

26 Feb '20

I was facing the same issue, the rrd files are not generated for some routers for only ports. You can check if the rrd files are present under /opt/observium/rrd/<device_name>/port*.rrd I ran the poller explicitly and the rrd files were generated. You can try the same on that specific device, with the following command. sudo ./poller.php -h <device_id> -m ports -dd watch out for the snmpbulkwalk command that gets printed on the screen. Regard’s Manish From: observium <observium-bounces(a)observium.org> on behalf of Chris Macneill via observium <observium(a)observium.org> Reply to: observium <observium(a)observium.org> Date: Wednesday, 26 February 2020 at 10:54 AM To: observium <observium(a)observium.org> Cc: Chris Macneill <cmacneill(a)cmit.nz> Subject: [Observium] Port Description Parsing - Cust Graphs "Error Drawing Graph" Hi, We're currently using Observium v20.1.10233 and have a problem with "Error Drawing Graph" for all ports with a "Cust" prefix. Ports with "Core", "Peer" or "Transit" prefix correctly show graphs. The ports we're monitoring are VLANs, the Peer/Transit are simple 802.1q VLANs, the Core/Customer VLANs are QinQ, i.e. two layers of 802.1q headers. All port types are correctly detected by SNMP and listed against the Router. Given that "Core" displays graphs correctly, this doesn't seem to be related to QinQ, but specifically to the "Cust" prefix. Examples that correctly show graphs, 1st is 802.1q, 2nd is QinQ:- Peering: Datacom CHC<->Chorus [10Gbit] {Chorus SVID.100} Core: Zelan Workshop, 50 Palmerston St, Westport [1Gbit] {Chorus CVID.100} Example (QinQ) that gives "Error Drawing Graph":- Cust: GDC Westland Recreation Centre, 83 High St, Greymouth [100Mbit] {Chorus CVID.113} All our routers are MikroTik, so can't determine if this is a router OS/hardware specific issue. Regards Chris Macneill Zelan Ltd.

2 1

Not seeing additional CPU's.
by Scott L. Kaiser 25 Feb '20

25 Feb '20

2 1

only front page working
by Ross [Eve IT] 25 Feb '20

25 Feb '20

Hello, Recently installed the CE version on a local Debian box running nginx and I have having a bizarre issue. Only the front page loads, it loads fine. The moment I click on any link, whether it is a device or trying to go into Settings, it just throws a 404. I don't see any errors in nginx. I thought it might have something to do with the web_url & base_url, I have set that in the config.php but no luck. I'm sure it's something I have missed :/ Ross.

8 22

Re: [Observium] Port red file generation issue
by Manish Shringarpure 25 Feb '20

25 Feb '20

Hi Adam, Thanks for your reply. All the rrd files inside the device directory have user as root and group as root. Even the other devices where the graphs are showing up have user as root and group as root. Following is the screenshot of the rrdtool dump of a port file. <ds> 23 <name> OUTOCTETS </name> 24 <type> DERIVE </type> 25 <minimal_heartbeat>600</minimal_heartbeat> 26 <min>0.0000000000e+00</min> 27 <max>1.2500000000e+10</max> 28 29  30 <last_ds>472721674480</last_ds> 31 <value>NaN</value> 32 <unknown_sec> 214 </unknown_sec> 33 </ds> 34 35 <ds> 36 <name> INERRORS </name> 37 <type> DERIVE </type> 38 <minimal_heartbeat>600</minimal_heartbeat> 39 <min>0.0000000000e+00</min> 40 <max>1.2500000000e+10</max> 41 42  43 <last_ds>0</last_ds> 44 <value>NaN</value> 45 <unknown_sec> 214 </unknown_sec> 46 </ds> All values seem to be NaN. Does observium write any error logs where such errors could be seen? Regard’s Manish From: observium <observium-bounces(a)observium.org> on behalf of Adam Armstrong via observium <observium(a)observium.org> Reply to: Observium <observium(a)observium.org> Date: Monday, 24 February 2020 at 3:08 PM To: Manish Shringarpure via observium <observium(a)observium.org> Cc: Adam Armstrong <adama(a)memetic.org> Subject: Re: [Observium] Port red file generation issue This is probanly a permissioms issue. If you manually ran the poller as root, the observium user won't have write permissions to that directory. Adam. Sent from BlueMail<http://www.bluemail.me/r?b=15818> On 24 Feb 2020, at 05:30, Manish Shringarpure via observium <observium(a)observium.org<mailto:observium@observium.org>> wrote: Hi, I am new to observium. I have a strange issue ;for only one of the devices in the network. The port*.rrd files for this device is not getting generated in the /opt/observium/rrd path. The other rrd files are being generated for this device. Because of which the dashboard does not show any graphs for the ports on this device. I ran the poller script manually for this particular device and the ports*.rrd files got generated but after I exported the files to an XML I could see all values as NaN. Also these port rrd files are not getting updated at regular intervals like the other rrd files for the same device. How do I debug this? Help would be appreciated. Regards, Manish ________________________________ observium mailing list observium(a)observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium

2 1

API strange issue
by Daniel Rolfe 24 Feb '20

24 Feb '20

Hi All, Can anyone think of what I'm missing with this issue ? see images below: So I have an alert checker with ID 4 [image: image.png] But hitting the api directly for that id gives a 404 [image: image.png] Observium details [image: image.png] Thanks in advance images attached also in case of non html email clients Regards, Daniel

3 3

Port red file generation issue
by Manish Shringarpure 24 Feb '20

24 Feb '20

Hi, I am new to observium. I have a strange issue ;for only one of the devices in the network. The port*.rrd files for this device is not getting generated in the /opt/observium/rrd path. The other rrd files are being generated for this device. Because of which the dashboard does not show any graphs for the ports on this device. I ran the poller script manually for this particular device and the ports*.rrd files got generated but after I exported the files to an XML I could see all values as NaN. Also these port rrd files are not getting updated at regular intervals like the other rrd files for the same device. How do I debug this? Help would be appreciated. Regards, Manish

2 1