- observium - lists.observium.org

Device randomly now taking longer to poll
by Simon Mousey Smith 31 Jan '18

31 Jan '18

Hi All Im trying to work out why 1 of our switches has all of a sudden decided to now take 28s to poll, even tho using it for months its only taken 9s? From the 'tab=perf' of the device, its showing ‘ports’,’fdb-table’,’netstats’,’ospf’ are showng as really high, 9sec each really? I have restarted the equipment incase it was maybe that, same issue Ive upgraded to the latest firmware too but still the same issue? Any other ideas where I can look? Output of /opt/observium/poller.php -h 18 -r -dd https://pastebin.com/Bdpm3abQ <https://pastebin.com/Bdpm3abQ> HP Procurve 1810G - 8GE, P2.22 Regards Simon

2 6

Re: [Observium] unable to add device from Web UI in 9017
by Richard Wigzell 30 Jan '18

30 Jan '18

Hello, output below. root@bsplin709:/opt/observium# svn status ? html/includes/navbar-custom.inc.php M html/includes/search/devices.inc.php ? html/overlib.js ? html/weathermap We have a custom navbar for weathermap and have search/devices.inc.php look at device purpose / description instead of location. Richard Wigzell Technical Lead, Storage Platforms IT Services | University of Oxford 13 Banbury Road, Oxford OX2 6NN T: 01865 616282 www.it.ox.ac.uk -----Original Message----- From: Mike Stupalov [mailto:mike@stupalov.ru] Sent: 30 January 2018 22:32 To: Observium <observium(a)observium.org>; Richard Wigzell <richard.wigzell(a)it.ox.ac.uk> Subject: Re: [Observium] unable to add device from Web UI in 9017 Hi, I'm not see errors and there no changes relevant to such trouble. Show status of your local install: cd /opt/observium svn status > Richard Wigzell <mailto:richard.wigzell@it.ox.ac.uk> > 31 January 2018 at 01:02 > > Hello, it was last confirmed working from the Web UI in 9002. > > We are using exact same hostname, community name and version in both Web UI and CLI. > > cid:image001.jpg@01CE9215.D39244B0 <https://www.it.ox.ac.uk/> > > > > *Richard Wigzell* > Technical Lead, Storage Platforms > IT Services | University of Oxford > > 13 Banbury Road, Oxford OX2 6NN > > > *T:* 01865 616282 > www.it.ox.ac.uk <https://www.it.ox.ac.uk/> > > *From:*observium [mailto:observium-bounces@observium.org] *On Behalf Of *Tom Laermans > *Sent:* 30 January 2018 21:52 > *To:* observium(a)observium.org > *Subject:* Re: [Observium] unable to add device from Web UI in 9017 > > What version did you update from? Did it work in that version? You're using the same hostname and community from the CLI? > > Tom > > On 1/30/2018 10:36 PM, Richard Wigzell wrote: > > > > _______________________________________________ > observium mailing list > observium(a)observium.org > http://postman.memetic.org/cgi-bin/mailman/listinfo/observium > Tom Laermans <mailto:tom.laermans@powersource.cx> > 31 January 2018 at 00:52 > What version did you update from? Did it work in that version? You're using the same hostname and community from the CLI? > > Tom > > On 1/30/2018 10:36 PM, Richard Wigzell wrote: > > > _______________________________________________ > observium mailing list > observium(a)observium.org > http://postman.memetic.org/cgi-bin/mailman/listinfo/observium > Richard Wigzell <mailto:richard.wigzell@it.ox.ac.uk> > 31 January 2018 at 00:36 > > Hello, we have updated to 9017 and are not able to add a device from web UI but can fine from the CLI. > > We just get this: > > Anyone having this issue ? or suggestions welcome please. > > cid:image001.jpg@01CE9215.D39244B0 <https://www.it.ox.ac.uk/> > > > > *Richard Wigzell* > Technical Lead, Storage Platforms > IT Services | University of Oxford > > 13 Banbury Road, Oxford OX2 6NN > > > *T:* 01865 616282 > www.it.ox.ac.uk <https://www.it.ox.ac.uk/> > > > > _______________________________________________ > observium mailing list > observium(a)observium.org > http://postman.memetic.org/cgi-bin/mailman/listinfo/observium -- Mike Stupalov https://stupalov.com

1 0

unable to add device from Web UI in 9017
by Richard Wigzell 30 Jan '18

30 Jan '18

Hello, we have updated to 9017 and are not able to add a device from web UI but can fine from the CLI. We just get this: [cid:image002.png@01D39A12.6C361990] Anyone having this issue ? or suggestions welcome please. [cid:image001.jpg@01CE9215.D39244B0]<https://www.it.ox.ac.uk/> Richard Wigzell Technical Lead, Storage Platforms IT Services | University of Oxford 13 Banbury Road, Oxford OX2 6NN T: 01865 616282 www.it.ox.ac.uk<https://www.it.ox.ac.uk/>

