- observium - lists.observium.org

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