I am now trying to connect my freeradius to mssql2000 on freeBSD4.8, keeping getting
failure:
I am doing as below:
setup unixODBC at /usr/apps/unixODBC
compile and install freeTDS0.61 with --with-unixODBC at /usr/local/freetds
complie and isntall freeradius 0.7.1 at /usr/apps/radius
then I set the ini files as below:
odbc.ini
---------------------------------------------
[MyServer70]
Description = MS SQLServer2000
Driver = TDS
Server = 192.168.0.34
Database = master
UID = sa
PWD = 262721
Port = 1433
TDS_Version = 7.0
odbcinst.ini
--------------------------------------------
[TDS]
Description = FreeTDS v0.60
Driver = /usr/local/freetds/lib/libtdsodbc.so
FileUsage = 5
freetds.conf
-----------------------------------------------
# A typical Microsoft SQL Server 7.0 configuration
[MyServer70]
host = 192.168.0.34
port = 1433
tds version = 7.0
sql.conf of freeradius:
-------------------------------------------------
driver = "rlm_sql_unixodbc"
server = "MyServer70"
login = "temp5"
password = ""
radius_db = "master"
then I install the ODBC at /usr/apps/unixODBC/bin as below:
odbcinst -i -d -f ../etc/odbcinst.ini
odbcinst -i -s -f ../etc/odbc.ini
and the next, I have a test :
/isql -v MyServer70 temp5
It works fine.(I noticed that whereever I place the freetds.conf for even I delete it
from the computer, isql works fine )
and then , I start radius and got the trace info as below:
rlm_sql: Driver rlm_sql_unixodbc loaded and linked
rlm_sql: Attempting to connect to [EMAIL PROTECTED]:/master
rlm_sql: starting 0
rlm_sql: Attempting to connect #0
rlm_sql_unixodbc: Connection failed
rlm_sql: Failed to connect DB handle #0
rlm_sql: starting 1
rlm_sql: starting 2
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
