- observium - lists.observium.org

Port names for D-Link 'smart' switches
by Dirk-Willem van Gulik 10 Feb '16

10 Feb '16

Minor feature suggestion for the D-LINK switches. As, iin Observium, one cannot change the port description, you need to rely on being able to set those in the switches (e.g. when you want to use Peering, Transit and other trickery). On D-LINK ifName contains a generated Slot0/1 … Slot0/28, etc. These cannot be changed. However at .1.3.6.1.4.1.171.10.76.21.1.1.16.1.2 (DGS series) .1.3.6.1.4.1.171.10.75.15.2.1.14.1.3 (DES series) and so on - there is a always a table with a sysPortDescString : $ snmptranslate -Tp -M+`pwd`:d-link -m+DES-1210-28MEbx .1.3.6.1.4.1.171.10.75.15.2.1.14.1.3 +-- -RW- String sysPortDescString(3) Textual Convention: DisplayString Size: 0..32 I.e. in the private enterprise MIBs for the various DGS/DES switches there is a sysPortDescString that can be set by the user through the file/SDN or web interfaces. Example of the output below. May be useful to pick up. Dw. snmpwalk -M+/usr/local/www/observium/mibs/d-link -m+Q-BRIDGE-MIB -m+DGS-1210-28P-CX -v2c -c public 10.11.0.18 sysPortDescString DGS-1210-28P-CX::sysPortDescString.1 = STRING: Guest_Port DGS-1210-28P-CX::sysPortDescString.2 = STRING: Guest_Port DGS-1210-28P-CX::sysPortDescString.3 = STRING: Guest_Port DGS-1210-28P-CX::sysPortDescString.4 = STRING: Guest_Port DGS-1210-28P-CX::sysPortDescString.5 = STRING: Guest_Port DGS-1210-28P-CX::sysPortDescString.6 = STRING: Guest_Port DGS-1210-28P-CX::sysPortDescString.7 = STRING: Guest_Port DGS-1210-28P-CX::sysPortDescString.8 = STRING: Guest_Port DGS-1210-28P-CX::sysPortDescString.9 = STRING: Flow 39 DGS-1210-28P-CX::sysPortDescString.10 = STRING: DGS-1210-28P-CX::sysPortDescString.11 = STRING: PI 39 DGS-1210-28P-CX::sysPortDescString.12 = STRING: Flow 37 DGS-1210-28P-CX::sysPortDescString.13 = STRING: DGS-1210-28P-CX::sysPortDescString.14 = STRING: Beeb DGS-1210-28P-CX::sysPortDescString.15 = STRING: DGS-1210-28P-CX::sysPortDescString.16 = STRING: Lintercept DGS-1210-28P-CX::sysPortDescString.17 = STRING: DGS-1210-28P-CX::sysPortDescString.18 = STRING: DGS-1210-28P-CX::sysPortDescString.19 = STRING: DGS-1210-28P-CX::sysPortDescString.20 = STRING: DGS-1210-28P-CX::sysPortDescString.21 = STRING: Wifi - Ypenburg DGS-1210-28P-CX::sysPortDescString.22 = STRING: Wifi - Soesteberg DGS-1210-28P-CX::sysPortDescString.23 = STRING: Wifi - Valkenburg DGS-1210-28P-CX::sysPortDescString.24 = STRING: DGS-1210-28P-CX::sysPortDescString.25 = STRING: TopOfRack: 16A DGS-1210-28P-CX::sysPortDescString.26 = STRING: TopOfRack: 16B DGS-1210-28P-CX::sysPortDescString.27 = STRING: TopOfRack: 19A DGS-1210-28P-CX::sysPortDescString.28 = STRING: TopOfRack: 19B

3 4

Random NetMan UPS sensors appeared
by Robert Williams 09 Feb '16

09 Feb '16

Hi, Our daily discovery has just found a load of (invalid) new sensors on all our various Riello NetMan cards everywhere, easiest to show the image below. Basically, it seems to find various infratec-rms sensors, whatever they are? Obviously they don't exist on these devices, so we suddenly got a load of alarms from each UPS for each of the "failed" sensors: Running 7575 - Any ideas? Cheers! Robert Williams Custodian Data Centre Email: Robert(a)CustodianDC.com http://www.CustodianDC.com

2 3

Rename ports? Ignore?
by John May 09 Feb '16

09 Feb '16

Is it possible to rename ports on a device? Eg: to make a switch's ports named as per the server connected to them? Also, can ports be ignored as servers can on the reporting? - John -- ------------------------------------------------------------------- John May : President http://www.pointinspace.com/ Point In Space Internet Solutions 800.664.8610 919.338.8198

1 1

Accessing Observium from mobile devices
by Laz C. Peterson 08 Feb '16

08 Feb '16

