some doubts, im newbie, radius authentication and mysql.

[Alan DeKok]

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