Closed danielblomqvist closed 3 years ago
Hi! I'm not really a wireless person and we don't have an AIR-CT8540-K9 to try, but I can confirm that it also does not work on the AIR-CT5508-K9 and AIR-CT8510-K9 we have here. I don't know if it ever worked, but in the current version it seems to fail on both in the same way:
netdisco-do macsuck -DSI -d 10.0.128.4
...snip...
Read CISCO-LWAPP-DOT11-MIB
Read CISCO-LWAPP-DOT11-CLIENT-MIB
Read IF-MIB
Read SNMPv2-MIB
Read AIRESPACE-WIRELESS-MIB
Read CISCO-LWAPP-AP-MIB
Read IP-MIB
Read CISCO-CDP-MIB
Read AIRESPACE-SWITCHING-MIB
SNMP::Info::_global uptime : DISMAN-EVENT-MIB::sysUpTimeInstance : .1.3.6.1.2.1.1.3.0
SNMP::Info::_global description : SNMPv2-MIB::sysDescr.0 : .1.3.6.1.2.1.1.1.0
SNMP::Info::_global id : SNMPv2-MIB::sysObjectID.0 : .1.3.6.1.2.1.1.2.0
SNMP::Info 3.70
SNMP::Info::device_type() layers:00000111 id:9 sysDescr:"Cisco Controller"
SNMP::Info::_load_attr orig_i_index : IF-MIB::ifIndex : .1.3.6.1.2.1.2.2.1.1
SNMP::Info::_load_attr airespace_apif_slot : AIRESPACE-WIRELESS-MIB::bsnAPIfSlotId : .1.3.6.1.4.1.14179.2.2.2.1.1
SNMP::Info::_load_attr airespace_if_name : AIRESPACE-SWITCHING-MIB::agentInterfaceName : .1.3.6.1.4.1.14179.1.2.13.1.1
SNMP::Info::_load_attr orig_fw_mac : AIRESPACE-WIRELESS-MIB::bsnMobileStationMacAddress : .1.3.6.1.4.1.14179.2.1.4.1.1
SNMP::Info::_load_attr airespace_sta_mac : AIRESPACE-WIRELESS-MIB::bsnMobileStationAPMacAddr : .1.3.6.1.4.1.14179.2.1.4.1.4
SNMP::Info::_load_attr airespace_sta_slot : AIRESPACE-WIRELESS-MIB::bsnMobileStationAPIfSlotId : .1.3.6.1.4.1.14179.2.1.4.1.5
error:snmp_translate_obj:Unknown OID qb_fw_vlan
SNMP::Info::_validate_autoload_method(qb_fw_vlan) Unable to resolve method.
error:snmp_translate_obj:Unknown OID vtp_version
SNMP::Info::_validate_autoload_method(vtp_version) Unable to resolve method.
[9732] 2020-03-31 23:01:39 debug [10.0.128.4] reindexing to vlan 0 (ver: 2, class: SNMP::Info::Layer2::Airespace)
SNMP::Info::clear_cache() - Cache Cleared.
[9732] 2020-03-31 23:01:39 debug [10.0.128.4] macsuck - 0 updated forwarding table entries
[9732] 2020-03-31 23:01:39 debug [10.0.128.4] macsuck - removed 0 fwd table entries to archive
[9732] 2020-03-31 23:01:39 debug -> run worker main/wirelessnodes/100
SNMP::Info::_load_attr client_txrate : CISCO-LWAPP-DOT11-CLIENT-MIB::cldcClientCurrentTxRateSet : .1.3.6.1.4.1.9.9.599.1.3.1.1.17
SNMP::Info::_load_attr cd11_proto : CISCO-LWAPP-DOT11-CLIENT-MIB::cldcClientProtocol : .1.3.6.1.4.1.9.9.599.1.3.1.1.6
SNMP::Info::_load_attr cd11n_ch_bw : CISCO-LWAPP-DOT11-MIB::cldHtDot11nChannelBandwidth : .1.3.6.1.4.1.9.9.612.1.1.1.1.2
[9732] 2020-03-31 23:01:39 info macsuck: finished at Wed Apr 1 01:01:39 2020
[9732] 2020-03-31 23:01:39 info macsuck: status done: Ended macsuck for 10.0.128.4
I'll just leave this here as an additional data point. You wouldn't by coincidence be able to tell what version you had when it still worked? Then we could narrow down what things changed in netdisco, snmp-info and netdisco-mibs since then.
I am getting the same thing on multiple AIR-CT5520-K9 running 8.5.161.0 & 8.3.133.0. This is a new install of Netdisco so its never worked for me.
App::Netdisco: 2.44.15 SNMP::Info: 3.70 DB Schema: 61 PostgreSQL: 10.00.12 Perl: 5.26.1
Netdisco is also not filling in any of the reports under "Wireless" assuming because of this.
Throwing a DB expetion error "[29997] 2020-04-08 10:04:35 debug -> DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::Pg::st execute failed: ERROR: invalid input syntax for type macaddr:"
netdisco@netdisco:~$ netdisco-do macsuck -d 192.168.252.5 -DI
[29997] 2020-04-08 10:04:34 info App::Netdisco version 2.044015 loaded.
[29997] 2020-04-08 10:04:35 info macsuck: [192.168.252.5] started at Wed Apr 8 10:04:35 2020
[29997] 2020-04-08 10:04:35 debug macsuck: running with timeout 600s
[29997] 2020-04-08 10:04:35 debug => running workers for phase: check
[29997] 2020-04-08 10:04:35 debug -> run worker check/_base_/0
[29997] 2020-04-08 10:04:35 debug Macsuck is able to run.
[29997] 2020-04-08 10:04:35 debug => running workers for phase: main
[29997] 2020-04-08 10:04:35 debug -> run worker main/nodes/100
[29997] 2020-04-08 10:04:35 debug snmp reader cache warm: [192.168.252.5]
[29997] 2020-04-08 10:04:35 debug [192.168.252.5:161] try_connect with ver: 3, class: SNMP::Info::Layer2::Airespace, comm: <hidden>
SNMP::Info::_global uptime : DISMAN-EVENT-MIB::sysUpTimeInstance : .1.3.6.1.2.1.1.3.0
SNMP::Info::_global description : SNMPv2-MIB::sysDescr.0 : .1.3.6.1.2.1.1.1.0
SNMP::Info::_global id : SNMPv2-MIB::sysObjectID.0 : .1.3.6.1.2.1.1.2.0
SNMP::Info 3.70
SNMP::Info::device_type() layers:00000111 id:9 sysDescr:"Cisco Controller"
SNMP::Info::_load_attr orig_i_index : IF-MIB::ifIndex : .1.3.6.1.2.1.2.2.1.1
SNMP::Info::_load_attr airespace_apif_slot : AIRESPACE-WIRELESS-MIB::bsnAPIfSlotId : .1.3.6.1.4.1.14179.2.2.2.1.1
SNMP::Info::_load_attr airespace_if_name : AIRESPACE-SWITCHING-MIB::agentInterfaceName : .1.3.6.1.4.1.14179.1.2.13.1.1
SNMP::Info::_load_attr: BULKWALK OID not increasing at /home/netdisco/perl5/lib/perl5/App/Netdisco/Worker/Plugin/Macsuck/Nodes.pm line 34.
SNMP::Info::_load_attr orig_fw_mac : AIRESPACE-WIRELESS-MIB::bsnMobileStationMacAddress : .1.3.6.1.4.1.14179.2.1.4.1.1
SNMP::Info::_load_attr airespace_sta_mac : AIRESPACE-WIRELESS-MIB::bsnMobileStationAPMacAddr : .1.3.6.1.4.1.14179.2.1.4.1.4
SNMP::Info::_load_attr airespace_sta_slot : AIRESPACE-WIRELESS-MIB::bsnMobileStationAPIfSlotId : .1.3.6.1.4.1.14179.2.1.4.1.5
SNMP::Info::_validate_autoload_method(qb_fw_vlan) Unable to resolve method.
SNMP::Info::_load_attr airespace_if_name : AIRESPACE-SWITCHING-MIB::agentInterfaceName : .1.3.6.1.4.1.14179.1.2.13.1.1
SNMP::Info::_load_attr: BULKWALK OID not increasing at /home/netdisco/perl5/lib/perl5/App/Netdisco/Worker/Plugin/Macsuck/Nodes.pm line 279.
[29997] 2020-04-08 10:04:35 debug -> DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::Pg::st execute failed: ERROR: invalid input syntax for type macaddr: "ø-|·¸" [for Statement "SELECT me.mac, me.ip FROM ( SELECT ip, mac FROM device where mac = any (?::macaddr[])
UNION
SELECT ip, mac FROM device_port dp where mac = any (?::macaddr[])
) me GROUP BY mac, ip" with ParamValues: 1='{"ø-|.·¸","Ã...2¬[","ôÃ.HS.ë"}', 2='{"ø-|.·¸","Ã...2¬[","ôÃ.HS.ë"}'] at /home/netdisco/perl5/lib/perl5/App/Netdisco/Util/PortMAC.pm line 42
[29997] 2020-04-08 10:04:35 debug bless( {'msg' => "DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::Pg::st execute failed: ERROR: invalid input syntax for type macaddr: \"\x{f8}-|\x{b7}\x{b8}\" [for Statement \"SELECT me.mac, me.ip FROM ( SELECT ip, mac FROM device where mac = any (?::macaddr[])
UNION
SELECT ip, mac FROM device_port dp where mac = any (?::macaddr[])
) me GROUP BY mac, ip\" with ParamValues: 1='{\"\x{c3}\x{b8}-|.\x{c2}\x{b7}\x{c2}\x{b8}\",\"\x{c3}...2\x{c2}\x{ac}[\",\"\x{c3}\x{b4}\x{c3}.HS.\x{c3}\x{ab}\"}', 2='{\"\x{c3}\x{b8}-|.\x{c2}\x{b7}\x{c2}\x{b8}\",\"\x{c3}...2\x{c2}\x{ac}[\",\"\x{c3}\x{b4}\x{c3}.HS.\x{c3}\x{ab}\"}'] at /home/netdisco/perl5/lib/perl5/App/Netdisco/Util/PortMAC.pm line 42
"}, 'DBIx::Class::Exception' )
[29997] 2020-04-08 10:04:35 debug -> run worker main/wirelessnodes/100
SNMP::Info::_load_attr client_txrate : CISCO-LWAPP-DOT11-CLIENT-MIB::cldcClientCurrentTxRateSet : .1.3.6.1.4.1.9.9.599.1.3.1.1.17
SNMP::Info::_load_attr cd11_proto : CISCO-LWAPP-DOT11-CLIENT-MIB::cldcClientProtocol : .1.3.6.1.4.1.9.9.599.1.3.1.1.6
SNMP::Info::_load_attr cd11n_ch_bw : CISCO-LWAPP-DOT11-MIB::cldHtDot11nChannelBandwidth : .1.3.6.1.4.1.9.9.612.1.1.1.1.2
SNMP::Info::_load_attr cd11_rateset : CISCO-LWAPP-DOT11-CLIENT-MIB::cldcClientDataRateSet : .1.3.6.1.4.1.9.9.599.1.3.1.1.18
SNMP::Info::_validate_autoload_method(cd11_uptime) Unable to resolve method.
SNMP::Info::_load_attr cd11_sigstrength : AIRESPACE-WIRELESS-MIB::bsnMobileStationRSSI : .1.3.6.1.4.1.14179.2.1.6.1.1
SNMP::Info::_load_attr cd11_sigqual : AIRESPACE-WIRELESS-MIB::bsnMobileStationSnr : .1.3.6.1.4.1.14179.2.1.6.1.26
SNMP::Info::_validate_autoload_method(cd11_port) Unable to resolve method.
SNMP::Info::_load_attr cd11_rxpkt : AIRESPACE-WIRELESS-MIB::bsnMobileStationPacketsReceived : .1.3.6.1.4.1.14179.2.1.6.1.5
SNMP::Info::_load_attr cd11_txpkt : AIRESPACE-WIRELESS-MIB::bsnMobileStationPacketsSent : .1.3.6.1.4.1.14179.2.1.6.1.6
SNMP::Info::_load_attr cd11_rxbyte : AIRESPACE-WIRELESS-MIB::bsnMobileStationBytesReceived : .1.3.6.1.4.1.14179.2.1.6.1.2
SNMP::Info::_load_attr cd11_txbyte : AIRESPACE-WIRELESS-MIB::bsnMobileStationBytesSent : .1.3.6.1.4.1.14179.2.1.6.1.3
SNMP::Info::_load_attr cd11_ssid : AIRESPACE-WIRELESS-MIB::bsnMobileStationSsid : .1.3.6.1.4.1.14179.2.1.4.1.7
[29997] 2020-04-08 10:04:35 debug [192.168.252.5] macsuck - processed 3 wireless nodes
[29997] 2020-04-08 10:04:35 info macsuck: finished at Wed Apr 8 10:04:35 2020
[29997] 2020-04-08 10:04:35 info macsuck: status info: [192.168.252.5] macsuck - processed 3 wireless nodes
netdisco@netdisco:~$ netdisco-do show -d 192.168.252.5 -e specify -DI
[30104] 2020-04-08 10:10:17 info App::Netdisco version 2.044015 loaded.
[30104] 2020-04-08 10:10:17 info show: [192.168.252.5]/specify started at Wed Apr 8 10:10:17 2020
[30104] 2020-04-08 10:10:17 debug show: running with timeout 600s
[30104] 2020-04-08 10:10:17 debug => running workers for phase: check
[30104] 2020-04-08 10:10:17 debug -> run worker check/_base_/0
[30104] 2020-04-08 10:10:17 debug Show is able to run
[30104] 2020-04-08 10:10:17 debug => running workers for phase: main
[30104] 2020-04-08 10:10:17 debug -> run worker main/_base_/100
[30104] 2020-04-08 10:10:17 debug snmp reader cache warm: [192.168.252.5]
[30104] 2020-04-08 10:10:17 debug [192.168.252.5:161] try_connect with ver: 3, class: SNMP::Info::Layer2::Airespace, comm: <hidden>
SNMP::Info::_global uptime : DISMAN-EVENT-MIB::sysUpTimeInstance : .1.3.6.1.2.1.1.3.0
SNMP::Info::_global description : SNMPv2-MIB::sysDescr.0 : .1.3.6.1.2.1.1.1.0
SNMP::Info::_global id : SNMPv2-MIB::sysObjectID.0 : .1.3.6.1.2.1.1.2.0
SNMP::Info 3.70
SNMP::Info::device_type() layers:00000111 id:9 sysDescr:"Cisco Controller"
SNMP::Info 3.70
SNMP::Info::device_type() layers:00000111 id:9 sysDescr:"Cisco Controller"
SNMP::Info::specify() - Changed Class to SNMP::Info::Layer2::Airespace.
SNMP::Info::_validate_autoload_method(_data_printer) Unable to resolve method.
SNMP::Info::Layer2::Airespace {
Parents SNMP::Info::Airespace, SNMP::Info::CDP, SNMP::Info::Bridge, Exporter
Linear @ISA SNMP::Info::Layer2::Airespace, SNMP::Info::Airespace, SNMP::Info, Exporter, SNMP::Info::CDP, SNMP::Info::Bridge
public methods (9) : cd11_mac, cd11_txrate, i_mac, model, munge_cd11n_ch_bw, munge_cd11_proto, munge_cd11_rateset, os, vendor
private methods (0)
internals: {
args {
AuthPass "<HIDDEN>",
AuthProto "SHA",
AutoSpecify 0,
BulkRepeaters 20,
BulkWalk 1,
Debug 1,
DebugSNMP 0,
DestHost "192.168.252.5",
IgnoreNetSNMPConf 1,
MibDirs [
[0] "/home/netdisco/netdisco-mibs/3com",
[1] "/home/netdisco/netdisco-mibs/adtran",
[2] "/home/netdisco/netdisco-mibs/aerohive",
[3] "/home/netdisco/netdisco-mibs/alcatel",
[4] "/home/netdisco/netdisco-mibs/allied",
[5] "/home/netdisco/netdisco-mibs/apc",
[6] "/home/netdisco/netdisco-mibs/arista",
[7] "/home/netdisco/netdisco-mibs/aruba",
[8] "/home/netdisco/netdisco-mibs/asante",
[9] "/home/netdisco/netdisco-mibs/avaya",
[10] "/home/netdisco/netdisco-mibs/bluecoat",
[11] "/home/netdisco/netdisco-mibs/bluesocket",
[12] "/home/netdisco/netdisco-mibs/brother",
[13] "/home/netdisco/netdisco-mibs/cabletron",
[14] "/home/netdisco/netdisco-mibs/ceragon",
[15] "/home/netdisco/netdisco-mibs/checkpoint",
[16] "/home/netdisco/netdisco-mibs/ciena",
[17] "/home/netdisco/netdisco-mibs/cisco",
[18] "/home/netdisco/netdisco-mibs/ciscosb",
[19] "/home/netdisco/netdisco-mibs/citrix",
[20] "/home/netdisco/netdisco-mibs/colubris",
[21] "/home/netdisco/netdisco-mibs/cyclades",
[22] "/home/netdisco/netdisco-mibs/d-link",
[23] "/home/netdisco/netdisco-mibs/dell",
[24] "/home/netdisco/netdisco-mibs/eaton",
[25] "/home/netdisco/netdisco-mibs/enterasys",
[26] "/home/netdisco/netdisco-mibs/etherwan",
[27] "/home/netdisco/netdisco-mibs/exinda",
[28] "/home/netdisco/netdisco-mibs/EXTRAS",
[29] "/home/netdisco/netdisco-mibs/extreme",
[30] "/home/netdisco/netdisco-mibs/extricom",
[31] "/home/netdisco/netdisco-mibs/f5",
[32] "/home/netdisco/netdisco-mibs/force10",
[33] "/home/netdisco/netdisco-mibs/fortinet",
[34] "/home/netdisco/netdisco-mibs/foundry",
[35] "/home/netdisco/netdisco-mibs/gigamon",
[36] "/home/netdisco/netdisco-mibs/h3c",
[37] "/home/netdisco/netdisco-mibs/hirschmann",
[38] "/home/netdisco/netdisco-mibs/hp",
[39] "/home/netdisco/netdisco-mibs/hpe",
[40] "/home/netdisco/netdisco-mibs/huawei",
[41] "/home/netdisco/netdisco-mibs/ibm",
[42] "/home/netdisco/netdisco-mibs/juniper",
[43] "/home/netdisco/netdisco-mibs/lancom",
[44] "/home/netdisco/netdisco-mibs/lantronix",
[45] "/home/netdisco/netdisco-mibs/lenovo",
[46] "/home/netdisco/netdisco-mibs/liebert",
[47] "/home/netdisco/netdisco-mibs/mediant",
[48] "/home/netdisco/netdisco-mibs/meraki",
[49] "/home/netdisco/netdisco-mibs/meru",
[50] "/home/netdisco/netdisco-mibs/microsens",
[51] "/home/netdisco/netdisco-mibs/mikrotik",
[52] "/home/netdisco/netdisco-mibs/moser-baer",
[53] "/home/netdisco/netdisco-mibs/motorola",
[54] "/home/netdisco/netdisco-mibs/nateks",
[55] "/home/netdisco/netdisco-mibs/net-snmp",
[56] "/home/netdisco/netdisco-mibs/netapp",
[57] "/home/netdisco/netdisco-mibs/netgear",
[58] "/home/netdisco/netdisco-mibs/netonix",
[59] "/home/netdisco/netdisco-mibs/netscreen",
[60] "/home/netdisco/netdisco-mibs/nexans",
[61] "/home/netdisco/netdisco-mibs/nortel",
[62] "/home/netdisco/netdisco-mibs/northerndesign",
[63] "/home/netdisco/netdisco-mibs/oneaccess",
[64] "/home/netdisco/netdisco-mibs/opengear",
[65] "/home/netdisco/netdisco-mibs/packetfront",
[66] "/home/netdisco/netdisco-mibs/paloalto",
[67] "/home/netdisco/netdisco-mibs/pica8",
[68] "/home/netdisco/netdisco-mibs/pulsesecure-gateway",
[69] "/home/netdisco/netdisco-mibs/rad",
[70] "/home/netdisco/netdisco-mibs/redlionram",
[71] "/home/netdisco/netdisco-mibs/rfc",
[72] "/home/netdisco/netdisco-mibs/rittal",
[73] "/home/netdisco/netdisco-mibs/riverbed",
[74] "/home/netdisco/netdisco-mibs/ruckus",
[75] "/home/netdisco/netdisco-mibs/schleifenbauer",
[76] "/home/netdisco/netdisco-mibs/sentry",
[77] "/home/netdisco/netdisco-mibs/siemens",
[78] "/home/netdisco/netdisco-mibs/sixnet",
[79] "/home/netdisco/netdisco-mibs/sonicwall",
[80] "/home/netdisco/netdisco-mibs/teleste",
[81] "/home/netdisco/netdisco-mibs/tplink",
[82] "/home/netdisco/netdisco-mibs/trapeze",
[83] "/home/netdisco/netdisco-mibs/vmware",
[84] "/home/netdisco/netdisco-mibs/xirrus"
],
NonIncreasing 1,
PrivPass "<HIDDEN>",
PrivProto "AES",
RemotePort 161,
Retries 0,
SecLevel "authPriv",
SecName "<HIDDEN>",
Session SNMP::Session,
Timeout 3000000,
Version 3
},
BulkRepeaters 20,
BulkWalk 1,
class "SNMP::Info::Layer2::Airespace",
debug 1,
funcs {
airespace_ap_ethermac "bsnAPEthernetMacAddress",
airespace_ap_fw "bsnAPBootVersion",
airespace_apif "bsnAPIfOperStatus",
airespace_apif_admin "bsnAPIfAdminStatus",
airespace_apif_a_pwr "bsnAPIfAbsolutePowerList",
airespace_apif_ch_num "bsnAPIfPhyChannelNumber",
airespace_apif_oride "bsnAPIfWlanOverride",
airespace_apif_power "bsnAPIfPhyTxPowerLevel",
airespace_apif_slot "bsnAPIfSlotId",
airespace_apif_type "bsnAPIfType",
airespace_ap_ip "bsnApIpAddress",
airespace_ap_loc "bsnAPLocation",
airespace_ap_mac "bsnAPDot3MacAddress",
airespace_ap_model "bsnAPModel",
airespace_ap_name "bsnAPName",
airespace_ap_serial "bsnAPSerialNumber",
airespace_ap_status "bsnAPAdminStatus",
airespace_ap_sw "bsnAPSoftwareVersion",
airespace_ap_type "bsnAPType",
airespace_bl_descr "bsnBlackListClientDescription",
airespace_bl_mac "bsnBlackListClientMacAddress",
airespace_bl_rstat "bsnBlackListClientRowStatus",
airespace_duplex "agentPortPhysicalStatus",
airespace_duplex_admin "agentPortPhysicalMode",
airespace_ess_aclname "bsnDot11EssAclName",
airespace_ess_bcast "bsnDot11EssBroadcastSsid",
airespace_ess_idx "bsnDot11EssIndex",
airespace_ess_ifname "bsnDot11EssInterfaceName",
airespace_ess_macflt "bsnDot11EssMacFiltering",
airespace_ess_qos "bsnDot11EssQualityOfService",
airespace_ess_radio_pol "bsnDot11EssRadioPolicy",
airespace_ess_sec_auth "bsnDot11EssSecurityAuthType",
airespace_ess_ssid "bsnDot11EssSsid",
airespace_ess_status "bsnDot11EssAdminStatus",
airespace_if_acl "agentInterfaceAclName",
airespace_if_ip "agentInterfaceIPAddress",
airespace_if_mac "agentInterfaceMacAddress",
airespace_if_mask "agentInterfaceIPNetmask",
airespace_if_name "agentInterfaceName",
airespace_if_rstat "agentInterfaceRowStatus",
airespace_if_type "agentInterfaceType",
airespace_if_vlan "agentInterfaceVlanId",
airespace_oride_id "bsnAPIfWlanOverrideId",
airespace_oride_ssid "bsnAPIfWlanOverrideSsid",
airespace_sta_delete "bsnMobileStationDeleteAction",
airespace_sta_ess_idx "bsnMobileStationEssIndex",
airespace_sta_ip "bsnMobileStationIpAddress",
airespace_sta_mac "bsnMobileStationAPMacAddr",
airespace_sta_slot "bsnMobileStationAPIfSlotId",
airespace_sta_ssid "bsnMobileStationSsid",
airespace_user_access "bsnUserAccessMode",
airespace_user_ess_idx "bsnUserEssIndex",
airespace_user_ifname "bsnUserInterfaceName",
airespace_user_name "bsnUserName",
airespace_user_pw "bsnUserPassword",
airespace_user_rstat "bsnUserRowStatus",
airespace_user_type "bsnUserType",
ap_if_mac "cLApIfMacAddress",
cdp_addr "cdpCacheAddress",
cdp_capabilities "cdpCacheCapabilities",
cdp_dev_id "cdpCacheDeviceId",
cdp_dev_port "cdpCacheDevicePort",
cdp_domain "cdpCacheVTPMgmtDomain",
cdp_duplex "cdpCacheDuplex",
cdp_platform "cdpCachePlatform",
cdp_power "cdpCachePowerConsumption",
cdp_pri_mgmt_addr "cdpCachePrimaryMgmtAddr",
cdp_pri_mgmt_type "cdpCachePrimaryMgmtAddrType",
cdp_proto "cdpCacheAddressType",
cdp_sec_mgmt_addr "cdpCacheSecondaryMgmtAddr",
cdp_sec_mgmt_type "cdpCacheSecondaryMgmtAddrType",
cdp_ver "cdpCacheVersion",
cdp_vlan "cdpCacheNativeVLAN",
cd11n_ch_bw "cldHtDot11nChannelBandwidth",
cd11_proto "cldcClientProtocol",
cd11_rateset "cldcClientDataRateSet",
cd11_rxbyte "bsnMobileStationBytesReceived",
cd11_rxpkt "bsnMobileStationPacketsReceived",
cd11_sigqual "bsnMobileStationSnr",
cd11_sigstrength "bsnMobileStationRSSI",
cd11_ssid "bsnMobileStationSsid",
cd11_txbyte "bsnMobileStationBytesSent",
cd11_txpkt "bsnMobileStationPacketsSent",
client_txrate "cldcClientCurrentTxRateSet",
fw_mac "bsnMobileStationMacAddress",
i_alias "ifAlias",
i_bad_proto_in "ifInUnknownProtos",
i_description "ifDescr",
i_discards_in "ifInDiscards",
i_discards_out "ifOutDiscards",
i_errors_in "ifInErrors",
i_errors_out "ifOutErrors",
i_index "ifIndex",
i_lastchange "ifLastChange",
i_mac "ifPhysAddress",
i_mtu "ifMtu",
i_name "ifName",
interfaces "ifIndex",
i_octet_in "ifInOctets",
i_octet_in64 "ifHCInOctets",
i_octet_out "ifOutOctets",
i_octet_out64 "ifHCOutOctets",
ip_broadcast "ipAdEntBcastAddr",
i_pkts_bcast_in "ifInBroadcastPkts",
i_pkts_bcast_in64 "ifHCInBroadcastPkts",
i_pkts_bcast_out "ifOutBroadcastPkts",
i_pkts_bcast_out64 "ifHCOutBroadcastPkts",
i_pkts_multi_in "ifInMulticastPkts",
i_pkts_multi_in64 "ifHCInMulticastPkts",
i_pkts_multi_out "ifOutMulticastPkts",
i_pkts_multi_out64 "ifHCOutMulticastPkts",
i_pkts_nucast_in "ifInNUcastPkts",
i_pkts_nucast_out "ifOutNUcastPkts",
i_pkts_ucast_in "ifInUcastPkts",
i_pkts_ucast_in64 "ifHCInUcastPkts",
i_pkts_ucast_out "ifOutUcastPkts",
i_pkts_ucast_out64 "ifHCOutUcastPkts",
ipr_age "ipRouteAge",
ipr_dest "ipRouteNextHop",
ipr_if "ipRouteIfIndex",
ipr_info "ipRouteInfo",
ipr_mask "ipRouteMask",
ipr_proto "ipRouteProto",
ipr_route "ipRouteDest",
ipr_type "ipRouteType",
ipr_1 "ipRouteMetric1",
ipr_2 "ipRouteMetric2",
ipr_3 "ipRouteMetric3",
ipr_4 "ipRouteMetric4",
ipr_5 "ipRouteMetric5",
i_qlen_out "ifOutQLen",
i_specific "ifSpecific",
i_speed "ifSpeed",
i_speed_high "ifHighSpeed",
i_stack_status "ifStackStatus",
i_type "ifType",
i_up "ifOperStatus",
i_up_admin "ifAdminStatus",
new_ip_index "ipAddressIfIndex",
new_ip_prefix "ipAddressPrefix",
new_ip_type "ipAddressType",
old_ip_index "ipAdEntIfIndex",
old_ip_netmask "ipAdEntNetMask",
old_ip_table "ipAdEntAddr"
},
globals {
airespace_bssid_mode "agentNetworkBroadcastSsidMode",
airespace_lwapp_mode "agentSwitchLwappTransportMode",
airespace_mac "agentInventoryBurnedInMacAddress",
airespace_maint_ver "agentInventoryMaintenanceLevel",
airespace_mc_mode "agentNetworkMulticastMode",
airespace_model "agentInventoryMachineModel",
airespace_os "agentInventoryOperatingSystem",
airespace_prod_name "agentInventoryProductName",
airespace_serial "agentInventorySerialNumber",
airespace_type "agentInventoryMachineType",
airespace_ul_file "agentTransferUploadFilename",
airespace_ul_ip "agentTransferUploadServerIP",
airespace_ul_mode "agentTransferUploadMode",
airespace_ul_path "agentTransferUploadPath",
airespace_ul_start "agentTransferUploadStart",
airespace_ul_status "agentTransferUploadStatus",
airespace_ul_type "agentTransferUploadDataType",
airespace_vendor "agentInventoryManufacturerName",
cdp_gid "cdpGlobalDeviceId",
cdp_holdtime "cdpGlobalHoldTime",
cdp_interval "cdpGlobalMessageInterval",
cdp_run "cdpGlobalRun",
contact "sysContact",
description "sysDescr",
id "sysObjectID",
ipforwarding "ipForwarding",
layers "sysServices",
location "sysLocation",
name "sysName",
os_ver "agentInventoryProductVersion",
ports "ifNumber",
uptime "sysUpTime"
},
IgnoreNetSNMPConf 1,
init \ 1,
mibdirs var{args}{MibDirs},
mibs {
AIRESPACE-SWITCHING-MIB "agentInventorySerialNumber",
AIRESPACE-WIRELESS-MIB "bsnAPName",
CISCO-CDP-MIB "cdpGlobalRun",
CISCO-LWAPP-AP-MIB "cLApIfMacAddress",
CISCO-LWAPP-DOT11-CLIENT-MIB "cldcClientCurrentTxRateSet",
CISCO-LWAPP-DOT11-MIB "cldHtDot11nChannelBandwidth",
IF-MIB "ifIndex",
IP-MIB "ipAdEntAddr",
SNMPv2-MIB "sysObjectID"
},
munge {
airespace_ap_ethermac sub { ... },
airespace_ap_mac var{munge}{airespace_ap_ethermac},
airespace_bl_mac var{munge}{airespace_ap_ethermac},
airespace_if_mac var{munge}{airespace_ap_ethermac},
airespace_sta_mac var{munge}{airespace_ap_ethermac},
ap_if_mac var{munge}{airespace_ap_ethermac},
cdp_capabilities sub { ... },
cdp_domain sub { ... },
cdp_ip sub { ... },
cdp_platform var{munge}{cdp_domain},
cdp_power sub { ... },
cdp_ver var{munge}{cdp_domain},
cd11n_ch_bw sub { ... },
cd11_proto sub { ... },
cd11_rateset sub { ... },
cd11_rxpkt sub { ... },
cd11_txpkt var{munge}{cd11_rxpkt},
fw_port var{munge}{airespace_ap_ethermac},
i_mac var{munge}{airespace_ap_ethermac},
i_octet_in64 sub { ... },
i_octet_out64 var{munge}{i_octet_in64},
i_pkts_bcast_in64 var{munge}{i_octet_in64},
i_pkts_bcast_out64 var{munge}{i_octet_in64},
i_pkts_multi_out64 var{munge}{i_octet_in64},
i_pkts_mutli_in64 var{munge}{i_octet_in64},
i_pkts_ucast_in64 var{munge}{i_octet_in64},
i_pkts_ucast_out64 var{munge}{i_octet_in64},
i_speed sub { ... },
i_speed_high sub { ... },
i_up sub { ... },
ip var{munge}{cdp_ip},
layers sub { ... },
mac var{munge}{airespace_ap_ethermac}
},
nosuch 1,
sess var{args}{Session},
snmp_comm "public",
snmp_user "<HIDDEN>",
snmp_ver 3,
store {}
}
}
[30104] 2020-04-08 10:10:18 info show: finished at Wed Apr 8 10:10:18 2020
[30104] 2020-04-08 10:10:18 info show: status done: Showed specify response from 192.168.252.5```
Any output I can provide on this to help?
I'll just leave this here as an additional data point. You wouldn't by coincidence be able to tell what version you had when it still worked? Then we could narrow down what things changed in netdisco, snmp-info and netdisco-mibs since then. 11
Im not 100% sure but I think I was running: 2.042005 or 2.042007 before I upgraded
Hello. I think we have similar problem.
We have two controllers and an AP w/o controller
AIR-CT2504-K9 AIR-WLC2112-K9 AIR-AP1130
Discover and arpnip works fine. macsuck doesn't on any of them. In wireless reports we can see
channel distribution ssid inventory radio channel and power
but client count is empty.
There is an error on macsuck
[netdisco@ra ~]$ bin/netdisco-do macsuck -d 192.168.111.194 -D
[80000] 2020-07-24 07:54:56 info App::Netdisco version 2.046001 loaded.
[80000] 2020-07-24 07:54:56 info macsuck: [192.168.111.194] started at Fri Jul 24 10:54:56 2020
[80000] 2020-07-24 07:54:57 debug macsuck: running with timeout 600s
[80000] 2020-07-24 07:54:57 debug => running workers for phase: check
[80000] 2020-07-24 07:54:57 debug -> run worker check/_base_/0
[80000] 2020-07-24 07:54:57 debug Macsuck is able to run.
[80000] 2020-07-24 07:54:57 debug => running workers for phase: main
[80000] 2020-07-24 07:54:57 debug -> run worker main/nodes/100
[80000] 2020-07-24 07:54:57 debug snmp reader cache warm: [192.168.111.194]
[80000] 2020-07-24 07:54:57 debug [192.168.111.194:161] try_connect with ver: 2, class: SNMP::Info::Layer2::Airespace, comm: <hidden>
[80000] 2020-07-24 07:54:58 debug -> DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::Pg::st execute failed: ERROR: invalid byte sequence for encoding "UTF8": 0xe8 0xb1 0xfc [for Statement "SELECT me.mac, me.ip FROM ( SELECT ip, mac FROM device where mac = any (?::macaddr[])
UNION
SELECT ip, mac FROM device_port dp where mac = any (?::macaddr[])
) me GROUP BY mac, ip" with ParamValues: 1='{"è±ü{..","(9&ÄH#"}', 2='{"è±ü{..","(9&ÄH#"}'] at /home/netdisco/perl5/lib/perl5/App/Netdisco/Util/PortMAC.pm line 42
[80000] 2020-07-24 07:54:58 debug bless( {'msg' => "DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::Pg::st execute failed: ERROR: invalid byte sequence for encoding \"UTF8\": 0xe8 0xb1 0xfc [for Statement \"SELECT me.mac, me.ip FROM ( SELECT ip, mac FROM device where mac = any (?::macaddr[])
UNION
SELECT ip, mac FROM device_port dp where mac = any (?::macaddr[])
) me GROUP BY mac, ip\" with ParamValues: 1='{\"\x{e8}\x{b1}\x{fc}{..\",\"(9&\x{c4}H#\"}', 2='{\"\x{e8}\x{b1}\x{fc}{..\",\"(9&\x{c4}H#\"}'] at /home/netdisco/perl5/lib/perl5/App/Netdisco/Util/PortMAC.pm line 42
"}, 'DBIx::Class::Exception' )
[80000] 2020-07-24 07:54:58 debug -> run worker main/wirelessnodes/100
[80000] 2020-07-24 07:54:58 debug [192.168.111.194] macsuck - processed 2 wireless nodes
[80000] 2020-07-24 07:54:58 info macsuck: finished at Fri Jul 24 10:54:58 2020
[80000] 2020-07-24 07:54:58 info macsuck: status info: [192.168.111.194] macsuck - processed 2 wireless nodes
App::Netdisco 2.046001 backend Centos 7.8 Perl 5.16.3 net-snmp-5.7.2
SNMP::Info::_load_attr: BULKWALK OID not increasing at /home/netdisco/perl5/lib/perl5/App/Netdisco/Worker/Plugin/Macsuck/Nodes.pm line 279. [29997] 2020-04-08 10:04:35 debug -> DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::Pg::st execute failed: ERROR: invalid input syntax for type macaddr: "ø-|·¸" [for Statement "SELECT me.mac, me.ip FROM ( SELECT ip, mac FROM device where mac = any (?::macaddr[]) UNION SELECT ip, mac FROM device_port dp where mac = any (?::macaddr[]) ) me GROUP BY mac, ip" with ParamValues: 1='{"ø-|.·¸","Ã...2¬[","ôÃ.HS.ë"}', 2='{"ø-|.·¸","Ã...2¬[","ôÃ.HS.ë"}'] at /home/netdisco/perl5/lib/perl5/App/Netdisco/Util/PortMAC.pm line 42 [29997] 2020-04-08 10:04:35 debug bless( {'msg' => "DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::Pg::st execute failed: ERROR: invalid input syntax for type macaddr: \"\x{f8}-|\x{b7}\x{b8}\" [for Statement \"SELECT me.mac, me.ip FROM ( SELECT ip, mac FROM device where mac = any (?::macaddr[]) UNION SELECT ip, mac FROM device_port dp where mac = any (?::macaddr[]) ) me GROUP BY mac, ip\" with ParamValues: 1='{\"\x{c3}\x{b8}-|.\x{c2}\x{b7}\x{c2}\x{b8}\",\"\x{c3}...2\x{c2}\x{ac}[\",\"\x{c3}\x{b4}\x{c3}.HS.\x{c3}\x{ab}\"}', 2='{\"\x{c3}\x{b8}-|.\x{c2}\x{b7}\x{c2}\x{b8}\",\"\x{c3}...2\x{c2}\x{ac}[\",\"\x{c3}\x{b4}\x{c3}.HS.\x{c3}\x{ab}\"}'] at /home/netdisco/perl5/lib/perl5/App/Netdisco/Util/PortMAC.pm line 42 "}, 'DBIx::Class::Exception' ) [29997] 2020-04-08 10:04:35 debug -> run worker main/wirelessnodes/100
this seem to be locale related at first glance. if you are running linux, what's the output of the locale
command? perhaps postgres is trying to to fancy things with utf8, or perhaps a newer perl module changed dbix functioning, or perhaps we broke something by accident ;)
for example, on my opensuse15.1 this would be:
testdisc@linux002:~> locale
LANG=en_US.UTF-8
LC_CTYPE="en_US.UTF-8"
LC_NUMERIC="en_US.UTF-8"
LC_TIME="en_US.UTF-8"
LC_COLLATE="en_US.UTF-8"
LC_MONETARY="en_US.UTF-8"
LC_MESSAGES="en_US.UTF-8"
LC_PAPER="en_US.UTF-8"
LC_NAME="en_US.UTF-8"
LC_ADDRESS="en_US.UTF-8"
LC_TELEPHONE="en_US.UTF-8"
LC_MEASUREMENT="en_US.UTF-8"
LC_IDENTIFICATION="en_US.UTF-8"
LC_ALL=
@inphobia looks the same to me except "LANGUAGE"
netdisco@netdisco:~$ locale LANG=en_US.UTF-8 LANGUAGE= LC_CTYPE="en_US.UTF-8" LC_NUMERIC="en_US.UTF-8" LC_TIME="en_US.UTF-8" LC_COLLATE="en_US.UTF-8" LC_MONETARY="en_US.UTF-8" LC_MESSAGES="en_US.UTF-8" LC_PAPER="en_US.UTF-8" LC_NAME="en_US.UTF-8" LC_ADDRESS="en_US.UTF-8" LC_TELEPHONE="en_US.UTF-8" LC_MEASUREMENT="en_US.UTF-8" LC_IDENTIFICATION="en_US.UTF-8" LC_ALL=
Looks the same for me also:
LANG=en_US.UTF-8
LANGUAGE=
LC_CTYPE="en_US.UTF-8"
LC_NUMERIC="en_US.UTF-8"
LC_TIME="en_US.UTF-8"
LC_COLLATE="en_US.UTF-8"
LC_MONETARY="en_US.UTF-8"
LC_MESSAGES="en_US.UTF-8"
LC_PAPER="en_US.UTF-8"
LC_NAME="en_US.UTF-8"
LC_ADDRESS="en_US.UTF-8"
LC_TELEPHONE="en_US.UTF-8"
LC_MEASUREMENT="en_US.UTF-8"
LC_IDENTIFICATION="en_US.UTF-8"
LC_ALL=
Is there anything we can do to help on this issue?
@rc9000 Is there an easy way to install an older version of Netdisco? (for example: curl -L https://cpanmin.us/ | perl - --notest --local-lib ~/perl5 App::Netdisco to install the current version) I could then try to narrow down what version it was before this problem occured
@danielblomqvist that would be extremely helpful if you can figure out what version still worked. Yes cpanm has an @version syntax, see my comments here.
However in this specific case the issue might also be in SNMP::Info, and I suspect cpanm will install its latest version even if you specify an old Netdisco version. If you go back further than Oct. 2019 (SNMP::Info 3.70, last release), the best way is to start with an empty ~/perl5 and then cpanm the desired SNMP::Info into it first.
Re-reading this topic and looking at the byte-barf you and @Hedgehog57 have in the query parameter that should be a mac address, it seems that Cisco and we do not agree what the content of these MIB nodes is. I think the way to go is to find out what OID something like "ø-|.·¸","Ã...2¬[","ôÃ.HS.ë"
is read from, and then check the MIB how this has to be interpreted. Typically this is a RFC1213 "Physical Address" as OCTET STRING, ie. the 12 bytes of the MAC. But the barf seems to have a lot more bytes, so as a wild guess the latest AIR-CT OS instead maybe writes the bytes of the ASCII representation in there? Looks suspiciously similar:
mac = [ 0x0, 0xa, 0x83, 0xb1, 0xc0, 0x8e ]
[ chr(byte) for byte in mac ]
['\x00', '\n', '\x83', '±', 'À', '\x8e']
@danielblomqvist that would be extremely helpful if you can figure out what version still worked. Yes cpanm has an @Version syntax, see my comments here.
I have not had time to figure it out what version it still was working, but i will try it out soon.
One thing i noticed is that sometimes it actually works to do macsuck. On the 14th of every month it can successfully do a macsuck. Could this be because of the data being archived, maybe some 30-day-old-data policy? and then new data is inserted?
Seems to have the same problem. Have a new docker install that never been able to get the wireless AP from the cisco WLC.
AIR-CT8540-K9 | v. 8.5.161.0
sudo docker-compose -f dc-netdisco-do.yml run netdisco-do macsuck -d 10.70.224.139 -e specify -DI
WARNING: Found orphan containers (netdisco_netdisco-backend_1, netdisco_netdisco-web_1) for this project. If you removed or renamed this service in your compose file, you can run this command with the --remove-orphans flag to clean it up.
Creating netdisco_netdisco-do_run ... done
Attempting to create directory /home/netdisco/perl5
[1] 2021-02-03 07:00:40 info App::Netdisco version 2.047002 loaded.
[1] 2021-02-03 07:00:40 info macsuck: [10.70.224.139] started at Wed Feb 3 07:00:40 2021
[1] 2021-02-03 07:00:40 debug macsuck: running with timeout 600s
[1] 2021-02-03 07:00:40 debug => running workers for phase: check
[1] 2021-02-03 07:00:40 debug -> run worker check/_base_/0
[1] 2021-02-03 07:00:40 debug Macsuck is able to run.
[1] 2021-02-03 07:00:40 debug => running workers for phase: main
[1] 2021-02-03 07:00:40 debug -> run worker main/nodes/100
[1] 2021-02-03 07:00:40 debug snmp reader cache warm: [10.70.224.139]
[1] 2021-02-03 07:00:40 debug [10.70.224.139:161] try_connect with ver: 3, class: SNMP::Info::Layer2::Airespace, comm: <hidden>
SNMP::Info::_global uptime : DISMAN-EVENT-MIB::sysUpTimeInstance : .1.3.6.1.2.1.1.3.0
SNMP::Info::_global description : SNMPv2-MIB::sysDescr.0 : .1.3.6.1.2.1.1.1.0
SNMP::Info::_global id : SNMPv2-MIB::sysObjectID.0 : .1.3.6.1.2.1.1.2.0
SNMP::Info 3.71
SNMP::Info::device_type() layers:00000111 id:9 sysDescr:"Cisco Controller"
SNMP::Info::_load_attr orig_i_index : IF-MIB::ifIndex : .1.3.6.1.2.1.2.2.1.1
SNMP::Info::_load_attr airespace_apif_slot : AIRESPACE-WIRELESS-MIB::bsnAPIfSlotId : .1.3.6.1.4.1.14179.2.2.2.1.1
SNMP::Info::_load_attr airespace_if_name : AIRESPACE-SWITCHING-MIB::agentInterfaceName : .1.3.6.1.4.1.14179.1.2.13.1.1
SNMP::Info::_load_attr orig_fw_mac : AIRESPACE-WIRELESS-MIB::bsnMobileStationMacAddress : .1.3.6.1.4.1.14179.2.1.4.1.1
SNMP::Info::_load_attr airespace_sta_mac : AIRESPACE-WIRELESS-MIB::bsnMobileStationAPMacAddr : .1.3.6.1.4.1.14179.2.1.4.1.4
SNMP::Info::_load_attr airespace_sta_slot : AIRESPACE-WIRELESS-MIB::bsnMobileStationAPIfSlotId : .1.3.6.1.4.1.14179.2.1.4.1.5
SNMP::Info::_validate_autoload_method(qb_fw_vlan) Unable to resolve method.
[1] 2021-02-03 07:00:49 debug -> DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::Pg::st execute failed: ERROR: malformed array literal: "{"ÌÇ`HÚ.","´�ß��¦","�Ò�~
","D�`@=�","²»5ç��","�Fs","Òh½/�","�Ú>�R�","Z3¬4]","*KG£�Á",($:","Ü�(¨·Â","d]�¼�º","¤Ñ�
Yt","6)ç;Ëä","ÆÚÂÄäã","¤Ñ�/ì:","tpým�J","vñÆ���","Ü¢fdÄ�","º�&Z½Ë",f�Ãå¨","ºá¹Çx","ÌÇ`�´","B�àq","úñla» ","´cr3ø","$¦8","@�(&�","Ü¢fdÁ","°5��öé","$÷","°5��öl","\\õÚX�¥","<ܼ4Pv",".¼¹ÄñZ","�c�e","Âï��8","�á{fµ","��òçã","-Z|sE","ä§ ´ß","VÞ�wýK","�¢îî","zÏÓAú","�àc%Ã�","¼TQ�","\\_geci","�½Eì[µ","
/°:�&","RÚÖàØ","ÈöP¾Q_","�¸J¤;�","<j§çØ:","lÇìXÚÂ","Yr�¤�","Ô;7â�","~·ez
","$«ä�","ê³å","
ݳ","¬_>dÊ","[\"Ga¢","l·Ik�","ü0","¦ÄÜðÅÔ","üw?(","Æ�¦|Ow","lÇìûs�","hìÅ�5û","�e�+<W","úçä|f","�æPjC","�F!´","ÌÇ`Uè�","ιy3ü]","�p°\\[","\\÷æ|På","4.¶�BÃ","Ty��Ë","â<òaÓ[","B¡áà-¿","ÀÎÍÅÕE","ð�v5 2","þßvê
["," Å�É´","<j§çÙ\\",""
DETAIL: Unexpected end of input. [for Statement "SELECT me.mac, me.ip FROM ( SELECT ip, mac FROM device where mac = any (?::macaddr[])
UNION
SELECT ip, mac FROM device_port dp where mac = any (?::macaddr[])
) me GROUP BY mac, ip" with ParamValues: 1='{"Ã�Ã.`HÃ..","´Â.Ã.Â.Â�¦","Â.ÂÃ.Â.~
","DÂ.`@=Â.","²»5çÂ.Â.",".Â.F..s","Ã.h.½/Â.","Â.Ã.>Â.RÂ.","Z3¬4.]","*KG£Â.Ã.",".x.($:","Ã.Â�(¨·Ã.","d]Â.¼Â.º","¤Ã.Â�
Yt","6)ç;Ã�ä","Ã.Ã.Ã.Ã.äã","¤Ã.Â�/ì:","tpýmÂ.J","vñÃ.Â.Â�Â.","Ã.¢fdÃ.Â.","ºÂ.&Z½Ã�",".fÂ.Ã.å¨","ºáÃ.¹Ã.x","Ã�Ã.`.Â.´","BÂ..à q.","úñla» ","Ã.´cr3ø","$.z¦.8","@Â.(&.Â.","Ã.¢fdÃ..","°5Â.Â�öé","$.z.÷.","°5Â.Â�öl","\\õÃ.XÂ.Â¥","<Ã.¼4Pv",".¼¹Ã.ñZ","Â�c..Â.e","Ã..ïÂ.Â�8","Â.á{f.µ","Â�Â.òçã.",".-Z|sE","䧠´.Ã.","VÃ.Â.wýK","Â..¢.îî","zÃ.Ã..Aú","Â.à c%Ã.Â.","¼TQ..Â.","\\_geci","Â.½Eì[µ","
/°:Â.&","RÃ..Ã.à Ã.","Ã.öP¾Q_","Â�¸J¤;Â.","<j§çÃ.:","lÃ.ìXÃ.Ã.",".YrÂ.¤Â.","Ã.;.7âÂ.","~·.ez
","$.z«äÂ.","¤.ê³.Ã¥","
Ã.³","¬_>.dÃ�",".[\"Ga¢","l·I.kÂ.","ò..ü0.","¦Ã.Ã.ðÃ.Ã.","üwt.?(","Ã.Â.¦|Ow","lÃ.ìûsÂ....', 2='{"Ã�Ã.`HÃ..","´Â.Ã.Â.Â�¦","Â.ÂÃ.Â.~
","DÂ.`@=Â.","²»5çÂ.Â.",".Â.F..s","Ã.h.½/Â.","Â.Ã.>Â.RÂ.","Z3¬4.]","*KG£Â.Ã.",".x.($:","Ã.Â�(¨·Ã.","d]Â.¼Â.º","¤Ã.Â�
Yt","6)ç;Ã�ä","Ã.Ã.Ã.Ã.äã","¤Ã.Â�/ì:","tpýmÂ.J","vñÃ.Â.Â�Â.","Ã.¢fdÃ.Â.","ºÂ.&Z½Ã�",".fÂ.Ã.å¨","ºáÃ.¹Ã.x","Ã�Ã.`.Â.´","BÂ..à q.","úñla» ","Ã.´cr3ø","$.z¦.8","@Â.(&.Â.","Ã.¢fdÃ..","°5Â.Â�öé","$.z.÷.","°5Â.Â�öl","\\õÃ.XÂ.Â¥","<Ã.¼4Pv",".¼¹Ã.ñZ","Â�c..Â.e","Ã..ïÂ.Â�8","Â.á{f.µ","Â�Â.òçã.",".-Z|sE","䧠´.Ã.","VÃ.Â.wýK","Â..¢.îî","zÃ.Ã..Aú","Â.à c%Ã.Â.","¼TQ..Â.","\\_geci","Â.½Eì[µ","
/°:Â.&","RÃ..Ã.à Ã.","Ã.öP¾Q_","Â�¸J¤;Â.","<j§çÃ.:","lÃ.ìXÃ.Ã.",".YrÂ.¤Â.","Ã.;.7âÂ.","~·.ez
","$.z«äÂ.","¤.ê³.Ã¥","
Ã.³","¬_>.dÃ�",".[\"Ga¢","l·I.kÂ.","ò..ü0.","¦Ã.Ã.ðÃ.Ã.","üwt.?(","Ã.Â.¦|Ow","lÃ.ìûsÂ....'] at /home/netdisco/perl5/lib/perl5/App/Netdisco/Util/PortMAC.pm line 42
[1] 2021-02-03 07:00:49 debug bless( {'msg' => "DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::Pg::st execute failed: ERROR: malformed array literal: \"{\"\x{cc}\x{c7}`H\x{da}.\",\"\x{b4}\x{9c}\x{df}\x{96}\x{8b}\x{a6}\",\"\x{88}\x{ad}\x{d2}\x{86}~
\",\"D\x{91}`\@=\x{87}\",\"\x{b2}\x{bb}5\x{e7}\x{9e}\x{92}\",\"\x{9e}Fs\",\"\x{d2}h\x{bd}/\x{92}\",\"\x{9c}\x{da}>\x{9d}R\x{97}\",\"Z3\x{ac}4]\",\"*KG\x{a3}\x{97}\x{c1}\",\(\$:\",\"\x{dc}\x{8b}(\x{a8}\x{b7}\x{c2}\",\"d]\x{86}\x{bc}\x{9c}\x{ba}\",\"\x{a4}\x{d1}\x{8c}
Yt\",\"6)\x{e7};\x{cb}\x{e4}\",\"\x{c6}\x{da}\x{c2}\x{c4}\x{e4}\x{e3}\",\"\x{a4}\x{d1}\x{8c}/\x{ec}:\",\"tp\x{fd}m\x{98}J\",\"v\x{f1}\x{c6}\x{88}\x{8b}\x{87}\",\"\x{dc}\x{a2}fd\x{c4}\x{9f}\",\"\x{ba}\x{91}&Z\x{bd}\x{cb}\",\f\x{98}\x{c3}\x{e5}\x{a8}\",\"\x{ba}\x{e1}\x{c2}\x{b9}\x{c7}x\",\"\x{cc}\x{c7}`\x{93}\x{b4}\",\"B\x{98}\x{e0}q\",\"\x{fa}\x{f1}la\x{bb} \",\"\x{c2}\x{b4}cr3\x{f8}\",\"\$\x{a6}8\",\"\@\x{9c}(&\x{88}\",\"\x{dc}\x{a2}fd\x{c1}\",\"\x{b0}5\x{9f}\x{8d}\x{f6}\x{e9}\",\"\$\x{f7}\",\"\x{b0}5\x{9f}\x{8d}\x{f6}l\",\"\\\\\x{f5}\x{da}X\x{9a}\x{a5}\",\"<\x{dc}\x{bc}4Pv\",\".\x{bc}\x{b9}\x{c4}\x{f1}Z\",\"\x{8a}c\x{9d}e\",\"\x{c2}\x{ef}\x{8f}\x{8c}8\",\"\x{90}\x{e1}{f\x{b5}\",\"\x{8c}\x{8e}\x{f2}\x{e7}\x{e3}\",\"-Z|sE\",\"\x{e4}\x{a7}\x{a0}\x{b4}\x{df}\",\"V\x{de}\x{9d}w\x{fd}K\",\"\x{96}\x{a2}\x{ee}\x{ee}\",\"z\x{cf}\x{d3}A\x{fa}\",\"\x{9c}\x{e0}c%\x{c3}\x{8e}\",\"\x{bc}TQ\x{94}\",\"\\\\_geci\",\"\x{88}\x{bd}E\x{ec}[\x{b5}\",\"
/\x{b0}:\x{91}&\",\"R\x{da}\x{d6}\x{e0}\x{d8}\",\"\x{c8}\x{f6}P\x{be}Q_\",\"\x{8c}\x{b8}J\x{a4};\x{9b}\",\"<j\x{a7}\x{e7}\x{d8}:\",\"l\x{c7}\x{ec}X\x{da}\x{c2}\",\"Yr\x{96}\x{a4}\x{8e}\",\"\x{d4};7\x{e2}\x{9f}\",\"~\x{b7}ez
\",\"\$\x{ab}\x{e4}\x{91}\",\"\x{a4\x{ea}\x{b3}\x{e5}\",\"
\x{dd}\x{b3}\",\"\x{ac}_>d\x{ca}\",\"[\\\"Ga\x{a2}\",\"l\x{b7}Ik\x{9d}\",\"\x{f2\x{fc}0\",\"\x{a6}\x{c4}\x{dc}\x{f0}\x{c5}\x{d4}\",\"\x{fc}w?(\",\"\x{c6}\x{9e}\x{a6}|Ow\",\"l\x{c7}\x{ec}\x{fb}s\x{87}\",\"h\x{ec}\x{c5}\x{83}5\x{fb}\",\"\x{94}e\x{9c}+<W\",\"\x{fa}\x{e7}\x{e4}|f\",\"\x{80}\x{e6}PjC\",\"\x{9e}F!\x{b4}\",\"\x{cc}\x{c7}`U\x{e8}\x{89}\",\"\x{ce}\x{b9}y3\x{fc}]\",\"\x{8e}p\x{b0}\\\\[\",\"\\\\\x{f7}\x{e6}|P\x{e5}\",\"4.\x{b6}\x{8b}B\x{c3}\",\"Ty\x{94}\x{9a}\x{cb}\",\"\x{e2}<\x{f2}a\x{d3}[\",\"B\x{a1}\x{e1}\x{e0}-\x{bf}\",\"\x{c0}\x{ce}\x{cd}\x{c5}\x{d5}E\",\"\x{f0}\x{8a}v5\x{a0}2\",\"\x{fe}\x{df}v\x{ea}
[\",\"\x{a0}\x{c5}\x{89}\x{c9}\x{b4}\",\"<j\x{a7}\x{e7}\x{d9}\\\\\",\"\"
DETAIL: Unexpected end of input. [for Statement \"SELECT me.mac, me.ip FROM ( SELECT ip, mac FROM device where mac = any (?::macaddr[])
UNION
SELECT ip, mac FROM device_port dp where mac = any (?::macaddr[])
) me GROUP BY mac, ip\" with ParamValues: 1='{\"\x{c3}\x{8c}\x{c3}.`H\x{c3}..\",\"\x{c2}\x{b4}\x{c2}.\x{c3}.\x{c2}.\x{c2}\x{8b}\x{c2}\x{a6}\",\"\x{c2}.\x{c2}\x{ad}\x{c3}.\x{c2}.~
\",\"D\x{c2}.`\@=\x{c2}.\",\"\x{c2}\x{b2}\x{c2}\x{bb}5\x{c3}\x{a7}\x{c2}.\x{c2}.\",\".\x{c2}.F..s\",\"\x{c3}.h.\x{c2}\x{bd}/\x{c2}.\",\"\x{c2}.\x{c3}.>\x{c2}.R\x{c2}.\",\"Z3\x{c2}\x{ac}4.]\",\"*KG\x{c2}\x{a3}\x{c2}.\x{c3}.\",\".x.(\$:\",\"\x{c3}.\x{c2}\x{8b}(\x{c2}\x{a8}\x{c2}\x{b7}\x{c3}.\",\"d]\x{c2}.\x{c2}\x{bc}\x{c2}.\x{c2}\x{ba}\",\"\x{c2}\x{a4}\x{c3}.\x{c2}\x{8c}
Yt\",\"6)\x{c3}\x{a7};\x{c3}\x{8b}\x{c3}\x{a4}\",\"\x{c3}.\x{c3}.\x{c3}.\x{c3}.\x{c3}\x{a4}\x{c3}\x{a3}\",\"\x{c2}\x{a4}\x{c3}.\x{c2}\x{8c}/\x{c3}\x{ac}:\",\"tp\x{c3}\x{bd}m\x{c2}.J\",\"v\x{c3}\x{b1}\x{c3}.\x{c2}.\x{c2}\x{8b}\x{c2}.\",\"\x{c3}.\x{c2}\x{a2}fd\x{c3}.\x{c2}.\",\"\x{c2}\x{ba}\x{c2}.&Z\x{c2}\x{bd}\x{c3}\x{8b}\",\".f\x{c2}.\x{c3}.\x{c3}\x{a5}\x{c2}\x{a8}\",\"\x{c2}\x{ba}\x{c3}\x{a1}\x{c3}.\x{c2}\x{b9}\x{c3}.x\",\"\x{c3}\x{8c}\x{c3}.`.\x{c2}.\x{c2}\x{b4}\",\"B\x{c2}..\x{c3}\x{a0}q.\",\"\x{c3}\x{ba}\x{c3}\x{b1}la\x{c2}\x{bb} \",\"\x{c3}.\x{c2}\x{b4}cr3\x{c3}\x{b8}\",\"\$.z\x{c2}\x{a6}.8\",\"\@\x{c2}.(&.\x{c2}.\",\"\x{c3}.\x{c2}\x{a2}fd\x{c3}..\",\"\x{c2}\x{b0}5\x{c2}.\x{c2}\x{8d}\x{c3}\x{b6}\x{c3}\x{a9}\",\"\$.z.\x{c3}\x{b7}.\",\"\x{c2}\x{b0}5\x{c2}.\x{c2}\x{8d}\x{c3}\x{b6}l\",\"\\\\\x{c3}\x{b5}\x{c3}.X\x{c2}.\x{c2}\x{a5}\",\"<\x{c3}.\x{c2}\x{bc}4Pv\",\".\x{c2}\x{bc}\x{c2}\x{b9}\x{c3}.\x{c3}\x{b1}Z\",\"\x{c2}\x{8a}c..\x{c2}.e\",\"\x{c3}..\x{c3}\x{af}\x{c2}.\x{c2}\x{8c}8\",\"\x{c2}.\x{c3}\x{a1}{f.\x{c2}\x{b5}\",\"\x{c2}\x{8c}\x{c2}.\x{c3}\x{b2}\x{c3}\x{a7}\x{c3}\x{a3}.\",\".-Z|sE\",\"\x{c3}\x{a4}\x{c2}\x{a7}\x{c2}\x{a0}\x{c2}\x{b4}.\x{c3}.\",\"V\x{c3}.\x{c2}.w\x{c3}\x{bd}K\",\"\x{c2}..\x{c2}\x{a2}.\x{c3}\x{ae}\x{c3}\x{ae}\",\"z\x{c3}.\x{c3}..A\x{c3}\x{ba}\",\"\x{c2}.\x{c3}\x{a0}c%\x{c3}.\x{c2}.\",\"\x{c2}\x{bc}TQ..\x{c2}.\",\"\\\\_geci\",\"\x{c2}.\x{c2}\x{bd}E\x{c3}\x{ac}[\x{c2}\x{b5}\",\"
/\x{c2}\x{b0}:\x{c2}.&\",\"R\x{c3}..\x{c3}.\x{c3}\x{a0}\x{c3}.\",\"\x{c3}.\x{c3}\x{b6}P\x{c2}\x{be}Q_\",\"\x{c2}\x{8c}\x{c2}\x{b8}J\x{c2}\x{a4};\x{c2}.\",\"<j\x{c2}\x{a7}\x{c3}\x{a7}\x{c3}.:\",\"l\x{c3}.\x{c3}\x{ac}X\x{c3}.\x{c3}.\",\".Yr\x{c2}.\x{c2}\x{a4}\x{c2}.\",\"\x{c3}.;.7\x{c3}\x{a2}\x{c2}.\",\"~\x{c2}\x{b7}.ez
\",\"\$.z\x{c2}\x{ab}\x{c3}\x{a4}\x{c2}.\",\"\x{c2}\x{a4}.\x{c3}\x{aa}\x{c2}\x{b3}.\x{c3}\x{a5}\",\"
p\x{c3}.\$f\x{c2}\x{bf}\",\"\x{c2}\x{a6}\x{c3}.2\x{c3}\x{bb}>\x{c2}\x{8a}\",\"\x{c3}\x{a6}\x{c3}\x{b0}\x{c2}\x{a3}\x{c3}.q5\",\"\x{c3}\x{a4}\x{c2}.\x{c3}.`:-\",\"\x{c2}.}\x{c3}.#5\x{c3}.\",\"*.3\x{c2}\x{b5}X\\x{c2}.\",\".\x{c2}.ql\x{c2}.\x{c2}\x{b1}\",\"\x{c2}\x{a6}\x{c3}\x{a1}&\x{c3}.\x{c2}\x{ac}A\",\".\x{c3}\x{aa}V\x{c2}.\x{c3}.\x{c2}\x{89}\",\"`\x{c3}\x{be}\x{c3}.\x{c2}\x{ac}\x{c3}.P\",\"\x{c2}.\x{c2}\x{a8}*+b\x{c3}.\x{c2}\x{b3}\",\"\x{c2}\x{ac}_>.d\x{c3}\x{8a}\",\".[\\\"Ga\x{c2}\x{a2}\",\"l\x{c2}\x{b7}I.k\x{c2}.\",\"\x{c3}\x{b2}..\x{c3}\x{bc}0.\",\"\x{c2}\x{a6}\x{c3}.\x{c3}.\x{c3}\x{b0}\x{c3}.\x{c3}.\",\"\x{c3}\x{bc}wt.?(\",\"\x{c3}.\x{c2}.\x{c2}\x{a6}|Ow\",\"l\x{c3}.\x{c3}\x{ac}\x{c3}\x{bb}s\x{c2}....', 2='{\"\x{c3}\x{8c}\x{c3}.`H\x{c3}..\",\"\x{c2}\x{b4}\x{c2}.\x{c3}.\x{c2}.\x{c2}\x{8b}\x{c2}\x{a6}\",\"\x{c2}.\x{c2}\x{ad}\x{c3}.\x{c2}.~
\",\"D\x{c2}.`\@=\x{c2}.\",\"\x{c2}\x{b2}\x{c2}\x{bb}5\x{c3}\x{a7}\x{c2}.\x{c2}.\",\".\x{c2}.F..s\",\"\x{c3}.h.\x{c2}\x{bd}/\x{c2}.\",\"\x{c2}.\x{c3}.>\x{c2}.R\x{c2}.\",\"Z3\x{c2}\x{ac}4.]\",\"*KG\x{c2}\x{a3}\x{c2}.\x{c3}.\",\".x.(\$:\",\"\x{c3}.\x{c2}\x{8b}(\x{c2}\x{a8}\x{c2}\x{b7}\x{c3}.\",\"d]\x{c2}.\x{c2}\x{bc}\x{c2}.\x{c2}\x{ba}\",\"\x{c2}\x{a4}\x{c3}.\x{c2}\x{8c}
Yt\",\"6)\x{c3}\x{a7};\x{c3}\x{8b}\x{c3}\x{a4}\",\"\x{c3}.\x{c3}.\x{c3}.\x{c3}.\x{c3}\x{a4}\x{c3}\x{a3}\",\"\x{c2}\x{a4}\x{c3}.\x{c2}\x{8c}/\x{c3}\x{ac}:\",\"tp\x{c3}\x{bd}m\x{c2}.J\",\"v\x{c3}\x{b1}\x{c3}.\x{c2}.\x{c2}\x{8b}\x{c2}.\",\"\x{c3}.\x{c2}\x{a2}fd\x{c3}.\x{c2}.\",\"\x{c2}\x{ba}\x{c2}.&Z\x{c2}\x{bd}\x{c3}\x{8b}\",\".f\x{c2}.\x{c3}.\x{c3}\x{a5}\x{c2}\x{a8}\",\"\x{c2}\x{ba}\x{c3}\x{a1}\x{c3}.\x{c2}\x{b9}\x{c3}.x\",\"\x{c3}\x{8c}\x{c3}.`.\x{c2}.\x{c2}\x{b4}\",\"B\x{c2}..\x{c3}\x{a0}q.\",\"\x{c3}\x{ba}\x{c3}\x{b1}la\x{c2}\x{bb} \",\"\x{c3}.\x{c2}\x{b4}cr3\x{c3}\x{b8}\",\"\$.z\x{c2}\x{a6}.8\",\"\@\x{c2}.(&.\x{c2}.\",\"\x{c3}.\x{c2}\x{a2}fd\x{c3}..\",\"\x{c2}\x{b0}5\x{c2}.\x{c2}\x{8d}\x{c3}\x{b6}\x{c3}\x{a9}\",\"\$.z.\x{c3}\x{b7}.\",\"\x{c2}\x{b0}5\x{c2}.\x{c2}\x{8d}\x{c3}\x{b6}l\",\"\\\\\x{c3}\x{b5}\x{c3}.X\x{c2}.\x{c2}\x{a5}\",\"<\x{c3}.\x{c2}\x{bc}4Pv\",\".\x{c2}\x{bc}\x{c2}\x{b9}\x{c3}.\x{c3}\x{b1}Z\",\"\x{c2}\x{8a}c..\x{c2}.e\",\"\x{c3}..\x{c3}\x{af}\x{c2}.\x{c2}\x{8c}8\",\"\x{c2}.\x{c3}\x{a1}{f.\x{c2}\x{b5}\",\"\x{c2}\x{8c}\x{c2}.\x{c3}\x{b2}\x{c3}\x{a7}\x{c3}\x{a3}.\",\".-Z|sE\",\"\x{c3}\x{a4}\x{c2}\x{a7}\x{c2}\x{a0}\x{c2}\x{b4}.\x{c3}.\",\"V\x{c3}.\x{c2}.w\x{c3}\x{bd}K\",\"\x{c2}..\x{c2}\x{a2}.\x{c3}\x{ae}\x{c3}\x{ae}\",\"z\x{c3}.\x{c3}..A\x{c3}\x{ba}\",\"\x{c2}.\x{c3}\x{a0}c%\x{c3}.\x{c2}.\",\"\x{c2}\x{bc}TQ..\x{c2}.\",\"\\\\_geci\",\"\x{c2}.\x{c2}\x{bd}E\x{c3}\x{ac}[\x{c2}\x{b5}\",\"
/\x{c2}\x{b0}:\x{c2}.&\",\"R\x{c3}..\x{c3}.\x{c3}\x{a0}\x{c3}.\",\"\x{c3}.\x{c3}\x{b6}P\x{c2}\x{be}Q_\",\"\x{c2}\x{8c}\x{c2}\x{b8}J\x{c2}\x{a4};\x{c2}.\",\"<j\x{c2}\x{a7}\x{c3}\x{a7}\x{c3}.:\",\"l\x{c3}.\x{c3}\x{ac}X\x{c3}.\x{c3}.\",\".Yr\x{c2}.\x{c2}\x{a4}\x{c2}.\",\"\x{c3}.;.7\x{c3}\x{a2}\x{c2}.\",\"~\x{c2}\x{b7}.ez
\",\"\$.z\x{c2}\x{ab}\x{c3}\x{a4}\x{c2}.\",\"\x{c2}\x{a4}.\x{c3}\x{aa}\x{c2}\x{b3}.\x{c3}\x{a5}\",\"
p\x{c3}.\$f\x{c2}\x{bf}\",\"\x{c2}\x{a6}\x{c3}.2\x{c3}\x{bb}>\x{c2}\x{8a}\",\"\x{c3}\x{a6}\x{c3}\x{b0}\x{c2}\x{a3}\x{c3}.q5\",\"\x{c3}\x{a4}\x{c2}.\x{c3}.`:-\",\"\x{c2}.}\x{c3}.#5\x{c3}.\",\"*.3\x{c2}\x{b5}X\\x{c2}.\",\".\x{c2}.ql\x{c2}.\x{c2}\x{b1}\",\"\x{c2}\x{a6}\x{c3}\x{a1}&\x{c3}.\x{c2}\x{ac}A\",\".\x{c3}\x{aa}V\x{c2}.\x{c3}.\x{c2}\x{89}\",\"`\x{c3}\x{be}\x{c3}.\x{c2}\x{ac}\x{c3}.P\",\"\x{c2}.\x{c2}\x{a8}*+b\x{c3}.\x{c2}\x{b3}\",\"\x{c2}\x{ac}_>.d\x{c3}\x{8a}\",\".[\\\"Ga\x{c2}\x{a2}\",\"l\x{c2}\x{b7}I.k\x{c2}.\",\"\x{c3}\x{b2}..\x{c3}\x{bc}0.\",\"\x{c2}\x{a6}\x{c3}.\x{c3}.\x{c3}\x{b0}\x{c3}.\x{c3}.\",\"\x{c3}\x{bc}wt.?(\",\"\x{c3}.\x{c2}.\x{c2}\x{a6}|Ow\",\"l\x{c3}.\x{c3}\x{ac}\x{c3}\x{bb}s\x{c2}....'] at /home/netdisco/perl5/lib/perl5/App/Netdisco/Util/PortMAC.pm line 42
"}, 'DBIx::Class::Exception' )
[1] 2021-02-03 07:00:49 debug -> run worker main/wirelessnodes/100
SNMP::Info::_load_attr client_txrate : CISCO-LWAPP-DOT11-CLIENT-MIB::cldcClientCurrentTxRateSet : .1.3.6.1.4.1.9.9.599.1.3.1.1.17
SNMP::Info::_load_attr cd11_proto : CISCO-LWAPP-DOT11-CLIENT-MIB::cldcClientProtocol : .1.3.6.1.4.1.9.9.599.1.3.1.1.6
SNMP::Info::_load_attr cd11n_ch_bw : CISCO-LWAPP-DOT11-MIB::cldHtDot11nChannelBandwidth : .1.3.6.1.4.1.9.9.612.1.1.1.1.2
SNMP::Info::_load_attr cd11_rateset : CISCO-LWAPP-DOT11-CLIENT-MIB::cldcClientDataRateSet : .1.3.6.1.4.1.9.9.599.1.3.1.1.18
SNMP::Info::_validate_autoload_method(cd11_uptime) Unable to resolve method.
SNMP::Info::_load_attr cd11_sigstrength : AIRESPACE-WIRELESS-MIB::bsnMobileStationRSSI : .1.3.6.1.4.1.14179.2.1.6.1.1
SNMP::Info::_load_attr cd11_sigqual : AIRESPACE-WIRELESS-MIB::bsnMobileStationSnr : .1.3.6.1.4.1.14179.2.1.6.1.26
SNMP::Info::_validate_autoload_method(cd11_port) Unable to resolve method.
SNMP::Info::_load_attr cd11_rxpkt : AIRESPACE-WIRELESS-MIB::bsnMobileStationPacketsReceived : .1.3.6.1.4.1.14179.2.1.6.1.5
SNMP::Info::_load_attr cd11_txpkt : AIRESPACE-WIRELESS-MIB::bsnMobileStationPacketsSent : .1.3.6.1.4.1.14179.2.1.6.1.6
SNMP::Info::_load_attr cd11_rxbyte : AIRESPACE-WIRELESS-MIB::bsnMobileStationBytesReceived : .1.3.6.1.4.1.14179.2.1.6.1.2
SNMP::Info::_load_attr cd11_txbyte : AIRESPACE-WIRELESS-MIB::bsnMobileStationBytesSent : .1.3.6.1.4.1.14179.2.1.6.1.3
SNMP::Info::_load_attr cd11_ssid : AIRESPACE-WIRELESS-MIB::bsnMobileStationSsid : .1.3.6.1.4.1.14179.2.1.4.1.7
[1] 2021-02-03 07:01:17 debug [10.70.224.139] macsuck - processed 3939 wireless nodes
[1] 2021-02-03 07:01:17 debug => running workers for phase: late
[1] 2021-02-03 07:01:17 debug -> run worker late/hooks/0
[1] 2021-02-03 07:01:17 debug [10.70.224.139] hooks - 0 queued
[1] 2021-02-03 07:01:17 info macsuck: finished at Wed Feb 3 07:01:17 2021
[1] 2021-02-03 07:01:17 info macsuck: status info: [10.70.224.139] macsuck - processed 3939 wireless nodes
I did some tests.
[root@monitoring netdisco]# docker-compose -f netdisco-do.yml run netdisco-do macsuck -d 192.168.130.2 -e specify -DI
Attempting to create directory /home/netdisco/perl5
[1] 2021-03-11 09:09:45 info App::Netdisco version 2.047002 loaded.
[1] 2021-03-11 09:09:46 info macsuck: [192.168.130.2] started at Thu Mar 11 09:09:46 2021
[1] 2021-03-11 09:09:46 debug macsuck: running with timeout 600s
[1] 2021-03-11 09:09:46 debug => running workers for phase: check
[1] 2021-03-11 09:09:46 debug -> run worker check/_base_/0
[1] 2021-03-11 09:09:46 debug Macsuck is able to run.
[1] 2021-03-11 09:09:46 debug => running workers for phase: main
[1] 2021-03-11 09:09:46 debug -> run worker main/nodes/100
[1] 2021-03-11 09:09:46 debug snmp reader cache warm: [192.168.130.2]
[1] 2021-03-11 09:09:46 debug [192.168.130.2:161] try_connect with ver: 2, class: SNMP::Info::Layer2::Airespace, comm: <hidden>
SNMP::Info::_global uptime : DISMAN-EVENT-MIB::sysUpTimeInstance : .1.3.6.1.2.1.1.3.0
SNMP::Info::_global description : SNMPv2-MIB::sysDescr.0 : .1.3.6.1.2.1.1.1.0
SNMP::Info::_global id : SNMPv2-MIB::sysObjectID.0 : .1.3.6.1.2.1.1.2.0
SNMP::Info 3.71
SNMP::Info::device_type() layers:00000111 id:9 sysDescr:"Cisco Controller"
SNMP::Info::_load_attr orig_i_index : IF-MIB::ifIndex : .1.3.6.1.2.1.2.2.1.1
SNMP::Info::_load_attr airespace_apif_slot : AIRESPACE-WIRELESS-MIB::bsnAPIfSlotId : .1.3.6.1.4.1.14179.2.2.2.1.1
SNMP::Info::_load_attr airespace_if_name : AIRESPACE-SWITCHING-MIB::agentInterfaceName : .1.3.6.1.4.1.14179.1.2.13.1.1
SNMP::Info::_load_attr orig_fw_mac : AIRESPACE-WIRELESS-MIB::bsnMobileStationMacAddress : .1.3.6.1.4.1.14179.2.1.4.1.1
SNMP::Info::_load_attr airespace_sta_mac : AIRESPACE-WIRELESS-MIB::bsnMobileStationAPMacAddr : .1.3.6.1.4.1.14179.2.1.4.1.4
SNMP::Info::_load_attr airespace_sta_slot : AIRESPACE-WIRELESS-MIB::bsnMobileStationAPIfSlotId : .1.3.6.1.4.1.14179.2.1.4.1.5
SNMP::Info::_validate_autoload_method(qb_fw_vlan) Unable to resolve method.
[1] 2021-03-11 09:09:46 debug -> DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::Pg::st execute failed: ERROR: invalid input syntax for type macaddr: "(²½O▒" [for Statement "SELECT me.mac, me.ip FROM ( SELECT ip, mac FROM device where mac = any (?::macaddr[])
UNION
SELECT ip, mac FROM device_port dp where mac = any (?::macaddr[])
) me GROUP BY mac, ip" with ParamValues: 1='{"(²½O.Ã.","tÃ¥
¦à à ",".êV/.g"}', 2='{"(²½O.Ã.","tÃ¥
¦à à ",".êV/.g"}'] at /home/netdisco/perl5/lib/perl5/App/Netdisco/Util/PortMAC.pm line 42
[1] 2021-03-11 09:09:46 debug bless( {'msg' => "DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::Pg::st execute failed: ERROR: invalid input syntax for type macaddr: \"(\x{b2}\x{bd}Ox{d1}\" [for Statement \"SELECT me.mac, me.ip FROM ( SELECT ip, mac FROM device where mac = any (?::macaddr[])
UNION
SELECT ip, mac FROM device_port dp where mac = any (?::macaddr[])
) me GROUP BY mac, ip\" with ParamValues: 1='{\"(\x{c2}\x{b2}\x{c2}\x{bd}O.\x{c3}.\",\"t\x{c3}\x{a5}
\x{c2}\x{a6}\x{c3}\x{a0}\x{c3}\x{a0}\",\".\x{c3}\x{aa}V/.g\"}', 2='{\"(\x{c2}\x{b2}\x{c2}\x{bd}O.\x{c3}.\",\"t\x{c3}\x{a5}
\x{c2}\x{a6}\x{c3}\x{a0}\x{c3}\x{a0}\",\".\x{c3}\x{aa}V/.g\"}'] at /home/netdisco/perl5/lib/perl5/App/Netdisco/Util/PortMAC.pm line 42
"}, 'DBIx::Class::Exception' )
[1] 2021-03-11 09:09:46 debug -> run worker main/wirelessnodes/100
SNMP::Info::_load_attr client_txrate : CISCO-LWAPP-DOT11-CLIENT-MIB::cldcClientCurrentTxRateSet : .1.3.6.1.4.1.9.9.599.1.3.1.1.17
SNMP::Info::_load_attr cd11_proto : CISCO-LWAPP-DOT11-CLIENT-MIB::cldcClientProtocol : .1.3.6.1.4.1.9.9.599.1.3.1.1.6
SNMP::Info::_load_attr cd11n_ch_bw : CISCO-LWAPP-DOT11-MIB::cldHtDot11nChannelBandwidth : .1.3.6.1.4.1.9.9.612.1.1.1.1.2
SNMP::Info::_load_attr cd11_rateset : CISCO-LWAPP-DOT11-CLIENT-MIB::cldcClientDataRateSet : .1.3.6.1.4.1.9.9.599.1.3.1.1.18
SNMP::Info::_validate_autoload_method(cd11_uptime) Unable to resolve method.
SNMP::Info::_load_attr cd11_sigstrength : AIRESPACE-WIRELESS-MIB::bsnMobileStationRSSI : .1.3.6.1.4.1.14179.2.1.6.1.1
SNMP::Info::_load_attr cd11_sigqual : AIRESPACE-WIRELESS-MIB::bsnMobileStationSnr : .1.3.6.1.4.1.14179.2.1.6.1.26
SNMP::Info::_validate_autoload_method(cd11_port) Unable to resolve method.
SNMP::Info::_load_attr cd11_rxpkt : AIRESPACE-WIRELESS-MIB::bsnMobileStationPacketsReceived : .1.3.6.1.4.1.14179.2.1.6.1.5
SNMP::Info::_load_attr cd11_txpkt : AIRESPACE-WIRELESS-MIB::bsnMobileStationPacketsSent : .1.3.6.1.4.1.14179.2.1.6.1.6
SNMP::Info::_load_attr cd11_rxbyte : AIRESPACE-WIRELESS-MIB::bsnMobileStationBytesReceived : .1.3.6.1.4.1.14179.2.1.6.1.2
SNMP::Info::_load_attr cd11_txbyte : AIRESPACE-WIRELESS-MIB::bsnMobileStationBytesSent : .1.3.6.1.4.1.14179.2.1.6.1.3
SNMP::Info::_load_attr cd11_ssid : AIRESPACE-WIRELESS-MIB::bsnMobileStationSsid : .1.3.6.1.4.1.14179.2.1.4.1.7
[1] 2021-03-11 09:09:46 debug [192.168.130.2] macsuck - processed 3 wireless nodes
[1] 2021-03-11 09:09:46 debug => running workers for phase: late
[1] 2021-03-11 09:09:46 debug -> run worker late/hooks/0
[1] 2021-03-11 09:09:46 debug [192.168.130.2] hooks - 0 queued
[1] 2021-03-11 09:09:46 info macsuck: finished at Thu Mar 11 09:09:46 2021
[1] 2021-03-11 09:09:46 info macsuck: status info: [192.168.130.2] macsuck - processed 3 wireless nodes
[root@monitoring netdisco]# snmpwalk -v2c -c public 192.168.130.2 .1.3.6.1.4.1.14179.2.1.4.1
SNMPv2-SMI::enterprises.14179.2.1.4.1.1.4.234.86.47.15.103 = Hex-STRING: 04 EA 56 2F 0F 67
SNMPv2-SMI::enterprises.14179.2.1.4.1.1.40.178.189.79.27.209 = Hex-STRING: 28 B2 BD 4F 1B D1
SNMPv2-SMI::enterprises.14179.2.1.4.1.1.116.229.11.166.224.224 = Hex-STRING: 74 E5 0B A6 E0 E0
SNMPv2-SMI::enterprises.14179.2.1.4.1.2.4.234.86.47.15.103 = IpAddress: 192.168.107.146
SNMPv2-SMI::enterprises.14179.2.1.4.1.2.40.178.189.79.27.209 = IpAddress: 0.0.0.0
SNMPv2-SMI::enterprises.14179.2.1.4.1.2.116.229.11.166.224.224 = IpAddress: 192.168.107.122
SNMPv2-SMI::enterprises.14179.2.1.4.1.3.4.234.86.47.15.103 = STRING: "host/hostname1"
SNMPv2-SMI::enterprises.14179.2.1.4.1.3.40.178.189.79.27.209 = STRING: "host/hostname2"
SNMPv2-SMI::enterprises.14179.2.1.4.1.3.116.229.11.166.224.224 = STRING: "host/hostname3"
SNMPv2-SMI::enterprises.14179.2.1.4.1.4.4.234.86.47.15.103 = Hex-STRING: 1C DE A7 4F 5A E0
SNMPv2-SMI::enterprises.14179.2.1.4.1.4.40.178.189.79.27.209 = Hex-STRING: 1C DE A7 CE D0 00
SNMPv2-SMI::enterprises.14179.2.1.4.1.4.116.229.11.166.224.224 = Hex-STRING: 1C DE A7 CE A0 C0
As one can see MAC addresses are like "AA BB CC DD EE FF". But Postgresql macaddr datatype is different. https://www.postgresql.org/docs/12/datatype-net-types.html
If received MAC address will be converted to "aa:bb:cc:dd:ee:ff" maybe problem will be fixed?
Hello,
I have the same problem here. Maybe this could help you to find the bug.
It works with the docker version "netdisco:2.044002-backend" but does not work since the version "netdisco:2.044015-backend".
I couldn't test the intermediate versions between 2.044002 and 2.044015 because they are not available on dockerhub anymore.
It works with the docker version "netdisco:2.044002-backend" but does not work since the version "netdisco:2.044015-backend".
ahha, this made me look at the changes and have another look at the actual error:
SNMP::Info::_validate_autoload_method(qb_fw_vlan) Unable to resolve method.
it seems that between those 2 netdisco version the snmp::info req was raised from 3.68 to 3.70, which removed bridge support. normally this is included when using snmp::info::layer2, but for some reason airespace doesn't. i've readded bridge support. a new snmp::info release should be coming in a few weeks, but you can always test the master branch from git.
It works with the docker version "netdisco:2.044002-backend" but does not work since the version "netdisco:2.044015-backend".
ahha, this made me look at the changes and have another look at the actual error:
SNMP::Info::_validate_autoload_method(qb_fw_vlan) Unable to resolve method.
it seems that between those 2 netdisco version the snmp::info req was raised from 3.68 to 3.70, which removed bridge support. normally this is included when using snmp::info::layer2, but for some reason airespace doesn't. i've readded bridge support. a new snmp::info release should be coming in a few weeks, but you can always test the master branch from git.
I can verify that the fix does work. I downloaded the new Airespace.pm from github and replaced the old one in my installation, and now macsuck work correctly.
I can verify that it does work. Just downloaded the new Airespace.pm from github and replaced the old one in my installation.
Thank you, this works.
With the newest docker build macsuck work again. But Netdisco do not populate Report -> Wireless with information. It do work for the aruba controller though.
I'll close this because the original problem (Cisco controller macsuck) is fixed. If there is another problem (@ntaken your issue with Aruba), we should have a new ticket.
Expected Behavior
Should be able to do a 'macsuck' on WLC, AIR-CT8540-K9. Discover and Arpnip works fine.
Current Behavior
Using Webinterface Job Queue just shows status: "Info"
Your Environment
Software Version App::Netdisco 2.44.15 SNMP::Info 3.70 DB Schema 61 PostgreSQL 10.00.12 Perl 5.26.1
I think this problem occured after upgrading netdisco in february. A couple a days ago i noticed that the WLC didnt had an up-to-date Macsuck entry. So I tried upgrading to the latest version but still same effect, no up-to-date macsuck.
Device information