- observium - lists.observium.org

front page editing
by Josh Bierman 20 Nov '15

20 Nov '15

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

3 4

Hoosekeeping Biling/Groups
by Robin Douine 20 Nov '15

20 Nov '15

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

1 1

Monitoring Snom phones
by Tim Vaughan 19 Nov '15

19 Nov '15

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

9 30

Re: [Observium] Who's running Observium on distros that aren't Ubuntu/Debian/RHEL/CentOS?
by T-MONT Administrator 19 Nov '15

19 Nov '15

Hi Guys, My installation is running smoothly on Slackware Linux ver. 14.1 (x86_64). No special, dedicated actions performed to launch Observium beside of manual installation of RRDTool and few requires dependencies. Regards, Pawel On 19.11.2015 01:46, Ciro Iriarte wrote: > 2015-07-25 16:42 GMT-04:00 Adam Armstrong <adama(a)memetic.org>: > >> Hi Guys, >> >> Are any of you running Observium on distros which aren't the ones we >> recommend? >> >> Did you have to do anything special? >> >> I think we're probably way more friendly to non-debian distros now >> that >> we've lost a lot of legacy stuff! >> >> Thanks, >> adam. >> >> _______________________________________________ >> observium mailing list >> observium(a)observium.org >> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium >> >> > Running it on SLES11: > > https://iriarte.it/?p=158&lang=es > > Post can be improved after migration though :D > > > > > _______________________________________________ > observium mailing list > observium(a)observium.org > http://postman.memetic.org/cgi-bin/mailman/listinfo/observium >

1 0

Setting Location
by Josh Hopper 19 Nov '15

19 Nov '15

Is there a way via command line to set the Location of a device? For example, in the GUI you click on a given device and hover over the Gear in the far right. Then click Properties. Under the Device Settings tab there is a Custom Location. This is the location I would like to set. I ran an SNMP Enabler tool and enabled, set and added 100 devices today to Observium. Rather than set this individually, I was hoping I could do it in bulk via SSH. -- Sincerely, Joshua Hopper, A+ CE Sr. Network Administrator [cid:image001.jpg@01D11BAA.500B4080] 420 3rd Ave NW Hickory NC 28601 Office: 828-449-1839x2160 | Cell: 828-855-7565

9 24

Who's running Observium on distros that aren't Ubuntu/Debian/RHEL/CentOS?
by Adam Armstrong 19 Nov '15

19 Nov '15

Hi Guys, Are any of you running Observium on distros which aren't the ones we recommend? Did you have to do anything special? I think we're probably way more friendly to non-debian distros now that we've lost a lot of legacy stuff! Thanks, adam.

5 6

Fwd: Epmp snmp intergration
by Tim Schroepfer 19 Nov '15

19 Nov '15

Does anyone have the config files to make Observium recognize Cambium Epmp 1000 Radios ?

3 3

UNIX Agent - lmsensor
by Federico Olivieri 18 Nov '15

18 Nov '15

Hi All, Sorry to take your time with this question but I am sure you can help me with that. On Script section of Observium UNIX agetn I found this script for lm sensor #!/bin/bash lmsensors=`which sensors` if [ $? -eq 0 ] then echo '<<<lmsensors>>>' $lmsensors fi On my environment the command for getting CPU temp is "sensor" root@banana:~# sensors fam15h_power-pci-00c4 Adapter: PCI adapter power1: 0.00 W (crit = 25.00 W) nct6776-isa-0290 Adapter: ISA adapter Vcore: +1.03 V (min = +0.00 V, max = +1.74 V) in1: +1.89 V (min = +0.00 V, max = +0.00 V) ALARM AVCC: +3.33 V (min = +0.00 V, max = +0.00 V) ALARM +3.3V: +3.34 V (min = +0.00 V, max = +0.00 V) ALARM in4: +0.73 V (min = +0.00 V, max = +0.00 V) ALARM in5: +1.71 V (min = +0.00 V, max = +0.00 V) ALARM 3VSB: +3.44 V (min = +0.00 V, max = +0.00 V) ALARM Vbat: +3.28 V (min = +0.00 V, max = +0.00 V) ALARM fan1: 0 RPM (min = 0 RPM) ALARM fan2: 1234 RPM (min = 0 RPM) ALARM fan3: 0 RPM (min = 0 RPM) ALARM fan4: 0 RPM (min = 0 RPM) ALARM fan5: 0 RPM (min = 0 RPM) ALARM SYSTIN: +40.0°C (high = +0.0°C, hyst = +0.0°C) ALARM sensor = thermistor CPUTIN: +42.0°C (high = +80.0°C, hyst = +75.0°C) sensor = thermistor AUXTIN: +47.0°C (high = +80.0°C, hyst = +75.0°C) sensor = thermistor cpu0_vid: +0.000 V intrusion0: OK intrusion1: ALARM In order to plot some nice graphs in observiu, how can I integrate that command in that script ? Thanks

