netdisco-users Digest, Vol 162, Issue 20

Thu, 30 Jan 2020 04:54:44 -0800 

Send netdisco-users mailing list submissions to
        [email protected]

To subscribe or unsubscribe via the World Wide Web, visit
        https://lists.sourceforge.net/lists/listinfo/netdisco-users
or, via email, send a message with subject or body 'help' to
        [email protected]

You can reach the person managing the list at
        [email protected]

When replying, please edit your Subject line so it is more specific
than "Re: Contents of netdisco-users digest..."

Today's Topics:

   1. Cisco / AIR-CT2504-K9 - mac addresses binary? (V?clav Ovs?k)
--- Begin Message --- 
Hi everybody,
thanks for great Netdisco at the first place! :-)

I have a little trouble to gather MACs from Cisco WLC controllers.
I can't do macsuck, see the first 30 lines (attached file) of 

 netdisco-do macsuck -D 255 -d wlc1.net.i.cz

It seems to me, that SNMP table is indexed by client MAC address in
binary form. When I tried to dump a few records...

 netdisco@netdisco:~$ snmpwalk  -m CISCO-LWAPP-DOT11-CLIENT-MIB  -v2c 
-cicz-ro-new -Cc wlc1.net.i.cz 
CISCO-LWAPP-DOT11-CLIENT-MIB::cldcClientSessionID|head -n 5
 CISCO-LWAPP-DOT11-CLIENT-MIB::cldcClientSessionID.'.!j.P.' = STRING: 
5e313af4/00:21:6a:fd:50:bb/427620
 CISCO-LWAPP-DOT11-CLIENT-MIB::cldcClientSessionID.'.#h...' = STRING: 
5e3193d3/00:23:68:c0:eb:bc/430062
 CISCO-LWAPP-DOT11-CLIENT-MIB::cldcClientSessionID.'.$...H' = STRING: 
5e313a56/00:24:d7:97:b1:48/427592
 CISCO-LWAPP-DOT11-CLIENT-MIB::cldcClientSessionID.'.$....' = STRING: 
5e313655/00:24:d7:f3:8d:14/427434
 CISCO-LWAPP-DOT11-CLIENT-MIB::cldcClientSessionID.'.%K..J' = STRING: 
5e306062/00:25:4b:85:a7:4a/425767

I assume, the client MAC address is the middle part of ClientSessionID,
as ASCII codes of letters of SNMP index correspond to middle part of
the value. So maybe the Netdisco assumes the MAC address are textual,
but they are binary?

Best Regards
-- 
Zito

