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