SV: freeradius and MS SQL -- anyone got it working?

[Erik Ågren]

Hi

If Anyone got this to work, couldn't you give me an example of how its done.
Including necessary changes in the odbc.ini (and where to put it) and the other files that I have to change.

I'm trying to connect using iodbc, but when starting up FreeRADIUS I get the following:

rlm_sql (sql): Driver rlm_sql_iodbc (module rlm_sql_iodbc) loaded and linked rlm_sql (sql): Attempting to connect to @MSSQL:/ rlm_sql (sql): starting 0 rlm_sql (sql): Attempting to connect rlm_sql_iodbc #0
sql_create_socket: SQLConnectfailed:  [iODBC][Driver Manager]Specified driver could not be loaded rlm_sql (sql): Failed to connect DB handle #0 rlm_sql (sql): starting 1 rlm_sql (sql): starting 2 rlm_sql (sql): starting 3 rlm_sql (sql): starting 4 rlm_sql (sql): Failed to connect to any SQL server.

***************************************************************

rlm_sql (sql): Attempting to connect to @MSSQL:/

This looks strange, but I just tried to use the DSN name, as suggested. Any suggestion about what to do here?


Thanx

/Erik


-----Ursprungligt meddelande-----
Från: freeradius-users-bounces at lists.freeradius.org [mailto:freeradius-users-bounces at lists.freeradius.org] För Arne Götje (???)
Skickat: den 1 oktober 2005 08:58
Till: freeradius-users at lists.freeradius.org
Ämne: Re: freeradius and MS SQL -- anyone got it working?

On Friday 30 September 2005 21:28, Duane Cox wrote:
> There are a few qwerks with getting FreeRadius to work with MSSQL.

thought so... :)

> First thing, the FreeTDS files have been removed (more like
> abandonded) from FreeRadius.
> If you really want to call FreeTDS direclty, you will have to download 
> the files from the "attic".
> But more than that you will also have to update the files as they do 
> not currently compile properly, they are a bit old.
> I would suggest to go with unixodbc or iodbc, even though using 
> FreeTDS is IMHO the best way, it's not supported.

oh... ok, then I'll go with unixodbc.

> Second, in order to get MSSQL to work with the current version of 
> FreeRadius 1.0.5, you will need to install either unixodbc or iodbc.
> I chose unixodbc; and in doing so it requires FreeTDS.  So install 
> both FreeTDS and unixODBC.
>
> Third.  You will need to include mssql.conf and call rlm_sql_unixodbc.  
> The mssql.conf has to many tricks to it.  First the default driver is 
> invalid and the "server" is really the DSN and must match that name 
> found in /etc/odbc.ini.  Also /etc/odbc.ini must be readable by the 
> freeradius daemon.  Also, there is an extra statement in the 
> mssql.conf that is totaly not used and can be deleted; it's 
> "authenticate_query".
>
> These things should help you out.  If you need any further assistance, 
> ie. configure/make commands and file contents ask again.

Thanks. :)

Could you give me an example how the /etc/odbc.ini has to look like?

Cheers
Arne
--
Arne Götje (高盛華) <arne at linux.org.tw>
PGP/GnuPG key: 1024D/685D1E8C
Fingerprint: 2056 F6B7 DEA8 B478 311F  1C34 6E9F D06E 685D 1E8C
Key available at wwwkeys.pgp.net.   Encrypted e-mail preferred.