- observium - lists.observium.org

DB errors
by Eduardo Schoedler 07 Jan '16

07 Jan '16

Updated to revision 7434. ___ _ _ / _ \ | |__ ___ ___ _ __ __ __(_) _ _ _ __ ___ | | | || '_ \ / __| / _ \| '__|\ \ / /| || | | || '_ ` _ \ | |_| || |_) |\__ \| __/| | \ V / | || |_| || | | | | | \___/ |_.__/ |___/ \___||_| \_/ |_| \__,_||_| |_| |_| Observium Professional 0.16.1.7434 http://www.observium.org -- Updating database/file schema 260 -> 261 ... (db) done (5 errors). 261 -> 262 ... (php) -- Done. # cat logs/update-errors.log [2016/01/07 17:53:33 -0200] discovery.php(20049): ====== Schema update 260 -> 261 ============== [2016/01/07 17:53:33 -0200] discovery.php(20049): Query: ALTER TABLE `pseudowires` DROP `pwMplsPeerLdpID`; [2016/01/07 17:53:33 -0200] discovery.php(20049): Error: (1091) Can't DROP 'pwMplsPeerLdpID'; check that column/key exists [2016/01/07 17:53:33 -0200] discovery.php(20049): Query: ALTER TABLE `pseudowires` ADD `pwOutboundLabel` INT(11) UNSIGNED NOT NULL AFTER `pwID`, ADD `pwInboundLabel` INT(11) UNSIGNED NOT NULL AFTER `pwOutboundLabel`; [2016/01/07 17:53:33 -0200] discovery.php(20049): Error: (1060) Duplicate column name 'pwOutboundLabel' [2016/01/07 17:53:33 -0200] discovery.php(20049): Query: ALTER TABLE `pseudowires` ADD `pwRowStatus` VARCHAR(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' AFTER `pwRemoteIfString`; [2016/01/07 17:53:33 -0200] discovery.php(20049): Error: (1060) Duplicate column name 'pwRowStatus' [2016/01/07 17:53:33 -0200] discovery.php(20049): Query: ALTER TABLE `pseudowires` ADD INDEX `row_status` (`device_id`, `pwRowStatus`); [2016/01/07 17:53:33 -0200] discovery.php(20049): Error: (1061) Duplicate key name 'row_status' [2016/01/07 17:53:33 -0200] discovery.php(20049): Query: CREATE TABLE `pseudowires-state` ( `pseudowire_id` INT(11) UNSIGNED NOT NULL , `pwOperStatus` VARCHAR(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL , `pwLocalStatus` VARCHAR(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL , `pwRemoteStatus` VARCHAR(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL , `pwUptime` INT(11) UNSIGNED NOT NULL , `event` ENUM('ok','warning','alert','ignore') NOT NULL , `last_change` INT(11) UNSIGNED NOT NULL , PRIMARY KEY (`pseudowire_id`)) ENGINE = InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci; [2016/01/07 17:53:33 -0200] discovery.php(20049): Error: (1050) Table 'pseudowires-state' already exists -- Eduardo Schoedler

2 1

SFP sensor alerts
by Martin 07 Jan '16

07 Jan '16

Hi All, What is the best way to suppress alerts for Transceiver TX Power generated when a port is admin-down? cisco-entity-sensor mib has a default minimum value of 1mA, which is a perfectly valid minimum value under normal "up/up" conditions, but if the port is admin-shut it will switch off tx power, which is ok for admin-shut. Same situation for RX-power. Is there a way to take the admin status of the port in account for this kind of sensor readings? (ASR9k, IOS-XR) Thanks, Martin

3 4

Port Errors Showing for Alert-Disabled ports
by Robert Williams 07 Jan '16

07 Jan '16

Hi, Not sure when it started, but we now seem to get “Port Error” alerts on the main page for ports which are set to have their Alerts disabled, for example: [cid:image001.jpg@01D1494E.A318C000] On the device in question, they are indeed ‘No’ under the Alerts toggle: [cid:image002.jpg@01D1494E.A318C000] There are a large number of ports like this on our network with IP PDUs and similar, all of which have 10M/Half links and exist in a state of near-constant input errors as a result. This is of no concern at all and should be ignored (hence the toggle). Any suggestions? Is the Alerts toggle broken (for this feature on the main page) or is there another way to shush these, it’s kind of making the main page list a bit defunct ☺ Cheers all! Robert Williams Custodian Data Centre Email: Robert(a)CustodianDC.com http://www.CustodianDC.com

2 2

upgrade community version to paid version
by Ankit Dubey 07 Jan '16

07 Jan '16

Hi, I have installed community version and wish to upgrade it to paid version. I have gone through the link http://www.observium.org/docs/updating/#migrate-an-existing-community-editi… Please let me know - Do I need to pay and subscribe in advance on different system and install it on that system and transfer old config.php to new setup Or Do I need to provide internet connectivity to my existing server and need to put below mentioned command on this already running system - but when I will be prompted for payment? cd /opt mv observium observium-old svn co http://svn.observium.org/svn/observium/branches/stable observium cp observium-old/config.php observium mv observium-old/rrd observium-old/logs observium cd observium ./discovery.php -u Please provide contact detail of any sales person, with whom I can chat in detail regarding this as I need to procure two licenses on urgent basis. Best regards Ankit Dubey Lead, Packet Core Planning Division Network, CORPORATE CENTER -----Original Message----- From: observium [mailto:observium-bounces@observium.org] On Behalf Of observium-request(a)observium.org Sent: Tuesday, November 24, 2015 9:36 AM To: observium(a)observium.org Subject: observium Digest, Vol 64, Issue 133 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. MySQL application (Geoff Johnson) 2. Re: MySQL application (Spencer Ryan) 3. upgrade community version to paid version (Ankit Dubey) 4. Re: upgrade community version to paid version (Adam Armstrong) 5. Re: upgrade community version to paid version (Cody Cook) ---------------------------------------------------------------------- Message: 1 Date: Mon, 23 Nov 2015 16:43:48 -0800 From: Geoff Johnson <geoff.johnson(a)coanda.ca> To: observium(a)observium.org Subject: [Observium] MySQL application Message-ID: <CAB5X9BuAbNupewAXc=w7hymJPvx_WrAHFY8--YvLF9CW61=HAg(a)mail.gmail.com> Content-Type: text/plain; charset="utf-8" The instructions for configuring the MySQL application at https://observium.org/w/Application/MySQL are unclear about where the database user must be created. Do the user create steps need to be done on every host running MySQL that you want to monitor, or just once on the Observium server? I assume that it's the former, just looking for clarification. Thanks, Geoff

2 1

On the "Ports" page, can I set the "Quick Filters" option "Hide DOWN" as a default setting?
by Taylor Cassidy 06 Jan '16

06 Jan '16

Hi All, On the "Ports" page, how do I set the "Quick Filters" option "Hide DOWN" as a default setting? Thanks very much, Taylor C.

1 0

test_alerts.php should not be called statically
by Simon Smith 06 Jan '16

06 Jan '16

Hi All. having a strange issue, my HipChat Notifications stopped working, so be trying to debug them - I just keep getting 400 Bad Request but i’ve noticed something else weird, after i run the test_alerts.php with -dd I’m seeing o Notifying [email] Simon: simon(a)hestor.com Load class 'Mail_mime' from '/opt/observium/libs/pear/Mail/mime.php': OK Load class 'Mail' from '/opt/observium/libs/pear/Mail/Mail.php': OK PHP Strict Standards: Non-static method Mail::factory() should not be called statically in /opt/observium/includes/alerting/email.inc.php on line 153 Strict Standards: Non-static method Mail::factory() should not be called statically in /opt/observium/includes/alerting/email.inc.php on line 153 PHP Strict Standards: Non-static method PEAR::isError() should not be called statically in /opt/observium/includes/alerting/email.inc.php on line 157 Strict Standards: Non-static method PEAR::isError() should not be called statically in /opt/observium/includes/alerting/email.inc.php on line 157 I haven’t changed anything apart from weekly svn up’s could this error be affecting the hipchat? I’m setting the contact as room_id::ROOMID||from::FROMOBSERVIUMEMAILACCOUNT||token::VERYLONGTOKENHERE||url::https://URLOFHIPCHATSERVERWITHSSL am i missing something or has something changed? regards Simon

2 2

UNIX agent Postgres versions
by Attila Nagy 06 Jan '16

06 Jan '16

Hi everyone! I was in the process of configuring the UNIX agent and I found (as written in the documentation too) that the script only supports Postgres version 9. But after experimenting a little bit I realized that the script works perfectly with the 8.4 version. I was able to test with an 8.3 which was working as well. So maybe the script should be changed to enable any 8.X version. Anyway I created a patch and attached it. If some of you find it helpful then maybe post the version which was working, so we can update the version string. Regards, Tylla

3 3

Re: [Observium] How to aggregate multiple graphs
by ChanTy 06 Jan '16

06 Jan '16

Any comment ? From: observium <observium-bounces(a)observium.org> on behalf of apple <ty.chan(a)corp.mekongnet.com.kh> Reply-To: Observium Network Observation System <observium(a)observium.org> Date: Saturday, January 2, 2016 at 9:09 AM To: Observium Network Observation System <observium(a)observium.org> Subject: [Observium] How to aggregate multiple graphs Hi, Is it possible to aggregate multiple graphs into a single graph ? If yes, please help to provide me the steps. Regards, chanty _______________________________________________ observium mailing list observium(a)observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium

4 19

Problem adding devices after upgrading to 0.16.1.7393
by Roland Schwingel 05 Jan '16

05 Jan '16

Hi... Yesterday I upgraded my Observium to Version 0.16.1.7393 via svn. The "svn up" did follow an immediate "./discovery.php -u" and a flush of the browser cache. But when I try to add a device I get a somewhat incomplete screen. See attached screenshot. Is this a bug or did I do something wrong? Thanks for your help, Roland

6 9

Re: [Observium] Problem adding devices after upgrading to 0.16.1.7393
by Roland Schwingel 05 Jan '16

05 Jan '16

Hi Adam... Thanks for your reply... I tried deleting the html folder plus svn up but it did not help... I am using FF43 and Chrome 47. I can reproduce it with both browsers... But I found a way now on getting the panel back! I reduced the browser window width to at least the half of my screen (I do have 1980x1200 resolution). Then bling it popus up. As soon as I make it wider than 50% it goes away. Reproduced it with FF and Chrome on windows. Looks indeed like a CSS issue. Roland "observium" <observium-bounces(a)observium.org> wrote on 05.01.2016 15:31:48: > From: "Adam Armstrong" <adama(a)memetic.org> > To: "" <observium(a)observium.org>, > Date: 05.01.2016 15:34 > Subject: Re: [Observium] Problem adding devices after upgrading to 0.16.1.7393 > Sent by: "observium" <observium-bounces(a)observium.org> > > What browsers? > > Did you already try : > > rm -rf html > svn up > > ? > > I've just re-synced stable to current, but there are no relevant > changes in there. I suspect something to do with CSS, since it looks > like the form is hidden under the box-header div. Very odd. Removing > html/ and svn up'ing should fix it. > > adam. > On 05/01/2016 14:03:31, Tom Laermans <tom.laermans(a)powersource.cx> wrote: > I assume you're both running the stable train? Adam, I think a merge may > be in order.. this works fine on trunk. > > Tom > > On 2016-01-05 14:56, Lyndon Labuschagne wrote: > > I have the same issue > > > > On 2016/01/05, 10:08, "observium on behalf of Roland Schwingel" > > > > roland.schwingel(a)onevision.com> wrote: > > > >> Hi... > >> > >> Yesterday I upgraded my Observium to Version 0.16.1.7393 via svn. > >> The "svn up" did follow an immediate "./discovery.php -u" and a flush of > >> the browser cache. But when I try to add a device I get a somewhat > >> incomplete screen. See attached screenshot. > >> > >> Is this a bug or did I do something wrong? > >> > >> Thanks for your help, > >> > >> Roland

2 1