Username OR Serial Number

[David Teston]

>> [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 at georgialibraries.org
http://georgialibraries.org

On Tue, Nov 29, 2016 at 11:39 AM, Alan DeKok <aland at deployingradius.com>
wrote:

> On Nov 29, 2016, at 11:16 AM, David Teston <dteston at 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
>