Hello everyone, We are trying out Observium CE, now seriously considering the subscription, and really love the interface and functionality of the application. One requirement we have is being able to access this information from a mobile device, such as iPhone. I have been searching online, unable to find any information about this topic. Does anyone know of a solution to this, or is there an existing template, app or product that can interface with Observium? Beautiful piece of software. Much thanks for any suggestions or insight. ~ Laz Peterson Paravis, LLC

2 4

API for Helpdesk
by chott＠praha1.net 08 Feb '16

08 Feb '16

Hello team, we are looking for solution probably via API how we can check status of ports for Helpdesk Staff My idea is, now all Customer has Customer ID and same ID we are use in Description in Port on switch Can i via API load status of port UP/DOWN for if i know Description of port? Or open window with this status? Thank you Tom [email-header-praha1] Tomas Chott technický ředitel chott(a)praha1.net<mailto:chott@praha1.net> Phone: +420 245 004 005 Mobile: +420 733 123 135 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>

1 0

BGP Tab missing
by Duncan Mossop 08 Feb '16

08 Feb '16

Hi Adam, I would like to pick up an old thread, we’ve got a Juniper router that shows the following log entry at every polling: [cid:image001.png@01D161DB.426DF6D0] But has no BGP tab ☺ Last time we spoke you confirmed the data was there in MySQL so I’m curious where I can go next or if I can get some paid support on this? Thanks, Duncan Mossop • Operations Manager, SystemHOST Ltd ________________________________ dmossop(a)systemhost.co.uk [cid:image046f12.PNG@da9ed394.4998a39f] 01524 737414 systemhost.co.uk<http://www.systemhost.co.uk> [Twitter]<https://twitter.com/systemhost> Follow us on Twitter ________________________________ SystemHOST Ltd Registered office: Holmere Hall, Yealand Conyers, Carnforth, Lancs, LA5 9SN Registered in England No.05028996 VAT No. 927386490 This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. By opening this email or its attachments, you accept liability for any damage that may be caused to your computer hardware, software or data. ________________________________

2 2

Alert check config for a UPS "Status" entry
by Spencer Ryan 08 Feb '16

08 Feb '16

We'd like to alert when any of our APC UPS'es output status is not "online" I see an alert check type is "status" but I'm not sure what to use for the other settings. Right now we have a UPS in hardware bypass due to a bad inverter (ugh) and the status entry says "event alert, status hardwareFailureBypass". Any tips? *Spencer Ryan* | Senior Systems Administrator | sryan(a)arbor.net *Arbor Networks* +1.734.794.5033 (d) | +1.734.846.2053 (m) www.arbornetworks.com

3 6

Graph presentation page - leaving it up for a long period
by Dirk-Willem van Gulik 08 Feb '16

08 Feb '16

During observing a team using observium coming from one of the similar competing platforms; noticed a fair bit of confusion as to what updates and what not. Mostly during ‘dive ins’ when something post incident was ‘kept an eye on’ for the ensuing 3-6 hours; including across work-shift related handovers. The issue is which pages auto-refresh - and which not. And I think the only place where it jars is at the date selection/update buttoned pages. Specifically - when you look at the detailed graph; i.e. on: http://10.11.0.132/graphs/to=1454928724/id=7287/type=sensor_graph/from=1454… Having gotten there from an overview page such as: http://10.11.0.132/device/device=722/tab=health/metric=temperature/id= 7287/ it shows right away as a most recent 24 hour ‘date preset’. The user then sees this page nicely reload every N minutes (as confirmed in the top right of the page). And an experienced ops-hand will track that from the corner of his/her eye - and ignore it the instant the graph stays ‘sane’. BUT in reality the date preset does not track - it is just the 6/24/48h/week/month/year tiny graphs at the top that get updated. And that is easy to miss. So two small UX things suggestions: 1) Would it be possible if, left unattended after, to start rolling with the time; updating the date presets bar when it was never touched in the first place. OR once it was shown for 2-3 minutes - highlight something in the Date preset bar to signal the data is out of date — e.g. have the Update/reload button on the far right be highlighted; i.e. signal an update is possible/due/needed. OR perhaps in combination with a pause/play button very OBVIOUSLY set to ‘pause’ as a more generic idea. 2) Since the preset shown there is in effect the second preset from the 6, 24, 48, one week bare above it - may be nice to indicate this - i.e. that the preset has been filled out in this mode. Dw.

1 0

db.log filling server [SEC=UNCLASSIFIED]
by Peter.Hine＠familycourt.gov.au 08 Feb '16

08 Feb '16