2 1

How to delete ports of devices?
by Chaman Rathee 18 Nov '15

18 Nov '15

Hi Team, I have many ports that are showing down at observium monitoring system. So, please suggest how to delete "Down Ports" in observium. ......... With Best Regards, Chaman Rathee Mob. No:- +91-9560055816 [Fabrikam] Privileged or confidential information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), please delete this message and kindly notify the sender by an emailed reply. Opinions, conclusions and other information in this message that do not relate to the official business of Progression and its associate entities shall be understood as neither given nor endorsed by them.

6 12

Autodiscovery Question
by Lyndon Labuschagne 18 Nov '15

18 Nov '15

Hi All I have added the below to the config file, but nothing seems to be getting discovered, is there a $config[Œautodiscover¹] = TRUE or something I am missing? $config['autodiscovery']['ip_nets'] = array("10.200.4.0/24", "10.200.1.0/24"); $config['autodiscovery']['xdp'] = TRUE; // Autodiscover hosts via discovery protocols $config['autodiscovery']['snmpscan'] = TRUE; // autodiscover hosts via SNMP scanning $config['discover_services'] = false; ## Autodiscover services via SNMP on devices of type "server"

3 5

Front page custom graphs not displaying as expected
by Josh Bierman 17 Nov '15

17 Nov '15

Hello all, here is the snippet from my config.php ----------------------------------------------------- // Device status settings // Show the status messages you want $config['frontpage']['device_status']['max']['interval'] = 24; // Maximal interval for which to display devices status (in hours) $config['frontpage']['device_status']['max']['count'] = 200; $config['frontpage']['device_status']['uptime'] = true; $config['frontpage']['device_status']['devices'] = true; // Show the down devices $config['frontpage']['device_status']['ports'] = true; // Show the down ports $config['frontpage']['device_status']['links'] = true; // Show the down inter-device links (with CDP/LLDP linked devices) $config['frontpage']['device_status']['errors'] = true; // Show the ports with interface errors/ $config['frontpage']['device_status']['services'] = true; // Custom traffic graphs $config['frontpage']['custom_traffic']['ids'] = "3697"; // COMMA SEPARATED PORT ID FOR EXAMPLE: "1,2,3,4,5" $config['frontpage']['custom_traffic']['title'] = "Traffic"; // Your own title for the custom traffic graphs // Custom mini graphs $config['frontpage']['minigraphs']['ids'] = "51,device_processor,CPU"; // Comma and semicolon separated array list, first the device id or graph id followed by the image type and the text header you want (example: "2,$ $config['frontpage']['minigraphs']['legend'] = false; // Enable/Disable the legend on custom mini graph view $config['frontpage']['minigraphs']['title'] = "Mini Graphs Overview"; -------------------------------------------------- Based on that config I would expect graphs for 4 ports, showing 24 hour time periods on each, and a mini graph underneath showing CPU usage on that device (its a fortinet firewall) Instead I see this: [image: Inline image 1] Traffic graphs for one port, three timescales and no CPU. What did I do wrong? version 0.15.11.7197 Joshua Bierman Director of Technology Yeshivat Noam 201-261-1919 x136

1 0

Question about Map Locations, Geocoding and SNMP
by Ximena Cardinali 17 Nov '15

17 Nov '15

Hello There, Here's the situation: Last week we changed our Geocoding API to yandex, just for the sake of testing. After that, our map Locations looked really funny. Then, we changed back to mapquest and now our map shows just the Atlantic Ocean. Before that, we had no Geocoding API on our Observium config. Our Locations were all being retrieved from the SNMP Config (sysLocation) from all our devices. I also tried with "$config['geocoding']['enable'] = FALSE;" and with "$config['location_menu_geocoded'] = FALSE;" but I still get the ocean. So here's my stupid question: How can I go back to our first Status, where all Locations are retrieved per SNMP without Geocoding and our Map shows back the Devices as we had in the Setup? Thanks! --- *Ximena E. Cardinali *| Linux SysAdmin

3 4

Pushover Setup
by Daniel Wandrei 16 Nov '15

