- observium - lists.observium.org

Lot of DB errors
by Bastiaan Topper 24 Nov '15

24 Nov '15

Hi, I receive a lot of DB errors on my Observium server every polling interval. [2015/11/22 13:11:31 +0100] poller.php(14640): Failed dbQuery (#1062 - Duplicate entry '10471' for key 'PRIMARY'), Query: INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('10471') [2015/11/22 13:11:31 +0100] poller.php(14640): Failed dbQuery (#1062 - Duplicate entry '10472' for key 'PRIMARY'), Query: INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('10472') [2015/11/22 13:11:31 +0100] poller.php(14640): Failed dbQuery (#1062 - Duplicate entry '10473' for key 'PRIMARY'), Query: INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('10473') [2015/11/22 13:11:31 +0100] poller.php(14640): Failed dbQuery (#1062 - Duplicate entry '10474' for key 'PRIMARY'), Query: INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('10474') [2015/11/22 13:11:31 +0100] poller.php(14640): Failed dbQuery (#1062 - Duplicate entry '10476' for key 'PRIMARY'), Query: INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('10476') [2015/11/22 13:11:31 +0100] poller.php(14640): Failed dbQuery (#1062 - Duplicate entry '10477' for key 'PRIMARY'), Query: INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('10477') [2015/11/22 13:11:31 +0100] poller.php(14640): Failed dbQuery (#1062 - Duplicate entry '10478' for key 'PRIMARY'), Query: INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('10478') [2015/11/22 13:11:31 +0100] poller.php(14640): Failed dbQuery (#1062 - Duplicate entry '10480' for key 'PRIMARY'), Query: INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('10480') [2015/11/22 13:11:31 +0100] poller.php(14640): Failed dbQuery (#1062 - Duplicate entry '10481' for key 'PRIMARY'), Query: INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('10481') [2015/11/22 13:11:31 +0100] poller.php(14640): Failed dbQuery (#1062 - Duplicate entry '10482' for key 'PRIMARY'), Query: INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('10482') [2015/11/22 13:11:31 +0100] poller.php(14640): Failed dbQuery (#1062 - Duplicate entry '10484' for key 'PRIMARY'), Query: INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('10484') [2015/11/22 13:11:31 +0100] poller.php(14640): Failed dbQuery (#1062 - Duplicate entry '10485' for key 'PRIMARY'), Query: INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('10485') [2015/11/22 13:11:31 +0100] poller.php(14640): Failed dbQuery (#1062 - Duplicate entry '10486' for key 'PRIMARY'), Query: INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('10486') [2015/11/22 13:11:31 +0100] poller.php(14640): Failed dbQuery (#1062 - Duplicate entry '10488' for key 'PRIMARY'), Query: INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('10488') [2015/11/22 13:11:31 +0100] poller.php(14640): Failed dbQuery (#1062 - Duplicate entry '10489' for key 'PRIMARY'), Query: INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('10489') [2015/11/22 13:11:31 +0100] poller.php(14640): Failed dbQuery (#1062 - Duplicate entry '10490' for key 'PRIMARY'), Query: INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('10490') [2015/11/22 13:11:31 +0100] poller.php(14640): Failed dbQuery (#1062 - Duplicate entry '10491' for key 'PRIMARY'), Query: INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('10491') [2015/11/22 13:11:31 +0100] poller.php(14640): Failed dbQuery (#1062 - Duplicate entry '10493' for key 'PRIMARY'), Query: INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('10493') [2015/11/22 13:11:31 +0100] poller.php(14640): Failed dbQuery (#1062 - Duplicate entry '10494' for key 'PRIMARY'), Query: INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('10494') [2015/11/22 13:11:31 +0100] poller.php(14640): Failed dbQuery (#1062 - Duplicate entry '10495' for key 'PRIMARY'), Query: INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('10495') [2015/11/22 13:11:31 +0100] poller.php(14640): Failed dbQuery (#1062 - Duplicate entry '67419' for key 'PRIMARY'), Query: INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('67419') Every 5 minutes I have thousands of these errors in my error log (db.log in the observium logs folder). What could cause this? And how can I troubleshoot this? I already tried to delete a few from the mentioned entries from the database, but it recreates them and still returns the errors. Almost all errors are for the alert_table-state table. Thanks and regards, Bastiaan

6 15

Debugging rsyslog
by Tim Vaughan 24 Nov '15

24 Nov '15

I have a number of devices on separate VLANs to my Observium server. They are configured to send their logs via syslog to Observium. I have firewall rules in place on our router to allow this traffic between VLANs and I can see the traffic being passed in firewall logs. However, the log messages never seem to make it into Observium. How can I go about debugging rsyslog to see whether the logs arrive correctly at the server and are correctly processed by rsyslogd?

1 0

PHP Weathermap
by Serghei Golipad 24 Nov '15

24 Nov '15

Guys, Anyone minds sharing Observium version of Weathermap please? Cheers PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS EMAIL. Kelway (UK) Ltd is a Company registered in England and Wales. This email is sent for and on behalf of Kelway Holdings Limited. Kelway Holdings Limited is the UK holding company for Kelway (UK) Limited trading as Kelway. The registered office for Kelway Holdings Limited (Company Number 05872067) and its UK group undertakings is 10 Fleet Place, London, EC4M 7RB. VAT Registration 902 1949 39. Confidentiality: This e-mail contains proprietary information, some or all of which may be confidential and/or legally privileged. It is for the intended recipient only. If an addressing or transmission error has misdirected this e-mail, please notify the author by replying to this e-mail and then delete the original. If you are not the intended recipient you may not use, disclose, distribute, copy, print or rely on any information contained in this e-mail. You must not inform any other person other than Kelway or the sender of its existence. For more information about Kelway please visit www.kelway.co.uk

3 3

Dlink DES-1210-28
by Support 24 Nov '15

24 Nov '15

Hi, we have added a brand new Dlink (DES 1210-28) under monitor with last release of Observium (update just yesterday) the discover is ok but the data of interfaces (packets, bandwith, etc..) is not collect the devices is been delete e added more times any ideas? saluti, Giuseppe Caputo _____________________________________________________________________ NUCKLEO Information Technology Solutions Support & Delivery Team http://www.nuckleo.com _____________________________________________________________________

1 0

upgrade community version to paid version
by Ankit Dubey 24 Nov '15

24 Nov '15

Hi, I have installed community version and wish to upgrade it to paid version. What is the process? Do I need to provide internet connectivity to already installed server which is having community version and there is some process to upgrade the same to paid version directly? Best regards Ankit Dubey Lead, Packet Core Planning Division Network, CORPORATE CENTER ________________________________ This E-Mail may contain Confidential and/or legally privileged Information and is meant for the intended recipient(s) only. If you have received this e-mail in error and are not the intended recipient/s, Kindly notify the sender and then delete this e-mail immediately from your system. You are also hereby notified that any use, any form of reproduction, dissemination, copying, disclosure, modification, distribution and/or publication of this e-mail, its contents or its attachment/s other than by its intended recipient/s is strictly prohibited and may be unlawful. Internet Communications cannot be guaranteed to be secure or error-free as information could be delayed, intercepted, corrupted, lost, or contain viruses. Sistema Shyam Teleservices Limited does not accept any liability for any errors, omissions, viruses or computer problems experienced by any recipient as a result of this e-mail.

3 2

Arista "sensors" module taking a very long time
by Spencer Ryan 24 Nov '15

24 Nov '15

I'm hoping the answer isn't "make arista fix their SNMP engine" Polling a 7280 (64 ports of 10G) takes about 180 second, with 99% of that time in the sensors module. Running it in debug I see a lot of stalls, and this effectively repeating CMD[/usr/bin/snmpget -v2c -c *** -Pu -OUqnv -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':' core-1.aa.it.arbor.net':'161' aristaEntSensorThresholdHighWarning] EXITCODE[1] CMD RUNTIME[0.005s] STDOUT[ ] STDERR[ aristaEntSensorThresholdHighWarning: Unknown Object Identifier (Sub-id not found: (top) -> aristaEntSensorThresholdHighWarning) ] SNMP_STATUS[FALSE] SQL[SELECT * FROM `snmp_errors` WHERE `device_id` = '96' AND `error_code` = '1002' AND `snmp_cmd` = 'snmpget' AND `snmp_options` = '-OUqnv' AND `mib` = 'SNMPv2-MIB' AND `oid` = 'aristaEntSensorThresholdHighWarning';] SQL RUNTIME[0.00026798s] SQL[UPDATE `snmp_errors` set `error_count` ='471101',`updated` ='1448318766' WHERE `error_id` = '802'] SQL RUNTIME[0.00107193s] Array ( [sensor_value] => ) [RRD Disabled - update /opt/observium/rrd/ core-1.aa.it.arbor.net/sensor-power-entity-sensor-100315212.rrd N:0] Any idea if that's something you can fix? *Spencer Ryan* | Senior Systems Administrator | sryan(a)arbor.net *Arbor Networks* +1.734.794.5033 (d) | +1.734.846.2053 (m) www.arbornetworks.com

3 4

Re: [Observium] How to delete ports of devices?
by Tim Toepp 20 Nov '15

20 Nov '15

Chaman, Are they actually down? Meaning not being used? Or are you saying they are being incorrectly reported? So if they are actually down and you are asking how to NOT see the down ports in your listing: when you are on the GUI and you are looking at the Ports of a specific Device, click under Quick Filter you can hide different ports based on their status and one of the option is 'Hide Down'. The downside is that it doesn't retain and I haven't found a system wide setting/preference. If this works for you, what you could do is submit a feature request to make it a global setting not just a Quick Filter. But you really do not want to delete ports that are down as then you'll have to add them later when they become in use. HTH, Tim Date: Wed, 18 Nov 2015 10:32:07 +0530 From: Chaman Rathee <chaman.rathee(a)progression.com> To: 'Observium Network Observation System' <observium(a)observium.org> Subject: [Observium] How to delete ports of devices? Message-ID: <000001d121be$462b9820$d282c860$(a)progression.com> Content-Type: text/plain; charset="us-ascii" Hi Team, I have many ports that are showing down at observium monitoring system. So, please suggest how to delete "Down Ports" in observium. ......... With Best Regards, Chaman Rathee Mob. No:- +91-9560055816 --------------------------------------------------------------------------------------------------------------------- This e-mail and any attachments are from a sender at the Metropolitan School District of Washington Township in Indianapolis, Indiana. They are intended for the named recipients and may contain information that is confidential or privileged under Indiana and Federal Law. Any error in addressing or sending this e-mail is not a waiver of confidentiality and does not consent to copying or distribution of this e-mail or attachments. If you receive this e-mail in error, please notify the sender of the error by return e-mail and delete this e-mail and its attachments. If there is a need to speak to the sender, please call [317] 845-9400 and they can provide you with contact information.

1 0

front page editing
by Josh Bierman 20 Nov '15

20 Nov '15

Hello All, I want to keep the default layout of the front page with one change: replace the map with a traffic graph. When I tried this using the [frontpage][order] line (removed map from order and put in a custom graph, included EVERYTHING else) , the "Devices,Ports,Sensors" table at the top diapered. How do i get it back? Even if the answer is as simple as RTFM-pages #-## that would help. Thanks, Joshua Bierman Director of Technology Yeshivat Noam

3 4

Hoosekeeping Biling/Groups
by Robin Douine 20 Nov '15

20 Nov '15

Hello, We have users who have billing and groups permission but when we launch /opt/observium/housekeeping.php -b, the users loose their rights. It seems the problem is linked to this log : 1 entity entries in tables 'entity_permissions' for non-existing devices will be deleted [y/N]: Indeed, billing and groups doesn't be directly linked to devices. Best regards -- Robin DOUINE

1 1

Monitoring Snom phones
by Tim Vaughan 19 Nov '15

19 Nov '15

Hi, I'm trying to add several Snom 710 phones. The documentation says they will accept SNMP requests (http://wiki.snom.com/Category:HowTo:SNMP). However, I can't add it from Observium even if I enter my installation's IP address as trusted in the phone config. Checking the phone logs after trying to add them, I see: 17/11/2015 11:19:53 [NOTICE] TOOLS: SNMP: Received unknown object identifier 06082b06010201010200 17/11/2015 11:19:53 [NOTICE] TOOLS: SNMP: Received unknown object identifier 06082b06010201010300 17/11/2015 11:20:03 [NOTICE] TOOLS: SNMP: Received unknown object identifier 06082b06010201010200 17/11/2015 11:20:03 [NOTICE] TOOLS: SNMP: Received unknown object identifier 06082b06010201010300 Has anyone managed to get their Snom phones talking to Observium? -- Mobile: 07868246225 Skype: tvaughan Twitter: twitter.com/tvaughan

9 30