- observium - lists.observium.org

Re: [Observium] Missing ethernet port when monitoring Synology NAS
by Roeland Mertens 11 Jan '18

11 Jan '18

> I will install a Jessie version (Debian 8) and mysql instead of > MariaDB. I’ll let you know. Thanks for now. > > Regards, > > Edwin > <..snip...> Just out of curiosity, what does "show create table ports\G" say? rgds, -- Roeland

1 0

Re: [Observium] Missing ethernet port when monitoring Synology NAS
by Simon Mousey Smith 11 Jan '18

11 Jan '18

HI All Im having a similar issue in relations to ports strangely enough? Its only started happened since last SVN update which was midday today [2018/01/11 21:57:18 +0000] poller.php(17372): Failed dbQuery (#1062 - Duplicate entry '30-4' for key 'device_ifIndex'), Query: INSERT INTO `ports` (`device_id`,`ifIndex`) VALUES ('30','4’) Observium 17.12.8997 (26th December 2017) OS Linux 4.4.0-109-generic [amd64] (Ubuntu 16.04) Apache 2.4.18 (Ubuntu) PHP 7.0.22-0ubuntu0.16.04.1 (OPcache: ENABLED) Python 2.7.12 MySQL 5.7.20-0ubuntu0.16.04.1 (extension: mysqli 5.0.12-dev) SNMP NET-SNMP 5.7.3 RRDtool 1.5.5 Any suggestions? Regards Simon > On 11 Jan 2018, at 19:37, Edwin Dijkstra <e.r.dijkstra(a)ziggo.nl> wrote: > > I will install a Jessie version (Debian 8) and mysql instead of MariaDB. I’ll let you know. Thanks for now. > > Regards, > > Edwin > > > From: observium [mailto:observium-bounces@observium.org <mailto:observium-bounces@observium.org>] On Behalf Of Adam Armstrong > Sent: Thursday, January 11, 2018 7:26 PM > To: observium(a)observium.org <mailto:observium@observium.org> > Subject: Re: [Observium] Missing ethernet port when monitoring Synology NAS > > Try removing MariaDB and finding a MySQL package somewhere. That database is behaving strangely. > > adam. > > Adam Armstrong > Managing Director & Lead Architect > Observium Limited > http://www.observium.org <http://www.observium.org/> > http://docs.observium.org <http://docs.observium.org/> > http://jira.observium.org <http://jira.observium.org/>On 2018-01-11 16:48:14, Edwin Dijkstra <e.r.dijkstra(a)ziggo.nl <mailto:e.r.dijkstra@ziggo.nl>> wrote: >> >> In my case: >> >> Server version: 10.1.23-MariaDB-9+deb9u1 Raspbian 9.0 >> >> (For the time being, it’s running on a Raspberry Pi (just to see whether Observium will work for me) >> >> I followed the Debian/Ubuntu installation guide on the Observium website. >> >> Regards, >> >> Edwin >> >> >> From: observium [mailto:observium-bounces@observium.org <mailto:observium-bounces@observium.org>] On Behalf Of Adam Armstrong >> Sent: Thursday, January 11, 2018 5:19 PM >> To: observium(a)observium.org <mailto:observium@observium.org> >> Subject: Re: [Observium] Missing ethernet port when monitoring Synology NAS >> >> This is not an Observium issue, this is a weirdly configured database issue. This isn't the first time recently there's been someone seeing db insert problems that make zero sense. >> >> It's complaining about duplicate PRIMARY key, but that key is just port_id, which is AUTO_INCREMENT. If it thinks there's a duplicate of an AUTO_INCREMENTING primary key, it's the MySQL server being utterly broken. It probably also explains why that guy with the the routeros device couldn't insert more than two devices either. Presumably they're both running the same broken MySQL. >> >> Has someone packed up a MySQL in some distro with dumb settings? >> >> What OS is this running on, and where did the MySQL package come from? >> >> adam. >> >> Adam Armstrong >> Managing Director & Lead Architect >> Observium Limited >> http://www.observium.org <http://www.observium.org/> >> http://docs.observium.org <http://docs.observium.org/> >> http://jira.observium.org <http://jira.observium.org/>On 2018-01-11 16:09:29, Tom Laermans <tom.laermans(a)powersource.cx <mailto:tom.laermans@powersource.cx>> wrote: >>> >>> Looks like ifAlias isn't being returned. The INSERT passes '' to be inserted, which defaults to 0, but can only work for the first interface a device has... >>> >>> Tom >>> >>> >>> On 01/11/2018 05:03 PM, Edwin Dijkstra wrote: >>>> Ran the discovery, part of the output: >>>> >>>> o Discovering ports . >>>> SQL[INSERT INTO `ports` (`device_id`,`ifIndex`,`ifAlias`,`ifDescr`,`ifName`,`ifType`) VALUES ('5','2','','eth0','eth0','ethernetCsmacd')] >>>> SQL RUNTIME[0.00110412s] >>>> ERROR[Error in query: (Duplicate entry '0' for key 'PRIMARY') 1062] >>>> >>>> SQL[SELECT * FROM `ports` WHERE `device_id` = '5' AND `ifIndex` = '2'] >>>> SQL RUNTIME[0.00229788s] >>>> eth0(2)[] >>>> SQL[INSERT INTO `ports` (`device_id`,`ifIndex`,`ifAlias`,`ifDescr`,`ifName`,`ifType`) VALUES ('5','3','','sit0','sit0','tunnel')] >>>> SQL RUNTIME[0.00102282s] >>>> ERROR[Error in query: (Duplicate entry '0' for key 'PRIMARY') 1062] >>>> >>>> A database issue? >>>> >>>> Regards, >>>> >>>> Edwin >>>> >>>> >>>> From: observium [mailto:observium-bounces@observium.org <mailto:observium-bounces@observium.org>] On Behalf Of Adam Armstrong >>>> Sent: Wednesday, January 10, 2018 10:48 PM >>>> To: observium(a)observium.org <mailto:observium@observium.org> >>>> Subject: Re: [Observium] Missing ethernet port when monitoring Synology NAS >>>> >>>> ./discovery.php -h <hostname> -m ports -d >>>> >>>> adam. >>>> >>>> Adam Armstrong >>>> Managing Director & Lead Architect >>>> Observium Limited >>>> http://www.observium.org <http://www.observium.org/> >>>> http://docs.observium.org <http://docs.observium.org/> >>>> http://jira.observium.org <http://jira.observium.org/>On 2018-01-10 16:06:16, Edwin Dijkstra <e.r.dijkstra(a)ziggo.nl <mailto:e.r.dijkstra@ziggo.nl>> wrote: >>>>> >>>>> That’s what I thought;) >>>>> >>>>> When I scan the device using a simple SNMP tester, 3 IF’s are found: >>>>> >>>>> Found standard interfaces: >>>>> 1:lo: (001) lo Traffic,Connected,10 MBit/s,Software Loopback,lo, 64 Bit >>>>> 2:eth0: (002) eth0 Traffic,Connected,1 GBit/s,Ethernet,eth0, 64 Bit >>>>> 3:sit0: (003) sit0 Traffic,Not Connected,,Tunnel,sit0, 64 Bit >>>>> >>>>> Testing standard interfaces... >>>>> 1/10/2018 4:41:48 PM (861 ms) : SNMP Datatype: ASN_APP_COUNTER64 >>>>> 1/10/2018 4:41:48 PM (865 ms) : SNMP Datatype: ASN_APP_COUNTER64 >>>>> Test 1:lo (1.3.6.1.2.1.31.1.1.1.6.1,1.3.6.1.2.1.31.1.1.1.10.1): in=1891611 out=1891611 >>>>> 1/10/2018 4:41:48 PM (871 ms) : SNMP Datatype: ASN_APP_COUNTER64 >>>>> 1/10/2018 4:41:48 PM (877 ms) : SNMP Datatype: ASN_APP_COUNTER64 >>>>> Test 2:eth0 (1.3.6.1.2.1.31.1.1.1.6.2,1.3.6.1.2.1.31.1.1.1.10.2): in=92965523517 out=2582822450 >>>>> 1/10/2018 4:41:48 PM (884 ms) : SNMP Datatype: ASN_APP_COUNTER64 >>>>> 1/10/2018 4:41:48 PM (887 ms) : SNMP Datatype: ASN_APP_COUNTER64 >>>>> Test 3:sit0 (1.3.6.1.2.1.31.1.1.1.6.3,1.3.6.1.2.1.31.1.1.1.10.3): in=0 out=0 >>>>> >>>>> In Observium I only see the lo IF: >>>>> >>>>> Regards, >>>>> >>>>> Regards, >>>>> >>>>> Edwin >>>>> >>>>> >>>>> From: observium [mailto:observium-bounces@observium.org <mailto:observium-bounces@observium.org>] On Behalf Of Adam Armstrong >>>>> Sent: Wednesday, January 10, 2018 4:26 PM >>>>> To: 'Observium' >>>>> Cc: 'Observium' >>>>> Subject: Re: [Observium] Missing ethernet port when monitoring Synology NAS >>>>> >>>>> Monitoring interfaces is about as industry standard as it gets. If we're not picking up a port, it's because your device is bizarrely not exposing it. >>>>> >>>>> Have you tried walking the ifTable and seeing if it's present? >>>>> >>>>> Adam. >>>>> >>>>> Sent from BlueMail <http://www.bluemail.me/r?b=11687> >>>>> On 9 Jan 2018, at 16:42, Edwin Dijkstra <e.r.dijkstra(a)ziggo.nl <mailto:e.r.dijkstra@ziggo.nl>> wrote: >>>>> Hi, >>>>> >>>>> >>>>> I’m pretty new on ObserviumJ and could use some help: Added my Synology NAS. Want to monitor also the Network interface, but the only port I see is the loopback IF… >>>>> >>>>> >>>>> Thanks in advance. >>>>> >>>>> >>>>> Regards, >>>>> >>>>> >>>>> Edwin >>>>> >>>>> observium mailing list >>>>> observium(a)observium.org <mailto:observium@observium.org> >>>>> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium <http://postman.memetic.org/cgi-bin/mailman/listinfo/observium> >>>> >>>> >>>> >>>> _______________________________________________ >>>> observium mailing list >>>> observium(a)observium.org <mailto:observium@observium.org> >>>> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium <http://postman.memetic.org/cgi-bin/mailman/listinfo/observium> > _______________________________________________ > observium mailing list > observium(a)observium.org <mailto:observium@observium.org> > http://postman.memetic.org/cgi-bin/mailman/listinfo/observium <http://postman.memetic.org/cgi-bin/mailman/listinfo/observium>

2 1

Re: [Observium] Missing ethernet port when monitoring Synology NAS
by Tom Laermans 11 Jan '18

11 Jan '18

Looks like ifAlias isn't being returned. The INSERT passes '' to be inserted, which defaults to 0, but can only work for the first interface a device has... Tom On 01/11/2018 05:03 PM, Edwin Dijkstra wrote: > > Ran the discovery, part of the output: > > o Discovering ports . > > SQL[INSERT INTO `ports` > (`device_id`,`ifIndex`,`ifAlias`,`ifDescr`,`ifName`,`ifType`) VALUES > ('5','2','','eth0','eth0','ethernetCsmacd')] > > SQL RUNTIME[0.00110412s] > > ERROR[Error in query: (Duplicate entry '0' for key 'PRIMARY') 1062] > > SQL[SELECT * FROM `ports` WHERE `device_id` = '5' AND `ifIndex` = '2'] > > SQL RUNTIME[0.00229788s] > > eth0(2)[] > > SQL[INSERT INTO `ports` > (`device_id`,`ifIndex`,`ifAlias`,`ifDescr`,`ifName`,`ifType`) VALUES > ('5','3','','sit0','sit0','tunnel')] > > SQL RUNTIME[0.00102282s] > > ERROR[Error in query: (Duplicate entry '0' for key 'PRIMARY') 1062] > > A database issue? > > Regards, > > Edwin > > *From:*observium [mailto:observium-bounces@observium.org] *On Behalf > Of *Adam Armstrong > *Sent:* Wednesday, January 10, 2018 10:48 PM > *To:* observium(a)observium.org > *Subject:* Re: [Observium] Missing ethernet port when monitoring > Synology NAS > > ./discovery.php -h <hostname> -m ports -d > > adam. > > Adam Armstrong > > Managing Director & Lead Architect > > Observium Limited > > http://www.observium.org > > http://docs.observium.org > > http://jira.observium.org > > On 2018-01-10 16:06:16, Edwin Dijkstra <e.r.dijkstra(a)ziggo.nl > <mailto:e.r.dijkstra@ziggo.nl>> wrote: > > That’s what I thought;) > > When I scan the device using a simple SNMP tester, 3 IF’s are found: > > Found standard interfaces: > > 1:lo: (001) lo Traffic,Connected,10 MBit/s,Software Loopback,lo, > 64 Bit > > 2:eth0: (002) eth0 Traffic,Connected,1 GBit/s,Ethernet,eth0, 64 Bit > > 3:sit0: (003) sit0 Traffic,Not Connected,,Tunnel,sit0, 64 Bit > > Testing standard interfaces... > > 1/10/2018 4:41:48 PM (861 ms) : SNMP Datatype: ASN_APP_COUNTER64 > > 1/10/2018 4:41:48 PM (865 ms) : SNMP Datatype: ASN_APP_COUNTER64 > > Test 1:lo (1.3.6.1.2.1.31.1.1.1.6.1,1.3.6.1.2.1.31.1.1.1.10.1): > in=1891611 out=1891611 > > 1/10/2018 4:41:48 PM (871 ms) : SNMP Datatype: ASN_APP_COUNTER64 > > 1/10/2018 4:41:48 PM (877 ms) : SNMP Datatype: ASN_APP_COUNTER64 > > Test 2:eth0 (1.3.6.1.2.1.31.1.1.1.6.2,1.3.6.1.2.1.31.1.1.1.10.2): > in=92965523517 out=2582822450 > > 1/10/2018 4:41:48 PM (884 ms) : SNMP Datatype: ASN_APP_COUNTER64 > > 1/10/2018 4:41:48 PM (887 ms) : SNMP Datatype: ASN_APP_COUNTER64 > > Test 3:sit0 (1.3.6.1.2.1.31.1.1.1.6.3,1.3.6.1.2.1.31.1.1.1.10.3): > in=0 out=0 > > In Observium I only see the lo IF: > > Regards, > > Regards, > > Edwin > > *From:*observium [mailto:observium-bounces@observium.org] *On > Behalf Of *Adam Armstrong > *Sent:* Wednesday, January 10, 2018 4:26 PM > *To:* 'Observium' > *Cc:* 'Observium' > *Subject:* Re: [Observium] Missing ethernet port when monitoring > Synology NAS > > Monitoring interfaces is about as industry standard as it gets. If > we're not picking up a port, it's because your device is bizarrely > not exposing it. > > Have you tried walking the ifTable and seeing if it's present? > > Adam. > > Sent from BlueMail <http://www.bluemail.me/r?b=11687> > > On 9 Jan 2018, at 16:42, Edwin Dijkstra <e.r.dijkstra(a)ziggo.nl > <mailto:e.r.dijkstra@ziggo.nl>> wrote: > > Hi, > > I’m pretty new on ObserviumJand could use some help: Added my > Synology NAS. Want to monitor also the Network interface, but the > only port I see is the loopback IF… > > Thanks in advance. > > Regards, > > Edwin > > ------------------------------------------------------------------------ > > observium mailing list observium(a)observium.org > <mailto:observium@observium.org> > http://postman.memetic.org/cgi-bin/mailman/listinfo/observium > > > > _______________________________________________ > observium mailing list > observium(a)observium.org > http://postman.memetic.org/cgi-bin/mailman/listinfo/observium

4 3

Re: [Observium] Missing ethernet port when monitoring Synology NAS
by Adam Armstrong 11 Jan '18

11 Jan '18

./discovery.php -h <hostname> -m ports -d adam. Adam Armstrong Managing Director & Lead Architect Observium Limited http://www.observium.org http://docs.observium.org http://jira.observium.org On 2018-01-10 16:06:16, Edwin Dijkstra <e.r.dijkstra(a)ziggo.nl> wrote: That’s what I thought;) When I scan the device using a simple SNMP tester, 3 IF’s are found: Found standard interfaces: 1:lo: (001) lo Traffic,Connected,10 MBit/s,Software Loopback,lo, 64 Bit 2:eth0: (002) eth0 Traffic,Connected,1 GBit/s,Ethernet,eth0, 64 Bit 3:sit0: (003) sit0 Traffic,Not Connected,,Tunnel,sit0, 64 Bit Testing standard interfaces... 1/10/2018 4:41:48 PM (861 ms) : SNMP Datatype: ASN_APP_COUNTER64 1/10/2018 4:41:48 PM (865 ms) : SNMP Datatype: ASN_APP_COUNTER64 Test 1:lo (1.3.6.1.2.1.31.1.1.1.6.1,1.3.6.1.2.1.31.1.1.1.10.1): in=1891611 out=1891611 1/10/2018 4:41:48 PM (871 ms) : SNMP Datatype: ASN_APP_COUNTER64 1/10/2018 4:41:48 PM (877 ms) : SNMP Datatype: ASN_APP_COUNTER64 Test 2:eth0 (1.3.6.1.2.1.31.1.1.1.6.2,1.3.6.1.2.1.31.1.1.1.10.2): in=92965523517 out=2582822450 1/10/2018 4:41:48 PM (884 ms) : SNMP Datatype: ASN_APP_COUNTER64 1/10/2018 4:41:48 PM (887 ms) : SNMP Datatype: ASN_APP_COUNTER64 Test 3:sit0 (1.3.6.1.2.1.31.1.1.1.6.3,1.3.6.1.2.1.31.1.1.1.10.3): in=0 out=0 In Observium I only see the lo IF: Regards, Regards, Edwin From: observium [mailto:observium-bounces@observium.org] On Behalf Of Adam Armstrong Sent: Wednesday, January 10, 2018 4:26 PM To: 'Observium' Cc: 'Observium' Subject: Re: [Observium] Missing ethernet port when monitoring Synology NAS Monitoring interfaces is about as industry standard as it gets. If we're not picking up a port, it's because your device is bizarrely not exposing it. Have you tried walking the ifTable and seeing if it's present? Adam. Sent from BlueMail [http://www.bluemail.me/r?b=11687] On 9 Jan 2018, at 16:42, Edwin Dijkstra <e.r.dijkstra(a)ziggo.nl [mailto:e.r.dijkstra@ziggo.nl]> wrote: Hi, I’m pretty new on ObserviumJ and could use some help: Added my Synology NAS. Want to monitor also the Network interface, but the only port I see is the loopback IF… Thanks in advance. Regards, Edwin observium mailing list observium(a)observium.org [mailto:observium@observium.org] http://postman.memetic.org/cgi-bin/mailman/listinfo/observium [http://postman.memetic.org/cgi-bin/mailman/listinfo/observium]

2 1

Polling/alerts
by Hermes J. Martinez 11 Jan '18

11 Jan '18

Hello everyone, I am new to Observium and I have a question, can someone explain to me how the polling works? And the email alerts are sent when the device is down/up(Recover) or when the polling time is met? For example: In the next image I have two cases at 9:37am I received the email for the alert and for the recovery (this is normal or I need to check somethings in the config?) Thank you! kind Regards Hermes J. Martinez Sistemas corporativo <mailto:hermes.martinez@pueblobonito.com.mx> hermes.martinez(a)pueblobonito.com.mx (669) 989-8900 | EXT 8656 (669) 120-8470 <http://www.pueblobonito.com/> www.pueblobonito.com.mx <http://www.pueblobonito.com/real-escape> Read about the Real Escape at Pueblo Bonito Connect with us <https://twitter.com/PuebloBonito> <https://plus.google.com/103008660176547960870/about> <https://www.facebook.com/PuebloBonitoResort> <https://www.instagram.com/pueblobonito/> <http://www.pueblobonito.com/blog/> Do you really need to print this e-mail? En realidad necesita imprimir este correo? Aviso Legal / Legal Notice http://img.pueblobonito.com.mx/legal

2 2

Consultant help?
by Ben Filippelli 11 Jan '18

11 Jan '18

Is there any gurus out there willing to work with me on setting up some remote monitoring and alerts on observium Sent from Nine<http://www.9folders.com/>

7 15

stopping queued alerts
by Edvinas K 10 Jan '18

10 Jan '18

Hello, Recently we had a case when network infrastructure went down, and only after some time we fixed it. Observium noticed it and everything was OK. But in meantime of fixing it - Observium started to flood with alerts - this may be the correct case. But after we repaired the network - and everything was OK, we still had a flood of old errors and it continued about an hour or so. I tried to disable email alerts through config.php, supress all alerts through WEB interface - but nothing helped. So is there any manual way to stop the Alerting queue ? Thanks

3 3

Re: [Observium] Missing ethernet port when monitoring Synology NAS
by Adam Armstrong 10 Jan '18

10 Jan '18

Monitoring interfaces is about as industry standard as it gets. If we're not picking up a port, it's because your device is bizarrely not exposing it. Have you tried walking the ifTable and seeing if it's present? Adam. ⁣Sent from BlueMail On 9 Jan 2018, 16:42, at 16:42, Edwin Dijkstra <e.r.dijkstra(a)ziggo.nl> wrote: >Hi, > > > >I'm pretty new on ObserviumJ and could use some help: Added my Synology >NAS. >Want to monitor also the Network interface, but the only port I see is >the >loopback IF. > > > >Thanks in advance. > > > >Regards, > > > >Edwin > > > >------------------------------------------------------------------------ > >_______________________________________________ >observium mailing list >observium(a)observium.org >http://postman.memetic.org/cgi-bin/mailman/listinfo/observium

2 1

Adjust values returned for custom OID
by Vater, Wolfgang 10 Jan '18

10 Jan '18

Hi, I collect temperature data through a custom OID The value returned is 236. That is 23.6 °C Is there a way to have Observium display this with one decimal point? Wolfgang Vater | Lead Client Architect | Enterprise Services Unisys Deutschland GmbH | +49 162 255 9338 | wolfgang.vater(a)unisys.com | Philipp-Reis-Str. 2 | 65795 Hattersheim <http://www.unisys.com/> Unisys Deutschland GmbH | Geschäftsführer: Sandro Lindner & Dr. Uwe Heckert | Sitz der Gesellschaft: Hattersheim | Amtsgericht: Frankfurt/Main HRB 7929 THIS COMMUNICATION MAY CONTAIN CONFIDENTIAL AND/OR OTHERWISE PROPRIETARY MATERIAL and is thus for use only by the intended recipient. If you received this in error, please contact the sender and delete the e-mail and its attachments from all computers. DIESE E-MAIL IST AUSSCHLIESSLICH FÜR DEN ADRESSATEN BESTIMMT UND KANN VERTRAULICHE INFORMATIONEN ENTHALTEN. Sollten Sie nicht der Adressat dieser Informationen sein, bitten wir Sie, sich mit dem Absender in Verbindung zu setzen und die Informationen von Ihren Endgeräten zu entfernen. <http://www.linkedin.com/company/unisys> <http://twitter.com/unisyscorp> <https://plus.google.com/+UnisysCorp/posts> <http://www.youtube.com/theunisyschannel> <http://www.facebook.com/unisyscorp> <https://vimeo.com/unisys> <http://blogs.unisys.com/>

5 6

exclude or skip wildcard match for poller and discovery
by Richard Wigzell 10 Jan '18

10 Jan '18

Hello, We are currently running Pro r8993 with 650+ devices and will be adding another 400 or so shortly, to support this we will try a deployment as described in some detail by Markus: http://blog.best-practice.se/2017/10/scaling-observium-horizontally.html We do however also have another edge case to deal with in the form of an infrastructure that we cannot look into but can send out of, the inhibitor is political and not technical. We are halfway to solving it technically however by using a poller remotely with wildcard host name matching as the 'remote' stuff has a common domain part. Our other 'normal' pollers however need to be told to exclude or skip polling / discovery of the remote devices. Can a wildcard skip or exclude be added to the poller-wrapper script for this purpose? Picture attached for reference. 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/>

3 3