16 Nov '15

Hello, how do I setup Pushover Alerting? When adding a Contact and selecting Pushover, I'm missing the relevant Options like User Key and Application Token. Maybe I'm blind or my Installation is f*cked up but I can't find the needed the needed Fields: [cid:image001.png@01D1204B.47DC9710] Mit freundlichen Grüßen aus Rheine / Best regards from Rheine Daniel Wandrei Systemadministrator Shaghafi GmbH Kanalstraße 97 | 48432 Rheine Tel. +49 (0) 5971 899086-303 Fax +49 (0) 5971 899086-149 Internet: www.shaghafi.de<http://www.shaghafi.de/> E-Mail: daniel.wandrei(a)shaghafi.de<mailto:daniel.wandrei@shaghafi.de> Geschäftsführer: Parham Shaghafi Amtsgericht Steinfurt Nr. 4620 USt-ID-Nr: DE 206292649 Haftungssausschluss/Disclaimer: Diese Nachricht enthält vertrauliche Informationen und ist ausschließlich für den Adressaten bestimmt. Jeder Gebrauch durch Dritte ist verboten. Falls Sie die Daten irrtümlich erhalten haben, nehmen Sie bitte Kontakt mit dem Absender auf und löschen Sie die Daten auf jedem Computer und Datenträger. Das unerlaubte Kopieren, sowie die unbefugte Weitergabe dieser Mail sind nicht gestattet. Die Shaghafi GmbH ist nicht verantwortlich für die ordnungsgemäße, vollständige oder verzögerungsfreie Übertragung dieser Nachricht.

4 4

New Observium install showing text where PHP should be?
by linuxthefish 16 Nov '15

16 Nov '15

Hi, I've just followed the Observium install instructions and I have a strange issue with Observium's PHP files. I'm not sure if this is an Apache issue as I don't use Apache and installed it as the instructions said, but I created a phpinfo file and it ran fine! This was first seen with the Subscription edition, but I've removed that and tried the community edition with the same problems. the issue is that observium is showing a file that starts with the following in my browser: <?php /** * Observium * * This file is part of Observium. * * @package observium * @subpackage webinterface * @author Adam Armstrong <adama(a)memetic.org> * @copyright (C) 2006-2015 Adam Armstrong * */ Thanks, Edmund

2 1

UNIX-Agent on remote client
by Federico Olivieri 16 Nov '15

16 Nov '15

Hi All I have a server that is running Observium with Unix Agent and everything is ok. Recently I installed a second remote server and is a SNMP client on my observium. Because this server is running Power DNS I would enable the UNIX-AGENT om this client and see the graphs for pdns on my Observium. Can anyone assist me on this? Thank You very much Federico

3 5

Hangs up on polling of device for long time..........!
by Chaman Rathee 15 Nov '15

15 Nov '15

Hi Team, During polling of devices, it hangs up on one device and not exceed for next device. Please suggest. [cid:image001.png@01D11BAB.33B1C160] ......... With Best Regards, Chaman Rathee Mob. No:- +91-9560055816 [Fabrikam] Privileged or confidential information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), please delete this message and kindly notify the sender by an emailed reply. Opinions, conclusions and other information in this message that do not relate to the official business of Progression and its associate entities shall be understood as neither given nor endorsed by them.

7 18

Does per-user permission exist in LDAP?
by Cody Cook 15 Nov '15

15 Nov '15

Now that I'm LDAP authenticating to my domain, am I completely restricted to using auth_ldap_groups to set permissions? In the UI, I can go to User > Edit Users, drop down the list to see my domain users, but when I try to apply changes to these users (setting Global Read, or Normal user), I am redirected to the Observium User Management screen with no visible changes to any user account. There's no notification to tell me what went wrong or that editing LDAP user permissions is not possible. After switching to LDAP, Observium no longer provides authentication errors, and I'm getting something to the same effect when trying to edit users. Clicking on a user in my level 10 shows me that this user is an administrator, but users in my level 1 are showing disabled. The drop down list shows the same level 10 users as disabled as well. /debug doesn't help since it reloads the page. profile_sql doesn't seem to show me every SQL query being made. Observium 0.15.11.7173 (rolling)

5 7

Re: [Observium] observium Digest, Vol 61, Issue 74
by Marko Uusitalo 13 Nov '15

13 Nov '15

