rlm_sql_mysql encoding issue

[Ivan Kalik]

> This is my radcheck table:
> mysql> select * from radcheck;
> +----+--------------+--------------------+----+---------+
> | id | username     | attribute          | op | value   |
> +----+--------------+--------------------+----+---------+
> |  1 | MACH01\testuser | Cleartext-Password | := | mysecret |
> +----+--------------+--------------------+----+---------+
>
> However in the (radiusd -X) I am seeing the following:
> rlm_sql (sql): Reserving sql socket id: 4
> [sql]   expand: SELECT id, username, attribute, value, op           FROM
> radchec
> k           WHERE username = '%{SQL-User-Name}'           ORDER BY id ->
> SELECT
> id, username, attribute, value, op           FROM radcheck
> WHERE username = 'MACH01=5Ctestuser'           ORDER BY id
>
> 'MACH01\testuser' is changed to 'MACH01=5Ctestuser' and thus FR does not
> find it.

'MACH01=5Ctestuser' is in the request. You are not using proper character
for / when typing the request. Either your supplicant or your keyboard
aren't doing utf-8.

Ivan Kalik
Kalik Informatika ISP