"Lewis Bergman" <lbergman@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.