MSSQL and FreeRADIUS
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 identifier to a stored procedure on the SQL server and then give the output in the format desired by the module. If anyone has already done this, please tell me where to go for the 411. TIA ___ Brian Johnson Internet Operations Specialist Northern Valley Communications "Let's Roll!" - Todd Beamer
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 in the mssql.conf file. doc/variables.txt ? Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: MSSQL and FreeRADIUS
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 file. I would like to pass the username and the NAS address or other identifier to a stored procedure on the SQL server and then give the output in the format desired by the module. If anyone has already done this, please tell me where to go for the 411. TIA ___ Brian Johnson Internet Operations Specialist Northern Valley Communications Let's Roll! - Todd Beamer - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: MSSQL and FreeRADIUS
I've always believed that you start with what you know and work from that stance. After I get to know freeRADIUS better I may determine that LDAP, or whatever else, is a better solution. For the time being this is the route we have chosen. -Original Message- From: [EMAIL PROTECTED] [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 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 identifier to a stored procedure on the SQL server and then give the output in the format desired by the module. If anyone has already done this, please tell me where to go for the 411. TIA ___ Brian Johnson Internet Operations Specialist Northern Valley Communications Let's Roll! - Todd Beamer - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: MSSQL and FreeRADIUS
Aren't these variables for submiting to accounting records? If all of these are usable in the authentication process, why have you limited the number of variables significantly from what is listed as being depreciated in a future version? SNIP The following one-character variables are also defined. However, they are duplicates of the previous general cases, and are only provided for backwards compatibility. They may be removed in a future release. %a Protocol (SLIP/PPP) %c Callback-Number %d request day (DD) %f Framed IP address %i Calling Station ID %l request timestamp %m request month (MM) %n NAS IP address %p Port number %s Speed (PW_CONNECT_INFO) %t request in ctime format %u User name %A radacct_dir %C clientname %D request date (MMDD) %L radlog_dir %M MTU %R radius_dir %S request timestamp in SQL format %T request timestamp in database format %U Stripped User name %V Request-Authenticator (Verified/None) %Y request year () %Z All request attributes except password (must have big buffer) SNIP Brian J. -Original Message- From: [EMAIL PROTECTED] [mailto:freeradius-users-admin;lists.cistron.nl] On Behalf Of Alan DeKok Sent: Thursday, November 07, 2002 12:10 PM To: [EMAIL 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 in the mssql.conf file. doc/variables.txt ? Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
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 have you
limited the number of variables significantly from what is listed as
being depreciated in a future version?
What do you mean by that? Most of the one-letter variables are
short-hands for longer ones. e.g. %c == %{Callback-Number}. There's
no need to have both, so the short one will probably be removed in a
future release.
Alan DeKok.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: MSSQL and FreeRADIUS
Thank you for clarifying this for me.
So I could use %n or %{Framed IP address}.
Is that correct?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:freeradius-users-admin;lists.cistron.nl] On Behalf Of
Alan DeKok
Sent: Thursday, November 07, 2002 12:34 PM
To: [EMAIL PROTECTED]
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 have you
limited the number of variables significantly from what is listed as
being depreciated in a future version?
What do you mean by that? Most of the one-letter variables are
short-hands for longer ones. e.g. %c == %{Callback-Number}. There's
no need to have both, so the short one will probably be removed in a
future release.
Alan DeKok.
-
List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
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}
pedantic mode off
Alan DeKok.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: MSSQL and FreeRADIUS
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 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 identifier to a stored procedure on the SQL server and then give the output in the format desired by the module. If anyone has already done this, please tell me where to go for the 411. TIA ___ Brian Johnson Internet Operations Specialist Northern Valley Communications Let's Roll! - Todd Beamer - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: MSSQL and FreeRADIUS
Ouch Alan! Don't hit me so hard. ;)
http://www.dictionary.com/search?q=pedantic%20
Thank you very much for the information and now I believe my head is
screwed straight. :)
-Original Message-
From: [EMAIL PROTECTED]
[mailto:freeradius-users-admin;lists.cistron.nl] On Behalf 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}
pedantic mode off
Alan DeKok.
-
List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
MSSQL and Freeradius
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 rlm_sql_freetds: file not found rlm_sql: Make sure it (and all its dependent libraries!) are in the search path of your system's ld. radiusd.conf[8]: sql: Module instantiation failed I noticed that rlm_sql_freetds.so does not exist in my system. All other rlm_sql_*.so files are inside the /usr/local/lib. Anybody knows why rlm_sql_freetds.so is not being created by the install script? I tried this on both freebsd 4.X and Redhat Linux 7.X as well as the stable and CVS copies of freeradius and I got the same result. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: 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 the problem, i tried installing it under slackware 8.0 and it went through without complaining. have you tried adding the path (/usr/local/lib) where it looks for shared libraries in your ld.so.conf file? don't forget to run 'ldconfig' after adding the path. hope this helps, ronald On Wed, 18 Sep 2002, Andrew G. Buenaventura wrote: 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 rlm_sql_freetds: file not found rlm_sql: Make sure it (and all its dependent libraries!) are in the search path of your system's ld. radiusd.conf[8]: sql: Module instantiation failed I noticed that rlm_sql_freetds.so does not exist in my system. All other rlm_sql_*.so files are inside the /usr/local/lib. Anybody knows why rlm_sql_freetds.so is not being created by the install script? I tried this on both freebsd 4.X and Redhat Linux 7.X as well as the stable and CVS copies of freeradius and I got the same result. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html -- [Never be afraid to try something new. Remember, amateurs built the ark, and professionals built the Titanic.] - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: MSSQL and Freeradius
I forgot to mention that I am using mssql.conf and that my driver is rlm_sql_freetds. I am using Microsoft's SQL 2k and not mysql. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 6:34 PM To: [EMAIL PROTECTED] Subject: Re: 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 the problem, i tried installing it under slackware 8.0 and it went through without complaining. have you tried adding the path (/usr/local/lib) where it looks for shared libraries in your ld.so.conf file? don't forget to run 'ldconfig' after adding the path. hope this helps, ronald On Wed, 18 Sep 2002, Andrew G. Buenaventura wrote: 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 rlm_sql_freetds: file not found rlm_sql: Make sure it (and all its dependent libraries!) are in the search path of your system's ld. radiusd.conf[8]: sql: Module instantiation failed I noticed that rlm_sql_freetds.so does not exist in my system. All other rlm_sql_*.so files are inside the /usr/local/lib. Anybody knows why rlm_sql_freetds.so is not being created by the install script? I tried this on both freebsd 4.X and Redhat Linux 7.X as well as the stable and CVS copies of freeradius and I got the same result. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html -- [Never be afraid to try something new. Remember, amateurs built the ark, and professionals built the Titanic.] - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: MSSQL and Freeradius
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 using mssql.conf and that my driver is rlm_sql_freetds. I am using Microsoft's SQL 2k and not mysql. -- [Never be afraid to try something new. Remember, amateurs built the ark, and professionals built the Titanic.] - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: MSSQL and Freeradius
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 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 using mssql.conf and that my driver is rlm_sql_freetds. I am using Microsoft's SQL 2k and not mysql. -- [Never be afraid to try something new. Remember, amateurs built the ark, and professionals built the Titanic.] - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
