chilli + freeradius + mysql : Password check failed

Mon Nov 30 10:36:14 CET 2009

   Hi all,

  Forgive me for not answering but weekends I do not work J

>tnt at kalik.net>Is it well written oon the login page? Try simpler password (something>like 12345 - that will work even with CAPS LOCK on). If it still fails>take it up with chillispot people.

I have tried with 1234 :

--------------------------------- INICIO ---------------------------------------------------

Mon Nov 30 10:45:56 2009 : Debug: rlm_sql (sql): Released sql socket id: 4
Mon Nov 30 10:45:56 2009 : Info: ++[sql] returns ok
Mon Nov 30 10:45:56 2009 : Info: ++[expiration] returns noop
Mon Nov 30 10:45:56 2009 : Info: ++[logintime] returns noop
Mon Nov 30 10:45:56 2009 : Info: [pap] Found existing Auth-Type, not changing it.
Mon Nov 30 10:45:56 2009 : Info: ++[pap] returns noop
Mon Nov 30 10:45:56 2009 : Debug: rlm_sqlcounter: Entering module authorize code
Mon Nov 30 10:45:56 2009 : Debug: sqlcounter_expand:  'SELECT SUM(AcctSessionTime) FROM radacct WHERE UserName='%{User-Name}''
Mon Nov 30 10:45:56 2009 : Info: [noresetcounter]       expand: SELECT SUM(AcctSessionTime) FROM radacct WHERE UserName='%{User-Name}' -> SELECT SUM(AcctSessionTime) FROM radacct WHERE UserName='9799-8798-3665-6561'
Mon Nov 30 10:45:56 2009 : Debug: sqlcounter_expand:  '%{sql:SELECT SUM(AcctSessionTime) FROM radacct WHERE UserName='9799-8798-3665-6561'}'
Mon Nov 30 10:45:56 2009 : Info: [noresetcounter] sql_xlat
Mon Nov 30 10:45:56 2009 : Info: [noresetcounter]       expand: %{User-Name} -> 9799-8798-3665-6561
Mon Nov 30 10:45:56 2009 : Info: [noresetcounter] sql_set_user escaped user --> '9799-8798-3665-6561'
Mon Nov 30 10:45:56 2009 : Info: [noresetcounter]       expand: SELECT SUM(AcctSessionTime) FROM radacct WHERE UserName='9799-8798-3665-6561' -> SELECT SUM(AcctSessionTime) FROM radacct WHERE UserName='9799-8798-3665-6561'
Mon Nov 30 10:45:56 2009 : Debug: rlm_sql (sql): Reserving sql socket id: 3
Mon Nov 30 10:45:56 2009 : Info: [noresetcounter] row[0] returned NULL
Mon Nov 30 10:45:56 2009 : Debug: rlm_sql (sql): Released sql socket id: 3
Mon Nov 30 10:45:56 2009 : Info: [noresetcounter]       expand: %{sql:SELECT SUM(AcctSessionTime) FROM radacct WHERE UserName='9799-8798-3665-6561'} -> 
Mon Nov 30 10:45:56 2009 : Debug: rlm_sqlcounter: No integer found in string ""
Mon Nov 30 10:45:56 2009 : Info: ++[noresetcounter] returns noop
Mon Nov 30 10:45:56 2009 : Debug: rlm_sqlcounter: Entering module authorize code
Mon Nov 30 10:45:56 2009 : Debug: rlm_sqlcounter: Could not find Check item value pair
Mon Nov 30 10:45:56 2009 : Info: ++[dailycounter] returns noop
Mon Nov 30 10:45:56 2009 : Debug: rlm_sqlcounter: Entering module authorize code
Mon Nov 30 10:45:56 2009 : Debug: rlm_sqlcounter: Could not find Check item value pair
Mon Nov 30 10:45:56 2009 : Info: ++[monthlycounter] returns noop
Mon Nov 30 10:45:56 2009 : Info: Found Auth-Type = CHAP
Mon Nov 30 10:45:56 2009 : Info: +- entering group CHAP {...}
Mon Nov 30 10:45:56 2009 : Info: [chap] login attempt by "9799-8798-3665-6561" with CHAP password
Mon Nov 30 10:45:56 2009 : Info: [chap] Using clear text password "1234" for user 9799-8798-3665-6561 authentication.
Mon Nov 30 10:45:56 2009 : Info: [chap] Password check failed
Mon Nov 30 10:45:56 2009 : Info: ++[chap] returns reject
Mon Nov 30 10:45:56 2009 : Info: Failed to authenticate the user.
Mon Nov 30 10:45:56 2009 : Info: Using Post-Auth-Type Reject
Mon Nov 30 10:45:56 2009 : Info: +- entering group REJECT {...}
Mon Nov 30 10:45:56 2009 : Info: [attr_filter.access_reject]    expand: %{User-Name} -> 9799-8798-3665-6561
Mon Nov 30 10:45:56 2009 : Debug:  attr_filter: Matched entry DEFAULT at line 11
Mon Nov 30 10:45:56 2009 : Info: ++[attr_filter.access_reject] returns updated
Mon Nov 30 10:45:56 2009 : Info: Delaying reject of request 0 for 1 seconds
Mon Nov 30 10:45:56 2009 : Debug: Going to the next request
Mon Nov 30 10:45:56 2009 : Debug: Waking up in 0.9 seconds.
Mon Nov 30 10:45:57 2009 : Info: Sending delayed reject for request 0
Sending Access-Reject of id 0 to 192.168.65.99 port 38212
Mon Nov 30 10:45:57 2009 : Debug: Waking up in 4.9 seconds.
Mon Nov 30 10:46:02 2009 : Info: Cleaning up request 0 ID 0 with timestamp +40
Mon Nov 30 10:46:02 2009 : Debug: Ready to process requests.

--------------------------------------------------- FIN --------------------------------------------------------------------------------------------------

>José Adiel Blandón Rivera canchex at gmail.com
> 
>are you using Crypted password in the database? you have to use clear passwords in the database to successful login through chillispot and freeradius.
> 
>Regards

I am using Clear passwords :

mysql> select * from radcheck;
+----+---------------------+--------------------+----+-------+
| id | username            | attribute          | op | value |
+----+---------------------+--------------------+----+-------+
|  2 | 9799-8798-3665-6561 | Cleartext-Password | := | 1234  | 
+----+---------------------+--------------------+----+-------+
1 row in set (0.00 sec)

mysql>

>Charles" charles at goma.kivu-online.com
> 
>Whats the version of freeradius are you using?

Mon Nov 30 10:45:15 2009 : Info: FreeRADIUS Version 2.1.7, for host i486-pc-linux-gnu, built on Nov 13 2009 at 15:28:37
Mon Nov 30 10:45:15 2009 : Info: Copyright (C) 1999-2009 The FreeRADIUS server project and contributors.
Mon Nov 30 10:45:15 2009 : Info: There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A
Mon Nov 30 10:45:15 2009 : Info: PARTICULAR PURPOSE.
Mon Nov 30 10:45:15 2009 : Info: You may redistribute copies of FreeRADIUS under the terms of the
Mon Nov 30 10:45:15 2009 : Info: GNU General Public License v2.
Mon Nov 30 10:45:15 2009 : Info: Starting - reading configuration files ...

Regards!! 		 	   		  
_________________________________________________________________
Windows Live: Make it easier for your friends to see what you’re up to on Facebook.
http://www.microsoft.com/middleeast/windows/windowslive/see-it-in-action/social-network-basics.aspx?ocid=PID23461::T:WLMTAGL:ON:WL:en-xm:SI_SB_2:092009
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20091130/85e97d25/attachment.html>