MSSQL and FreeRADIUS

2002-11-07 Thread Brian Johnson
Title: Message I am looking to create a completely custom user system database backend for FreeRADIUS. I was wondering if there is a doc on the variables that may be used in the SQL queries specified in the mssql.conf file. I would like to pass the username and the NAS address or other

Re: MSSQL and FreeRADIUS

2002-11-07 Thread Alan DeKok
Brian Johnson [EMAIL PROTECTED] wrote: ? I am looking to create a completely custom user system database backend for FreeRADIUS. I was wondering if there is a doc on the variables that may be used in the SQL queries specified in the mssql.conf file. doc/variables.txt ? Alan DeKok. - List

Re: MSSQL and FreeRADIUS

2002-11-07 Thread Guillermo Schimmel
May I ask why? You have excelent choices out there, i.e. LDAP. Brian Johnson wrote: I am looking to create a completely custom user system database backend for FreeRADIUS. I was wondering if there is a doc on the variables that may be used in the SQL queries specified in the mssql.conf

RE: MSSQL and FreeRADIUS

2002-11-07 Thread Brian Johnson
] [mailto:freeradius-users-admin;lists.cistron.nl] On Behalf Of Guillermo Schimmel Sent: Thursday, November 07, 2002 12:12 PM To: [EMAIL PROTECTED] Subject: Re: MSSQL and FreeRADIUS May I ask why? You have excelent choices out there, i.e. LDAP. Brian Johnson wrote: I am looking

RE: MSSQL and FreeRADIUS

2002-11-07 Thread Brian Johnson
PROTECTED] Subject: Re: MSSQL and FreeRADIUS Brian Johnson [EMAIL PROTECTED] wrote: ? I am looking to create a completely custom user system database backend for FreeRADIUS. I was wondering if there is a doc on the variables that may be used in the SQL queries specified

Re: MSSQL and FreeRADIUS

2002-11-07 Thread Alan DeKok
Brian Johnson [EMAIL PROTECTED] wrote: Aren't these variables for submiting to accounting records? Huh? Those are the variables which may be used any time, any where, in the server. If all of these are usable in the authentication process, why have you limited the number of variables

RE: MSSQL and FreeRADIUS

2002-11-07 Thread Brian Johnson
] Subject: Re: MSSQL and FreeRADIUS Brian Johnson [EMAIL PROTECTED] wrote: Aren't these variables for submiting to accounting records? Huh? Those are the variables which may be used any time, any where, in the server. If all of these are usable in the authentication process, why

Re: MSSQL and FreeRADIUS

2002-11-07 Thread Alan DeKok
Brian Johnson [EMAIL PROTECTED] wrote: So I could use %n or %{Framed IP address}. Is that correct? No, you've got to use the dictionary names: %{Framed-IP-Address} pedantic mode off Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

RE: MSSQL and FreeRADIUS

2002-11-07 Thread Brian Johnson
Also, can the queries be a simple call to a stored procedure? Brian J. -Original Message- From: [EMAIL PROTECTED] [mailto:freeradius-users-admin;lists.cistron.nl] On Behalf Of Brian Johnson Sent: Thursday, November 07, 2002 11:44 AM To: [EMAIL PROTECTED] Subject: MSSQL and FreeRADIUS I

RE: MSSQL and FreeRADIUS

2002-11-07 Thread Brian Johnson
Of Alan DeKok Sent: Thursday, November 07, 2002 1:03 PM To: [EMAIL PROTECTED] Subject: Re: MSSQL and FreeRADIUS Brian Johnson [EMAIL PROTECTED] wrote: So I could use %n or %{Framed IP address}. Is that correct? No, you've got to use the dictionary names: %{Framed-IP-Address

MSSQL and Freeradius

2002-09-18 Thread Andrew G. Buenaventura
I would like to run freeradius-0.7.1 and let it authenticate and record accounting details in MS SQL 2000. I have already installed freeradius and created the SQL schema using the script provided. When I run radiusd -xx , I got the following error: rlm_sql: Could not link driver

Re: MSSQL and Freeradius

2002-09-18 Thread arise
hi, i've just upgraded to the latest CVS snapshot under FreeBSD 4.5 and so far, it was running perfectly. i'm doing ldap authentication + mysql accounting. i tried looking for the file rlm_sql_freetds.so and it was not existent on my system as well. for the sake of reproducing the problem, i

RE: MSSQL and Freeradius

2002-09-18 Thread Andrew G. Buenaventura
: MSSQL and Freeradius hi, i've just upgraded to the latest CVS snapshot under FreeBSD 4.5 and so far, it was running perfectly. i'm doing ldap authentication + mysql accounting. i tried looking for the file rlm_sql_freetds.so and it was not existent on my system as well. for the sake of reproducing

RE: MSSQL and Freeradius

2002-09-18 Thread arise
hi, you need to install the freetds set of libraries. this allows your *nix box to talk to ms sql server or sybase databases. for more info, visit: http://www.freetds.org hope this helps, ronald On Wed, 18 Sep 2002, Andrew G. Buenaventura wrote: I forgot to mention that I am

RE: MSSQL and Freeradius

2002-09-18 Thread Andrew G. Buenaventura
Thanks. I wonder why rlm_sql_freetds.so is not being created by the install program. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 8:22 PM To: [EMAIL PROTECTED] Subject: RE: MSSQL and Freeradius hi, you need to install