Username OR Serial Number

[Alan DeKok]

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.