unsubscribe Marko Uusitalo Senior Lecturer Helsinki Metropolia University of Applied Sciences Bulevardi 31 00180 HELSINKI FINLAND GSM +358 50 3525 975 Email Marko.uusitalo(a)metropolia.fi www.metropolia.fi/en ________________________________________ Lähettäjä: observium [observium-bounces(a)observium.org] käyttäjän observium-request(a)observium.org [observium-request(a)observium.org] puolesta Lähetetty: 12. elokuuta 2015 9:50 Vastaanottaja: observium(a)observium.org Aihe: observium Digest, Vol 61, Issue 74 Send observium mailing list submissions to observium(a)observium.org To subscribe or unsubscribe via the World Wide Web, visit http://postman.memetic.org/cgi-bin/mailman/listinfo/observium or, via email, send a message with subject or body 'help' to observium-request(a)observium.org You can reach the person managing the list at observium-owner(a)observium.org When replying, please edit your Subject line so it is more specific than "Re: Contents of observium digest..." Today's Topics: 1. Re: 'Duplicate entry' issues on vlans_fdb (Aaron Mayfield) ---------------------------------------------------------------------- Message: 1 Date: Wed, 12 Aug 2015 06:50:01 +0000 From: Aaron Mayfield <amayfield(a)artisaninfrastructure.com> To: Observium Network Observation System <observium(a)observium.org> Subject: Re: [Observium] 'Duplicate entry' issues on vlans_fdb Message-ID: <f42b01e9c6a44b1783eb4bc895f324f9(a)NG-USA-MXAI.neverfailgroup.com> Content-Type: text/plain; charset="utf-8" Yeah this seems to be a performance issue of some type and the fdb table stuff seems like a side effect. I?m scratching my head as to why it worked fine before the upgrade. In fact, here is the observium.log output before/after the upgrade: [2015/08/11 10:42:14 -0500] poller-wrapper.py(23384): /opt/observium/poller-wrapper.py: polled 45 devices in 131 seconds with 8 workers [2015/08/11 10:47:12 -0500] poller-wrapper.py(3121): /opt/observium/poller-wrapper.py: polled 45 devices in 131 seconds with 8 workers [2015/08/11 10:52:13 -0500] poller-wrapper.py(15078): /opt/observium/poller-wrapper.py: polled 45 devices in 132 seconds with 8 workers [2015/08/11 10:57:13 -0500] poller-wrapper.py(27618): /opt/observium/poller-wrapper.py: polled 45 devices in 131 seconds with 8 workers [2015/08/11 11:02:14 -0500] poller-wrapper.py(7205): /opt/observium/poller-wrapper.py: polled 45 devices in 132 seconds with 8 workers [2015/08/11 11:07:14 -0500] poller-wrapper.py(19611): /opt/observium/poller-wrapper.py: polled 45 devices in 132 seconds with 8 workers [2015/08/11 11:12:12 -0500] poller-wrapper.py(31781): /opt/observium/poller-wrapper.py: polled 45 devices in 131 seconds with 8 workers [2015/08/11 11:17:15 -0500] poller-wrapper.py(11383): /opt/observium/poller-wrapper.py: polled 45 devices in 133 seconds with 8 workers [2015/08/11 11:22:15 -0500] poller-wrapper.py(23688): /opt/observium/poller-wrapper.py: polled 45 devices in 133 seconds with 8 workers [2015/08/11 11:27:14 -0500] poller-wrapper.py(3412): /opt/observium/poller-wrapper.py: polled 45 devices in 133 seconds with 8 workers [2015/08/11 11:32:10 -0500] poller-wrapper.py(15327): /opt/observium/poller-wrapper.py: polled 45 devices in 128 seconds with 8 workers [2015/08/11 11:37:14 -0500] poller-wrapper.py(27814): /opt/observium/poller-wrapper.py: polled 45 devices in 132 seconds with 8 workers [2015/08/11 11:42:13 -0500] poller-wrapper.py(7491): /opt/observium/poller-wrapper.py: polled 45 devices in 132 seconds with 8 workers [2015/08/11 11:47:13 -0500] poller-wrapper.py(19987): /opt/observium/poller-wrapper.py: polled 45 devices in 131 seconds with 8 workers [2015/08/11 11:52:15 -0500] poller-wrapper.py(32100): /opt/observium/poller-wrapper.py: polled 45 devices in 133 seconds with 8 workers [2015/08/11 11:57:14 -0500] poller-wrapper.py(11743): /opt/observium/poller-wrapper.py: polled 45 devices in 133 seconds with 8 workers [2015/08/11 12:02:22 -0500] poller-wrapper.py(23906): /opt/observium/poller-wrapper.py: polled 45 devices in 140 seconds with 8 workers [2015/08/11 12:06:52 -0500] poller-wrapper.py(4395): /opt/observium/poller-wrapper.py: polled 45 devices in 111 seconds with 8 workers [2015/08/11 12:21:24 -0500] poller-wrapper.py(11770): /opt/observium/poller-wrapper.py: polled 45 devices in 683 seconds with 8 workers [2015/08/11 12:38:09 -0500] poller-wrapper.py(17020): /opt/observium/poller-wrapper.py: polled 45 devices in 1388 seconds with 8 workers [2015/08/11 12:48:30 -0500] poller-wrapper.py(26555): /opt/observium/poller-wrapper.py: polled 45 devices in 1708 seconds with 8 workers [2015/08/11 13:06:30 -0500] poller-wrapper.py(2438): /opt/observium/poller-wrapper.py: polled 45 devices in 2487 seconds with 8 workers [2015/08/11 13:12:30 -0500] poller-wrapper.py(9984): /opt/observium/poller-wrapper.py: polled 45 devices in 2548 seconds with 8 workers [2015/08/11 13:31:56 -0500] poller-wrapper.py(19437): /opt/observium/poller-wrapper.py: polled 45 devices in 3414 seconds with 8 workers [2015/08/11 13:40:50 -0500] poller-wrapper.py(25290): /opt/observium/poller-wrapper.py: polled 45 devices in 3647 seconds with 8 workers [2015/08/11 13:55:34 -0500] poller-wrapper.py(956): /opt/observium/poller-wrapper.py: polled 45 devices in 4231 seconds with 8 workers [2015/08/11 14:02:54 -0500] poller-wrapper.py(7354): /opt/observium/poller-wrapper.py: polled 45 devices in 4370 seconds with 8 workers [2015/08/11 14:20:50 -0500] poller-wrapper.py(14288): /opt/observium/poller-wrapper.py: polled 45 devices in 5147 seconds with 8 workers I did the upgrade and then the poller starts running poorly. Then I see the side effect of the of the duplicate entries with the fdb table because the poller processes are running so slowly they are stacking on top of each other. So I have some kind of performance issue. One strange thing, I only have 45 devices I?m polling, yet the port count under the Port menu says I have 44859 ports. That must be a miscalculation of some type or my database is messed up somewhere. Not sure if related or not. Going to continue to try the poller manually and see if I can figure out where the slowdown is. From: observium [mailto:observium-bounces@observium.org] On Behalf Of Adam Armstrong Sent: Wednesday, August 12, 2015 1:33 AM To: observium(a)observium.org Subject: Re: [Observium] 'Duplicate entry' issues on vlans_fdb Man, why didn't I think of this? This sounds like the problem. I guess something caused your poller processes to get confused, and they ended up running in parallel, not unthinkable when the same part of the poller process runs for so long, 74 seconds for the fdb-table module. If you don't /really/ need this data, I'd recommend disabling it. It's one of the trade offs we have to make between performance and data. If you still want the fdb data, you can force that module to be run using a less-often scheduled process in cron like ./poller.php -h all -m fdb-table Note that this will break whatever graphs (fdb count?) that fdb-table produces, but you'll still have the data in the database. adam. On 12/08/2015 07:28:55, Tom Laermans <tom.laermans(a)powersource.cx<mailto:tom.laermans@powersource.cx>> wrote: If you're running multiple simultaneous pollers against the same device is not unthinkable they'll all be trying to insert the same data into the table... Tom On Aug 12, 2015 8:02 AM, Aaron Mayfield wrote: > > Here is the requested output. I had to kill all the other poller processes running on the system to get it to run (they were hosing the CPU). Oddly enough, once I killed all the other processes, I didn?t any problems running it (back to being fast). Also don?t seem to be getting the errors in the db.log when running the poller ?one-at-a-time?. > > > > > > > > From: observium [mailto:observium-bounces@observium.org] On Behalf Of Adam Armstrong > Sent: Tuesday, August 11, 2015 11:52 PM > To: observium(a)observium.org<mailto:observium@observium.org> > Subject: Re: [Observium] 'Duplicate entry' issues on vlans_fdb > > > > Hi Aaron, > > > > These seem to be gone from my db.log. Could you send me a ./poller.php -h 54 -m fdb-table -d ? > > > > Thanks, > > adam. >> >> On 12/08/2015 05:01:53, Aaron Mayfield wrote: >> >> Just today I updated to the latest and greatest (0.15.8.6882). I was several revisions behind and several database updates were done as a result. After the update, I noticed my poller.php processes started taking all the CPU, started getting gaps in the graphs, etc. I noticed thousands of these entries in db.log: >> >> >> [2015/08/11 22:01:02 -0500] poller.php(21342): Failed dbQuery (#1062 - Duplicate entry '54-2083-6ef88537f91f' for key 'dev_vlan_mac'), Query: INSERT INTO `vlans_fdb` (`device_id`,`vlan_id`,`port_id`,`mac_address`,`fdb_status`) VALUES ('54','2083','220115','6ef88537f91f','learned') >> [2015/08/11 22:01:02 -0500] poller.php(21342): Failed dbQuery (#1062 - Duplicate entry '54-2084-005056a927c2' for key 'dev_vlan_mac'), Query: INSERT INTO `vlans_fdb` (`device_id`,`vlan_id`,`port_id`,`mac_address`,`fdb_status`) VALUES ('54','2084','220115','005056a927c2','learned') >> [2015/08/11 22:01:02 -0500] poller.php(21342): Failed dbQuery (#1062 - Duplicate entry '54-2084-a66aaf0bf4cc' for key 'dev_vlan_mac'), Query: INSERT INTO `vlans_fdb` (`device_id`,`vlan_id`,`port_id`,`mac_address`,`fdb_status`) VALUES ('54','2084','220115','a66aaf0bf4cc','learned') >> [2015/08/11 22:01:02 -0500] poller.php(21342): Failed dbQuery (#1062 - Duplicate entry '54-2085-228a3d193c66' for key 'dev_vlan_mac'), Query: INSERT INTO `vlans_fdb` (`device_id`,`vlan_id`,`port_id`,`mac_address`,`fdb_status`) VALUES ('54','2085','220115','228a3d193c66','learned') >> [2015/08/11 22:01:02 -0500] poller.php(21342): Failed dbQuery (#1062 - Duplicate entry '54-2086-0ee7c729643b' for key 'dev_vlan_mac'), Query: INSERT INTO `vlans_fdb` (`device_id`,`vlan_id`,`port_id`,`mac_address`,`fdb_status`) VALUES ('54','2086','220115','0ee7c729643b','learned') >> >> If I run a poller process against a switch manually, everything seems to run fine with the exception of the fdb-table module, which is taking over 600 seconds to run. >> >> Here is the schema of my vlans_fdb file: >> >> mysql> show columns from vlans_fdb >> -> ; >> +-------------+-------------+------+-----+---------+-------+ >> | Field | Type | Null | Key | Default | Extra | >> +-------------+-------------+------+-----+---------+-------+ >> | device_id | int(11) | NO | PRI | NULL | | >> | vlan_id | int(11) | NO | PRI | NULL | | >> | port_id | int(11) | YES | MUL | NULL | | >> | mac_address | varchar(32) | NO | PRI | NULL | | >> | fdb_status | varchar(32) | NO | | NULL | | >> +-------------+-------------+------+-----+---------+-------+ >> 5 rows in set (0.00 sec) >> >> mysql> >> mysql> show index from vlans_fdb >> -> ; >> +-----------+------------+--------------+--------------+-------------+-----------+-------------+---- ----+--------+------+------------+---------+ >> | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub art | Packed | Null | Index_type | Comment | >> +-----------+------------+--------------+--------------+-------------+-----------+-------------+---- ----+--------+------+------------+---------+ >> | vlans_fdb | 0 | dev_vlan_mac | 1 | device_id | A | 15 | ULL | NULL | | BTREE | | >> | vlans_fdb | 0 | dev_vlan_mac | 2 | vlan_id | A | 18348 | ULL | NULL | | BTREE | | >> | vlans_fdb | 0 | dev_vlan_mac | 3 | mac_address | A | 128440 | ULL | NULL | | BTREE | | >> | vlans_fdb | 1 | device_id | 1 | device_id | A | 78 | ULL | NULL | | BTREE | | >> | vlans_fdb | 1 | port_id | 1 | port_id | A | 431 | ULL | NULL | YES | BTREE | | >> +-----------+------------+--------------+--------------+-------------+-----------+-------------+---- ----+--------+------+------------+---------+ >> 5 rows in set (0.04 sec) >> >> mysql> >> >> Does my table structure look right? I see someone else on the list has had this same issue, but there is no indication that this should be a problem in the latest version. >> >> What should I check? Thanks for any help. >> >> >> >> >> Aaron Mayfield >> Cloud Expert >> Networking Specialist >> >> 12400 Hwy. 71 W. Suite 350-407 >> Austin, TX 78738 >> T. 512.600.4297 >> www.artisaninfrastructure.com<http://www.artisaninfrastructure.com> >> Partner portal: https://portal.vpdc.us >> Partner support: support(a)artisaninfrastructure.com<mailto:support@artisaninfrastructure.com> >> >> >> >> This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error, please notify the system manager. Please note that any views or opinions present in this email are solely those of the author and do not necessarily represent those of the company. Finally the recipient should check this email and any attachment for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. (Proprietary & Confidential ? Artisan Infrastructure, Inc. et all.) >> _______________________________________________ >> observium mailing list >> observium(a)observium.org<mailto:observium@observium.org> >> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium > > This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error, please notify the system manager. Please note that any views or opinions present in this email are solely those of the author and do not necessarily represent those of the company. Finally the recipient should check this email and any attachment for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. (Proprietary & Confidential ? Artisan Infrastructure, Inc. et all.) _______________________________________________ observium mailing list observium(a)observium.org<mailto:observium@observium.org> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error, please notify the system manager. Please note that any views or opinions present in this email are solely those of the author and do not necessarily represent those of the company. Finally the recipient should check this email and any attachment for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. (Proprietary & Confidential ? Artisan Infrastructure, Inc. et all.)

