Re: chilli + freeradius + mysql : Password check failed
Hi all, Forgive me for not answering but weekends I do not work J
tnt@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@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@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/soc...
tnt@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 :
...
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 ...
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)
Authentication failed because password used on chilli end wasn't 1234. Take it up with them and see if something was misconfigured on the hotspot. But something is not quite right on this debug. If this is your radcheck table, where did the noresetcounter attribute come from? radgroupcheck? Ivan Kalik
participants (2)
-
David BiTx0 -
tnt@kalik.net