- observium - lists.observium.org

No Auth_Mechanisms defined to add user
by David Shirk 06 Apr '16

06 Apr '16

All, So I followed the install process to a T, and it was going very well until I hit this: ./adduser.php <my username> <my Password> 10Observium CE 0.16.1.7533Add User ERROR: no valid auth_mechanism defined. I am running Debian 7 VM, and all dependencies are there. $config['auth_mechanism] = "mysql"; is in the config.php Anyone else run into this before?

1 0

Re: [Observium] Question Regarding CISCO and TX Discards
by Richard Müller 06 Apr '16

06 Apr '16

Hy Guys, thanks to all your feedback. I thought there is some "special black magic command" the guy from the ISP does not know (and me either) - "show int..." is of course known to me and should be known to everybody working on an ISP - but reality looks different. ;-) @Adam: Thanks for the Reference, to sort out the kind of error, this really helps me out. Richard -- Richard Müller | Geschäftsführer teamix GmbH Südwestpark 43 90449 Nürnberg Tel.: +49 911 30999 0 | Fax: +49 911 30999 99 mail: rm(a)teamix.de | web: http://www.teamix.de | blog: http://blog.teamix.de Amtsgericht Nürnberg, HRB 18320 | Geschäftsführer: Oliver Kügow, Richard Müller Systemhaus Check 2016 – wie zufrieden sind Sie? http://umfragen.idgmedia.de/uc/cw/sys2016/

1 0

Question Regarding CISCO and TX Discards
by Richard Müller 06 Apr '16

06 Apr '16

Hy Observium Community I have a router, which is only accessible via SNMP from my company, and it shows up some TX-Discards Just look on this picture: [cid:image001.png@01D1903E.84B547A0] Unfortunately the company who is administering the Router tells me that they do not see any error. I really do not have a clue which kind of Tx Discards these are and how they can be shown in CLI. Does anybody have a clue which “show” Command I have to tell the guy from the ISP that he is seeing these kinds of errors, also. It is a CISCO2911/K9 and it is a Gigabit Ethernet Interface. Thanks in advance. Richard -- <http://www.teamix.de>[teamix]<http://www.teamix.de> Richard Müller Geschäftsführer teamix GmbH Südwestpark 43 90449 Nürnberg Tel.: +49 911 30999 0 Fax: +49 911 30999 99 mail: rm(a)teamix.de web: http://www.teamix.de blog: http://blog.teamix.de Amtsgericht Nürnberg, HRB 18320 | Geschäftsführer: Oliver Kügow, Richard Müller Systemhaus Check 2016 – wie zufrieden sind Sie? http://umfragen.idgmedia.de/uc/cw/sys2016/

3 3

Monitoring job status
by Mark Creamer 06 Apr '16

06 Apr '16

Hi, is there a way within Observium to monitor a file system to check that a new file appears at a given time, or alternatively to monitor a log for an entry to appear? The idea is, there are some scheduled tasks running on a Linux server. We can have each task do something on completion, like write a file somewhere, write to a log, post to a database, etc. We want to see if Observium can watch for something like that and alert if it doesn't occur. Method is completely undecided at this point so any ideas are much appreciated. Thanks, -- Mark

1 0

Mail list archives.
by Luiz Gustavo Fernandes 06 Apr '16

06 Apr '16

Hello guys, where can I find the file from the email list? The link to the archive is broken. http://postman.memetic.org/cgi-bin/mailman/listinfo/observium -> http://postman.memetic.org/pipermail/observium/ Thanks

1 0

Observium detected as spam
by Simon Smith 06 Apr '16

06 Apr '16

Hi All, not sure if this is an issue with our mailcleaners or observium emails ? but our mailcleaners are now picking up observium emails as spam ? Score Description 2.0 TO_NO_BRKTS_HTML_IMG 2.0 XPRIO 1.3 HTML: images with 2000-2400 bytes of words 0.0 HTML included in message 5.3 we have a score of 5 set, so sadly just passes it the emails where never being detected with these TO_NO_BRKTS_HTML_IMG ? or XPIRO ? in the past, only recently? has the been any changes in the email alerts code at all ? Regards Simon - Hestor Ltd

2 2

