Fetching users from external source

Stefan Paetow Stefan.Paetow at jisc.ac.uk
Mon May 11 17:54:22 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 |

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 at jabber.dev.ja.net
skype: stefan.paetow.janet
Lumen House, Library Avenue, Harwell Oxford, Didcot, OX11 0SG

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.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 496 bytes
Desc: Message signed with OpenPGP using GPGMail
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20150511/f19dfa0d/attachment.sig>

More information about the Freeradius-Users mailing list