Hi,
I have recently run into an odd issue that I am hoping someone can help with.
We have several autonomous Cisco APs working well with Packetfence. Recently
we added our first WLC which, initially, worked quite well. Now after moving
it to its permanent home, we are unable to access the guest ssid. Our internal
802.1x ssid continues to work well.
In the logs I see an attempt to update the location log with a null value for
column 'dot1x_username'. This occurs only for attempts to connect to the
WLC/guest network from an ipad and one of my two android devices. My second
android device is able to connect without issue. Is there some step of
configuration on the controller that we are overlooking that is causing PF to
think an open connection should have a dot1x username? Where can I look for
more clues as to what's happening?
Packetfence v4.1
WLC 2504 running 7.4.121.0
Routed network.
10.71.110.66 is a registration interface on my packetfence server.
May 06 15:10:05 pf::WebAPI(16010) INFO: handling radius autz request: from
switch_ip => 10.71.230.10, connection_type => Wireless-802.11-NoEAP mac =>
38:aa:3c:47:47:36, port => 1, username => 38aa3c474736 (pf::radius::authorize)
May 06 15:10:05 pf::WebAPI(16010) INFO: Connection type is WIRELESS_MAC_AUTH.
Getting role from node_info (pf::vlan::getNormalVlan)
May 06 15:10:05 pf::WebAPI(16010) INFO: Device is comming from a secure
connection and has been auto registered, we unreg it and forward it to the
portal (pf::vlan::getNormalVlan)
May 06 15:10:06 pf::WebAPI(16010) INFO: Username was defined '38aa3c474736' -
returning user based role 'registration' (pf::vlan::getNormalVlan)
May 06 15:10:06 pf::WebAPI(16010) INFO: MAC: 38:aa:3c:47:47:36, PID: briany,
Status: reg. Returned VLAN: 227 (pf::vlan::fetchVlanForNode)
May 06 15:10:07 pfdhcplistener(16111) INFO: DHCPOFFER from 10.71.110.66
(00:50:56:94:35:a9) to host 38:aa:3c:47:47:36 (10.71.227.110)
(main::parse_dhcp_offer)
May 06 15:10:07 pfdhcplistener(16111) INFO: DHCPREQUEST from 38:aa:3c:47:47:36
(10.71.227.110) (main::parse_dhcp_request)
May 06 15:10:07 pfdhcplistener(16111) INFO: could not resolve 10.71.227.110 to
mac in ARP table (pf::iplog::ip2macinarp)
May 06 15:10:07 pfdhcplistener(16111) WARN: could not resolve 10.71.227.110 to
mac (pf::iplog::ip2mac)
May 06 15:10:07 pfdhcplistener(16111) WARN: unable to resolve 38:aa:3c:47:47:36
to ip (pf::iplog::mac2ip)
May 06 15:10:07 pfdhcplistener(16111) WARN: unable to convert connection_type
to string. called from main pf::locationlog::locationlog_insert_closed
(pf::util::connection_type_to_str)
May 06 15:10:07 pfdhcplistener(16111) INFO: Asked to insert a locationlog entry
with connection type unknown. (pf::locationlog::locationlog_insert_closed)
May 06 15:10:07 pfdhcplistener(16111) WARN: database query failed with: Column
'dot1x_username' cannot be null. (errno: 1048), will try again
(pf::db::db_query_execute)
May 06 15:10:07 pfdhcplistener(16111) WARN: database query failed with: Column
'dot1x_username' cannot be null. (errno: 1048), will try again
(pf::db::db_query_execute)
May 06 15:10:07 pfdhcplistener(16111) WARN: database query failed with: Column
'dot1x_username' cannot be null. (errno: 1048), will try again
(pf::db::db_query_execute)
May 06 15:10:07 pfdhcplistener(16111) ERROR: Database issue: We tried 3 times
to serve query locationlog_insert_closed_sql called from
pf::locationlog::locationlog_insert_closed and we failed. Is the database
running? (pf::db::db_query_execute)
May 06 15:10:07 pfdhcplistener(16111) INFO: 38:aa:3c:47:47:36 requested an IP.
DHCP Fingerprint: OS::1111 (Generic Android). Modified node with last_dhcp =
2014-05-06 15:10:07,computername = android-b6512e9b0f26dcdd,dhcp_fingerprint =
1,33,3,6,15,28,51,58,59 (main::listen_dhcp)
--
Brian Youngstrom [email protected]
Allen Institute for Brain Science 206-548-7044
http://alleninstitute.org http://www.brain-map.org
------------------------------------------------------------------------------
Is your legacy SCM system holding you back? Join Perforce May 7 to find out:
• 3 signs your SCM is hindering your productivity
• Requirements for releasing software faster
• Expert tips and advice for migrating your SCM now
http://p.sf.net/sfu/perforce
_______________________________________________
PacketFence-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/packetfence-users