1 0

What boolean operators are available when creating groups ?
by Jesper Frank Nemholt 11 Nov '15

11 Nov '15

Hi! I've been using equals and match and wildcard (*) when aggregating together data in the group feature, however I now have to create a group where I need to exclude certain things and select others with wildcard. I am not sure this works, and I can't find anything in the documentation about it. basically I need to include all hosts with a certain hostname pattern, except a few ones with a slightly different pattern. If I wrote it in two lines, it would be like this : hostname match foo-is*.bar.com hostname != foo-is4*.bar.com Anyway way to do this ? /Jesper

3 2

Updating SNMP from v1 to v3
by Timothy Kaufman 11 Nov '15

11 Nov '15

Hello, We have about 80 devices that we are updating from SNMP v1 to v3. I can¹t seem to find a way to do this in bulk either from CLI or from web UI. I can update the devices one by one in the web ui, if I try from the CLI with the add_user.php script it complains about the device being known. Can someone offer some insight on how I might accomplish this without changing each device individually in the UI? Thanks Tim

2 1

Port Descriptions on Linux hosts?
by Telsin 11 Nov '15

11 Nov '15

I’ve got someRHEL boxes running as routers in Observium, and I’m wondering how to apply names to them so they get picked up as Transit, Peering, Customer, etc. Any solution for this? Thanks! -Darrell

