Ok.<br>I made that wiht Cleartex-Password and it serves too:<br><br>rad_recv: Access-Request packet from host 127.0.0.1 port 32793, id=55, length=212<br> Vendor-14559-Attr-8 = 0x312e302e3132<br> User-Name = "juanpal"<br>
User-Password = "juanpal"<br> NAS-IP-Address = 192.168.181.1<br> Service-Type = Login-User<br> Framed-IP-Address = 192.168.181.3<br> Calling-Station-Id = "08-00-27-D6-27-3B"<br>
Called-Station-Id = "08-00-27-C0-08-85"<br> NAS-Identifier = "nas01"<br> Acct-Session-Id = "499ee06c00000001"<br> NAS-Port-Type = Wireless-802.11<br> NAS-Port = 1<br>
WISPr-Logoff-URL = "<a href="http://192.168.181.1:3990/logoff">http://192.168.181.1:3990/logoff</a>"<br> Message-Authenticator = 0x16771e0e536870155a6ea764daae4c34<br>+- entering group authorize<br>
++[preprocess] returns ok<br> expand: /var/log/freeradius/radacct/%{Client-IP-Address}/auth-detail-%Y%m%d -> /var/log/freeradius/radacct/<a href="http://127.0.0.1/auth-detail-20090220">127.0.0.1/auth-detail-20090220</a><br>
rlm_detail: /var/log/freeradius/radacct/%{Client-IP-Address}/auth-detail-%Y%m%d expands to /var/log/freeradius/radacct/<a href="http://127.0.0.1/auth-detail-20090220">127.0.0.1/auth-detail-20090220</a><br> expand: %t -> Fri Feb 20 11:55:31 2009<br>
++[auth_log] returns ok<br> expand: %{Realm} -><br>++[attr_filter] returns noop<br>++[chap] returns noop<br>++[mschap] returns noop<br> rlm_realm: No '@' in User-Name = "juanpal", looking up realm NULL<br>
rlm_realm: No such realm "NULL"<br>++[suffix] returns noop<br> rlm_eap: No EAP-Message, not doing EAP<br>++[eap] returns noop<br>++[files] returns noop<br> expand: %{User-Name} -> juanpal<br>rlm_sql (sql): sql_set_user escaped user --> 'juanpal'<br>
rlm_sql (sql): Reserving sql socket id: 3<br> 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 = 'juanpal' ORDER BY id<br>
rlm_sql (sql): User found in radcheck table<br> expand: SELECT id, UserName, Attribute, Value, op FROM radreply WHERE Username = '%{SQL-User-Name}' ORDER BY id -> SELECT id, UserName, Attribute, Value, op FROM radreply WHERE Username = 'juanpal' ORDER BY id<br>
expand: SELECT GroupName FROM usergroup WHERE UserName='%{SQL-User-Name}' -> SELECT GroupName FROM usergroup WHERE UserName='juanpal'<br>rlm_sql (sql): Released sql socket id: 3<br>++[sql] returns ok<br>
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!<br>!!! Replacing User-Password in config items with Cleartext-Password. !!!<br>!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!<br>
!!! Please update your configuration so that the "known good" !!!<br>!!! clear text password is in Cleartext-Password, and not in User-Password. !!!<br>!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!<br>
auth: type Local<br>auth: user supplied User-Password matches local User-Password<br>Login OK: [juanpal/juanpal] (from client localhost port 1 cli 08-00-27-D6-27-3B)<br>+- entering group post-auth<br> expand: /var/log/freeradius/radacct/%{Client-IP-Address}/reply-detail-%Y%m%d -> /var/log/freeradius/radacct/<a href="http://127.0.0.1/reply-detail-20090220">127.0.0.1/reply-detail-20090220</a><br>
rlm_detail: /var/log/freeradius/radacct/%{Client-IP-Address}/reply-detail-%Y%m%d expands to /var/log/freeradius/radacct/<a href="http://127.0.0.1/reply-detail-20090220">127.0.0.1/reply-detail-20090220</a><br> expand: %t -> Fri Feb 20 11:55:31 2009<br>
++[reply_log] returns ok<br>rlm_sql (sql): Processing sql_postauth<br> expand: %{User-Name} -> juanpal<br>rlm_sql (sql): sql_set_user escaped user --> 'juanpal'<br>WARNING: Deprecated conditional expansion ":-". See "man unlang" for details<br>
expand: INSERT into radpostauth (id, user, pass, reply, date) values ('', '%{User-Name}', '%{User-Password:-Chap-Password}', '%{reply:Packet-Type}', NOW()) -> INSERT into radpostauth (id, user, pass, reply, date) values ('', 'juanpal', 'juanpal', 'Access-Accept', NOW())<br>
rlm_sql (sql) in sql_postauth: query is INSERT into radpostauth (id, user, pass, reply, date) values ('', 'juanpal', 'juanpal', 'Access-Accept', NOW())<br>rlm_sql (sql): Reserving sql socket id: 2<br>
rlm_sql (sql): Released sql socket id: 2<br>++[sql] returns ok<br>Sending Access-Accept of id 55 to 127.0.0.1 port 32793<br>Finished request 4.<br>Going to the next request<br>Waking up in 4.9 seconds.<br>rad_recv: Accounting-Request packet from host 127.0.0.1 port 3779, id=4, length=146<br>
Vendor-14559-Attr-8 = 0x312e302e3132<br> Acct-Status-Type = Start<br> User-Name = "juanpal"<br> Calling-Station-Id = "08-00-27-D6-27-3B"<br> NAS-Port-Type = Wireless-802.11<br>
NAS-Port = 1<br> NAS-Port-Id = "00000001"<br> Framed-IP-Address = 192.168.181.3<br> Acct-Session-Id = "499ee06c00000001"<br> NAS-IP-Address = 192.168.181.1<br> Called-Station-Id = "08-00-27-C0-08-85"<br>
NAS-Identifier = "nas01"<br>+- entering group preacct<br>++[preprocess] returns ok<br>rlm_acct_unique: Hashing 'NAS-Port = 1,Client-IP-Address = 127.0.0.1,NAS-IP-Address = 192.168.181.1,Acct-Session-Id = "499ee06c00000001",User-Name = "juanpal"'<br>
rlm_acct_unique: Acct-Unique-Session-ID = "d2c306121c0bde41".<br>++[acct_unique] returns ok<br> rlm_realm: No '@' in User-Name = "juanpal", looking up realm NULL<br> rlm_realm: No such realm "NULL"<br>
++[suffix] returns noop<br>++[files] returns noop<br>+- entering group accounting<br> expand: /var/log/freeradius/radacct/%{Client-IP-Address}/detail-%Y%m%d -> /var/log/freeradius/radacct/<a href="http://127.0.0.1/detail-20090220">127.0.0.1/detail-20090220</a><br>
rlm_detail: /var/log/freeradius/radacct/%{Client-IP-Address}/detail-%Y%m%d expands to /var/log/freeradius/radacct/<a href="http://127.0.0.1/detail-20090220">127.0.0.1/detail-20090220</a><br> expand: %t -> Fri Feb 20 11:55:31 2009<br>
++[detail] returns ok<br> expand: /var/log/freeradius/radutmp -> /var/log/freeradius/radutmp<br> expand: %{User-Name} -> juanpal<br>++[radutmp] returns ok<br> expand: %{User-Name} -> juanpal<br>
rlm_sql (sql): sql_set_user escaped user --> 'juanpal'<br> expand: INSERT into radacct (AcctSessionId, AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType, AcctStartTime, AcctStopTime, AcctSessionTime, AcctAuthentic, ConnectInfo_start, ConnectInfo_stop, AcctInputOctets, AcctOutputOctets, CalledStationId, CallingStationId, AcctTerminateCause, ServiceType, FramedProtocol, FramedIPAddress, AcctStartDelay, AcctStopDelay) values('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}', '%{NAS-Port-Type}', '%S', '0', '0', '%{Acct-Authentic}', '%{Connect-Info}', '', '0', '0', '%{Called-Station-Id}', '%{Calling-Station-Id}', '', '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}', '%{Acct-Delay-Time}', '0') -> INSERT into radacct (AcctSessionId, AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType, AcctStartTime, AcctStopTime, AcctSessionTime, AcctAuthentic, ConnectInfo_start, ConnectInfo_stop, AcctInputOctets, AcctOutputOctets, CalledStationId, CallingStationId, AcctTerminateCause, ServiceType, FramedProtocol, FramedIPAddress, AcctStartDelay, AcctStopDelay) values('499ee06c00000001', 'd2c306121c0bde41', 'juanpal', '', '192.168.181.1', '1', 'Wireless-802.11', '2009-02-20 11:55:31', '0', '0', '', '', '', '0', '0', '08-00-27-C0-08-85', '08-00-27-D6-27-3B', '', '', '', '192.168.181.3', '', '0')<br>
rlm_sql (sql): Reserving sql socket id: 1<br>rlm_sql (sql): Released sql socket id: 1<br>++[sql] returns ok<br>Sending Accounting-Response of id 4 to 127.0.0.1 port 3779<br>Finished request 5.<br>Cleaning up request 5 ID 4 with timestamp +171<br>
Going to the next request<br>Waking up in 4.7 seconds.<br>Cleaning up request 4 ID 55 with timestamp +171<br>Ready to process requests.<br><br>Thanks a Lot<br><br><br><div class="gmail_quote">On Fri, Feb 20, 2009 at 12:49 PM, <span dir="ltr"><<a href="mailto:tnt@kalik.net">tnt@kalik.net</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div class="Ih2E3d">>I change the password user from md5 to User-Password and can login.<br>
><br>
>I don't know if that was the suggestion, but thanks a lot<br>
><br>
>><br>
</div><div class="Ih2E3d">>> Try with Cleartext-Password first. And use := not == as operator.<br>
>><br>
<br>
</div>No. I ment what I wrote. User-Password shouldn't be used. Use<br>
Cleartext-Password.<br>
<div><div></div><div class="Wj3C7c"><br>
Ivan Kalik<br>
Kalik Informatika ISP<br>
<br>
-<br>
List info/subscribe/unsubscribe? See <a href="http://www.freeradius.org/list/users.html" target="_blank">http://www.freeradius.org/list/users.html</a><br>
</div></div></blockquote></div><br><br clear="all"><br>-- <br>Juan Pablo Botero<br>Administrador de Sistemas informáticos<br><a href="http://jpill.wordpress.com">http://jpill.wordpress.com</a><br>eSSuX: <a href="http://slcolombia.org/eSSuX">http://slcolombia.org/eSSuX</a><br>
Linux Registered user #435293<br>