<div>I will be glad, if anyone can direct me to whare The log below is the part of the debug for the new test freeradius server 2.1.6 am testing with.</div><div><br></div><div>However, the hotspotlogin,cgi is able to pass the param username to the radius but when the query is run against the database the "Tue Jun 9 14:59:48 2009 : Info: [sql] expand: %{User-Name} -> 0x32333435363738393031" the value of the username sent is changed.</div>
<div><br></div><div>I have disabled the chap in the /usr/local/etc/raddb/sites-enabled/default.</div><div><br></div><div>kindly advise on what to do.</div><div><br></div><div>################### my radcheck has the info below.</div>
<div><br></div><div><div>mysql> select * from radcheck;</div><div>+-----+------------+--------------------+----+------------+</div><div>| id | username | attribute | op | value |</div><div>+-----+------------+--------------------+----+------------+</div>
<div>| 5 | 2345678901 | Auth-Type | := | Accept |</div><div>| 201 | 1234567890 | Cleartext-Password | := | 1234567890 |</div><div>+-----+------------+--------------------+----+------------+</div><div>4 rows in set (0.00 sec)</div>
<div><br></div><div><br></div><div>######################radiusd -XX (part of the debug)</div></div><div><br></div><div><div>rad_recv: Access-Request packet from host 127.0.0.1 port 44600, id=0, length=189</div><div> ChilliSpot-Max-Input-Octets = 0x32333435363738393031</div>
<div> ChilliSpot-Max-Output-Octets = 0</div><div> NAS-IP-Address = 127.0.0.1</div><div> Service-Type = Login-User</div><div> Framed-IP-Address = 192.168.182.2</div><div> Calling-Station-Id = "00-1F-29-80-62-F3"</div>
<div> Called-Station-Id = "00-50-DA-0C-C9-B0"</div><div> NAS-Identifier = "nas01"</div><div> Acct-Session-Id = "4a2e6a7700000000"</div><div> NAS-Port-Type = Wireless-802.11</div>
<div> NAS-Port = 0</div><div> Message-Authenticator = 0xf2ee6add34820fb96dcceef08c07bbc5</div><div> WISPr-Logoff-URL = "<a href="http://192.168.182.1:3990/logoff">http://192.168.182.1:3990/logoff</a>"</div>
<div>Tue Jun 9 14:59:48 2009 : Info: +- entering group authorize {...}</div><div>Tue Jun 9 14:59:48 2009 : Info: ++[preprocess] returns ok</div><div>Tue Jun 9 14:59:48 2009 : Info: ++[mschap] returns noop</div><div>Tue Jun 9 14:59:48 2009 : Info: [suffix] No '@' in User-Name = "2345678901", looking up realm NULL</div>
<div>Tue Jun 9 14:59:48 2009 : Info: [suffix] No such realm "NULL"</div><div>Tue Jun 9 14:59:48 2009 : Info: ++[suffix] returns noop</div><div>Tue Jun 9 14:59:48 2009 : Info: [eap] No EAP-Message, not doing EAP</div>
<div>Tue Jun 9 14:59:48 2009 : Info: ++[eap] returns noop</div><div>Tue Jun 9 14:59:48 2009 : Info: ++[unix] returns notfound</div><div>Tue Jun 9 14:59:48 2009 : Info: ++[files] returns noop</div><div>Tue Jun 9 14:59:48 2009 : Info: [sql] expand: %{User-Name} -> 0x32333435363738393031</div>
<div>Tue Jun 9 14:59:48 2009 : Info: [sql] sql_set_user escaped user --> '0x32333435363738393031'</div><div>Tue Jun 9 14:59:48 2009 : Debug: rlm_sql (sql): Reserving sql socket id: 4</div><div>Tue Jun 9 14:59:48 2009 : Info: [sql] expand: SELECT id, username, attribute, value, op FROM radcheck WHERE username = '%{SQL-User-Name}' ORDER BY id -> SELECT id, username, attribute, value, op FROM radcheck WHERE username = '0x32333435363738393031' ORDER BY id</div>
<div>Tue Jun 9 14:59:48 2009 : Info: [sql] expand: SELECT groupname FROM radusergroup WHERE username = '%{SQL-User-Name}' ORDER BY priority -> SELECT groupname FROM radusergroup WHERE username = '0x32333435363738393031' ORDER BY priority</div>
<div>Tue Jun 9 14:59:48 2009 : Debug: rlm_sql (sql): Released sql socket id: 4</div><div>Tue Jun 9 14:59:48 2009 : Info: [sql] User 0x32333435363738393031 not found</div><div>Tue Jun 9 14:59:48 2009 : Info: ++[sql] returns notfound</div>
<div>Tue Jun 9 14:59:48 2009 : Info: ++[expiration] returns noop</div><div>Tue Jun 9 14:59:48 2009 : Info: ++[logintime] returns noop</div><div>Tue Jun 9 14:59:48 2009 : Info: [pap] WARNING! No "known good" password found for the user. Authentication may fail because of this.</div>
<div>Tue Jun 9 14:59:48 2009 : Info: ++[pap] returns noop</div><div>Tue Jun 9 14:59:48 2009 : Debug: rlm_sqlcounter: Entering module authorize code</div><div>Tue Jun 9 14:59:48 2009 : Debug: rlm_sqlcounter: Could not find Check item value pair</div>
<div>Tue Jun 9 14:59:48 2009 : Info: ++[validity] returns noop</div><div>Tue Jun 9 14:59:48 2009 : Debug: rlm_sqlcounter: Entering module authorize code</div><div>Tue Jun 9 14:59:48 2009 : Debug: rlm_sqlcounter: Could not find Check item value pair</div>
<div>Tue Jun 9 14:59:48 2009 : Info: ++[noresetcounter] returns noop</div><div>Tue Jun 9 14:59:48 2009 : Debug: rlm_sqlcounter: Entering module authorize code</div><div>Tue Jun 9 14:59:48 2009 : Debug: rlm_sqlcounter: Could not find Check item value pair</div>
<div>Tue Jun 9 14:59:48 2009 : Info: ++[hotspotcontrol] returns noop</div><div>Tue Jun 9 14:59:48 2009 : Info: No authenticate method (Auth-Type) configuration found for the request: Rejecting the user</div><div>Tue Jun 9 14:59:48 2009 : Info: Failed to authenticate the user.</div>
<div>Tue Jun 9 14:59:48 2009 : Info: Using Post-Auth-Type Reject</div><div>Tue Jun 9 14:59:48 2009 : Info: +- entering group REJECT {...}</div><div>Tue Jun 9 14:59:48 2009 : Info: [attr_filter.access_reject] expand: %{User-Name} -> 0x32333435363738393031</div>
<div>Tue Jun 9 14:59:48 2009 : Debug: attr_filter: Matched entry DEFAULT at line 11</div><div>Tue Jun 9 14:59:48 2009 : Info: ++[attr_filter.access_reject] returns updated</div><div>Tue Jun 9 14:59:48 2009 : Info: Delaying reject of request 0 for 1 seconds</div>
<div>Tue Jun 9 14:59:48 2009 : Debug: Going to the next request</div><div>Tue Jun 9 14:59:48 2009 : Debug: Waking up in 0.9 seconds.</div><div>Tue Jun 9 14:59:49 2009 : Info: Sending delayed reject for request 0</div><div>
Sending Access-Reject of id 0 to 127.0.0.1 port 44600</div><div>Tue Jun 9 14:59:49 2009 : Debug: Waking up in 4.9 seconds.</div><div>Tue Jun 9 14:59:54 2009 : Info: Cleaning up request 0 ID 0 with timestamp +187</div><div>
Tue Jun 9 14:59:54 2009 : Debug: Ready to process requests.</div><div><br></div></div>