mysql troubles

[Alan DeKok]

"Lewis Bergman" <lbergman at wtxs.net> wrote:
> But, when I run the same sql command from the radius server's mysql client
> I get:
> mysql> SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username
> = 'testuser' ORDER BY id;
> +----+----------+---------------+----------+----+
> | id | UserName | Attribute     | Value    | op |
> +----+----------+---------------+----------+----+
> |  8 | testuser | User-Password | testuser | == |
> +----+----------+---------------+----------+----+

  See the rlm_sql documentation.  The '==' is a comparison operator.
Use ':='

> If I put the user in the users file, the correct post-auth sql query is
> executed and the accounting record is correctly inserted into the db.

  The users file is a little different than SQL.  Not for good
reasons, but it is different.

  Alan DeKok.