Fetching users from external source

mlstfr at ntcomputer.de mlstfr at ntcomputer.de
Sun May 17 20:27:50 CEST 2015

>> Having seen the amount of tables and properties in the sql module, I assumed it would be both overkill and too complicated to set up for my quite simple usage scenario. But maybe I am mistaken and it is as easy as giving freeradius the credentials and putting the usernames & passwords in a single table?
> It is that simple really. You won't need all the tables that the SQL module exposes. The radcheck table does in a database format what the users file does, i.e.
> +- id -+- username ---+--- attribute ------+ op +-- value    ---+
> | xxxx | username1    | ClearText-Password | := | password here |
> +------+--------------+--------------------+----+---------------+
> :
> :
I got everything working now, though it was not possible with the 
radcheck table only. First, I was forced to move the freeradius server 
from OpenWRT to another machine, because I didn't find a way to get a 
SQL driver running, second, freeradius refused to operate without a 
radreply table. In the end I applied the complete mysql template to my 
database, which worked out fine, though I'm now sitting on all the 
tables I didn't want to have in the first place. Maybe there is a way 
(which I have not found) to tweak the config so the radcheck table alone 
is sufficient?

Anyway, thanks for your help!

More information about the Freeradius-Users mailing list