Hi,
I have installed freeradius-0.3, MySQL.
This is my radchek table:
id UserName Attribute Value
1 aldo Password aldo
2 aldo Expiration 31 oct 2001
If record with id 2 is present in the table, the client authorization is
rejected and message is:
sql_set_user: escaped user --> 'aldo'
radius_xlat: 'SELECT id,UserName,Attribute,Value FROM radcheck WHERE
Username = 'aldo' ORDER BY id'
SELECT id,UserName,Attribute,Value FROM radcheck WHERE Username = 'aldo'
ORDER BY id
Password = "aldo"
Password = "aldo"
Expiration = "Oct 31 2001"
.......
rlm_sql: Released sql socket id: 4
rlm_sql: Pairs do not match [aldo]
modcall[authorize]: module "sql" returns notfound
modcall: group authorize returns ok
auth: No Auth-Type configuration for the request, rejecting the user
auth: Failed to validate the user.
Login incorrect: [aldo/aldo] (from nas 217.72.40.249 port 0)
Sending Access-Reject of id 0 to 217.72.40.249:2215
How can I insert attribute Expiration in MySQL database for sigle user?
Best regards,
Aldo
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