1 0

ports graphs errors
by Jeffrey d'Ambly 10 Nov '15

10 Nov '15

I’m seeing something odd with my Cisco ASA, for some reason the ports summary graph isn’t working. What is odd is that each of the individual interfaces are working fine. It looks like there is something wrong with the RRD command, how can I fix this? RRDTool Output: ERROR: String ends after the = sign on 'CDEF:inB=' Total time: 0.017 | RRDtool time: 0.015s RRDTool Command rrdtool graph /tmp/WyzPqJz6C3QdevQB.png -g --alt-autoscale --rigid --start 1447085684 --end 1447172084 --width 1159 --height 300 -c BACK#EEEEEE00 -c SHADEA#EEEEEE00 -c SHADEB#EEEEEE00 -c FONT#000000 -c CANVAS#FFFFFF00 -c GRID#a5a5a5 -c MGRID#FF9999 -c FRAME#5e5e5e -c ARROW#5e5e5e -R normal --font LEGEND:8:'DejaVuSansMono' --font AXIS:7:'DejaVuSansMono' --font-render-mode normal -E CDEF:inB= CDEF:outB= CDEF:octets=inB,outB,+ CDEF:doutB=outB,-1,* CDEF:inbits=inB,8,* CDEF:outbits=outB,8,* CDEF:bits=inbits,outbits,+ CDEF:doutbits=doutB,8,* VDEF:95thin=inbits,95,PERCENT VDEF:95thout=outbits,95,PERCENT VDEF:d95thout=doutbits,5,PERCENT VDEF:totin=inB,TOTAL VDEF:avein=inbits,AVERAGE VDEF:totout=outB,TOTAL VDEF:aveout=outbits,AVERAGE VDEF:tot=octets,TOTAL COMMENT:' \l' HRULE:999999999999999#FFFFFF:'Total Rx': GPRINT:inbits:LAST:%6.2lf%s GPRINT:inbits:AVERAGE:%6.2lf%s GPRINT:inbits:MIN:%6.2lf%s GPRINT:inbits:MAX:%6.2lf%s GPRINT:totin:%6.2lf%sB COMMENT:'\l' HRULE:999999999999999#FFFFFF:' Tx': GPRINT:outbits:LAST:%6.2lf%s GPRINT:outbits:AVERAGE:%6.2lf%s GPRINT:outbits:MIN:%6.2lf%s GPRINT:outbits:MAX:%6.2lf%s GPRINT:totout:%6.2lf%sB COMMENT:'\l' HRULE:999999999999999#FFFFFF:' Agg': GPRINT:bits:LAST:%6.2lf%s GPRINT:bits:AVERAGE:%6.2lf%s GPRINT:bits:MIN:%6.2lf%s GPRINT:bits:MAX:%6.2lf%s GPRINT:tot:%6.2lf%sB COMMENT:'\l' HRULE:0#999999 RRDTool Files Used No RRD information returned. This may be because the graph module doesn't yet return this data.

