MS-CHAPv2 not working

[Alan DeKok]

On Jun 3, 2019, at 9:36 PM, Matthew McTague via Freeradius-Users <freeradius-users at lists.freeradius.org> wrote:
> I'm still experiencing the same MS-CHAPv2 issues, where I connect as testlane5 at test.net.nz.

  No, you're not.

  Read the debug output.  There's a lot there, but it's not difficult if you *read* it.

> Works fine without the realm.
> 
> Cleartext-Password exists in database:
> 
> MariaDB [radius]> select * from radcheck\G;
> *************************** 1. row ***************************
>       id: 1
> username: testlane5
> attribute: Cleartext-Password
>       op: :=
>    value: R1zmj55L5o

  That's nice.
> ...
> (0) files: users: Matched entry DEFAULT at line 181
> (0)     [files] = ok
> (0) sql: EXPAND %{User-Name}
> (0) sql:    --> testlane5 at test.net.nz
> (0) sql: SQL-User-Name set to 'testlane5 at test.net.nz'
> rlm_sql (sql): Reserved connection (1)
> (0) sql: EXPAND SELECT id, username, attribute, value, op FROM radcheck WHERE username = '%{SQL-User-Name}' ORDER BY id
> (0) sql:    --> SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'testlane5 at test.net.nz' ORDER BY id
> (0) sql: Executing select query: SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'testlane5 at test.net.nz' ORDER BY id

  Hmm... that seems pretty darned clear.

  Read raddb/mods-config/sql/main/mysql/queries.conf

  See sql_user_name

  Alan DeKok.