- observium - lists.observium.org

Found bug? in p2p_radios poller / discovery
by Lyndon Labuschagne 16 Aug '17

16 Aug '17

Hello I am running Observium 17.7.8697 (stable), I also tried rolling but seem to have the same issue I noticed some radios on our network did not have the P2P radio tab while others did, in some cases these where identical radios with identical firmware. When I poll the devices with -dd I get the following The poller seems to push an error "ERROR[Error in query: (Column 'radio_name' cannot be null) 1048]” Now if I take and change the 8th position from NULL and add the “radio name” I can then see the P2P Radio tab in Observium and the correct information is visible, when the poller runs again the “radio_name” is removed "INSERT INTO `p2p_radios` (`device_id`,`radio_mib`,`radio_index`,`radio_tx_freq`,`radio_rx_freq`,`radio_tx_power`,`radio_rx_level`,`radio_name`,`radio_bandwidth`,`radio_modulation`,`radio_total_capacity`,`radio_standard`,`radio_loopback`,`radio_tx_mute`,`radio_eth_capacity`,`radio_e1t1_channels`,`radio_cur_capacity`) VALUES ('1150','ubnt-airmax-mib','1.128.42.168.46.239.89','5195000','5195000','27','-65',NULL,NULL,NULL,'146250000',NULL,NULL,NULL,NULL,NULL,'146250000’)]” More details output below if needed ##### Module Start: p2p-radios ##### SQL[SELECT * FROM `p2p_radios` WHERE `device_id` = '1150'] ROWS[1] SQL RUNTIME[0.00084591s] o UBNT-AirFIBER-MIB UBNT-AirFIBER-MIB CMD[/usr/bin/snmpwalk -t '1' -r '3' -v1 -c 'MTsnmpRO99' -Pu -OQUs -m UBNT-AirFIBER-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/ubiquiti 'udp':'sectornorth.highsite.kzn.domain.co.za':'161' airFiberConfigIndex] CMD EXITCODE[0] CMD RUNTIME[0.1514s] STDOUT[ ] All quotes stripped from snmp output, also for indexes and values! SNMP STATUS[TRUE] o UBNT-AirMAX-MIB CMD[/usr/bin/snmpwalk -t '1' -r '3' -v1 -c 'MTsnmpRO99' -Pu -OQUs -m UBNT-AirMAX-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/ubiquiti 'udp':'sectornorth.highsite.kzn.domain.co.za':'161' ubntRadioEntry] CMD EXITCODE[0] CMD RUNTIME[0.1872s] STDOUT[ ubntRadioIndex.1 = 5 ubntRadioMode.1 = apwds ubntRadioCCode.1 = 511 ubntRadioFreq.1 = 5195 ubntRadioDfsEnabled.1 = false ubntRadioTxPower.1 = 27 ubntRadioDistance.1 = 5550 ubntRadioChainmask.1 = 3 ubntRadioAntenna.1 = AM-5G20-90 - 20 dBi ] All quotes stripped from snmp output, also for indexes and values! SNMP STATUS[TRUE] CMD[/usr/bin/snmpwalk -t '1' -r '3' -v1 -c 'MTsnmpRO99' -Pu -OQUsb -m UBNT-AirMAX-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/ubiquiti 'udp':'sectornorth.highsite.kzn.domain.co.za':'161' ubntStaEntry] CMD EXITCODE[0] CMD RUNTIME[0.7916s] STDOUT[ ubntStaMac.1.68.217.231.42.38.41 = 44:d9:e7:2a:26:29 ubntStaMac.1.68.217.231.170.62.55 = 44:d9:e7:aa:3e:37 ubntStaMac.1.128.42.168.46.239.89 = 80:2a:a8:2e:ef:59 ubntStaName.1.68.217.231.42.38.41 = ubntStaName.1.68.217.231.170.62.55 = ubntStaName.1.128.42.168.46.239.89 = ubntStaSignal.1.68.217.231.42.38.41 = -62 ubntStaSignal.1.68.217.231.170.62.55 = -61 ubntStaSignal.1.128.42.168.46.239.89 = -65 ubntStaNoiseFloor.1.68.217.231.42.38.41 = -92 ubntStaNoiseFloor.1.68.217.231.170.62.55 = -92 ubntStaNoiseFloor.1.128.42.168.46.239.89 = -92 ubntStaDistance.1.68.217.231.42.38.41 = 5550 ubntStaDistance.1.68.217.231.170.62.55 = 3450 ubntStaDistance.1.128.42.168.46.239.89 = 5550 ubntStaCcq.1.68.217.231.42.38.41 = 98 ubntStaCcq.1.68.217.231.170.62.55 = 96 ubntStaCcq.1.128.42.168.46.239.89 = 98 ubntStaAmp.1.68.217.231.42.38.41 = 2 ubntStaAmp.1.68.217.231.170.62.55 = 3 ubntStaAmp.1.128.42.168.46.239.89 = 3 ubntStaAmq.1.68.217.231.42.38.41 = 85 ubntStaAmq.1.68.217.231.170.62.55 = 79 ubntStaAmq.1.128.42.168.46.239.89 = 70 ubntStaAmc.1.68.217.231.42.38.41 = 69 ubntStaAmc.1.68.217.231.170.62.55 = 58 ubntStaAmc.1.128.42.168.46.239.89 = 51 ubntStaLastIp.1.68.217.231.42.38.41 = 192.168.32.51 ubntStaLastIp.1.68.217.231.170.62.55 = 192.168.32.157 ubntStaLastIp.1.128.42.168.46.239.89 = 192.168.32.39 ubntStaTxRate.1.68.217.231.42.38.41 = 162500000 ubntStaTxRate.1.68.217.231.170.62.55 = 146250000 ubntStaTxRate.1.128.42.168.46.239.89 = 146250000 ubntStaRxRate.1.68.217.231.42.38.41 = 65000000 ubntStaRxRate.1.68.217.231.170.62.55 = 97500000 ubntStaRxRate.1.128.42.168.46.239.89 = 65000000 ubntStaTxBytes.1.68.217.231.42.38.41 = 719486789 ubntStaTxBytes.1.68.217.231.170.62.55 = 24312362017 ubntStaTxBytes.1.128.42.168.46.239.89 = 68627880045 ubntStaRxBytes.1.68.217.231.42.38.41 = 740486755 ubntStaRxBytes.1.68.217.231.170.62.55 = 2319151248 ubntStaRxBytes.1.128.42.168.46.239.89 = 5223854785 ubntStaConnTime.1.68.217.231.42.38.41 = 35:21:24:13.00 ubntStaConnTime.1.68.217.231.170.62.55 = 18:22:24:49.00 ubntStaConnTime.1.128.42.168.46.239.89 = 8:3:36:17.00 End of MIB ] All quotes stripped from snmp output, also for indexes and values! SNMP STATUS[TRUE] SQL[INSERT INTO `p2p_radios` (`device_id`,`radio_mib`,`radio_index`,`radio_tx_freq`,`radio_rx_freq`,`radio_tx_power`,`radio_rx_level`,`radio_name`,`radio_bandwidth`,`radio_modulation`,`radio_total_capacity`,`radio_standard`,`radio_loopback`,`radio_tx_mute`,`radio_eth_capacity`,`radio_e1t1_channels`,`radio_cur_capacity`) VALUES ('1150','ubnt-airmax-mib','1.68.217.231.42.38.41','5195000','5195000','27','-62',NULL,NULL,NULL,'162500000',NULL,NULL,NULL,NULL,NULL,'162500000')] ROWS[-1] SQL RUNTIME[0.00072384s] ERROR[Error in query: (Column 'radio_name' cannot be null) 1048] +RRD /opt/observium/rrd/sectornorth.highsite.kzn.domain.co.za/p2p_radio-ubnt-airmax-mib-1.68.217.231.42.38.41.rrd already exists - no need to create. RRD CMD[update /opt/observium/rrd/sectornorth.highsite.kzn.domain.co.za/p2p_radio-ubnt-airmax-mib-1.68.217.231.42.38.41.rrd N:27:-62:U:U:162500000:U:U] RRD RUNTIME[0.0011s] RRD STDOUT[OK u:0.01 s:0.00 r:6.67] RRD_STATUS[TRUE] SQL[UPDATE `p2p_radios` set `radio_rx_level` ='-61',`radio_bandwidth` =NULL,`radio_modulation` =NULL,`radio_total_capacity` ='146250000',`radio_standard` =NULL,`radio_loopback` =NULL,`radio_tx_mute` =NULL,`radio_eth_capacity` =NULL,`radio_e1t1_channels` =NULL,`radio_cur_capacity` ='146250000' WHERE `radio_id` = '143950'] ROWS[1] SQL RUNTIME[0.00200510s] URRD /opt/observium/rrd/sectornorth.highsite.kzn.domain.co.za/p2p_radio-ubnt-airmax-mib-1.68.217.231.170.62.55.rrd already exists - no need to create. RRD CMD[update /opt/observium/rrd/sectornorth.highsite.kzn.domain.co.za/p2p_radio-ubnt-airmax-mib-1.68.217.231.170.62.55.rrd N:27:-61:U:U:146250000:U:U] RRD RUNTIME[0.0011s] RRD STDOUT[OK u:0.01 s:0.00 r:6.67] RRD_STATUS[TRUE] SQL[INSERT INTO `p2p_radios` (`device_id`,`radio_mib`,`radio_index`,`radio_tx_freq`,`radio_rx_freq`,`radio_tx_power`,`radio_rx_level`,`radio_name`,`radio_bandwidth`,`radio_modulation`,`radio_total_capacity`,`radio_standard`,`radio_loopback`,`radio_tx_mute`,`radio_eth_capacity`,`radio_e1t1_channels`,`radio_cur_capacity`) VALUES ('1150','ubnt-airmax-mib','1.128.42.168.46.239.89','5195000','5195000','27','-65',NULL,NULL,NULL,'146250000',NULL,NULL,NULL,NULL,NULL,'146250000')] ROWS[-1] SQL RUNTIME[0.00034904s] ERROR[Error in query: (Column 'radio_name' cannot be null) 1048] +RRD /opt/observium/rrd/sectornorth.highsite.kzn.domain.co.za/p2p_radio-ubnt-airmax-mib-1.128.42.168.46.239.89.rrd already exists - no need to create. RRD CMD[update /opt/observium/rrd/sectornorth.highsite.kzn.domain.co.za/p2p_radio-ubnt-airmax-mib-1.128.42.168.46.239.89.rrd N:27:-65:U:U:146250000:U:U] RRD RUNTIME[0.0011s] RRD STDOUT[OK u:0.01 s:0.00 r:6.67] RRD_STATUS[TRUE] o Module time 1.1504s

1 1

IPSLA targets in IPv6
by Robert Williams 10 Aug '17

10 Aug '17

Hi all, We have a requirement for some IPv6 IPSLA instances on an ASR9k. Can't say this has ever come up before, but anyway, it appears that the IPv6 target IPs don't show up (thousand words below): Is this a known issue (ie. Cisco failing to send it) or did we find a bug? Interestingly, the actual 'result' latency data is all there (and correct) but somewhat difficult to comprehend without the target IP :) Cheers! Robert Williams Custodian Data Centres https://www.CustodianDC.com