[15115] 2020-01-29 14:14:23  info App::Netdisco version 2.044011 loaded.
[15115] 2020-01-29 14:14:24  info macsuck: [10.0.160.184] started at Wed Jan 29 
15:14:24 2020
[15115] 2020-01-29 14:14:24 debug macsuck: running with timeout 600s
[15115] 2020-01-29 14:14:24 debug => running workers for phase: check
[15115] 2020-01-29 14:14:24 debug -> run worker check/_base_/0
[15115] 2020-01-29 14:14:24 debug Macsuck is able to run.
[15115] 2020-01-29 14:14:24 debug => running workers for phase: main
[15115] 2020-01-29 14:14:24 debug -> run worker main/nodes/100
[15115] 2020-01-29 14:14:24 debug snmp reader cache warm: [10.0.160.184]
[15115] 2020-01-29 14:14:24 debug [10.0.160.184:161] try_connect with ver: 2, 
class: SNMP::Info::Layer2::Airespace, comm: <hidden>
[15115] 2020-01-29 14:14:24 debug -> DBIx::Class::Storage::DBI::_dbh_execute(): 
DBI Exception: DBD::Pg::st execute failed: ERROR:  malformed array literal: 
"{"è“       
Œé","e¶¡å","«ÅB§Ž","xOCñ”","lÇìE?¢","xø³4/","X溃å+","tµ‡u!","Ì/qjúE","De
ºÊi","$we.°","@°vè]","¤PFT™u","˜èÝõæ","|*1$(š","4A]IòÈ","<ðpÁ","(ðvl","¤éu%:¥","ÌÖBٖ","HPsdÌ°","ˆ±?wq","ø•ê:‚Ü","”°Žû€","¨f^Q","ðտӛÂ","±gMi","¨œíMß»","!•cÌø","l·I4œ)","|«à#ó","
 ×•>k","ä+4E؞","`ƒsP¿È","\\àÅTXN","àÜÿ'—þ","8xbêÑb","$w60”","€Np˜¾","Ø
šq2\"","ðä#x¬","µ=Gä","<ÂÔhô","ˆ±{7è","µ}O.","˜;‘IÙ","ðתÕ//","è6ƌ","ˆu˜KÕþ","h
 >•{c","䧠ó­","X*÷…
›í","xOCgÀã","¨4ju","tB‹Ðé=","|‰VÜô","ðÕ¿5C¯","„U¥vƒÃ","ˆ­Òƒ","p(‹6Ìk","dÇSC7Š","|‰VèM","H`_ƒÝâ","€5ÁzNm","@£Ìâ"
DETAIL:  Unexpected end of input. [for Statement "SELECT me.mac, me.ip FROM (  
SELECT dp.ip, dp.mac

  FROM
    (SELECT ip, mac FROM device
      UNION
    SELECT ip, mac FROM device_port) dp

  INNER JOIN
    (SELECT unnest( ? ::macaddr[] )) locals(m)
    ON (dp.mac = locals.m ::macaddr)

) me GROUP BY mac, ip" with ParamValues: 1='{"èÂ.      
Œ.é",".eÂ.¶¡å",".«Ã.B§Â.","xOCÂ.ñÂ.","lÃ.ìE?¢","x.ø³4/","XæºÂ.Ã¥+","tµÂ..u!","Ì/qjúE","De
ºÊi","$w.e.°","@°vÂ.è]","¤PFTÂ.u","Â..èÃ.õæ","|*1$(Â.","4A]IòÃ.","<ð.pÃ..","(ðv..l","¤éu%:Â¥",".ÌÃ.BÃ.Â.","HPsdÌ°","Â.±.?wq","øÂ.ê:Â.Ã.","Â.°.Â.ûÂ.","¨f..^Q","ðÃ.¿Ã.Â.Ã.",".±g.Mi","¨Â.íMÃ.»",".!Â.cÌø","l·I4Â.)","|.«Ã
 #ó"," Ã.Â.>.k","ä+4EÃ.Â.","`Â.sP¿Ã.","\\àÃ.TXN","à
