[From my initial message] let /policy.d/filter determine how to process it. [From your first message] when someone logs in using a serial number, look that up in the table, get the name.
How will it know whether or not they're using a serial number?
have a table which maps serial numbers to User-Names.
Could I just add a "serial" column to the radcheck table? -- David Teston PINES System Administrator Georgia Public Library Service 1800 Century Place, Suite 150 Atlanta, GA 30345 Office: 404-235-7206 Mobile: 404-623-8676 dteston@georgialibraries.org http://georgialibraries.org On Tue, Nov 29, 2016 at 11:39 AM, Alan DeKok <aland@deployingradius.com> wrote:
On Nov 29, 2016, at 11:16 AM, David Teston <dteston@georgialibraries.org> wrote:
I will be using EAP. If I leave unlang as is, I could rely on SQL to look for the username/serial. For example:
select * from radcheck; id | username | attribute | op | value | serial ----+---------------+----------------------+----+----------- ----+----------------- 1 | myself | User-Password | := | test-pass | 987688113
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;
Please don't do that. It is overly complex and fragile.
Go read my previous message. That solution will work, and will be enormously simpler.
Alan DeKok.
- List info/subscribe/unsubscribe? See http://www.freeradius.org/ list/users.html