- observium - lists.observium.org

svn Checksum mismatch error
by Johnson, Edward A. 13 Aug '15

13 Aug '15

We have been running Observium under RHEL 6 for over a year now. After one of the last updates, I noticed that php 5.4 or newer was needed. Unfortunately, php 5.3.3 is current in RHN but I was able to update to 5.4 using a different repository. Then I had an issue with xcache not being available for 5.4. This brings me to my current problem. I decided to go with the approved distro, Debian. My problem is that when I try to execute "svn co http://svn.observium.org/svn/observium/branches/stable observium", I get a few files and then randomly get the error “Checksum mismatch for ‘/opt/observium/somefilename.extension’ If I blow away the /opt/observium directory and run the command again, a different file gives me that error.

2 3

'Duplicate entry' issues on vlans_fdb
by Aaron Mayfield 12 Aug '15

12 Aug '15

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 Partner portal: https://portal.vpdc.us Partner support: support(a)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.)

2 2

Link to device - Feature request
by chott＠praha1.net 11 Aug '15

11 Aug '15

Hello team, i have question about create link in observium for open in new tab GUI of device config for example if iam in Device Overview, create some Icon or Text link to open New Tab for Device GUI configuration HTTP? Or SSH plugin https://addons.mozilla.org/EN-us/firefox/addon/firessh/ Tom [email-header-praha1] Tomas Chott technický ředitel chott(a)praha1.net<mailto:chott@praha1.net> Phone: +420 245 004 005 Mobile: +420 604 930 119 Metropolitní síť Praha 1 z.s.p.o. Jindrisska 18 110 00 Praha 1 Czech Republic www.praha1.net<http://www.praha1.net> [Popis: Facebook]<http://www.facebook.com/praha1net> <http://www.linkedin.com/pub/tomas-chott/49/97a/1aa>

5 15

Mikrotik SwitchOS long poller
by chott＠praha1.net 11 Aug '15

11 Aug '15

Hello team, we have Mikrotik Switch OS model RB260GS, there is Poller/Discovery Timing about 751s [X] There is Discovery log attached [email-header-praha1] Tomas Chott technický ředitel chott(a)praha1.net<mailto:chott@praha1.net> Phone: +420 245 004 005 Mobile: +420 604 930 119 Metropolitní síť Praha 1 z.s.p.o. Jindrisska 18 110 00 Praha 1 Czech Republic www.praha1.net<http://www.praha1.net> [Popis: Facebook]<http://www.facebook.com/praha1net> <http://www.linkedin.com/pub/tomas-chott/49/97a/1aa>

4 12

Broken graph.
by Zafar Pravaiz 11 Aug '15

11 Aug '15

Dear All, I am getting gap in graph for many devices. Any idea what needs to done to fix this. Help Appreciated. Thanks Zafar Pravaiz IT Senior Network Engineer Information Technology Department Tel +971 6 515 2164 Fax +971 6 515 2112 American University of Sharjah PO Box 26666, Sharjah United Arab Emirates http://www.aus.edu <http://www.aus.edu/> zpravaiz(a)aus.edu <mailto:youremail@aus.edu>

4 4

Re: [Observium] links to graphs
by Jeffrey d'Ambly 11 Aug '15

11 Aug '15

Got it working didn’t realize there was a config option for this $config['allow_unauth_graphs'] = 1; # Allow graphs to be viewed by anyone —jeff From: observium <observium-bounces(a)observium.org<mailto:observium-bounces@observium.org>> on behalf of Jeffrey <jeffrey.dambly(a)jasper.com<mailto:jeffrey.dambly@jasper.com>> Reply-To: Observium Network Observation System <observium(a)observium.org<mailto:observium@observium.org>> Date: Monday, August 10, 2015 at 1:36 PM To: "observium(a)observium.org<mailto:observium@observium.org>" <observium(a)observium.org<mailto:observium@observium.org>> Subject: [Observium] links to graphs I’m trying to create a simple dashboard view of some IP SLA graphs using Observium Enterprise, and I was wondering what I needed to do to pull these graphs into the dashboard. Linking to them staticly doesn’t work due to authentication. Is there a built in way I can auth and get a cookie for this? —Jeff

2 1

links to graphs
by Jeffrey d'Ambly 10 Aug '15

10 Aug '15

I’m trying to create a simple dashboard view of some IP SLA graphs using Observium Enterprise, and I was wondering what I needed to do to pull these graphs into the dashboard. Linking to them staticly doesn’t work due to authentication. Is there a built in way I can auth and get a cookie for this? —Jeff

1 0

[sh] <defunct>
by Simon Smith 10 Aug '15

10 Aug '15

Hi All, i did an update this morning to latest SVN and working fine (thumbs up) I then disabled the cron job to update PHP, MySQL and Apache as I’m still using 5.3, 5.2 and 2.2 (updated to 5.6, 5.5 and 2.4) now the apache has just completely gone tits up !? I’m seeing about 50 of ' [sh] <defunct> ' in my ‘ ps aux ‘ erm, where do i begin to start looking? i updated using https://launchpad.net/~ondrej/+archive/ubuntu/php5-5.6 <https://launchpad.net/~ondrej/+archive/ubuntu/php5-5.6> as I’m running ubuntu 12.04 lts regards Simon

6 18

Customer billing
by Jan Kuiper 10 Aug '15

10 Aug '15

Hi, I want to search for bills, but the bill search function does only give all bills instead of the requested Bill Name. Has anyone the same issue, if no what can I do wrong or fix it? I am running the stable version 6833. [cid:image002.png@01D0D38F.90DC38C0] 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.

2 1

RRD Graphs
by Andre Geißler 10 Aug '15

10 Aug '15

Hello Looks like the sizes of RRD graphs aren't correct. If in widescreen mode they are too big. In normal mode they are too small. See my attached Images. Andre

2 5