1. Do we have to specify a port number to connect to a MS SQL database? (If
so where, I can't find where to put one in MSSQL.conf)
2. Is it true that unixODBC does not work on it's own and still requires
freeTDS?
First I got freeRadius working with text files. So far so good. The move
to SQL has not yet worked. The user is hsvpnws, the database is wific. The
databases server is 192.168.0.126.
My Modules load, but my connection never makes it.
====================================================================
sql: simul_verify_query = ""
rlm_sql ((null)): Driver rlm_sql_unixodbc (module rlm_sql_unixodbc) loaded
and linked
rlm_sql ((null)): Attempting to connect to [EMAIL PROTECTED]:/wific
rlm_sql ((null)): starting 0
rlm_sql ((null)): Attempting to connect #0
rlm_sql_unixodbc: Connection failed
rlm_sql ((null)): Failed to connect DB handle #0
rlm_sql ((null)): starting 1
rlm_sql ((null)): starting 2
rlm_sql ((null)): starting 3
rlm_sql ((null)): starting 4
Module: Instantiated sql (sql)
Module: Loaded files
files: usersfile = "/etc/raddb/users"
files: acctusersfile = "/etc/raddb/acct_users"
files: preproxy_usersfile = "/etc/raddb/preproxy_users"
files: compat = "no"
Module: Instantiated files (files)
Module: Loaded detail
detail: detailfile = "/var/log/radius/radacct/%{Client-IP-Address}/detail"
detail: detailperm = 384
detail: dirperm = 493
detail: locking = no
Module: Instantiated detail (detail)
Module: Loaded radutmp
radutmp: filename = "/var/log/radius/radutmp"
radutmp: username = "%{User-Name}"
radutmp: perm = 384
radutmp: callerid = yes
Module: Instantiated radutmp (radutmp)
Listening on IP address *, ports 1812/udp and 1813/udp, with proxy on
1814/udp.
Ready to process requests.
====================================================================
At the top of the raddb trace (third line down here) there is a blank port
directive, but I can't find where to enter it in mssql.conf:
====================================================================
Module: Loaded SQL
sql: driver = "rlm_sql_unixodbc"
sql: server = "192.168.0.126"
sql: port = ""
sql: login = "hsvpnws"
sql: password = "eagles99"
sql: radius_db = "wific"
sql: acct_table = "radacct"
sql: acct_table2 = "radacct"
sql: authcheck_table = "radcheck"
sql: authreply_table = "radreply"
sql: groupcheck_table = "radgroupcheck"
sql: groupreply_table = "radgroupreply"
sql: usergroup_table = "usergroup"
sql: nas_table = "nas"
sql: dict_table = "dictionary"
sql: sqltrace = no
sql: sqltracefile = "/var/log/radius/sqltrace.sql"
sql: deletestalesessions = yes
sql: num_sql_socks = 5
sql: sql_user_name = "%{hsvpnws}"
====================================================================
I'm running the latest snapshot of freeRadius and freeTDS. (but the
symptons are the same with 0.7.1 and 0.60). I compiled and installed
unixODBC first, then the freeTDS, then recompiled freeRadius. The database
exists.
This is in my /usr/local/etc/odbc.ini:
[sqlserver]
Driver = TDS
Descripttion = SQL Server
Trace = Yes
Servername = 192.168.0.4
Database = wific
This is in my /usr/local/etc/odbcinst.ini:
[TDS]
Description = SQL 2000 Database
Driver = /usr/local/lib/libtdsodbc.so
FileUsage = 1
In mssql.conf the database type is declared as driver = "rlm_sql_unixodbc"
In radiusd.conf the following line chooses mssql.
# For MS-SQL, use ${confdir}/mssql.conf
$INCLUDE ${confdir}/mssql.conf
====================================================================
Any assistance or pointers greatly appreciated. Thanks for your time.
GT
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
