eb5c
+- entering group authorize
++[preprocess] returns ok
expand: /var/log/freeradius/radacct/%{Client-IP-Address}/auth-detail-%Y%m%d -> /var/log/freeradius/radacct/
127.0.0.1/auth-detail-20090219
rlm_detail: /var/log/freeradius/radacct/%{Client-IP-Address}/auth-detail-%Y%m%d expands to /var/log/freeradius/radacct/
127.0.0.1/auth-detail-20090219
expand: %t -> Thu Feb 19 13:13:58 2009
++[auth_log] returns ok
expand: %{Realm} ->
++[attr_filter] returns noop
++[chap] returns noop
++[mschap] returns noop
rlm_realm: No '@' in User-Name = "juanpal", looking up realm NULL
rlm_realm: No such realm "NULL"
++[suffix] returns noop
rlm_eap: No EAP-Message, not doing EAP
++[eap] returns noop
users: Matched entry DEFAULT at line 61
WARNING: Found User-Password == "...".
WARNING: Are you sure you don't mean Cleartext-Password?
WARNING: See "man rlm_pap" for more information.
users: Matched entry DEFAULT at line 201
++[files] returns ok
expand: %{User-Name} -> juanpal
rlm_sql (sql): sql_set_user escaped user --> 'juanpal'
rlm_sql (sql): Reserving sql socket id: 3
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
rlm_sql (sql): User found in radcheck table
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
expand: SELECT GroupName FROM usergroup WHERE
UserName='%{SQL-User-Name}' -> SELECT GroupName FROM usergroup WHERE
UserName='juanpal'
rlm_sql (sql): Released sql socket id: 3
++[sql] returns ok
rad_check_password: Found Auth-Type Local
auth: type Local
auth: user supplied User-Password does NOT match local User-Password
auth: Failed to validate the user.
Login incorrect: [juanpal/juanpal] (from client localhost port 1 cli 08-00-27-0A-F7-67)
Delaying reject of request 0 for 1 seconds
Going to the next request
Waking up in 0.9 seconds.
Sending delayed reject for request 0
Sending Access-Reject of id 68 to 127.0.0.1 port 32814
Service-Type = Login-User
Session-Timeout := 2400
Waking up in 4.9 seconds.
Cleaning up request 0 ID 68 with timestamp +10
Ready to process requests.
As you see, the user juanpal authenticate with mysql but the next step stop him
My user file has this:
DEFAULT Auth-Type := Local, Crypt-password = User-Password
Fall-Through = yes
Whit auth-type = System, the users need to be Systems users.
Whit aut-type = ACCEPT, anyone can loggin.
I don't know what try now, i had been google, read in many forums.
Thanks a lot.