3 6

Active Directory/SSO Issue
by Erimer, Tarkan 09 Aug '17

09 Aug '17

Hi, I'm trying to configure SSO with active directory per instructions at http://docs.observium.org/authentication/#active-directory-with-sso? But, once I enable "active_directory" in /opt/observium/config.php as the auth method. I got this error message on the browser : This page isn't working aaa.bbb.com redirected you too many times. Try clearing your cookies. ERR_TOO_MANY_REDIRECTS Any pointers, clues ? Thanks In Advance, Tarkan

2 2

VRF defined by route-target not route-distinguisher
by Simon Bell 09 Aug '17

09 Aug '17

Hi All, Just wondering if there is a way to use route-target to define our VRF's on observium instead of RD. We use route reflector's and therefore have a need for different RD's on each PE for the same VRF. However this means that we get 10 or so VRF's listings for the same VRF. Ideally we would just flip it to be RT if possible. (we use, Juniper MX, Cisco Nexus, Cisco IOS) Any feedback massively appreciated. Only had OBS running for just over a week and hugely impressed. Cheers Simon Simon Bell Core Network Architect Node4 Ltd. Pope Street, Normanton, Wakefield, WF6 2TA. ddi. 0845 123 2229 | t. 0845 123 2222 e. S.Bell(a)node4.co.uk Node4 Limited is registered in England No: 04759927 and has its registered office at Millennium Way, Pride Park, Derby, DE24 8HZ The information contained in this email is confidential and is intended for the exclusive use of the email addressee shown. If you are not the addressee, any disclosure, reproduction, distribution or other dissemination or use of this communication is strictly prohibited. If you have received this mail in error, please notify our mail manager at abuse(a)node4.co.uk and delete it from your system. Opinions expressed in this email are those of the individual not the company, unless specifically indicated to that effect. This email has been scanned inbound by Node4's Email Security System. This email message has been delivered safely and archived online by Mimecast.

