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

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 mysql/di

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-17 Thread tnt
>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. Doin

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 pr

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}'" > > > >autho