On Sep 12, 2019, at 4:43 AM, Bornemann, Hans <hans.bornemann@tu-dortmund.de> wrote
we are testing a wlan with "private preshared keys". In the cisco wlancontroller world
it works with the AAA override feature and some entries in the radius database.
If I transfer this entries to the mysql database, the aut-type was not set.
What is missing?
Read the debug output. And use "radiusd -X", not "radiusd -Xx". And don't post the debug output double-spaced.
I tested it with the default configuration, the sql module was enabled.
You didn't configure the SQL module correctly. I've edited the debug output below to look like it was done with "radiusd -X":
(9) sql: Executing select query: SELECT id, username, attribute, value, op FROM radcheck WHERE username = '3c15c2e840fe' ORDER BY id The 'rlm_sql_null' driver CANNOT be used for SELECTS. Please update the 'sql' module configuration to use a real database. Set 'driver = ...' to the database you want to use.
This is why we tell everyone to READ the debug output. It tells you EXACTLY what is going wrong, and how to fix it. Please READ the documentation, and follow the instructions. It's MUCH more efficient than doing random things, and wondering why the server doesn't work. Alan DeKok.