Freeradius not to read radgroupcheck table from MSSQL

Xiaochen Jing xjing at datavalet.com
Mon Oct 20 15:38:40 CEST 2008


Hi Ivan,

1. Is there a place that I should tell Freeradius to use mysql/dialup.conf
instead of mssql/dialup.conf? But I am really using MS SQL as database. 

2. How can I update dialup.conf? Does it work if I make install directly
version 2.1.1 on the system?

Thanks in advance

XJ


-----Original Message-----
From: freeradius-users-bounces+xjing=datavalet.com at lists.freeradius.org
[mailto:freeradius-users-bounces+xjing=datavalet.com at lists.freeradius.org]
On Behalf Of tnt at kalik.net
Sent: Friday, October 17, 2008 6:45 PM
To: FreeRadius users mailing list
Subject: RE: Freeradius not to read radgroupcheck table from MSSQL

Try authorize queries from mysql/dialup.conf. Perhaps mssql/dialup.conf
hasn't been updated. They look like 1.1.x to me.

Ivan Kalik
Kalik Informatika ISP


Dana 17/10/2008, "Xiaochen Jing" <xjing at datavalet.com> piše:

>Hello Ivan,
>
>I cannot find out where to configure group_membership_query. Should I see
>group check table being read in debug?
>
>Thanks in advance
>
>XJ
>
>
>-----Original Message-----
>From: freeradius-users-bounces+xjing=datavalet.com at lists.freeradius.org
>[mailto:freeradius-users-bounces+xjing=datavalet.com at lists.freeradius.org]
>On Behalf Of tnt at kalik.net
>Sent: Friday, October 17, 2008 11:23 AM
>To: FreeRadius users mailing list
>Subject: Re: Freeradius not to read radgroupcheck table from MSSQL
>
>>In /mssql/dialup.conf, I edit two queries for authorized_check_query and
>>authorize_group_check_query, instead of using the default ones. Doing this
>>is easy for our database programming.
>>
>>
>>
>>        authorize_check_query = "RADIUS_authorize_check_query
>>'%{SQL-User-Name}'"
>>
>>
>>
>>        authorize_group_check_query = "RADIUS_authorize_group_check_query
>>'%{SQL-User-Name}'"
>>
>
>Shouldn't there be a group_membership_query as well? And group check
>query depending on SQL-Group?
>
>Ivan Kalik
>Kalik Informatika ISP
>
>-
>List info/subscribe/unsubscribe? See
>http://www.freeradius.org/list/users.html
>
>-
>List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html
>
>

-
List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html





More information about the Freeradius-Users mailing list