Thank you. My apologies for leaving that out:
my /usr/local/freetds.conf file has this as the only section database
section:
[192.168.0.126]
host = 192.168.0.126
port = 1433
tds version = 7.0
Does the name in [brackets] have to match anything else in the other conf
files??
The test program tsql is working:
====================================================================
[glynn@localhost bin]$ tsql -S 192.168.0.126 -p 1433 -U hsvpnws
Password:
Msg 5703, Level 0, State 1, Server WFC-ACC1, Line 0
Changed language setting to us_english.
1> use wific
2> go
1> select * from customer;
2> go
Msg 208, Level 16, State 1, Server WFC-ACC1, Line 1
Invalid object name 'customer'.
1> select * from customers;
2> go
ID CustomerID Name Addr1 City State Zip
1 1 Microsoft 1 Microsoft Way
Redmond WA
98105
5 2 Oracle 1 Ellison Way
Dontknow
99999
1>
Yet radiusd can not get a connection to the database. Is there some logging
I can turn on or check to help me figure this out?
Thanks all
GT
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:freeradius-users-admin@;lists.cistron.nl]On Behalf Of Adorable
Dauz
Sent: Wednesday, November 06, 2002 5:53 PM
To: [EMAIL PROTECTED]
Subject: Re: (So close I can taste it...) freeradius & mssql2000
you need also to configure the freetds first.
----- Original Message -----
From: "Glynn Taylor" <[EMAIL PROTECTED]>
To: "Freeradius-Users" <[EMAIL PROTECTED]>
Sent: Thursday, November 07, 2002 6:36 AM
Subject: (So close I can taste it...) freeradius & mssql2000
>
> 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
-
List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
