- observium - lists.observium.org

db.log - Failed dbQuery
by Aaron Mayfield 21 Aug '18

21 Aug '18

I recently noticed my db.log file had grown to 18GB in size (I noticed because it filled my drive). It is filled by entries like this: [2018/08/20 14:11:56 -0500] poller.php(12451): Failed dbQuery (#1062 - Duplicate entry '88-2320-005056a94437-223078' for key 'dev_vlan_mac_port'), Query: INSERT INTO `vlans_fdb` (`device_id`,`vlan_id`,`port_id`,`mac_address`,`fdb_status`) VALUES ('88','2320','223078','005056a94437','') [2018/08/20 14:11:56 -0500] poller.php(12451): Failed dbQuery (#1062 - Duplicate entry '88-3004-005056a93130-223078' for key 'dev_vlan_mac_port'), Query: INSERT INTO `vlans_fdb` (`device_id`,`vlan_id`,`port_id`,`mac_address`,`fdb_status`) VALUES ('88','3004','223078','005056a93130','') [2018/08/20 14:11:56 -0500] poller.php(12451): Failed dbQuery (#1062 - Duplicate entry '88-3031-0050565b341c-223078' for key 'dev_vlan_mac_port'), Query: INSERT INTO `vlans_fdb` (`device_id`,`vlan_id`,`port_id`,`mac_address`,`fdb_status`) VALUES ('88','3031','223078','0050565b341c','') It continues to quickly grow and log entries all for different devices/mac addresses/vlans. Anyone else run into this recently? Here is version info (I updated today to make sure there wasn’t a recent fix): [cid:image001.png@01D438B2.CD1274E0]

1 0

OID for Stulz WIB 8000
by Marco Froehlich 20 Aug '18

20 Aug '18

Hello! I am looking for the OID descriptions for a Stulz WIB 8000. Does anyone already have this? *Marco*

1 1

Dependencies
by Luca Sasdelli 20 Aug '18

20 Aug '18

Hi all, maybe this is a FAQ, but still I can’t find a way to avoid seeing ALL customer devices down, from the outside, if the firewall only is down. I think that it would suffice to define a rule to mask a device status behind a “master” one. Best Luca

2 2

Re: [Observium] observium Digest, Vol 97, Issue 12
by Balaji-NOC Engineer 17 Aug '18

17 Aug '18

Dear Team, Please guide me how to add mini graphs in the front page. So,kindly guide me in WEB and also in CLI. 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 From: "observium-request" <observium-request(a)observium.org> To: "observium" <observium(a)observium.org> Sent: Friday, August 17, 2018 4:30:02 PM Subject: observium Digest, Vol 97, Issue 12 Send observium mailing list submissions to observium(a)observium.org To subscribe or unsubscribe via the World Wide Web, visit http://postman.memetic.org/cgi-bin/mailman/listinfo/observium or, via email, send a message with subject or body 'help' to observium-request(a)observium.org You can reach the person managing the list at observium-owner(a)observium.org When replying, please edit your Subject line so it is more specific than "Re: Contents of observium digest..." Today's Topics: 1. Re: Training/certification in Observium (Adam Armstrong) 2. Re: Training/certification in Observium (Thomas Steffensen) 3. How do I create a Memory filter using entity type (Moshe Yazdi) 4. Re: Training/certification in Observium (Klimek, Denis) 5. Re: Training/certification in Observium (Tomasz Karczewski) 6. Re: How do I create a Memory filter using entity type (Adam Armstrong) ---------------------------------------------------------------------- Message: 1 Date: Thu, 16 Aug 2018 13:47:28 +0100 From: "Adam Armstrong" <adama(a)memetic.org> To: "" <observium(a)observium.org> Subject: Re: [Observium] Training/certification in Observium Message-ID: <18626553-3d9c-4310-9b94-72d77e0ed866(a)getmailbird.com> Content-Type: text/plain; charset="utf-8" Hi, There isn't really such a thing. What sort of stuff are you having trouble understanding? Thanks, adam. On 2018-08-16 08:32:33, Thomas Steffensen <thomass(a)parknet.dk> wrote: Hi, Does anyone know of online training/certification in Observium besides the youtube tutorials? Med venligst hilsen, Thomas Steffensen Network Administrator Parknet | Esromgade 15, opgang 1, 5. sal | 2200 København N | Phone +45 3690 6000 Mobil +45 4265 0504 | www.parknet.dk [http://www.parknet.dk/] -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://postman.memetic.org/pipermail/observium/attachments/20180816/f922654…> ------------------------------ Message: 2 Date: Thu, 16 Aug 2018 12:53:55 +0000 From: Thomas Steffensen <thomass(a)parknet.dk> To: Observium <observium(a)observium.org> Subject: Re: [Observium] Training/certification in Observium Message-ID: <304c63d9bff44304a508ed0b5a5985a8(a)EXCH01.parknet.local> Content-Type: text/plain; charset="utf-8" Well… To make a long story short the person who set Observium up and was managing it is no longer at the company I am working for and I want to monitor some devices but I am not getting all the information I want. I want to monitor a Juniper MX204 router and I am getting some stats but I keep seeing: Device not yet discovered I am getting usage, logs and alerts but I want to see if I can pull BGP neighborship information. I am running version 16.10.8128 but I do not know if an upgrade to 17.9.8859 is the answer as at this point I am more afraid of breaking things. Basically I would like a breakdown of all functionalities. Med venligst hilsen, Thomas Steffensen Network Administrator Parknet | Esromgade 15, opgang 1, 5. sal | 2200 København N | Phone +45 3690 6000 Mobil +45 4265 0504 | www.parknet.dk<http://www.parknet.dk/> From: observium <observium-bounces(a)observium.org> On Behalf Of Adam Armstrong Sent: Thursday, August 16, 2018 2:47 PM To: observium(a)observium.org Subject: Re: [Observium] Training/certification in Observium Hi, There isn't really such a thing. What sort of stuff are you having trouble understanding? Thanks, adam. On 2018-08-16 08:32:33, Thomas Steffensen <thomass(a)parknet.dk<mailto:thomass@parknet.dk>> wrote: Hi, Does anyone know of online training/certification in Observium besides the youtube tutorials? Med venligst hilsen, Thomas Steffensen Network Administrator Parknet | Esromgade 15, opgang 1, 5. sal | 2200 København N | Phone +45 3690 6000 Mobil +45 4265 0504 | www.parknet.dk<http://www.parknet.dk/> -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://postman.memetic.org/pipermail/observium/attachments/20180816/91ed3ee…> ------------------------------ Message: 3 Date: Thu, 16 Aug 2018 16:03:29 +0300 From: Moshe Yazdi <moshe(a)istraresearch.com> To: observium(a)observium.org Subject: [Observium] How do I create a Memory filter using entity type Message-ID: <CAK=puYadJfdhgGJM+ZK1sf4=vhiTCMnhOkZj1pfg8F31OD1HUQ(a)mail.gmail.com> Content-Type: text/plain; charset="utf-8" Hey, I have a memory alert configured in observium, *mempool_perc greater 90* with * as an entity filter [image: image.png] I get the same threshold memory monitor for all memory entities I'd like to filter memory alerts by entities [image: image.png] Can you please provide a syntax example on how to create a filter for "Virtual memory" so i can set a different threshold for it How can I find these myself next time? Thanks, - Moshe -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://postman.memetic.org/pipermail/observium/attachments/20180816/0bca124…> -------------- next part -------------- A non-text attachment was scrubbed... Name: image.png Type: image/png Size: 28443 bytes Desc: not available URL: <http://postman.memetic.org/pipermail/observium/attachments/20180816/0bca124…> -------------- next part -------------- A non-text attachment was scrubbed... Name: image.png Type: image/png Size: 23862 bytes Desc: not available URL: <http://postman.memetic.org/pipermail/observium/attachments/20180816/0bca124…> ------------------------------ Message: 4 Date: Thu, 16 Aug 2018 13:48:41 +0000 From: "Klimek, Denis" <DKlimek(a)Stadtwerke-Norderstedt.de> To: 'Observium' <observium(a)observium.org> Subject: Re: [Observium] Training/certification in Observium Message-ID: <d7adbf087fca4ebe801c98c1213a00db(a)Donald.Stadtwerke.Norderstedt> Content-Type: text/plain; charset="utf-8" Hi, before upgrading anything I would suggest you doing a full backup of the machine OR that’s the advantage of Observium: Do a backup of the /opt/observium directory and their contents. Then you can upgrade it and in case of troubles you can simple restore the data from backup (directory or full backup of the system). So you will only loose data that got collected between upgrade process and restore process. PS: share your knowledge across all employees ☺ 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/> Von: observium [mailto:observium-bounces@observium.org] Im Auftrag von Thomas Steffensen Gesendet: Donnerstag, 16. August 2018 14:54 An: Observium Betreff: Re: [Observium] Training/certification in Observium Well… To make a long story short the person who set Observium up and was managing it is no longer at the company I am working for and I want to monitor some devices but I am not getting all the information I want. I want to monitor a Juniper MX204 router and I am getting some stats but I keep seeing: Device not yet discovered I am getting usage, logs and alerts but I want to see if I can pull BGP neighborship information. I am running version 16.10.8128 but I do not know if an upgrade to 17.9.8859 is the answer as at this point I am more afraid of breaking things. Basically I would like a breakdown of all functionalities. Med venligst hilsen, Thomas Steffensen Network Administrator Parknet | Esromgade 15, opgang 1, 5. sal | 2200 København N | Phone +45 3690 6000 Mobil +45 4265 0504 | www.parknet.dk<http://www.parknet.dk/> From: observium <observium-bounces(a)observium.org> On Behalf Of Adam Armstrong Sent: Thursday, August 16, 2018 2:47 PM To: observium(a)observium.org Subject: Re: [Observium] Training/certification in Observium Hi, There isn't really such a thing. What sort of stuff are you having trouble understanding? Thanks, adam. On 2018-08-16 08:32:33, Thomas Steffensen <thomass(a)parknet.dk<mailto:thomass@parknet.dk>> wrote: Hi, Does anyone know of online training/certification in Observium besides the youtube tutorials? Med venligst hilsen, Thomas Steffensen Network Administrator Parknet | Esromgade 15, opgang 1, 5. sal | 2200 København N | Phone +45 3690 6000 Mobil +45 4265 0504 | www.parknet.dk<http://www.parknet.dk/> -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://postman.memetic.org/pipermail/observium/attachments/20180816/53284f1…> ------------------------------ Message: 5 Date: Thu, 16 Aug 2018 15:42:22 +0200 From: "Tomasz Karczewski" <tkarczewski(a)man.olsztyn.pl> To: "'Observium'" <observium(a)observium.org> Subject: Re: [Observium] Training/certification in Observium Message-ID: <019e01d43566$f81132c0$e8339840$(a)man.olsztyn.pl> Content-Type: text/plain; charset="utf-8" 1. Check your cron if you have „/usr/bin/php /opt/observium/discovery.php -h all >> /dev/null 2>&1” if not add it to crontab (once a day for all hosts is ok). 2. Check your cron if you have „/usr/bin/php /opt/observium/discovery.php -h new >> /dev/null 2>&1” if not add it to crontab (5 minute interval is ok). 3. You can manualy do discovery using „/usr/bin/php /opt/observium/discovery.php -h your_host” anytime Tomasz Karczewski Administrator Sieci tkarczewski(a)man.olsztyn.pl http://www.man.olsztyn.pl http://www.uwm.edu.pl tel. (89) 523 45 55 fax. (89) 523 43 47 Ośrodek Eksploatacji i Zarządzania Miejską Siecią Komputerową OLMAN w Olsztynie Uniwersytet Warmińsko-Mazurski w Olsztynie From: Thomas Steffensen <thomass(a)parknet.dk> Sent: Thursday, August 16, 2018 2:54 PM To: Observium <observium(a)observium.org> Subject: Re: [Observium] Training/certification in Observium Well… To make a long story short the person who set Observium up and was managing it is no longer at the company I am working for and I want to monitor some devices but I am not getting all the information I want. I want to monitor a Juniper MX204 router and I am getting some stats but I keep seeing: Device not yet discovered I am getting usage, logs and alerts but I want to see if I can pull BGP neighborship information. I am running version 16.10.8128 but I do not know if an upgrade to 17.9.8859 is the answer as at this point I am more afraid of breaking things. Basically I would like a breakdown of all functionalities. Med venligst hilsen, Thomas Steffensen Network Administrator Parknet | Esromgade 15, opgang 1, 5. sal | 2200 København N | Phone +45 3690 6000 Mobil +45 4265 0504 | www.parknet.dk <http://www.parknet.dk/> From: observium <observium-bounces(a)observium.org <mailto:observium-bounces@observium.org> > On Behalf Of Adam Armstrong Sent: Thursday, August 16, 2018 2:47 PM To: observium(a)observium.org <mailto:observium@observium.org> Subject: Re: [Observium] Training/certification in Observium Hi, There isn't really such a thing. What sort of stuff are you having trouble understanding? Thanks, adam. On 2018-08-16 08:32:33, Thomas Steffensen <thomass(a)parknet.dk <mailto:thomass@parknet.dk> > wrote: Hi, Does anyone know of online training/certification in Observium besides the youtube tutorials? Med venligst hilsen, Thomas Steffensen Network Administrator Parknet | Esromgade 15, opgang 1, 5. sal | 2200 København N | Phone +45 3690 6000 Mobil +45 4265 0504 | www.parknet.dk <http://www.parknet.dk/> -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://postman.memetic.org/pipermail/observium/attachments/20180816/f41a59b…> -------------- next part -------------- A non-text attachment was scrubbed... Name: image001.jpg Type: image/jpeg Size: 2142 bytes Desc: not available URL: <http://postman.memetic.org/pipermail/observium/attachments/20180816/f41a59b…> -------------- next part -------------- A non-text attachment was scrubbed... Name: smime.p7s Type: application/pkcs7-signature Size: 4277 bytes Desc: not available URL: <http://postman.memetic.org/pipermail/observium/attachments/20180816/f41a59b…> ------------------------------ Message: 6 Date: Thu, 16 Aug 2018 15:42:14 +0100 From: "Adam Armstrong" <adama(a)memetic.org> To: "" <observium(a)observium.org> Subject: Re: [Observium] How do I create a Memory filter using entity type Message-ID: <6ca23e3e-4f5b-440f-b691-2a254e1ff1df(a)getmailbird.com> Content-Type: text/plain; charset="utf-8" Hi, http://docs.observium.org/entities/#memory You want mempool_descr Thanks, adam. On 2018-08-16 14:04:10, Moshe Yazdi <moshe(a)istraresearch.com> wrote: Hey, I have a memory alert configured in observium, mempool_perc greater 90 with * as an entity filter [image.png] I get the same threshold memory monitor for all memory entities I'd like to filter memory alerts by entities [image.png] Can you please provide a syntax example on how to create a filter for "Virtual memory" so i can set a different threshold for it How can I find these myself next time? Thanks, - Moshe _______________________________________________ observium mailing list observium(a)observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://postman.memetic.org/pipermail/observium/attachments/20180816/00915fa…> ------------------------------ Subject: Digest Footer _______________________________________________ observium mailing list observium(a)observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium ------------------------------ End of observium Digest, Vol 97, Issue 12 *****************************************

1 0

How do I create a Memory filter using entity type
by Moshe Yazdi 16 Aug '18

16 Aug '18

Hey, I have a memory alert configured in observium, *mempool_perc greater 90* with * as an entity filter [image: image.png] I get the same threshold memory monitor for all memory entities I'd like to filter memory alerts by entities [image: image.png] Can you please provide a syntax example on how to create a filter for "Virtual memory" so i can set a different threshold for it How can I find these myself next time? Thanks, - Moshe

2 1

Training/certification in Observium
by Thomas Steffensen 16 Aug '18

16 Aug '18

Hi, Does anyone know of online training/certification in Observium besides the youtube tutorials? Med venligst hilsen, Thomas Steffensen Network Administrator Parknet | Esromgade 15, opgang 1, 5. sal | 2200 København N | Phone +45 3690 6000 Mobil +45 4265 0504 | www.parknet.dk<http://www.parknet.dk/>

4 4

I am not able to login in web interface after new install observium CE 17.9.0
by Cesar Vazquez Moreno 15 Aug '18

15 Aug '18

Hello, After install observium Community Edition 17.9.0 in Centos 7 and Nginx, I am not able to login for first time using web interface. The adduser script added correctly the admin user (also I created 3 more users) with level 10. The weird is there is not record of the action in any log. I did research and found similar issue about 5 years ago where the problem was the disk or partition was full, this is not my case, my / filesystem is 47% and /temp filesystem is 2%. other possibility is the session_start() can have troubles to write, but without log it's only a guess. I want to try set session_save_path() just before session_start() to see if this solve the issue. if you think my idea can work, in what file where should I put the variable? What do you think? any other idea? -- Regards Zague

2 2

Email notification
by Philippe Hurtubise 15 Aug '18

15 Aug '18

Hi, After upgrading to latest version, email notification stopped working. Thanks Philippe Hurtubise

2 5

Slow page generation when using group permissions
by Christian Eriksson 13 Aug '18

13 Aug '18

Hi, When using user level 1 permission with group permission, page generation is very slow. I have a total of 447 devices, where group X has 225 members When a user with permission to group X logs in, the frontpage takes 24s to load(using status_summary/map/syslog/eventlog/). Clicking on a device takes 22s. When an admin logs in, the "same" frontpage takes 0.6s to load Anyone got any tips? Fast userspace caching might work but I just wondered if there is something else to it Observium 18.8.9366 (10th August 2018) OS Linux 4.4.0-130-generic [amd64] (Ubuntu 16.04) Apache 2.4.18 (Ubuntu) PHP 7.0.30-0ubuntu0.16.04.1 (OPcache: ENABLED) Python 2.7.12 MySQL 5.7.23-0ubuntu0.16.04.1 (extension: mysqli 5.0.12-dev) SNMP NET-SNMP 5.7.3 RRDtool 1.5.5 (rrdcached 1.5.5: unix:/var/run/rrdcached.sock) Fping 3.13 (IPv4 and IPv6) Regards Christian

2 1

Re: [Observium] observium Digest, Vol 97, Issue 9
by Ricardo Franco Cantero 13 Aug '18

13 Aug '18

Yes that's correct. We would like to have one entry in Observium with multiple devices connected below. Is that possible? Kind regards, Ricardo Franco Cantero TSP Bombeeck Group BV -----Oorspronkelijk bericht----- Van: observium <observium-bounces(a)observium.org> Namens observium-request(a)observium.org Verzonden: maandag 13 augustus 2018 13:00 Aan: observium(a)observium.org Onderwerp: observium Digest, Vol 97, Issue 9 Send observium mailing list submissions to observium(a)observium.org To subscribe or unsubscribe via the World Wide Web, visit http://postman.memetic.org/cgi-bin/mailman/listinfo/observium or, via email, send a message with subject or body 'help' to observium-request(a)observium.org You can reach the person managing the list at observium-owner(a)observium.org When replying, please edit your Subject line so it is more specific than "Re: Contents of observium digest..." Today's Topics: 1. Multiple devices, one IP (Ricardo Franco Cantero) 2. Re: Multiple devices, one IP (Markus Klock) ---------------------------------------------------------------------- Message: 1 Date: Mon, 13 Aug 2018 07:27:26 +0000 From: Ricardo Franco Cantero <r.francocantero(a)tsp-bombeeck.nl> To: "observium(a)observium.org" <observium(a)observium.org> Subject: [Observium] Multiple devices, one IP Message-ID: <VI1P190MB02566D0ABACA1A07A4E5FAE5AD390(a)VI1P190MB0256.EURP190.PROD.OUTLOOK.COM> Content-Type: text/plain; charset="utf-8" Hi, We monitor connections (modems) and we want to begin monitoring also devices behind these modems. I know we can add them through port mapping since they're running on the same IP but then our Observium will be filled with green dots. We would like to group them by IP. Is there an option for this? Kind regards, Ricardo Franco -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://postman.memetic.org/pipermail/observium/attachments/20180813/f3d08e8…> ------------------------------ Message: 2 Date: Mon, 13 Aug 2018 10:19:52 +0200 From: Markus Klock <markus(a)best-practice.se> To: Observium <observium(a)observium.org> Subject: Re: [Observium] Multiple devices, one IP Message-ID: <CAF6uZmKBF_Su7qbi+fTToafgoWphpD48-MAvxnKqt+mQc5WNKA(a)mail.gmail.com> Content-Type: text/plain; charset="utf-8" Hi, I do not understand, what do you mean Observium will be filled with green dots? are you talking about the map on the frontpage? /Markus 2018-08-13 9:27 GMT+02:00 Ricardo Franco Cantero < r.francocantero(a)tsp-bombeeck.nl>: > Hi, > > > > We monitor connections (modems) and we want to begin monitoring also > devices behind these modems. > > I know we can add them through port mapping since they’re running on > the same IP but then our Observium will be filled with green dots. We > would like to group them by IP. Is there an option for this? > > > > Kind regards, > > > > Ricardo Franco > > _______________________________________________ > observium mailing list > observium(a)observium.org > http://postman.memetic.org/cgi-bin/mailman/listinfo/observium > > -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://postman.memetic.org/pipermail/observium/attachments/20180813/c319423…> ------------------------------ Subject: Digest Footer _______________________________________________ observium mailing list observium(a)observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium ------------------------------ End of observium Digest, Vol 97, Issue 9 ****************************************

2 1