1 0

migrate to another os
by Farshid Abediny 08 Aug '17

08 Aug '17

Hello, we are using centos 6 right now and we want install new observium with ubuntu 16 and migrate our graph and data to new server, how can we do this? only graph and their data are important for us, thanks

4 5

Observium CE email notifications not working?
by Vikas Kumar 08 Aug '17

08 Aug '17

Hello everyone, I am a newbie to observium. I am using Observium CE 0.16.10.8128 (6th October 2016) . I have configured config.php as follows: $config['poller-wrapper']['alerter'] = TRUE; $config['email']['enable'] = TRUE; $config['email']['from'] = "noreply(a)xyz.com"; $config['email']['default'] = "uname(a)xyz.com"; $config['email']['default_only'] =TRUE; $config['email']['backend'] = "mail"; $config['email']['sendmail_path'] = "/usr/sbin/sendmail"; $config['email']['smtp_host'] = "smtp.xyz.com"; $config['email']['smtp_port'] = 587; $config['email']['smtp_timeout'] = 10; $config['email']['smtp_secure'] = "tls"; $config['email']['smtp_auth'] = TRUE; $config['email']['smtp_username'] = 'my uname'; $config['email']['smtp_password'] = 'my passwd'; I have added an alert check "device_status equals 0" for one of my server which i am monitoring using observium . The alert checker works fine as it can be seen from web based GUI but i am not receiving email notification on alert state change. Why so? Someone please guide me here is email notification not avaliable in this CE version or am i doing some where wrong? Thanks Regards, Vikas Kumar Masters Student CSE, IIT Bombay

