- observium - lists.observium.org

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

Stacking graphs custom oid
by Basile Bluntschli 29 Mar '16

29 Mar '16

Hi How can I stack graphs of custom oids? As of now I see all the different hosts associated with this particular custom oid all togheter in one graph but not stacked. All hosts draw their individual values. Thanks Basile Sent from my iPhone

2 5

Observium projector and Rapsberry
by chott＠praha1.net 29 Mar '16

29 Mar '16

Hello anybody use Rapsberry Pi for projector ? we are looking for some startup script - boot Linux with X, Start Browser and autologin to Observium :) Tom

3 2

issue with broken graph
by Pui Edylie 28 Mar '16

28 Mar '16

Dear Members, We are running latest commercial version and currently we have about 260 devices with 24 probers. We are getting graph that is breaking up but the link is ok. Anyone has any idea? Thanks! Regards, Edy

4 11

Re: [Observium] Fwd: Request to check error message
by Dante Nolido 28 Mar '16

28 Mar '16

Hi Vincent, Thank you very much for the info. I'll try this later and give update as well. Regards, Dante C. Nolido Network Engineer | IPC (IP Converge Data Services, Inc) netsupport(a)ipc.ph | www.ipc.ph | www.cloud.com.ph Trunkline: (+632) 848 8700 option 1 | Mobile: +63 9175049465 / +63 9285598049 YM: n3tsupp0rt | Skype: netsupport.ipconverge Facebook <http://www.facebook.com/ipcph> • Twitter <http://www.twitter.com/ipc_ph> • LinkedIn <http://www.linkedin.com/company/ip-converge-data-services-inc-ipc-/> • Google+ <http://plus.google.com/u/0/+IpcPh/posts> • Instagram <http://instagram.com/ipc_ph> ---------- original message ---------- From: vincentcw <vincentcw(a)yahoo.fr> Date: Mon, Mar 28, 2016 at 3:45 PM Subject: Re :[Observium] Fwd: Request to check error message To: Observium Network Observation System <observium(a)observium.org>, Dante Nolido <dante.nolido(a)ipc.ph> Cc: Sherlene Solatorio <sherlene.solatorio(a)ipc.ph> Hi Dante Edit the file /etc/yum.repo.d/epel.repo. Uncomment the line beginning by Baseurl And comment these beginning by Mirrorlist Then try agin the yum command Vince Le lun. j mars AM à 5:40, Dante Nolido <dante.nolido(a)ipc.ph> a écrit : Hi Observium, May we follow up our reported concern below? Thank you. Regards, Dante C. Nolido Network Engineer | IPC (IP Converge Data Services, Inc) netsupport(a)ipc.ph | www.ipc.ph | www.cloud.com.ph Trunkline: (+632) 848 8700 option 1 | Mobile: +63 9175049465 / +63 9285598049 YM: n3tsupp0rt | Skype: netsupport.ipconverge Facebook <http://www.facebook.com/ipcph> • Twitter <http://www.twitter.com/ipc_ph> • LinkedIn <http://www.linkedin.com/company/ip-converge-data-services-inc-ipc-/> • Google+ <http://plus.google.com/u/0/+IpcPh/posts> • Instagram <http://instagram.com/ipc_ph> ---------- original message ---------- From: Dante Nolido <dante.nolido(a)ipc.ph> Date: Mon, Mar 21, 2016 at 2:38 PM Subject: Request to check error message[Observium] To: observium-subscribe(a)observium.org Cc: Sherlene Solatorio <sherlene.solatorio(a)ipc.ph>, Dante Nolido < dante.nolido(a)ipc.ph> Hi Observium Support, Greetings! May we ask why when we follow your download procedures, we are getting below error? Your assistance will be highly appreciated. Thank you. [image: Inline image 1] Regards, Dante C. Nolido Network Engineer | IPC (IP Converge Data Services, Inc) netsupport(a)ipc.ph | www.ipc.ph | www.cloud.com.ph Trunkline: (+632) 848 8700 option 1 | Mobile: +63 9175049465 / +63 9285598049 YM: n3tsupp0rt | Skype: netsupport.ipconverge Facebook <http://www.facebook.com/ipcph> • Twitter <http://www.twitter.com/ipc_ph> • LinkedIn <http://www.linkedin.com/company/ip-converge-data-services-inc-ipc-/> • Google+ <http://plus.google.com/u/0/+IpcPh/posts> • Instagram <http://instagram.com/ipc_ph> _______________________________________________ observium mailing list observium(a)observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium

1 0