Alert Notifications when Alerting is Disabled
by Müller, Gabriel 05 Apr '16

05 Apr '16

For devices I recently have added to my Observium installation, I receive interface / port ALERT and RECOVERY notifications emails even though I did disable Alerting under Properties > Ports, selecting no in the Alerts column. Version: 0.16.3.7653 Professional Any idea? Many thanks, Br Gabriel

1 0

Fwd: The archives are broken
by ovizii 05 Apr '16

05 Apr '16

I am getting a 404 error when visiting your archives: http://postman.memetic.org/pipermail/observium/ <http://postman.memetic.org/pipermail/observium/> -- The information in this email and attachments hereto may contain legally privileged, proprietary or confidential information that is intended for a particular recipient. If you are not the intended recipient(s), or the employee or agent responsible for delivery of this message to the intended recipient(s), you are hereby notified that any disclosure, copying, distribution, retention or use of the contents of this e-mail information is prohibited and may be unlawful. When addressed to customers or vendors, any information contained in this e-mail is subject to the terms and conditions in the governing contract, if applicable. If you have received this communication in error, please immediately notify us by return e-mail, permanently delete any electronic copies of this communication and destroy any paper copies.

3 3

Fwd: snmp stopped on all monitored devices at once
by ovizii 05 Apr '16

05 Apr '16

To start off, I have read the FAQ and tried the points described there to fix this exact problem but it didn't help. I have one Proxmox host running a fe w LXC c o ntainers, Observium is installed on one of them and successfully gathered data from all of them for a few days then stopped and shows all of them as down. Here is what I tried and do not understand: ferguson is the Observium container snmpwalk -c XXX -v 2c ferguson gives results, I can see stats and numbers so its working querying itself. snmpwalk -Os -c XXX -v 2c fergusona iso.3.6.1.2.1.1.1 sysDescr.0 = STRING: Linux ferguson 4.2.8-1-pve #1 SMP Sat Mar 19 10:44:29 CET 2016 x86_64 cd /opt/observium/ ./poller.php -d -h ferguson CMD[/usr/bin/snmpget -t '5' -r '10' -v2c -c *** -Pu -OQUst -m SNMPv2-MIB -M /opt/obse rvium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ferguson':'161' sysObje ctID.0 sysUpTime.0] EXITCODE[1] CMD RUNTIME[55.0381s] STDOUT[ ] STDERR[ Timeout: No Response from udp:ferguson:161. ] SNMP_STATUS[FALSE] o Device status Device is not responding to SNMP requests Any ideas how to debug or fix this? -- The information in this email and attachments hereto may contain legally privileged, proprietary or confidential information that is intended for a particular recipient. If you are not the intended recipient(s), or the employee or agent responsible for delivery of this message to the intended recipient(s), you are hereby notified that any disclosure, copying, distribution, retention or use of the contents of this e-mail information is prohibited and may be unlawful. When addressed to customers or vendors, any information contained in this e-mail is subject to the terms and conditions in the governing contract, if applicable. If you have received this communication in error, please immediately notify us by return e-mail, permanently delete any electronic copies of this communication and destroy any paper copies.

1 0

sample config for pps alerts to monitor
by Sathish.I 05 Apr '16

05 Apr '16

Hello All, I want to create alert for packet/sec (PPS), please let me know the sample config to configure it on observium. Regards, sathish Description: Description: Description: Description: Description: Description: http://www.ctrls.com/email-signature/images/devider.jpg

4 7

Re: [Observium] Graph PPPoE Session
by ChanTy 04 Apr '16

04 Apr '16

Any comment ? From: observium <observium-bounces(a)observium.org> on behalf of Ty Chan <ty.chan(a)corp.mekongnet.com.kh> Reply-To: Observium Network Observation System <observium(a)observium.org> Date: Monday, April 4, 2016 at 11:43 AM To: Observium Network Observation System <observium(a)observium.org> Subject: [Observium] Graph PPPoE Session Hi , Is it possible to graph PPPoE session/Interface? Is the feature there or I need to add on ? Regards, chanty _______________________________________________ observium mailing list observium(a)observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium

2 1

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

04 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 04 Apr '16

04 Apr '16

1 0

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

04 Apr '16

3 6

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