2 1

syslog alert notifications not firing
by Joey Stanford 08 Aug '17

08 Aug '17

Howdy, I’ve setup syslog integration in our copy of observium. In the UI’s /syslog_alerts/ we are seeing the alerts. I have the syslog rules turned on in both our email and telegram contacts. I’ve rebuilt the rule checkers. Unfortunately we’re not getting alerted. We’re getting other alerts, just not for syslogs. I can’t find anything in the obs log or the server’s syslog that would tell me why it’s not working. Can anyone point me to how I can troubleshoot this please? Thanks, Joey

3 11

Community Edition Release Cycle
by BARRIE, Peter 07 Aug '17

07 Aug '17

Hi – I read somewhere that the Community edition is released on a 6 monthly cycle and can see that the last and current release is 0.16.10 (26th October 2016). I was just wondering if this is no longer the case or whether a fresh Community edition is due for release soon ? Thanks Peter. ________________________________ This e-mail is sent by Suncorp Group Limited ABN 66 145 290 124 or one of its related entities "Suncorp". Suncorp may be contacted at Level 28, 266 George Street, Brisbane or on 13 11 55 or at suncorp.com.au. The content of this e-mail is the view of the sender or stated author and does not necessarily reflect the view of Suncorp. The content, including attachments, is a confidential communication between Suncorp and the intended recipient. If you are not the intended recipient, any use, interference with, disclosure or copying of this e-mail, including attachments, is unauthorised and expressly prohibited. If you have received this e-mail in error please contact the sender immediately and delete the e-mail and any attachments from your system. 　

2 1

Storage reading error
by Timothy Illguth 07 Aug '17

07 Aug '17

Hello Support, Any advice on fixing observium so it doesn't drop reading storage? [image: Inline image 1] This seems to happen at random. I'll reboot the observium server and it comes up reading random machines as 0 storage. Thanks -- ___________________________ Tim Illguth Jr. Systems Administrator Alaska Satellite Facility (907) 474-7924

3 11

Polling
by MICHEAU Julien 07 Aug '17

07 Aug '17

Hello, After the installation we have an issue with the rrdtool. In order to have a graph we must have a polling each 5 minutes, but that's used a lot of cpu. Is it possible to have a polling each 15 minutes and have all the graphs or not. And if it's possible, how we can do this, we have searched but not find how do this. Thank you for your help. Cordialement/ Regards, MICHEAU Julien Référent client Direction Cloud et Internet des Objets Tel:+33<tel:+33> (0)4 76 23 91 69 Mob:+33 (0)6 84 86 49 85 E-mail: julien.micheau(a)spie.com<mailto:julien.micheau@spie.com> SPIE ICS www.spie-ics.com<http://www.spie-ics.com/> Parc Sud Galaxie - Rue du Sextant - Immeuble Antarès 38432 Echirolles Cedex ________________________________ ______________________________________________________________ Ce message et toutes les pièces jointes (ci-après le "message") sont confidentiels et établis à l'intention exclusive de ses destinataires. Toute modification, édition, utilisation ou diffusion non autorisée est interdite. Tout message électronique est susceptible d'altération. SPIE et ses filiales déclinent toute responsabilité au titre de ce message s'il a été altéré, déformé, falsifié, édité ou diffusé sans autorisation. This message and any attachments (the "message") are confidential and intended solely for the addressees. Any unauthorised alteration , printing , use or dissemination is prohibited. E-mails are susceptible to alteration. SPIE nor any of its subsidiaries or affiliates shall be liable for the message if altered, changed, falsified, printed or disseminated without authorisation. ______________________________________________________________

2 1