4 6

Cannot login. can this be license related?
by Henrik Cednert (Filmlance) 30 Jan '18

30 Jan '18

Hello Noticed yesterday that I had issues logging in to observium and the issues have continued. I don't get any error it just reloads the page and asks for user/pass, no "wrong password", "unknown user" nor "license error". I have looked in all logs I can think of but I cannot find a trace of what could be causing this. I have some sort of memory that there was some oddness when you renew your license. I can run 'svn update' though and if it was license related I don't think that works, right? Tried update AFTER I realised I cannot login, so not related to update. Nothing have changed in the environment or with the installation. Any pointers to where I should look for clues? Cheers and thanks -- Henrik Cednert cto | ...and then some Filmlance International mobile [ + 46 (0)704 71 89 54 ] skype [ cednert ]

3 3

netflow analyzer
by Farshid Abediny 27 Jan '18

27 Jan '18

Hello, is there anyway that add a integrated netflow analyzer to observium? thanks.

2 1

Monitoring MPLS LSPs
by Luis Balbinot 25 Jan '18

25 Jan '18

Hello there. I've just started working on a new module to include support for MPLS LSPs. Since I only have access to Juniper hardware I'm only working exclusively with the MPLS-MIB but it should be fairly easy to support other MIBs (like Cisco's MPLS-TE mib) because the dataset is pretty much the same. I have the discovery and polling modules ready. If anyone with experience on the web interface wants to join me, please let me know. Luis

2 1

Alerts on custom OID
by Brad Bendy 22 Jan '18

22 Jan '18

Hi, Trying to setup alerts on custom OID, my OID returns just a number and want to alert if it's above or below that. What do I use for the conditions? Im assuming fort the device associations I can reference by hostname or is there other OID/SNMP specific ones? I don't see this anywhere in the docs. So no clue what to put :) Thanks!

2 2

No Syslog alert notifications
by Richard Wigzell 18 Jan '18

18 Jan '18

Hello, we have syslog alert rules setup that are creating syslog alerts and we have a valid contact associated but we do not receive alert notifications. [cid:image002.png@01D3907B.8F6870C0] [cid:image003.png@01D3907C.7B0891E0] Email: [cid:image004.png@01D3907C.7B0891E0] We are running pro 8993. All other alerts working fine. Any help would be appreciated. Regards [cid:image001.jpg@01CE9215.D39244B0]<https://www.it.ox.ac.uk/> Richard Wigzell Technical Lead, Storage Platforms IT Services | University of Oxford 13 Banbury Road, Oxford OX2 6NN T: 01865 616282 www.it.ox.ac.uk<https://www.it.ox.ac.uk/>

1 0

Traps
by Arnoldo Vidal Bravo 18 Jan '18

18 Jan '18

hi, i'm deploying observium but it send mails on trap receive? -- Saluda cordialmente

5 5

wifi_ap table missing?
by Simon Mousey Smith 18 Jan '18

18 Jan '18

