... just create two identical entries in your SQL database for each set of credentials. ... one person can log in with two accounts.
You're right, but I may have to keep it all as one entry, just so the id field on the radcheck table is uniform and can correspond to the application database as well. I think I will modify the radcheck table (add column "serial number") and SQL queries. You have helped me find the best solution to this problem. Thanks for all of your help, Matthew. David -- David Teston PINES System Administrator http://georgialibraries.org On Tue, Nov 29, 2016 at 11:33 AM, Matthew Newton <mcn4@leicester.ac.uk> wrote:
On Tue, Nov 29, 2016 at 11:16:56AM -0500, David Teston wrote:
I guess you've got somewhere a record with a serial number, password and optional user name.
For testing, I'm copying credentials from an application we use/host which does include all of those.
Your simplest solution may then be to just create two identical entries in your SQL database for each set of credentials. One with username = the username, and the other with username = serial number.
That will keep your FreeRADIUS config much simpler.
User logs in with serial: User-Name = "987688113"
The new SQL query could be: SELECT id, UserName, Attribute, Value, Op FROM radcheck WHERE (Username = '987688113' OR serial = '987688113') ORDER BY id;
The SQL statements can all be modified, so you should be able to do something with it along these lines.
But breaking it down to its simplest, one person can log in with two accounts. So put two accounts in the database.
Otherwise, use unlang to work out what type of username is being used, and depending on that call the appropriate sql module, or use the appropriate sql statements.
Matthew
-- Matthew Newton, Ph.D. <mcn4@leicester.ac.uk>
Systems Specialist, Infrastructure Services, I.T. Services, University of Leicester, Leicester LE1 7RH, United Kingdom
For IT help contact helpdesk extn. 2253, <ithelp@le.ac.uk> - List info/subscribe/unsubscribe? See http://www.freeradius.org/ list/users.html