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 | +------+--------------+--------------------+----+---------------+ : : Pardon the crude ASCII art. Of course, if you don't use the password in the clear (which is a Bad Thing™), choose one of the password schemes here: http://deployingradius.com/documents/protocols/compatibility.html It will tell you which RADIUS authentication types work with which hashing type, although something like EAP-TTLS/PAP or EAP-TTLS/EAP-GTC with PAP will pretty much work with all of them. :-) Stefan Paetow Moonshot Industry & Research Liaison Coordinator t: +44 (0)1235 822 125 gpg: 0x3FCE5142 xmpp: stefanp@jabber.dev.ja.net skype: stefan.paetow.janet Lumen House, Library Avenue, Harwell Oxford, Didcot, OX11 0SG jisc.ac.uk Jisc is a registered charity (number 1149740) and a company limited by guarantee which is registered in England under Company No. 5747339, VAT No. GB 197 0632 86. Jisc’s registered office is: One Castlepark, Tower Hill, Bristol, BS2 0JA. T 0203 697 5800. Jisc Collections and Janet Ltd. is a wholly owned Jisc subsidiary and a company limited by guarantee which is registered in England under Company No. number 2881024, VAT No. GB 197 0632 86. The registered office is: Lumen House, Library Avenue, Harwell, Didcot, Oxfordshire, OX11 0SG. T 01235 822200.