Hi All Has anybody else seen this issue? It appears the wifi_aps table is missing? However I do have an wifi_accesspoints table? [2018/01/12 00:33:21 +0000] discovery.php(1241): Failed dbQuery (#1146 - Table 'observium.wifi_aps' doesn't exist), Query: SELECT * FROM `wifi_aps` WHERE `device_id` = ’38' SiMacBookPro:Observium Simon$ grep -r "wifi_aps" * html/pages/device.inc.php: $device_ap_count = dbFetchCell('SELECT COUNT(wifi_ap_id) FROM `wifi_aps` WHERE `device_id` = ?', array($device['device_id'])); html/pages/device/wifi/accesspoints.inc.php: $accesspoints = dbFetchRows('SELECT * FROM `wifi_aps` WHERE `device_id` = ? ORDER BY `ap_name` ASC', array($device['device_id'])); includes/discovery/wifi.inc.php:foreach (dbFetchRows("SELECT * FROM `wifi_aps` WHERE `device_id` = ?", array($device['device_id'])) as $ap) includes/discovery/wifi.inc.php: $GLOBALS['cache']['wifi_aps'][$ap['ap_index']] = $ap; includes/definitions/entities.inc.php:$config['entities'][$entity]['table'] = "wifi_aps"; includes/wifi.inc.php: if (is_array($GLOBALS['cache']['wifi_aps'][$ap['ap_index']])) includes/wifi.inc.php: $ap_db = $GLOBALS['cache']['wifi_aps'][$ap['ap_index']]; includes/wifi.inc.php: dbUpdate($update, 'wifi_aps', '`wifi_ap_id` = ?', array($ap_db['wifi_ap_id'])); includes/wifi.inc.php: $ap_id = dbInsert($insert, 'wifi_aps'); includes/wifi.inc.php: $GLOBALS['cache']['wifi_aps'][$ap['ap_index']] = $params; SiMacBookPro:Observium Simon$ grep -r "wifi_accesspoints" * html/includes/print/dot1xtable.inc.php: $aps_db = dbFetchRows("SELECT `wifi_accesspoint_id`, `name`, `ap_number` FROM `wifi_accesspoints`"); html/includes/search/accesspoints.inc.php:$results = dbFetchRows("SELECT * FROM `wifi_accesspoints` html/includes/graphs/wifi/auth.inc.php: $radio = dbFetchRow("SELECT * FROM `wifi_accesspoints`, `wifi_radios` WHERE `wifi_accesspoints`.`wifi_accesspoint_id` = `wifi_radios`.`accesspoint_id` AND `wifi_radios`.`wifi_radio_id` = ? ", array($vars['id'])); html/pages/device/wifi/overview.inc.php: $radios = dbFetchRows("SELECT * FROM `wifi_accesspoints` LEFT JOIN `wifi_radios` ON `wifi_accesspoints`.`wifi_accesspoint_id` = `wifi_radios`.`radio_ap` WHERE `wifi_accesspoints`.`device_id` = ? ", array($device['device_id'])); html/pages/device/wifi/accesspoint.inc.php: $radios = dbFetchRows("SELECT * FROM `wifi_accesspoints`, `wifi_radios` WHERE `wifi_accesspoints`.`wifi_accesspoint_id` = `wifi_radios`.`radio_ap` AND `device_id` = ? AND `wifi_accesspoints`.`wifi_accesspoint_id` = ? ORDER BY `radio_number` ASC", array($device['device_id'], $vars['accesspoint'])); includes/polling/wifi/trapeze-networks-client-session-mib.inc.php:$radios_db = dbFetchRows("SELECT `wifi_radio_id`, `radio_number`,`ap_number`, `wifi_accesspoints`.`device_id` FROM `wifi_accesspoints`, `wifi_radios` WHERE `wifi_radios`.`radio_ap` = wifi_accesspoints.`wifi_accesspoint_id` AND wifi_accesspoints.`device_id` = ?", array($device['device_id'])); includes/definitions.inc.php: 'ucd_diskio', 'vlans', 'vlans_fdb', 'vminfo', 'vrfs', 'wifi_accesspoints', 'wifi_sessions', includes/discovery/wifi/trapeze-networks-ap-config-mib.inc.php:$accesspoints_db = dbFetchRows("SELECT `name`, `model`, `location`, `fingerprint`, `serial`, `device_id`, `ap_number` FROM `wifi_accesspoints` WHERE `device_id` = ?", array($device['device_id'])); includes/discovery/wifi/trapeze-networks-ap-config-mib.inc.php: $accesspoint_id = dbInsert($db_insert, 'wifi_accesspoints'); includes/discovery/wifi/trapeze-networks-ap-config-mib.inc.php: $updated = dbUpdate($db_insert, 'wifi_accesspoints', '`ap_number` = ? AND `device_id` = ?', array($ap_number, $device['device_id'])); includes/discovery/wifi/trapeze-networks-ap-config-mib.inc.php:$accesspoints_db = dbFetchRows("SELECT `wifi_accesspoint_id`, `ap_number` FROM `wifi_accesspoints` WHERE `device_id` = ?", array($device['device_id'])); update/db_schema_mysql.sql:-- Table structure for table `wifi_accesspoints` update/db_schema_mysql.sql:CREATE TABLE `wifi_accesspoints` ( update/db_schema_mysql.sql:-- Indexes for table `wifi_accesspoints` update/db_schema_mysql.sql:ALTER TABLE `wifi_accesspoints` update/db_schema_mysql.sql:-- AUTO_INCREMENT for table `wifi_accesspoints` update/db_schema_mysql.sql:ALTER TABLE `wifi_accesspoints` update/141.sql:CREATE TABLE `wifi_accesspoints` ( `wifi_accesspoint_id` int(11) NOT NULL AUTO_INCREMENT, `device_id` int(11) NOT NULL, `ap_number` int(11) DEFAULT NULL, `name` varchar(45) DEFAULT NULL, `serial` varchar(45) DEFAULT NULL, `model` varchar(45) DEFAULT NULL, `location` varchar(45) DEFAULT NULL, `fingerprint` varchar(45) DEFAULT NULL, `delete` tinyint(4) DEFAULT NULL, PRIMARY KEY (`wifi_accesspoint_id`)); update/186.sql:ALTER TABLE `wifi_accesspoints` CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; SiMacBookPro:Observium Simon$ I can see when looking threw the code quickly that the is a sql file for wifi_accesspoints but not one for wifi_aps Can I just clone/copy the wifi_accesspoints table to wifi_aps? Regards Simon - Hestor Ltd

5 7