Hope this helps. If you are running freeradius as other than root.root, make sure that this user or group can read /etc/odbc/ Also read my previous post. Adjust to your liking or system...
cd /usr/src && rm -fr unixODBC-2.2.11 tar -zxvf unixODBC-2.2.11.tar.gz && cd unixODBC-2.2.11 && sed -i "s/void yyerror/#define YY_FLUSH_BUFFER\n\n&/" sqp/lex.l && ./configure --prefix=/usr --libexecdir=/usr/sbin --localstatedir=/var --sysconfdir=/etc/odbc --enable-ltdllib --with-gnu-ld --disa ble-gui && make && make install && find doc -name "Makefile*" -exec rm {} \; && chmod 644 doc/{lst,ProgrammerManual/Tutorial}/* && install -v -m755 -d /usr/share/doc/unixODBC-2.2.11 && cp -v -R doc/* /usr/share/doc/unixODBC-2.2.11 && rmdir /etc/odbc/ODBCDataSources && chown -fR root.odbc /etc/odbc && chmod 750 /etc/odbc && chmod 640 /etc/odbc/* cd /usr/src && rm -fr freetds-0.63 tar -zxvf freetds-0.63.tar.gz && cd freetds-0.63 && ./configure --prefix=/usr --libexecdir=/usr/sbin --localstatedir=/var --sysconfdir=/etc --with-unixodbc=/usr/lib --disable-apps && make && make install && rm -f /etc/{freetds,locales}.conf cd /usr/src && rm -fr freeradius-1.0.5 && tar -zxvf freeradius-1.0.5.tar.gz && cd freeradius-1.0.5 && patch -Np1 -i ../freeradius-1.0.5-stdout_log-1.patch && ./configure --prefix=/usr --libexecdir=/usr/sbin --localstatedir=/var --sysconfdir=/etc --with-raddbdir=/srv/radiusd --with-logdir =/var/log --with-radacctdir=/srv/radiusd/acct --with-gnu-ld --without-rlm_x99_token && make && make install cat /etc/odbc.ini [MSSQL-DB] description = FreeRADIUS ODBC for MSSQL 7.0 driver = FreeTDS server = mssql.yourdomain.com port = 1433 database = mydatabase tds_version = 7.0 language = us_english cat /etc/odbcinst.ini [FreeTDS] description = FreeTDS driver for MSSQL driver = /usr/lib/libtdsodbc.so setup = /usr/lib/libtdsS.so fileusage = 1 cat /srv/radiusd/mssql.conf sql { driver = "rlm_sql_unixodbc" server = "MSSQL-DB" login = "mylogin" password = "mypassword" radius_db = "mydatabase" acct_table1 = "radacct" acct_table2 = "radacct" authcheck_table = "radcheck" authreply_table = "radreply" [SNIP...] ----- Original Message ----- From: "Erik Ågren" <[EMAIL PROTECTED]> To: "'FreeRadius users mailing list'" <freeradius-users@lists.freeradius.org> Sent: Tuesday, October 04, 2005 3:57 AM Subject: SV: freeradius and MS SQL -- anyone got it working? > 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] För Arne Götje (???) > Skickat: den 1 oktober 2005 08:58 > Till: freeradius-users@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 (高盛華) <[EMAIL PROTECTED]> > 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. > > > > - > List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html > - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html