FreeTDS + UnixODBC to MSSQL Problems

Alex Chiodo ajcny90 at gmail.com
Fri Aug 2 18:35:38 CEST 2013


Version: FreeRADIUS Version 2.2.0, for host x86_64-pc-linux-gnu, built
on Jul 31 2013 at 15:36:48
OS: Ubuntu 12.04.2 LTS

Hi all-

Having some difficulties with Freeradius connecting to a SQL Server
2008 backend using the unixodbc module. I've recompiled the source
using the --with-rlm_sql_unixodbc flag and the module appears to be
loading fine. However, Freeradius does not seem to be able to
establish a connection with the server. I've configured my
freetds.conf, odbc.ini, and odbcinst.ini files properly because tsql
and isql can both connect to and query the server, but the debug
output from Freeradius gives me the following:

rlm_sql (sql): Driver rlm_sql_unixodbc (module rlm_sql_unixodbc)
loaded and linked
rlm_sql (sql): Attempting to connect to admin at 10.10.100.24:49355/radius
rlm_sql (sql): starting 0
rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #0
rlm_sql_unixodbc: SQL down 08001 [unixODBC][FreeTDS][SQL Server]Unable
to connect to data source
rlm_sql_unixodbc: Connection failed
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.

I'm using the mssql.conf template found at
https://github.com/FreeRADIUS/www.freeradius.org/blob/master/radiusd/raddb/mssql.conf
with the only changes being the connect info (server, login, port,
password), radius_db, and sqltrace, and radiusd.conf has an include
for mssql.conf.

I've tried running Wireshark on the SQL server and both tsql and isql
generate traffic to the server. Upon loading Freeradius, I see
absolutely no traffic coming from the radius server's IP. Any ideas
where my problem could lie?


More information about the Freeradius-Users mailing list