- observium - lists.observium.org

Cisco WS-C3850-48P
by Christopher N Callison 05 Apr '16

05 Apr '16

I have a pair of Cisco 3850 switches (stacked) that I'm using as a core for our relatively small office. I have added them to my Observium system and the normal Cisco L2 & L3 interfaces have been detected and are now in monitoring but the wireless features of the devices are not showing up. I would like to graph the number of active users for each WLAN. I see from Cisco's site (ftp://ftp.cisco.com/pub/mibs/supportlists/cat3850/cat3850-supportlist.html) , that there are a few wireless-oriented MIBs that are supported, but I don't see them in the list of MIBs on my Observium server. AIRESPACE-WIRELESS-MIB CISCO-LWAPP-IDS-MIB CISCO-LWAPP-AP-MIB CISCO-LWAPP-CCX-RM-MIB CISCO-LWAPP-CLIENT-ROAMING-MIB CISCO-LWAPP-DOT11-CCX-CLIENT-DIAG-MIB CISCO-LWAPP-DOT11-CCX-CLIENT-MIB CISCO-LWAPP-DOT11-CLIENT-CCX-REPORTS-MIB CISCO-LWAPP-DOT11-CLIENT-MIB CISCO-LWAPP-DOT11-MIB CISCO-LWAPP-DOWNLOAD-MIB CISCO-LWAPP-LINKTEST-MIB CISCO-LWAPP-MFP-MIB CISCO-LWAPP-MOBILITY-EXT-MIB CISCO-LWAPP-QOS-MIB CISCO-LWAPP-REAP-MIB CISCO-LWAPP-ROGUE-MIB CISCO-LWAPP-RRM-MIB CISCO-LWAPP-SI-MIB CISCO-LWAPP-TSM-MIB CISCO-LWAPP-WLAN-MIB CISCO-LWAPP-WLAN-SECURITY-MIB Is there a procedure for configuring the devices to start using the new MIBs once they have been copied to the appropriate directory or do I need to play around with a SNMP walker to find them myself? Chris Callison

2 3

Re: [Observium] Traffic Graph
by RackEnd 05 Apr '16

05 Apr '16

1 0

Re: [Observium] Traffic Graph
by RackEnd 05 Apr '16

05 Apr '16

3 6

Re: [Observium] Traffic Graph
by RackEnd 05 Apr '16

05 Apr '16

3 2

Traffic Graph
by RackEnd 05 Apr '16

05 Apr '16

2 1

Juniper BGP description
by Eduardo Schoedler 04 Apr '16

04 Apr '16

Hi, Is there a way to get bgp neigbor's description from Juniper? Their MIB support it? Thanks. -- Eduardo Schoedler

2 1

SNMP Trap Import
by Kevin Wormington 04 Apr '16

04 Apr '16

Hi, I’m new to Observium (paid version) and am working toward replacing Zabbix completely with it. I see that there is some old/unsupported support for importing LinkUp/LinkDown traps from snmptt in snmptrap.php. I’m going to be testing it out in the next few days and making any required fixes to get it going with current versions. I have also though about implementing some type of mechanism to log/alert on various traps other than LinkUp/LinkDown such as ColdStart, etc. I am curious if there is any interest in that from other users and any input on how people would like to see it implemented and if anyone else is currently using it. Thanks, Kevin

1 0

Graph PPPoE Session
by ChanTy 04 Apr '16

04 Apr '16

Hi , Is it possible to graph PPPoE session/Interface? Is the feature there or I need to add on ? Regards, chanty

1 0

Missing TenGigabit interfaces on Cisco WC-C4900M
by Per Jorgensen 03 Apr '16

03 Apr '16

Hi all First of all thank to the team of developer for making this program, and making it better and better everyday, love the look and ease of use. But I have run into a problem with a Tengigabit ethernet device I newly added into my Observium v. 0.12.8.3360. it seems that every thing get detected alright, except all the TenGigabitEthernet, interfaces dont show up anywhere in Observium, all other interfaces on that device gets detectet allright, and I can see the interfaces in the ports tab on the device, but not the TenGengigabit interfaces. btw: the device is a Cisco WS-C4900M Is that because Cisco WS-C4900M is not a supported device , or should I do some config changes to get TenGigabitEthernet to work ? if the WC-C4900M is not supported, how can I then contribute with information on the device , and help to then this device supported ? Best Regards Per Jorgensen

7 8

How to add support for new device/type?
by Jens Bürger 02 Apr '16

02 Apr '16

Hello everyone, first: the mailing list archive is somehow not online: http://postman.memetic.org/pipermail/observium/ So I couldn’t have look at the archive to see if my question was answered recently. I would like to add support for my PBX (Siemens HiPath 3000 series, model 3800) to Observium. There this a file containing MIBs available and someone also did preliminary support for Nagios: https://exchange.nagios.org/directory/Plugins/Hardware/Network-Gear/Siemens… So I had a look at this site: http://www.observium.org/docs/developing/add_os/ The file os.inc.php doesn’t exist, but a definitions.dat instead which is a binary file. So I wonder where to start i.e. getting some kind of device template I can start with? Thanks a lot, Jens

1 0

switchmap re: host<-->port L2/L3 matrix
by Rob VanHooren 02 Apr '16

02 Apr '16

indeed, it would be quite handy to have information about the end hosts. obviously not a full scrape of them for monitoring, but that they exist, what they are, and where. ideally, there could be some observium-style SPoG embrace of Pete Siemsen’s switchmap ( https://sourceforge.net/projects/switchmap/ ) his is a wonderfully useful tool in terms of how much information it packs onto one page, but visually … it’s rather archaic. $0.02 R. > On Apr 2, 2016, at 02:47, observium-request(a)observium.org wrote: > >> Adam / Tom / Justin / David /etc/ >> >> {various discussion about port matrix L2 L3 presentation etc…} >>

1 0

patch: show ip associated with mac
by Justin Cinkelj 02 Apr '16

02 Apr '16

Hi I here and there search for IP address belonging to certain MAC address. Below is a tiny patch to show that info in observium. Data is read from arpwatch datafile (path to datafile is set in config.php): // enable arpwatch $config['arpwatch']['datafile'] = "/var/lib/arpwatch/arp.dat"; And once IP is known, reverse DNS name is informative too. Patch acceptable for inclusion? BR Justin diff --git a/html/ajax/entity_popup.php b/html/ajax/entity_popup.php index 86c2b43..ef2fe18 100644 --- a/html/ajax/entity_popup.php +++ b/html/ajax/entity_popup.php @@ -73,6 +73,25 @@ switch ($vars['entity_type']) } else { echo 'Not Found'; } + // search for mac in arpwatch datafile + $aw_on = array_key_exists("arpwatch", $config) && + array_key_exists("datafile", $config["arpwatch"]) && + $config["arpwatch"]["datafile"]; + if ($aw_on) { + // lines are formated: mac ip timestamp name + $aw_file = "/var/lib/arpwatch/arp.dat"; + $aw_data = file_get_contents($aw_file); + $aw_data = explode("\n", $aw_data); + for ($line = 0; $line < count($aw_data); $line++) { + if (strpos($aw_data[$line], $vars['entity_id']) !== false) { + list($aw_mac, $aw_ip, $aw_timestamp, $aw_name) = preg_split("/\s+/", $aw_data[$line]); + echo "<br>arpwatch: " . $aw_ip . " " . $aw_name; + // with IP, rev DNS can be tried + $rdns_name = gethostbyaddr($aw_ip ); + echo "<br>rDNS: " . $rdns_name; + } + } + } } else { echo 'Not correct MAC address'; }

5 12

Raspberry Pi Chrome Kiosk
by Simon Smith 01 Apr '16

01 Apr '16

Hi All I just thought I would show off my Raspberry Pi Chrome Kiosk running Observium, monitoring one of our sites main Internet LAN port :D Raspberry Pi 3 being powered by USB off the TV, HDMI to TV and using built in WiFi, so no network leads! :D Regards Simon

2 3

Observium Error
by Sathish.I 31 Mar '16

31 Mar '16

Hello All, When I am logging to Observium via GUI, I am receiving below error. Please let us what is the error exactly?. MySQL Error 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) -Sathish

2 1

Alerts based on a sudden increase of packets per second
by Stephen Fulton 31 Mar '16

31 Mar '16

Hi all, Is there a way to generate an alert when an interface has a significant increase of packets per second, compared to a previous recorded amount? Is there a way to compare deltas? I'm looking to identify interfaces which may be experience a DoS situation. Thanks, -- Stephen

2 2

LDAP/AD Groups
by Spencer Ryan 31 Mar '16

31 Mar '16

Hey Tom, Can you log into an AD setup you have with /debug/ and tell me what this says? LDAP[UserID][XXXXX] In our environment I had to patch ldap.inc.php to get the UID to map properly (and thus apply groups). Before that the UserID would always be -1. I'm trying to figure out if I had some bad config.php settings, or if it's actually broken and I can send you guys the patch I wrote. Thanks! *Spencer Ryan* | Senior Systems Administrator | sryan(a)arbor.net *Arbor Networks* +1.734.794.5033 (d) | +1.734.846.2053 (m) www.arbornetworks.com

1 0

Solaris Filesystems not being read correctly
by Dano, Leo 31 Mar '16

31 Mar '16

Good morning all, Linux nodes read fine, but Solaris is not reading the partition size correctly. Example: / partition going directly onto the Solaris host shows is to be 5.7TB Observium shows it as much smaller 1.78tb Any thoughts? Or is Solaris not fully supported? Thanks, ----------------------- Leo Dano

3 2

Device Offline Alerts missing graph
by Jason Macri 31 Mar '16

31 Mar '16

Our alerts for device offline are showing the following, any tips on how to get the graph to display correctly? [cid:image005.jpg@01D18A5F.F2256C00] FYI we are running Observium 0.16.2.7635 (29th February 2016) Regards, Jason Macri Onsite Support Engineer How am I doing? Please click here<http://www.techpath.com.au/contact-us/feedback/> to rate my work. [cid:image001.png@01D18A5F.66443F90]<http://www.techpath.com.au/> P 1300 033 300 F 07 3809 3999 E jason(a)techpath.com.au www.techpath.com.au<http://www.techpath.com.au> Unit 2/55 Tradelink Rd, Hillcrest QLD 4118 [Facebook]<http://www.facebook.com/techpathau> [Twitter]<http://twitter.com/techpathau> [LinkedIn]<http://www.linkedin.com/company/techpathau> Note: This message may contain privileged and confidential information that is the property of the intended recipient. The information herein is intended only for use of the addressee. If you are not the intended recipient, then you are requested to return e-mail to TechPath Pty Ltd and destroy any copies made. Copying or disseminating any of this message is prohibited. Any views expressed in this message are those of the individual sender and may not necessarily reflect the views of TechPath Pty Ltd.

4 3

Going from Community to Subscription Edition?
by Dano, Leo 30 Mar '16

30 Mar '16

Hello all, Is the process painless in going from the Community Edition to the Subscription Version? Thanks, ----------------------- Leo Dano

4 5

Scheduled Maintenance problem
by Cody Cook 30 Mar '16

30 Mar '16

0.16.3.7712 When I am trying to schedule maintenance, I select the dates. On appy, it sets the dates to 1969. Before [image: Inline image 1] After [image: Inline image 2]

2 1

db.log errors
by Jason Lixfeld 30 Mar '16

30 Mar '16

Hi! Running 7229 on Debian 8.0, MySQL 5.5.43 I was seeing these errors filling up db.log: [2015/12/24 08:10:19 -0500] poller.php(32567): Failed dbQuery (#1062 - Duplicate entry '251-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('251','','3304742660','65536','input') [2015/12/24 08:10:19 -0500] poller.php(32567): Failed dbQuery (#1062 - Duplicate entry '251-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('251','','3304742676','65536','input') [2015/12/24 08:10:19 -0500] poller.php(1068): Failed dbQuery (#1062 - Duplicate entry '210-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('210','','3304742660','65536','input') [2015/12/24 08:10:19 -0500] poller.php(1068): Failed dbQuery (#1062 - Duplicate entry '210-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('210','','3304742676','65536','input') [2015/12/24 08:10:20 -0500] poller.php(1615): Failed dbQuery (#1062 - Duplicate entry '285-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('285','','3304742660','65536','input') [2015/12/24 08:10:20 -0500] poller.php(1615): Failed dbQuery (#1062 - Duplicate entry '285-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('285','','3304742676','65536','input') [2015/12/24 08:10:21 -0500] poller.php(26382): Failed dbQuery (#1062 - Duplicate entry '245-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('245','','3304742660','65536','input') [2015/12/24 08:10:21 -0500] poller.php(26382): Failed dbQuery (#1062 - Duplicate entry '245-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('245','','3304742676','65536','input') [2015/12/24 08:10:22 -0500] poller.php(26381): Failed dbQuery (#1062 - Duplicate entry '246-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('246','','3304742660','65536','input') [2015/12/24 08:10:22 -0500] poller.php(26381): Failed dbQuery (#1062 - Duplicate entry '246-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('246','','3304742676','65536','input’) After upgrading to 7338, running ./discovery.php -u, seeing the DB upgrades happen without incident, I’m still seeing the same: root@monitor:/opt/observium# svn update Updating '.’: … stuff … … things … Updated to revision 7338. root@monitor:/opt/observium# ./discovery.php -u ___ _ _ / _ \ | |__ ___ ___ _ __ __ __(_) _ _ _ __ ___ | | | || '_ \ / __| / _ \| '__|\ \ / /| || | | || '_ ` _ \ | |_| || |_) |\__ \| __/| | \ V / | || |_| || | | | | | \___/ |_.__/ |___/ \___||_| \_/ |_| \__,_||_| |_| |_| Observium Professional 0.15.12.7338 http://www.observium.org -- Updating database/file schema 252 -> 253 ... (db) done. 253 -> 254 ... (db) done. 254 -> 255 ... (db) done. -- Done. root@monitor:/opt/observium# [2015/12/24 08:20:06 -0500] poller.php(13878): Failed dbQuery (#1062 - Duplicate entry '209-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('209','','3304742660','65536','input') [2015/12/24 08:20:06 -0500] poller.php(13878): Failed dbQuery (#1062 - Duplicate entry '209-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('209','','3304742676','65536','input') [2015/12/24 08:20:06 -0500] poller.php(13870): Failed dbQuery (#1062 - Duplicate entry '228-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('228','','3304742660','65536','input') [2015/12/24 08:20:06 -0500] poller.php(13870): Failed dbQuery (#1062 - Duplicate entry '228-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('228','','3304742676','65536','input') [2015/12/24 08:20:06 -0500] poller.php(13881): Failed dbQuery (#1062 - Duplicate entry '243-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('243','','3304742660','65536','input') [2015/12/24 08:20:06 -0500] poller.php(13881): Failed dbQuery (#1062 - Duplicate entry '243-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('243','','3304742676','65536','input') [2015/12/24 08:20:06 -0500] poller.php(13880): Failed dbQuery (#1062 - Duplicate entry '203-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('203','','3304742660','65536','input') [2015/12/24 08:20:06 -0500] poller.php(13880): Failed dbQuery (#1062 - Duplicate entry '203-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('203','','3304742676','65536','input') [2015/12/24 08:20:06 -0500] poller.php(13879): Failed dbQuery (#1062 - Duplicate entry '276-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('276','','3304742660','65536','input') [2015/12/24 08:20:06 -0500] poller.php(13879): Failed dbQuery (#1062 - Duplicate entry '276-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('276','','3304742676','65536','input') [2015/12/24 08:20:07 -0500] poller.php(13890): Failed dbQuery (#1062 - Duplicate entry '250-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('250','','3304742660','65536','input') [2015/12/24 08:20:07 -0500] poller.php(13890): Failed dbQuery (#1062 - Duplicate entry '250-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('250','','3304742676','65536','input') [2015/12/24 08:20:07 -0500] poller.php(13895): Failed dbQuery (#1062 - Duplicate entry '241-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('241','','3304742660','65536','input') [2015/12/24 08:20:07 -0500] poller.php(13895): Failed dbQuery (#1062 - Duplicate entry '241-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('241','','3304742676','65536','input') [2015/12/24 08:20:10 -0500] poller.php(13860): Failed dbQuery (#1062 - Duplicate entry '229-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('229','','3304742660','65536','input') [2015/12/24 08:20:10 -0500] poller.php(13860): Failed dbQuery (#1062 - Duplicate entry '229-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('229','','3304742676','65536','input') [2015/12/24 08:20:10 -0500] poller.php(13883): Failed dbQuery (#1062 - Duplicate entry '230-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('230','','3304742660','65536','input') [2015/12/24 08:20:10 -0500] poller.php(13883): Failed dbQuery (#1062 - Duplicate entry '230-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('230','','3304742676','65536','input') [2015/12/24 08:20:10 -0500] poller.php(13864): Failed dbQuery (#1062 - Duplicate entry '162-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('162','','3304742660','65536','input') [2015/12/24 08:20:10 -0500] poller.php(13864): Failed dbQuery (#1062 - Duplicate entry '162-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('162','','3304742676','65536','input') [2015/12/24 08:20:10 -0500] poller.php(13854): Failed dbQuery (#1062 - Duplicate entry '244-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('244','','3304742660','65536','input') [2015/12/24 08:20:10 -0500] poller.php(13854): Failed dbQuery (#1062 - Duplicate entry '244-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('244','','3304742676','65536','input') [2015/12/24 08:20:11 -0500] poller.php(13834): Failed dbQuery (#1062 - Duplicate entry '184-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('184','','3304742660','65536','input') [2015/12/24 08:20:11 -0500] poller.php(13834): Failed dbQuery (#1062 - Duplicate entry '184-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('184','','3304742676','65536','input') [2015/12/24 08:20:11 -0500] poller.php(13793): Failed dbQuery (#1062 - Duplicate entry '163-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('163','','3304742660','65536','input') [2015/12/24 08:20:11 -0500] poller.php(13793): Failed dbQuery (#1062 - Duplicate entry '163-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('163','','3304742676','65536','input') [2015/12/24 08:20:11 -0500] poller.php(13779): Failed dbQuery (#1062 - Duplicate entry '193-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('193','','3304742660','65536','input') [2015/12/24 08:20:11 -0500] poller.php(13779): Failed dbQuery (#1062 - Duplicate entry '193-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('193','','3304742676','65536','input') [2015/12/24 08:20:11 -0500] poller.php(13771): Failed dbQuery (#1062 - Duplicate entry '239-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('239','','3304742660','65536','input') [2015/12/24 08:20:11 -0500] poller.php(13771): Failed dbQuery (#1062 - Duplicate entry '239-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('239','','3304742676','65536','input') [2015/12/24 08:20:11 -0500] poller.php(13832): Failed dbQuery (#1062 - Duplicate entry '270-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('270','','3304742660','65536','input') [2015/12/24 08:20:11 -0500] poller.php(13832): Failed dbQuery (#1062 - Duplicate entry '270-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('270','','3304742676','65536','input') [2015/12/24 08:20:11 -0500] poller.php(13799): Failed dbQuery (#1062 - Duplicate entry '161-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('161','','3304742660','65536','input') [2015/12/24 08:20:11 -0500] poller.php(13799): Failed dbQuery (#1062 - Duplicate entry '161-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('161','','3304742676','65536','input') [2015/12/24 08:20:11 -0500] poller.php(13756): Failed dbQuery (#1062 - Duplicate entry '204-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('204','','3304742660','65536','input') [2015/12/24 08:20:11 -0500] poller.php(13756): Failed dbQuery (#1062 - Duplicate entry '204-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('204','','3304742676','65536','input') [2015/12/24 08:20:12 -0500] poller.php(13765): Failed dbQuery (#1062 - Duplicate entry '222-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('222','','3304742660','65536','input') [2015/12/24 08:20:12 -0500] poller.php(13765): Failed dbQuery (#1062 - Duplicate entry '222-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('222','','3304742676','65536','input') [2015/12/24 08:20:13 -0500] poller.php(16864): Failed dbQuery (#1062 - Duplicate entry '273-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('273','','3304742660','65536','input') [2015/12/24 08:20:13 -0500] poller.php(16864): Failed dbQuery (#1062 - Duplicate entry '273-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('273','','3304742676','65536','input') [2015/12/24 08:20:13 -0500] poller.php(17012): Failed dbQuery (#1062 - Duplicate entry '281-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('281','','3304742660','65536','input') [2015/12/24 08:20:13 -0500] poller.php(17012): Failed dbQuery (#1062 - Duplicate entry '281-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('281','','3304742676','65536','input') [2015/12/24 08:20:13 -0500] poller.php(17032): Failed dbQuery (#1062 - Duplicate entry '181-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('181','','3304742660','65536','input') [2015/12/24 08:20:13 -0500] poller.php(17032): Failed dbQuery (#1062 - Duplicate entry '181-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('181','','3304742676','65536','input') [2015/12/24 08:20:13 -0500] poller.php(17217): Failed dbQuery (#1062 - Duplicate entry '278-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('278','','3304742660','65536','input') [2015/12/24 08:20:13 -0500] poller.php(17217): Failed dbQuery (#1062 - Duplicate entry '278-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('278','','3304742676','65536','input') [2015/12/24 08:20:13 -0500] poller.php(17345): Failed dbQuery (#1062 - Duplicate entry '211-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('211','','3304742660','65536','input') [2015/12/24 08:20:13 -0500] poller.php(17345): Failed dbQuery (#1062 - Duplicate entry '211-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('211','','3304742676','65536','input') [2015/12/24 08:20:14 -0500] poller.php(13737): Failed dbQuery (#1062 - Duplicate entry '232-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('232','','3304742660','65536','input') [2015/12/24 08:20:14 -0500] poller.php(13737): Failed dbQuery (#1062 - Duplicate entry '232-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('232','','3304742676','65536','input') [2015/12/24 08:20:14 -0500] poller.php(13735): Failed dbQuery (#1062 - Duplicate entry '226-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('226','','3304742660','65536','input') [2015/12/24 08:20:14 -0500] poller.php(13735): Failed dbQuery (#1062 - Duplicate entry '226-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('226','','3304742676','65536','input') [2015/12/24 08:20:18 -0500] poller.php(19456): Failed dbQuery (#1062 - Duplicate entry '210-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('210','','3304742660','65536','input') [2015/12/24 08:20:18 -0500] poller.php(19456): Failed dbQuery (#1062 - Duplicate entry '210-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('210','','3304742676','65536','input') [2015/12/24 08:20:18 -0500] poller.php(19111): Failed dbQuery (#1062 - Duplicate entry '238-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('238','','3304742660','65536','input') [2015/12/24 08:20:18 -0500] poller.php(19111): Failed dbQuery (#1062 - Duplicate entry '238-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('238','','3304742676','65536','input') [2015/12/24 08:20:18 -0500] poller.php(19948): Failed dbQuery (#1062 - Duplicate entry '285-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('285','','3304742660','65536','input') [2015/12/24 08:20:18 -0500] poller.php(19948): Failed dbQuery (#1062 - Duplicate entry '285-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('285','','3304742676','65536','input') [2015/12/24 08:20:18 -0500] poller.php(20215): Failed dbQuery (#1062 - Duplicate entry '279-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('279','','3304742660','65536','input') [2015/12/24 08:20:18 -0500] poller.php(20215): Failed dbQuery (#1062 - Duplicate entry '279-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('279','','3304742676','65536','input') [2015/12/24 08:20:18 -0500] poller.php(20315): Failed dbQuery (#1062 - Duplicate entry '242-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('242','','3304742660','65536','input') [2015/12/24 08:20:18 -0500] poller.php(20315): Failed dbQuery (#1062 - Duplicate entry '242-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('242','','3304742676','65536','input') [2015/12/24 08:20:18 -0500] poller.php(20298): Failed dbQuery (#1062 - Duplicate entry '284-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('284','','3304742660','65536','input') [2015/12/24 08:20:18 -0500] poller.php(20298): Failed dbQuery (#1062 - Duplicate entry '284-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('284','','3304742676','65536','input') [2015/12/24 08:20:18 -0500] poller.php(19663): Failed dbQuery (#1062 - Duplicate entry '172-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('172','','3304742660','65536','input') [2015/12/24 08:20:18 -0500] poller.php(19663): Failed dbQuery (#1062 - Duplicate entry '172-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('172','','3304742676','65536','input') [2015/12/24 08:20:19 -0500] poller.php(19825): Failed dbQuery (#1062 - Duplicate entry '277-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('277','','3304742660','65536','input') [2015/12/24 08:20:19 -0500] poller.php(19825): Failed dbQuery (#1062 - Duplicate entry '277-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('277','','3304742676','65536','input') [2015/12/24 08:20:19 -0500] poller.php(20333): Failed dbQuery (#1062 - Duplicate entry '251-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('251','','3304742660','65536','input') [2015/12/24 08:20:19 -0500] poller.php(20333): Failed dbQuery (#1062 - Duplicate entry '251-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('251','','3304742676','65536','input') [2015/12/24 08:20:19 -0500] poller.php(20258): Failed dbQuery (#1062 - Duplicate entry '283-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('283','','3304742660','65536','input') [2015/12/24 08:20:19 -0500] poller.php(20258): Failed dbQuery (#1062 - Duplicate entry '283-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('283','','3304742676','65536','input') [2015/12/24 08:20:20 -0500] poller.php(13725): Failed dbQuery (#1062 - Duplicate entry '245-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('245','','3304742660','65536','input') [2015/12/24 08:20:20 -0500] poller.php(13725): Failed dbQuery (#1062 - Duplicate entry '245-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('245','','3304742676','65536','input') [2015/12/24 08:20:21 -0500] poller.php(13719): Failed dbQuery (#1062 - Duplicate entry '246-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('246','','3304742660','65536','input') [2015/12/24 08:20:21 -0500] poller.php(13719): Failed dbQuery (#1062 - Duplicate entry '246-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('246','','3304742676','65536','input’) A previous post regarding DB errors requested column output from the DB for the affected table. I trust this might be useful in this case as well? mysql> show columns from ports_cbqos; +---------------------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------------+-------------+------+-----+---------+----------------+ | cbqos_id | int(11) | NO | PRI | NULL | auto_increment | | device_id | int(11) | NO | MUL | NULL | | | port_id | int(11) | NO | MUL | NULL | | | direction | varchar(16) | NO | | NULL | | | PrePolicyPkt | int(11) | NO | | NULL | | | PrePolicyPkt_rate | int(11) | NO | | NULL | | | PrePolicyByte | int(11) | NO | | NULL | | | PrePolicyByte_rate | int(11) | NO | | NULL | | | PostPolicyByte | int(11) | NO | | NULL | | | PostPolicyByte_rate | int(11) | NO | | NULL | | | DropPkt | int(11) | NO | | NULL | | | DropPkt_rate | int(11) | NO | | NULL | | | DropByte | int(11) | NO | | NULL | | | DropByte_rate | int(11) | NO | | NULL | | | NoBufDropPkt | int(11) | NO | | NULL | | | NoBufDropPkt_rate | int(11) | NO | | NULL | | | cbqos_lastpolled | int(11) | NO | | NULL | | | policy_index | int(11) | NO | | NULL | | | object_index | int(11) | NO | | NULL | | | policy_name | varchar(64) | NO | | NULL | | | object_name | varchar(64) | NO | | NULL | | +---------------------+-------------+------+-----+---------+----------------+ 21 rows in set (0.00 sec) mysql> Any ideas? Thanks in advance!

2 3

Transfer Historical data to another instance of Observium?
by Dano, Leo 30 Mar '16

30 Mar '16

Good morning all, I was wondering if there was a way to move some historical data from one Observium to another? Or is there mysql issues with ID's, etc? Thanks, ----------------------- Leo Dano

5 8

Telegram Bot Alerter
by Cody Cook 30 Mar '16

30 Mar '16

Hi, Noticed an alert checker for Telegram bots. Just recently got into Telegram. Is there any information on this? I setup my username (both with and without @) and put in the token from BotFather in the config and used test_alert.php -a 9 and it says it sends an alert. Do I need something to customize my bot to make it send messages? Thanks

4 13

Guest User Access
by Cameron Murray 29 Mar '16

29 Mar '16

Morning Everyone, Is it possible to setup a user with limited access to a specific customer group? Eg. IBM User can only see IBM devices? Regards, Cameron Murray Senior Communications Manager How am I doing? Please click here<http://www.techpath.com.au/contact-us/feedback/> to rate my work. [cid:image001.png@01D18A56.403FF950]<http://www.techpath.com.au/> P 1300 033 300 F 07 3809 3999 E cameron(a)techpath.com.au www.techpath.com.au<http://www.techpath.com.au> Unit 2/55 Tradelink Rd, Hillcrest QLD 4118 [Facebook]<http://www.facebook.com/techpathau> [Twitter]<http://twitter.com/techpathau> [LinkedIn]<http://www.linkedin.com/company/techpathau> Note: This message may contain privileged and confidential information that is the property of the intended recipient. The information herein is intended only for use of the addressee. If you are not the intended recipient, then you are requested to return e-mail to TechPath Pty Ltd and destroy any copies made. Copying or disseminating any of this message is prohibited. Any views expressed in this message are those of the individual sender and may not necessarily reflect the views of TechPath Pty Ltd.

1 0

syslog issue with Palo Alto Firewalls ?
by Bradley, Jim 29 Mar '16

29 Mar '16

Hey, So I’ve got a new installation of Observium pro up and running with 160+ devices, and everything is working as expected, with a minor exception: Syslog messages from Palo Alto boxes arrive successfully at the Centos 7 box, but are not added to the devices logging/syslog page in Observium. So far syslog messages for all other vendors are correctly added to the devices. Is there anything you can advise me to do to further diagnose whats wrong? or is there a problem with the format of Palo messages ? This is not critical to me, but i have 6 PA’s all of which are in the audit, and having the syslog of all the config changes right in the web gui along with the events and stats is a nice simple way for the auditors to get the warm and fuzzys about me not just making it all up.. it’d be great to have. I temporarily disabled the forward of syslog to Observium by commenting out “$IncludeConfig /etc/rsyslog.d/*.conf” and restarting rsyslog, at which point the below example messages successfully drop into /var/log/messages. Mar 28 16:10:42 Location-PA-200.usa.neopost.com 1,2016/03/28 16:10:42,001606058055,SYSTEM,routing,0,2016/03/28 16:10:42,,routed-config-p2-success,,0,0,general,informational,Route daemon configuration load phase-2 succeeded.,15787,0x0,0,0,0,0,,Location-PA-200 Mar 28 16:10:42 Location-PA-200.usa.neopost.com 1,2016/03/28 16:10:42,001606058055,SYSTEM,vpn,0,2016/03/28 16:10:42,,ike-config-p2-success,,0,0,general,informational,IKE daemon configuration load phase-2 succeeded.,15788,0x0,0,0,0,0,,Location-PA-200 Mar 28 16:10:42 Location-PA-200.usa.neopost.com 1,2016/03/28 16:10:42,001606058055,SYSTEM,ras,0,2016/03/28 16:10:42,,rasmgr-config-p2-success,,0,0,general,informational,RASMGR daemon configuration load phase-2 succeeded.,15789,0x0,0,0,0,0,,Location-PA-200 Mar 28 16:10:42 Location-PA-200.usa.neopost.com 1,2016/03/28 16:10:42,001606058055,SYSTEM,satd,0,2016/03/28 16:10:42,,satd-config-p2-success,,0,0,general,informational,SATD daemon configuration load phase-2 succeeded.,15790,0x0,0,0,0,0,,Location-PA-200 Mar 28 16:10:42 Location-PA-200.usa.neopost.com 1,2016/03/28 16:10:42,001606058055,SYSTEM,sslmgr,0,2016/03/28 16:10:42,,sslmgr-config-p2-success,,0,0,general,informational,SSLMGR daemon configuration load phase-2 succeeded.,15791,0x0,0,0,0,0,,Location-PA-200 The only caveat i can think of, is that i don’t have all my devices names in DNS, instead i cheated and built them in /etc/hosts. This seems to work for everything else, so I’m not sure thats whats causing this. My hunch is that the Observium syslog parser doesn’t like the string from the Palo’s, is there a way to see logs for that (without breaking everything else) ? [root@observium ~]# ping Location-PA-200.usa.neopost.com PING Location-PA-200.usa.neopost.com (10.10.10.2) 56(84) bytes of data. 64 bytes from Location-PA-200.usa.neopost.com (10.10.10.2): icmp_seq=1 ttl=52 time=44.3 ms 64 bytes from Location-PA-200.usa.neopost.com (10.10.10.2): icmp_seq=2 ttl=52 time=44.6 ms ^C --- Location-PA-200.usa.neopost.com ping statistics --- 2 packets transmitted, 2 received, 0% packet loss, time 1001ms rtt min/avg/max/mdev = 44.373/44.532/44.691/0.159 ms [root@observium ~]# Appreciate your help, Thanks -- Jim Bradley IT Network Engineer and Security Officer Phone: +1 203 301 3749<tel://+1%20203%20301%203749> Mobile: +1 203 308 3047<tel://+1%20203%20308%203047> Neopost USA - 478 Wheelers Farms Rd - 06461 Milford CT - United States www.neopost.com<http://www.neopost.com/>

1 0