how to transfer from "users file to sql"

Alan DeKok aland at deployingradius.com
Thu Sep 12 13:08:25 CEST 2019


On Sep 12, 2019, at 4:43 AM, Bornemann, Hans <hans.bornemann at 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.




More information about the Freeradius-Users mailing list