Checking MAC address with rlm_sql

[Alan DeKok]

Glen Harris wrote:
>> Can you paste the debug log? I'm guessing that the request to the
>> inner tunnel probably don't have Calling-Station-Id attribute.
>>
> Here it is:

  Did you read it?  There's a lot of stuff, but it's pretty obvious
what's going on:

> [sql]     expand: %{User-Name} -> user01
> [sql] sql_set_user escaped user --> 'user01'
> rlm_sql (sql): Reserving sql socket id: 3
> [sql]     expand: SELECT id, username, attribute, value, op          
> FROM radcheck           WHERE username = '%{SQL-User-Name}'          
> ORDER BY id -> SELECT id, username, attribute, value, op           FROM
> radcheck           WHERE username = 'user01'           ORDER BY id
> [sql]     expand: SELECT groupname           FROM radusergroup          
> WHERE username = '%{SQL-User-Name}'           ORDER BY priority ->
> SELECT groupname           FROM radusergroup           WHERE username =
> 'user01'           ORDER BY priority
> rlm_sql (sql): Released sql socket id: 3
> [sql] User user01 not found
> ++[sql] returns notfound

  What does that look like?

  Alan DeKok.