2 2

Slack Integration
by Guilherme de Freitas Figueiredo 10 Nov '15

10 Nov '15

Hello! on the directory alerts exists the slack.inc.php. directory in the alerts there is slack.inc.php. researched on the Internet (http://www.rickheil.com/?p=35#comment-39) and also in the full dump of the observium config file and saw that there are integration options with the slack. I tried to apply them but without success. someone already managed to do this integration? Below are the configs: $config['alerts']['slack']['username'] = "Observium"; $config['alerts']['slack']['channel'] = "#cgr"; $config['alerts']['slack']['url'] = " https://hooks.slack.com/services/T0BMNB4UC/B0BMU32QY/xeUSiseEo2qGlXKOACLR5Z… "; $config['alerts']['slack']['webhook_url'] = " https://hooks.slack.com/services/T0BMNB4UC/B0BMU32QY/xeUSiseEo2qGlXKOACLR5Z… "; $config['alerts']['slack']['default']['contact'] = "channel::#cgr||username::Observium||url:: https://hooks.slack.com/services/T0BMNB4UC/B0BMU32QY/xeUSiseEo2qGlXKOACLR5Z… "; Best Regards! []s! -- Guilherme de Freitas Figueiredo

3 4

Re: [Observium] OSPF nei alerts
by Samarasinghe, Sujith 10 Nov '15

10 Nov '15

Team, can we not use the ospf neighbor counts -1 to trigger a alert? Sujith. Confidentiality Note: This e-mail and any attachments are confidential and may be protected by legal privilege. If you are not the intended recipient, be aware that any disclosure, copying, distribution or use of this e-mail or any attachment is prohibited. If you have received this e-mail in error, please notify us immediately by returning it to the sender and delete this copy from your system. Thank you for your cooperation.

2 2

Active Directory help
by Cody Cook 09 Nov '15

09 Nov '15

Hi everyone, I know this subject is touched on in the past but any help from anyone who has this working would be appreciated. I've been following the FAQ for LDAP login via Active Directory but I always come across the same error. Fatal error: LDAP TLS required but not successfully negotiated [Connect error] In /debug, I see that it connects but then inserts a line saying that Auth failed. https://doc.rotten.soy/buqar.vhdl In my Windows Server 2012 R2 box, I see this line come up in the Event Viewer: "A fatal alert was generated and sent to the remote endpoint. This may result in termination of the connection. The TLS protocol defined fatal error code is 10. The Windows SChannel error state is 10." This is one of the more recent configs I've tried. https://doc.rotten.soy/wosej.php My filtered dsquery information is... https://doc.rotten.soy/inure.tex Things I've tried modifying: auth_ldap_binddn, I've tried changing this but this doesn't seem to be my problem since it appears to connect. (Should I have some kind of special rights for this user)? auth_ldap_suffix, This one I'm not sure exactly what the string is looking for. The actual CN of a user won't include the CN=Builtin. I've tried without. auth_ldap_group, tried with and without Domain Users CN. auth_ldap_groups, tried the full LDAP path and also just the "Domain Admins"/"Domain Users" What am I missing? :( Any help is greatly appreciated in what I am doing wrong. Is it a problem with my Server 2012 install and something I need to change? Is it a problem in one of the packages installed for Observium? Cody

1 1