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!!