RE: Freeradius not to read radgroupcheck table from MSSQL

2008-10-20 Thread Xiaochen Jing
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] 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

Re: Freeradius not to read radgroupcheck table from MSSQL

2008-10-20 Thread A . L . M . Buxey
Hi, 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. no. if you use MSSQL then use MSSQL files - what you will need to do is edit mssql/dialup.conf so that the queries that

RE: Freeradius not to read radgroupcheck table from MSSQL

2008-10-20 Thread tnt
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. Don't do that. mssql database needs mssql driver. 2. How can I update dialup.conf? Does it work if I make install directly version 2.1.1 on the

Freeradius not to read radgroupcheck table from MSSQL

2008-10-17 Thread Xiaochen Jing
Hello, My Freeradius seems only to read radcheck table, not to read radgroupcheck table from MS SQL. Here is my settings: 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

Re: Freeradius not to read radgroupcheck table from MSSQL

2008-10-17 Thread tnt
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}'

RE: Freeradius not to read radgroupcheck table from MSSQL

2008-10-17 Thread Xiaochen Jing
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

RE: Freeradius not to read radgroupcheck table from MSSQL

2008-10-17 Thread tnt
see group check table being read in debug? Thanks in advance XJ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, October 17, 2008 11:23 AM To: FreeRadius users mailing list Subject: Re: Freeradius not to read radgroupcheck