Ã.ÿ'Â.þ","8xbêÃ.b","$w.60Â.","Â.NpÂ.Â.¾","Ã.
Â.q2\"",".ðä#x¬","..µ=Gä","<.Ã.Ã.hô","Â.±.{7è","..µ}O.","Â.;Â.Â.IÃ.","ðÃ.ªÃ.//","è6..Ã.Œ","Â.uÂ.KÃ.þ","hÂ
 >Â.{c","䧠
ó.­","X*÷Â.Â.í","xOCgÃ.ã","¨4j.u.","tB‹Ã.é=","|‰VÃ..ô","ðÃ.¿5C¯","Â.UÂ¥vÂ.Ã.","Â.­Ã.Â...","p(‹6Ìk","dÃ.SC7Š","|‰VèM.","H`_Â.Ã.â","Â.5Ã.zNm","@£Ìâ']
 at /home/netdisco/perl5/lib/perl5/App/Netdisco/Util/PortMAC.pm line 42
[15115] 2020-01-29 14:14:24 debug bless( {'msg' => 
"DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::Pg::st execute 
failed: ERROR:  malformed array literal: \"{\"\x{e8}\x{93}    
\x{8c}\x{e9}\",\"e\x{90}\x{b6}\x{a1}\x{e5}\",\"\x{ab}\x{c5}B\x{a7}\x{8e}\",\"xOC\x{90}\x{f1}\x{94}\",\"l\x{c7}\x{ec}E?\x{a2}\",\"x\x{f8}\x{b3}4/\",\"X\x{e6}\x{ba}\x{83}\x{e5}+\",\"t\x{b5}\x{87}u!\",\"\x{cc}/qj\x{fa}E\",\"De
\x{ba}\x{ca}i\",\"\$we.\x{b0}\",\"\@\x{b0}v\x{8f}\x{e8}]\",\"\x{a4}PFT\x{99}u\",\"\x{98}\x{e8}\x{dd}\x{f5}\x{e6}\",\"|*1\$(\x{9a}\",\"4A]I\x{f2}\x{c8}\",\"<\x{f0}p\x{c1}\",\"(\x{f0}vl\",\"\x{a4}\x{e9}u%:\x{a5}\",\"\x{cc}\x{d6}B\x{d9}\x{96}\",\"HPsd\x{cc}\x{b0}\",\"\x{88}\x{b1}?wq\",\"\x{f8}\x{95}\x{ea}:\x{82}\x{dc}\",\"\x{94}\x{b0}\x{8e}\x{fb}\x{80}\",\"\x{a8}f^Q\",\"\x{f0}\x{d5}\x{bf}\x{d3}\x{9b}\x{c2}\",\"\x{b1}gMi\",\"\x{a8}\x{9c}\x{ed}M\x{df}\x{bb}\",\"!\x{95}c\x{cc}\x{f8}\",\"l\x{b7}I4\x{9c})\",\"|\x{ab}\x{e0}#\x{f3}\",\"\x{a0}\x{d7}\x{95}>k\",\"\x{e4}+4E\x{d8}\x{9e}\",\"`\x{83}sP\x{bf}\x{c8}\",\"\\\\\x{e0}\x{c5}TXN\",\"\x{e0}\x{dc}\x{ff}'\x{97}\x{fe}\",\"8xb\x{ea}\x{d1}b\",\"\$w60\x{94}\",\"\x{80}Np\x{81}\x{98}\x{be}\",\"\x{d8}

\x{9a}q2\\\"\",\"\x{f0}\x{e4}#x\x{ac}\",\"\x{b5}=G\x{e4}\",\"<\x{c2}\x{d4}h\x{f4}\",\"\x{88}\x{b1}{7\x{e8}\",\"\x{b5}}O.\",\"\x{98};\x{8f}\x{91}I\x{d9}\",\"\x{f0}\x{d7}\x{aa}\x{d5}//\",\"\x{e8}6\x{c6}\x{8c}\",\"\x{88}u\x{98}K\x{d5}\x{fe}\",\"h\x{a0}>\x{95}{c\",\"\x{e4}\x{a7}\x{a0}\x{f3}\x{ad}\",\"X*\x{f7}\x{85}\x{9b}\x{ed}\",\"xOCg\x{c0}\x{e3}\",\"\x{a8}4ju\",\"tB\x{8b}\x{d0}\x{e9}=\",\"|\x{89}V\x{dc}\x{f4}\",\"\x{f0}\x{d5}\x{bf}5C\x{af}\",\"\x{84}U\x{a5}v\x{83}\x{c3}\",\"\x{88}\x{ad}\x{d2}\x{83}\",\"p(\x{8b}6\x{cc}k\",\"d\x{c7}SC7\x{8a}\",\"|\x{89}V\x{e8}M\",\"H`_\x{83}\x{dd}\x{e2}\",\"\x{80}5\x{c1}zNm\",\"\@\x{a3}\x{cc}\x{e2}\"
DETAIL:  Unexpected end of input. [for Statement \"SELECT me.mac, me.ip FROM (  
SELECT dp.ip, dp.mac

  FROM
    (SELECT ip, mac FROM device
      UNION
    SELECT ip, mac FROM device_port) dp

--- End Message ---
_______________________________________________
Netdisco mailing list - Digest Mode
[email protected]
https://lists.sourceforge.net/lists/listinfo/netdisco-users














    











					Reply via email to