- observium - lists.observium.org

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

MIB discovery - systemORD table - feature parity
by Dirk-Willem van Gulik 07 Feb '16

07 Feb '16

On some systems SNMPv2-MIB:: sysORTable contains a list of MIBs supported by the agent. Of interest is the: sysORID entry which is defined as: An authoritative identification of a capabilities statement with respect to various MIB modules supported by the local SNMPv2 entity acting in an agent role. and has the OID of those MIBs. Below tiny patch allows these to be 1) automatically included in the (sensor) scan. 2) Provides an option to have some skipped ($config['autodiscovery']['snmp_sysord']['ignore’]). Dw Index: include-dir-mib.inc.php =================================================================== --- include-dir-mib.inc.php (revision HEAD) +++ include-dir-mib.inc.php (working copy) @@ -32,17 +32,39 @@ $include_lib = isset($include_lib) && $include_lib; -foreach (get_device_mibs($device) as $mib) +$mibs = get_device_mibs($device); + +// Check for any (extra) advertized MIBs in the sysORD table; note that we are +// intentionally using 'all' - as we need the textual MIB name in order to +// create a possible file name. +// +$advertizedMIBs = snmpwalk_cache_multi_oid($device, "SNMPv2-MIB::sysORID", array(), "all"); +foreach($advertizedMIBs as $index=> $entry) { + $mib = strtoupper(reset($entry)); + if (!strstr($mib,'-mib')) { + $mib = preg_replace('/MIB$/','-MIB',$mib); + }; + + if (!preg_grep('/'.$mib.'/i',$config['autodiscovery']['snmp_sysord']['ignore']) + && !preg_grep('/'.$mib.'/i', $mibs)) + { + array_push($mibs, $mib); + }; +}; + +foreach ($mibs as $mib) { $inc_dir = $config['install_dir'] . '/' . $include_dir . '/' . strtolower($mib); $inc_file = $inc_dir . '.inc.php'; - if (is_device_mib($device, $mib)) + // We are bypassing the 'is part of the get_device_mibs list' check; as we are passing + // a list sourced from get_device_mibs with possibly additional discovery. + // + if (is_device_mib($device, $mib, TRUE, FALSE)) { if (is_file($inc_file)) { if (OBS_DEBUG) { echo("[[$mib]]"); } - include($inc_file); if ($include_lib && is_file($inc_dir . '.lib.php’)) Index: common.inc.php =================================================================== --- common.inc.php (revision HEAD) +++ common.inc.php (working copy) @@ -2172,11 +2174,14 @@ // DOCME needs phpdoc block // TESTME needs unit testing // MOVEME to includes/functions.inc.php -function is_device_mib($device, $mib, $check_permissions = TRUE) +function is_device_mib($device, $mib, $check_permissions = TRUE, $check_in_mib_list = TRUE) { global $config; - $mib_permitted = in_array($mib, get_device_mibs($device)); // Check if mib available for device + $mib_permitted = TRUE; + if ($check_in_mib_list) + $mib_permitted = in_array($mib, get_device_mibs($device)); // Check if mib available for device + if ($check_permissions && $mib_permitted && (!isset($config['mibs'][$mib]['enable']) || $config['mibs'][$mib]['enable'])) { // Check if MIB permitted by config Index: defaults.inc.php =================================================================== --- defaults.inc.php (revision HEAD) +++ defaults.inc.php (working copy) @@ -174,6 +174,7 @@ $config['snmp']['v3'][0]['cryptopass'] = ""; // Privacy (Encryption) Passphrase $config['snmp']['v3'][0]['cryptoalgo'] = "AES"; // AES | DES + // Autodiscovery Settings $config['autodiscovery']['xdp'] = TRUE; // Autodiscover hosts via discovery protocols (CDP, LLDP, FDP, AMAP and other) @@ -186,6 +187,8 @@ $config['autodiscovery']['ip_nets'] = array("127.0.0.0/8", "192.168.0.0/16", "10.0.0.0/8", "172.16.0.0/12"); // Networks to permit autodiscovery $config['autodiscovery']['ping_skip'] = FALSE; // Skip icmp echo checks during autodiscovery (beware timeouts during discovery!) +$config['autodiscovery']['snmp_sysord']['ignore'] = array('snmpMPDCompliance',' usmMIBCompliance','snmpFrameworkMIBCompliance','vacmBasicGroup','snmpNotifyFullCompliance'); + $config['discover_services'] = FALSE; // Autodiscover services via SNMP on devices of type "server" // Mailer backend Settings

2 2

syslog not working for one server
by Patrick Marquetecken 07 Feb '16

07 Feb '16

Hi, I have syslog working for more then 10 hosts but, for one I can’t get it to work. This server is not in the same location, it sent its log through a vpn tunnel, when it arrives at the router I do a natting: Just forward to the observium server. I see the ump traffic arriving but notting show up in the syslog (database) We can monitor the server without any problems. anyone a suggestion ? Thanks

2 1