04 Apr '16

3 2

Traffic Graph
by RackEnd 04 Apr '16

04 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 30 Mar '16

30 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 29 Mar '16

29 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

Fwd: Request to check error message
by Dante Nolido 28 Mar '16

28 Mar '16

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>

2 1

Performance Data Aggregation
by Ruiz, Carlos 28 Mar '16

28 Mar '16

Good morning Maybe this is a silly question, if so sorry for disturbs If we collect performance data for almost 20k devices and we're interested in perform trend estimations with data for last 12months, does observium implement any aggregation method in order to avoid have an unmanageable amount of performance data stored?, if so, can you point me out to the proper place where i can find some information that can help me to understand the way this work is done? Thanks in advance for your help and patience and sorry again for these basic questions Kind Regards -- Carlos Ruiz Compute System Management Senior Engineer Roche Farma, S.A.Josefa Valcarcel, 40. ES-28027 Madrid (Spain) Phone: +34 91 305 99 25 Mobile: +34 662 10 46 14 * *

3 3

Authentication Failure
by Sathish.I 27 Mar '16

27 Mar '16

Hello Adam, I have found wired behavior with Observium, may be it is my configuration mistake or I am not sure. My issue, I am used login Observium GUI using admin user. After some days, when I try to login with observium I am getting authentication failed. Here I have not changed in configuration. This is happened, 3 times in last 1 month. Every time I used to rebuild the Observium. Please suggest a solution and let me know if you want any information. Regards, sathish

3 6

Display used VLAN's in the complete environment
by Jan Kuiper 25 Mar '16

25 Mar '16

Hello, Is it possible to create an view of the used vlan's in the complete environment? Now we can only see the vlan's configured on the different devices? If it is possible I like to see the vlan's to the different devices where it is used on and perhaps we can use a hyperlink to that device. VLan 1 "Name" --> Switch-01 --> Switch-02 Vlan 2 "Name 2" --> Switch-02 .... Met vriendelijke groet / Kind Regards, Jan Kuiper [cid:image001.jpg@01CF62F0.6DBAB760] Piramide ICT Services | Kollergang 9 | 7773 NG Hardenberg | Postbus 220 | 7770 AE Hardenberg info(a)piramide.nl<mailto:info@piramide.nl> | http://www.piramide.nl | +31 (0)523 261 387 Disclaimer Deze e-mail is uitsluitend bestemd voor de geadresseerde(n). Verstrekking aan en gebruik door anderen is niet toegestaan. Piramide sluit iedere aansprakelijkheid uit die voortvloeit uit elektronische verzending.

1 0

Stageing and live area
by Danny op de Dijk 25 Mar '16

25 Mar '16

Quick question to people who may know this bit of information regarding the license. We have as company an official version of Observium. We would like to know how many time we can install the software with that key. The reason is we would like to have a operational live situation and a testing area for new devices codes etc.... Is this possible or is it needed to buy two licenses. Thanks again for anyone that can answer this question. Kind regards, [B4ict_Logo_Only]Danny op de Dijk | B4ICT W: www.b4ict.nl<http://www.b4ict.nl> @: helpdesk(a)b4ict.nl<mailto:helpdesk@b4ict.nl> T: 035-678 06 65 Remote support (Windows)<http://www.b4ict.nl/downloads/teamviewer_windows.exe> Remote support (Mac)<http://www.b4ict.nl/downloads/teamviewer_mac.zip>

2 2

Custom MIBs
by Tibor Marchyn 25 Mar '16

25 Mar '16

Hi, We are using Sophos UTM (Astaro) appliance, but it's currently not supported by Observium by default. What is correct process to request adding support for additional MIBs? I didn't find simple answer if it's possible somehow just add MIB file to observium without developing. Thanks

1 0

Problem with RRD spikes
by Danny op de Dijk 25 Mar '16

25 Mar '16

