Re: [Observium] Missing ethernet port when monitoring Synology NAS
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@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
On 2018-01-10 16:06:16, Edwin Dijkstra <e.r.dijkstra@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@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@observium.org <mailto:observium@observium.org> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
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://docs.observium.org http://jira.observium.org On 2018-01-11 16:09:29, Tom Laermans 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@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@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@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@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@observium.org [mailto:observium@observium.org] http://postman.memetic.org/cgi-bin/mailman/listinfo/observium [http://postman.memetic.org/cgi-bin/mailman/listinfo/observium]
Hi Adam,
I confirm that my problem with the routerOS was a DB issue. I cleaned up the observium db in mysql and re-created it and now it works. But, no idea what was wrong with old db.
Alberto
Il 11/01/2018 16:18 Adam Armstrong ha scritto:
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://docs.observium.org http://jira.observium.org
On 2018-01-11 16:09:29, Tom Laermans 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] ON BEHALF OF Adam Armstrong SENT: Wednesday, January 10, 2018 10:48 PM TO: 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
On 2018-01-10 16:06:16, Edwin Dijkstra 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 [1]
On 9 Jan 2018, at 16:42, Edwin Dijkstra 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@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
Links:
[1] http://www.bluemail.me/r?b=11687 _______________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
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] On Behalf Of Adam Armstrong Sent: Thursday, January 11, 2018 5:19 PM To: 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
On 2018-01-11 16:09:29, Tom Laermans 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] On Behalf Of Adam Armstrong Sent: Wednesday, January 10, 2018 10:48 PM To: 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
On 2018-01-10 16:06:16, Edwin Dijkstra 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@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@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
_______________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
participants (4)
-
Adam Armstrong -
alberto＠busso.net -
Edwin Dijkstra -
Tom Laermans