Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Problem with macsuck on AIR-CT8540-K9 #708

Closed
danielblomqvist opened this issue Mar 20, 2020 · 19 comments
Closed

Problem with macsuck on AIR-CT8540-K9 #708

danielblomqvist opened this issue Mar 20, 2020 · 19 comments

Comments

@danielblomqvist
Copy link

danielblomqvist commented Mar 20, 2020

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

netdisco@ipmgmt:~$ netdisco-do show -d 10.11.19.10 -e specify -DI
[24271] 2020-03-20 13:43:51  info App::Netdisco version 2.044015 loaded.
[24271] 2020-03-20 13:43:51  info show: [10.11.19.10]/specify started at Fri Mar 20 14:43:51 2020
[24271] 2020-03-20 13:43:51 debug show: running with timeout 600s
[24271] 2020-03-20 13:43:51 debug => running workers for phase: check
[24271] 2020-03-20 13:43:51 debug -> run worker check/_base_/0
[24271] 2020-03-20 13:43:51 debug Show is able to run
[24271] 2020-03-20 13:43:51 debug => running workers for phase: main
[24271] 2020-03-20 13:43:51 debug -> run worker main/_base_/100
[24271] 2020-03-20 13:43:51 debug snmp reader cache warm: [10.11.19.10]
[24271] 2020-03-20 13:43:51 debug [10.11.19.10: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.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                {
            AutoSpecify         0,
            BulkRepeaters       20,
            BulkWalk            1,
            Community           "****",
            Debug               1,
            DebugSNMP           0,
            DestHost            "10.11.19.10",
            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       0,
            RemotePort          161,
            Retries             0,
            Session             SNMP::Session,
            Timeout             3000000,
            Version             2
        },
        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           "*****",
        snmp_user           "initial",
        snmp_ver            2,
        store               {}
    }
}
netdisco@ipmgmt:~$ ~/bin/netdisco-do macsuck -d 10.11.19.10 -DI
[14472] 2020-03-20 21:42:24  info App::Netdisco version 2.044015 loaded.
[14472] 2020-03-20 21:42:24  info macsuck: [10.11.19.10] started at Fri Mar 20 22:42:24 2020
[14472] 2020-03-20 21:42:24 debug macsuck: running with timeout 600s
[14472] 2020-03-20 21:42:24 debug => running workers for phase: check
[14472] 2020-03-20 21:42:24 debug -> run worker check/_base_/0
[14472] 2020-03-20 21:42:24 debug Macsuck is able to run.
[14472] 2020-03-20 21:42:24 debug => running workers for phase: main
[14472] 2020-03-20 21:42:24 debug -> run worker main/nodes/100
[14472] 2020-03-20 21:42:24 debug snmp reader cache warm: [10.11.19.10]
[14472] 2020-03-20 21:42:24 debug [10.11.19.10: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.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
SNMP::Info::_validate_autoload_method(qb_fw_vlan) Unable to resolve method.
[14472] 2020-03-20 21:42:31 debug -> DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::Pg::st execute failed: ERROR:  malformed array literal: "{"ÜÇ�3¹                         "
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='{"Ã.Ã.Â.3¹', 2='{"Ã.Ã.Â.3¹'] at /home/netdisco/perl5/lib/perl5/App/Netdisco/Util/PortMAC.pm line 42
[14472] 2020-03-20 21:42:31 debug bless( {'msg' => "DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::Pg::st execute failed: ERROR:  malformed array li                         teral: \"{\"\x{dc}\x{c7}\x{93}3\x{b9}\"
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{c3}.\x{c2}.3\x{c2}\x{b9}', 2='{\"\x{c3}.\x{c3}.\x{c2}.3\x{c2}\x{b9}'] at /home/netdisco/perl5/lib/perl5/Ap                         p/Netdisco/Util/PortMAC.pm line 42
"}, 'DBIx::Class::Exception' )
[14472] 2020-03-20 21:42:31 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
[14472] 2020-03-20 21:42:43 debug  [10.11.19.10] macsuck - processed 2884 wireless nodes
[14472] 2020-03-20 21:42:43  info macsuck: finished at Fri Mar 20 22:42:43 2020
[14472] 2020-03-20 21:42:43  info macsuck: status info:  [10.11.19.10] macsuck - processed 2884 wireless nodes
@rc9000
Copy link
Member

rc9000 commented Mar 31, 2020

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.

@Disco402
Copy link

Disco402 commented Apr 8, 2020

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```

@Disco402
Copy link

Any output I can provide on this to help?

@danielblomqvist
Copy link
Author

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

@Hedgehog57
Copy link

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

@inphobia
Copy link
Member

inphobia commented Aug 9, 2020

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=

@Disco402
Copy link

@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=

@danielblomqvist
Copy link
Author

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?

@danielblomqvist
Copy link
Author

@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

@rc9000
Copy link
Member

rc9000 commented Sep 29, 2020

@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
Copy link
Author

danielblomqvist commented Jan 4, 2021

@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?

@ntaken
Copy link

ntaken commented Feb 3, 2021

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

@Hedgehog57
Copy link

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?

@fendo64
Copy link

fendo64 commented Jun 16, 2021

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.

@inphobia
Copy link
Member

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.

@danielblomqvist
Copy link
Author

danielblomqvist commented Jun 21, 2021

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.

@fendo64
Copy link

fendo64 commented Jun 21, 2021

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.

@ntaken
Copy link

ntaken commented Sep 13, 2021

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.

@ollyg
Copy link
Member

ollyg commented Oct 4, 2021

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.

@ollyg ollyg closed this as completed Oct 4, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

8 participants