v0.16.1.7533 upgraded from 0.15.6.6430 ./discovery.php -u Observium Community Edition 0.16.1.7533 http://www.observium.org -- Database is up to date. it's full of entries like [2016/02/08 11:30:35 +1100] poller.php(622): Failed dbQuery (#1366 - Incorrect integer value: '' for column 'enabled' at row 1), Query: INSERT INTO `device_graphs` (` device_id`,`graph`,`enabled`) VALUES ('424','fdb_count','') [2016/02/08 11:30:35 +1100] poller.php(626): Failed dbQuery (#1366 - Incorrect integer value: '' for column 'enabled' at row 1), Query: INSERT INTO `device_graphs` (` device_id`,`graph`,`enabled`) VALUES ('427','fdb_count','') [2016/02/08 11:30:35 +1100] poller.php(622): Failed dbQuery (#1366 - Incorrect integer value: '' for column 'enabled' at row 1), Query: INSERT INTO `device_graphs` (` device_id`,`graph`,`enabled`) VALUES ('424','firewall_sessions_ipv4','') [2016/02/08 11:30:35 +1100] poller.php(610): Failed dbQuery (#1366 - Incorrect integer value: '' for column 'enabled' at row 1), Query: INSERT INTO `device_graphs` (` device_id`,`graph`,`enabled`) VALUES ('476','firewall_sessions_ipv4','') [2016/02/08 11:30:35 +1100] poller.php(626): Failed dbQuery (#1366 - Incorrect integer value: '' for column 'enabled' at row 1), Query: INSERT INTO `device_graphs` (` device_id`,`graph`,`enabled`) VALUES ('427','firewall_sessions_ipv4','') [2016/02/08 11:30:35 +1100] poller.php(603): Failed dbQuery (#1364 - Field 'ifInUcastPkts_delta' doesn't have a default value), Query: INSERT INTO `ports-state` (`pol l_time`,`poll_period`,`ifInOctets`,`ifOutOctets`,`ifInErrors`,`ifOutErrors`,`ifInUcastPkts`,`ifOutUcastPkts`,`ifInOctets_perc`,`ifOutOctets_perc`,`ifOctets_rate`,`ifU castPkts_rate`,`ifErrors_rate`,`port_id`) VALUES ('1454891434','1454891434','','','','','','','0','0','0','0','0','1668') [2016/02/08 11:30:35 +1100] poller.php(3592): Failed dbQuery (#1364 - Field 'mempool_polled' doesn't have a default value), Query: INSERT INTO `mempools-state` (`memp ool_id`) VALUES ('1973') [2016/02/08 11:30:35 +1100] poller.php(3592): Failed dbQuery (#1364 - Field 'mempool_polled' doesn't have a default value), Query: INSERT INTO `mempools-state` (`memp ool_id`) VALUES ('1974') [2016/02/08 11:30:35 +1100] poller.php(603): Failed dbQuery (#1364 - Field 'ifInUcastPkts_delta' doesn't have a default value), Query: INSERT INTO `ports-state` (`pol l_time`,`poll_period`,`ifInOctets`,`ifOutOctets`,`ifInErrors`,`ifOutErrors`,`ifInUcastPkts`,`ifOutUcastPkts`,`ifInOctets_perc`,`ifOutOctets_perc`,`ifOctets_rate`,`ifU castPkts_rate`,`ifErrors_rate`,`port_id`) VALUES ('1454891434','1454891434','','','','','','','0','0','0','0','0','1669') so the question is, how do i remediate it. thanks Peter Hine Senior Technical Support Engineer (Servers) FCoA ITS peter.hine(a)familycourt.gov.au ********************************************************************** The information contained in this e-mail (including any attachments) is for the exclusive use of the addressee. If you are not the intended recipient please notify the sender immediately and delete this e-mail. It is noted that legal privilege is not waived because you have read this e-mail. **********************************************************************

2 2

Custom Traffic Graph errors
by Roland Hill 07 Feb '16

07 Feb '16

Hi list, My installation details are as follows: Observium CE 0.16.1.7533 ##### Software versions ##### o OS Linux 4.2.0-27-generic [amd64] (Ubuntu 15.10) o Apache 2.4.12 o PHP 5.6.11-1ubuntu3.1 o Python 2.7.10 o MySQL 5.6.28-0ubuntu0.15.10.1 (extension: mysqli 5.6.28) o SNMP NET-SNMP 5.7.3 o RRDtool 1.5.4 ##### MySQL mode ##### o MySQL NO_ENGINE_SUBSTITUTION ##### Charset info ##### o PHP UTF-8 o MySQL utf8 ##### Timezones info ##### o Date Monday, 08-Feb-16 08:51:25 NZDT o PHP +13:00 o MySQL +13:00 Since upgrading to the latest CE version the Custom Traffic graphs have stopped displaying information, refer picture. I have let this run for a few days but they haven't updated. Any pointers would be appreciated. ...oh, and the new look and feel is great! -- Regards, Roland PGP Key 0xDA39319B = BCF0 1214 BAE9 5A3D 46FC 21A6 360D 9398 DA39 319B

1 0