alex wrote: > Only the first query looks to have a valid result. > SELECT id, UserName, Attribute, Value, op FROM radcheck > WHERE Username = '00:09:5b:65:98:b0' ORDER BY id > After that the other queries doesnt have a valid answer, so the user uis > rejected. > My question is, in the sql.conf, if i comment the queries that are searching > in the empty tables, could fix the problem? or the problem is in the radius > manager 2, when it add a user and is not adding to the other tables?
It won't help. Read the debug log: > 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. The server found a password, but it was wrong. Fix that, not the SQL queries. Alan DeKok. -- http://deployingradius.com - The web site of the book http://deployingradius.com/blog/ - The blog - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html