RE: SQL Statement in users file

2012-01-05 Thread McSparin, Joe
[mailto:freeradius-users-bounces+jmcsparin=hillcountrymemorial.org@lists .freeradius.org] On Behalf Of Brian Julin Sent: Thursday, January 05, 2012 12:22 PM To: FreeRadius users mailing list Subject: RE: SQL Statement in users file McSparin, Joe wrote: > > Does anyone know if there is a way in the

RE: SQL Statement in users file

2012-01-05 Thread Brian Julin
McSparin, Joe wrote: > > Does anyone know if there is a way in the users file to set > the Tunnel-Private-Group-id = "some_default_vlan" if the > following sql statement comes back blank. > > DEFAULT Auth-Type = "ntlm_auth" > Tunnel-Type = "VLAN", > Tu

RE: SQL Statement in users file

2012-01-05 Thread McSparin, Joe
sday, January 05, 2012 10:54 AM To: FreeRadius users mailing list Subject: RE: SQL Statement in users file With renewed confidence that this would work I found that I just needed to add the database name and remove the single quotes and it worked. I am curious about your suggestion to use &qu

RE: SQL Statement in users file

2012-01-05 Thread McSparin, Joe
Behalf Of Phil Mayers Sent: Thursday, January 05, 2012 10:29 AM To: freeradius-users@lists.freeradius.org Subject: Re: SQL Statement in users file On 05/01/12 15:24, McSparin, Joe wrote: > Does this seem like a doable scenario in the users file it doesn't > return anything but I'

Re: SQL Statement in users file

2012-01-05 Thread Phil Mayers
On 05/01/12 15:24, McSparin, Joe wrote: Does this seem like a doable scenario in the users file it doesn't return anything but I'm not sure if it is query issue or if those values are not available in the users file. DEFAULT Auth-Type = "ntlm_auth" Tunnel-Type = "VLAN", Tunnel-Medium-Type = "IEE

SQL Statement in users file

2012-01-05 Thread McSparin, Joe
Does this seem like a doable scenario in the users file it doesn't return anything but I'm not sure if it is query issue or if those values are not available in the users file. DEFAULT Auth-Type = "ntlm_auth" Tunnel-Type = "VLAN", Tunnel-Medium-Type = "IEEE-802",