Hi all,
Forgive me for not answering but weekends I do not work J
>[email protected]>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 [email protected]
>
>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" [email protected]
>
>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-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
