- observium - lists.observium.org

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

31 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 31 Jan '18

31 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 28 Jan '18

28 Jan '18

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

2 1

Monitoring MPLS LSPs
by Luis Balbinot 26 Jan '18

26 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 23 Jan '18

23 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

Observium Rolling PRO - status summary showing wrong info
by Serghei Golipad 18 Jan '18

18 Jan '18

Hi Guys, Ever since updating to php7 I'm seeing devices down in status summary but when I go to click on them it's not showing anything. I know for a fact there are no devices down. It happens very frequently on daily basis. Cheers PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS EMAIL. CDW Limited is a Company registered in England and Wales. This email is sent for and on behalf of CDW Finance Holdings Limited. CDW Finance Holdings Limited is the UK holding company for CDW Limited trading as CDW. The registered office for CDW Finance Holdings Limited (Company Number 05872067) and its UK group undertakings is 10 Fleet Place, London, EC4M 7RB. VAT Registration 902 1949 39. Confidentiality: This e-mail contains proprietary information, some or all of which may be confidential and/or legally privileged. It is for the intended recipient only. If an addressing or transmission error has misdirected this e-mail, please notify the author by replying to this e-mail and then delete the original. If you are not the intended recipient you may not use, disclose, distribute, copy, print or rely on any information contained in this e-mail. You must not inform any other person other than CDW or the sender of its existence. For more information about CDW please visit www.uk.cdw.com

2 4