[prev in list] [next in list] [prev in thread] [next in thread] 

List:       freeradius-users
Subject:    About Oracle Module!
From:       Íõ嫲¨ <bswhb () 263 ! net>
Date:       2001-03-28 12:25:28
[Download RAW message or body]

hi, everyone engrossed in RADIUS:

after correcting some errors in the file sql_oracle.c and sql_oracle.h, making is finally finished.
but another problem makes me puzzled.

root# ./radiusd -X
Starting - reading configuration files ...
reread_config:  reading radiusd.conf
Config:   including file: /usr/local/etc/raddb/proxy.conf
Config:   including file: /usr/local/etc/raddb/clients.conf
Config:   including file: /usr/local/etc/raddb/sql.conf
 main: prefix = "/usr/local"
 main: localstatedir = "/usr/local/var"
 main: logdir = "/usr/local/var/log"
 main: libdir = "/usr/local/lib"
 main: radacctdir = "/usr/local/var/log/radacct"
 main: hostname_lookups = no
read_config_files:  reading dictionary
read_config_files:  reading clients
read_config_files:  reading realms
read_config_files:  reading naslist
read_config_files:  entering modules setup
bla...bla...
Module: Loaded SQL 
 sql: driver = "rlm_sql_oracle"
 sql: server = "radius.mailserver.dctc"
 sql: login = "radius"
 sql: password = "radius"
 sql: radius_db = "0"
 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 = "/usr/local/var/log/sqltrace.sql"
 sql: deletestalesessions = yes
 sql: num_sql_socks = 5
 sql: sql_user_name = ""
rlm_sql: Driver rlm_sql_oracle loaded and linked
rlm_sql: Attempting to connect to radius@radius.mailserver.dctc:0
Init: Oracle logon failed: 'Error while trying to retrieve text for error ORA-12541'

rlm_sql:  Failed to connect sqlsocket 0
radiusd.conf[4]: sql: Module instantiation failed.


can u tell me how to set the radius_db item, is the "0" right? 
Oracle's version is 8.1.6, and it's deployed on Redhat Linux6.2.
any hints and suggestions will be appreciated!

					Wang Hanbo



[prev in list] [next in list] [prev in thread] [next in thread]