[Observium] Found bug? in p2p_radios poller / discovery

15 Aug 2017


      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

[Observium] Found bug? in p2p_radios poller / discovery

Lyndon Labuschagne