On Jun 3, 2019, at 9:36 PM, Matthew McTague via Freeradius-Users <freeradius-users@lists.freeradius.org> wrote:
I'm still experiencing the same MS-CHAPv2 issues, where I connect as testlane5@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@test.net.nz (0) sql: SQL-User-Name set to 'testlane5@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@test.net.nz' ORDER BY id (0) sql: Executing select query: SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'testlane5@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.