Dear readers, As of a couple of months now we are the happy users of Observium. And after a lot of tweaking and tunning we have a great tool monitoring our network and all of its devices. Still there are some issues we still can't work out or find any information about on the net. I'll describe as best as I can wat I want to fix. On the Observium site there is a section called Miscellaneous with a need trick to irradicate those RDD spikes. The code to use on the command line is as follow: for i in rrd/*/*.rrd; do scripts/removespikes.pl $i; done; And when I execute this code on de command line of Observium (Via Putty) I'm only getting an error message saying: -bash: scripts/removespikes.pl: Permission denied And this message a couple of times over and over again. After a short whil it stopes and nothing has been done to the spikes on the tables of Observium. So natuarly my question is what am I doing wrong, or better what file or folder hasn't got the right rights for me to execute this command. It would be very helpful if these kind of information or any kind of information was availible on the Observium website, but it isn't. And I'm very doudfull it will ever happen. So if anyone has somekind of solution it would be very helpfull. Kind regards, [B4ict_Logo_Only]Danny op de Dijk | B4ICT W: www.b4ict.nl<http://www.b4ict.nl> @: helpdesk(a)b4ict.nl<mailto:helpdesk@b4ict.nl> T: 035-678 06 65 Remote support (Windows)<http://www.b4ict.nl/downloads/teamviewer_windows.exe> Remote support (Mac)<http://www.b4ict.nl/downloads/teamviewer_mac.zip>

2 2

Nested location menu without geocodes
by Wiethoff, Helge 24 Mar '16

24 Mar '16

Hi all, is it possible to make the location menu nested without using geocodes? Approximateley like the geocodes are managed... For example: Switch A: snmp location "Building 1, Floor 2, Room 23" Switch B: snmp location "Building 1, Floor 2, Room 23" Switch C: snmp location "Building 1, Floor 1, Room 42" Locations ------- Building 1 -> Floor 1 -> Room 42 (2 devices) -> Floor 2 -> Room 23 (1 device) Building X ... Maybe this is already possible but i am not able to configure it right :-) Otherwise this would be a nice feature when many devices are placed in the same building but in different floors/rooms. cheers, Helge PS: using Observium Professional 0.16.3.7659

3 7

Installed Observium 0.16.1.7533 Custom-Default in Config not working?
by Dano, Leo 24 Mar '16

24 Mar '16

Hello all, I have two installs and one works fine but the other that installed the exact same way shows the Custom and Defualt settings in Global Settings at the same time. You cannot click on them to change from Default to Custom. I installed the same exact way this week, but the one I installed last week works fine. Any thoughts? Thanks, ----------------------- Leo Dano

3 14

Re: [Observium] QUALCOMM spoof attempt detected: Re: Installed Observium 0.16.1.7533 Custom-Default in Config not working?
by Dano, Leo 24 Mar '16

24 Mar '16

please allow Thanks, ----------------------- Leo Dano IT Engineer Associate Engineering Compute Business Unit Qualcomm Inc. 858-845-2610 -----Original Message----- From: request.allow.spoof(a)qualcomm.com [mailto:request.allow.spoof@qualcomm.com] Sent: Thursday, March 24, 2016 9:08 AM To: Observium Network Observation System <observium(a)observium.org> Subject: QUALCOMM spoof attempt detected: Re: [Observium] Installed Observium 0.16.1.7533 Custom-Default in Config not working? PLEASE RESEND THE INFORMATION USING A PERSONAL EMAIL ADDRESS. -------------------------------------------------------------------------------------- An email has been sent to you from outside of Qualcomm, but the “From” address has been changed (i.e., spoofed) to make it look like it originated from inside Qualcomm. Since this can indicate a phishing attack the email has been quarantined to protect you. “Spoofing” can also occur when you use your Qualcomm email address on external websites to send yourself, friends, and colleagues articles, directions, reservations, etc. If you do not recognize the email or the email sender, there is no action required by you. The quarantined email will be deleted. If the quarantined email is business related, simply reply to this email with a justification for its release. To learn more about spoofing and why this email may have been labeled a spoofed email, please visit http://qwiki.qualcomm.com/it/QCSpoof. Quarantine: https://quarantine.qualcomm.com Remote Host: omega.memetic.org Server IP: 37.59.0.47 Envelope Sender: observium-bounces(a)observium.org From: "Dano, Leo" <ldano(a)qualcomm.com> To: Observium Network Observation System <observium(a)observium.org> Subject: Re: [Observium] Installed Observium 0.16.1.7533 Custom-Default in Config not working?

1 0