That�s the same problem that I have.
Alan said that it�s a data strutcture conflit with old version..
try to remove all rlm_* at lib directory, build and install again
that didn�t work for me, i found a workaround that was setting the
"clean_delay" var to -1
------------------------------------------------------------
Marcelo Ferreira
Canbras TVA Cabo Ltda
Canbras Acesso - STA
Phone: +5511-4993-8728
Pager: +5511-5188-3838 cod. 158062
www.pagenet.com.br
------------------------------------------------------------
----- Original Message -----
From: "Rubby" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, December 26, 2001 11:17 PM
Subject: Problem about FreeRADIUS and Oracle
> I am a new comer of FreeRAIUS.
> I use FreeRADIUS 0.3 to authenticate by Oracle SQL.
> I inserted a row into RADCHECK table (username,attribute,value) values
> ('Rubby','Password','Rubby'),but freeradius server rejected.
> The debug infomation freeradius server printed as below:
>
>
> 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/snmp.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/radius"
> main: libdir = "/usr/local/lib"
> main: radacctdir = "/usr/local/var/log/radius/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
> main: max_request_time = 30
> main: cleanup_delay = 5
> main: max_requests = 1024
> main: delete_blocked_requests = 0
> main: port = 0
> main: allow_core_dumps = no
> main: log_stripped_names = no
> main: log_auth = no
> main: log_auth_badpass = no
> main: log_auth_goodpass = no
> main: pidfile = "/usr/local/var/run/radiusd.pid"
> main: user = "root"
> main: group = "root"
> main: usercollide = no
> main: lower_user = "no"
> main: lower_pass = "no"
> main: nospace_user = "no"
> main: nospace_pass = "no"
> main: proxy_requests = yes
> proxy: retry_delay = 5
> proxy: retry_count = 3
> proxy: synchronous = no
> proxy: dead_time = 120
> main: debug_level = 0
> read_config_files: entering modules setup
> Module: Library search path is /usr/local/lib
> Module: Loaded SQL
> sql: driver = "rlm_sql_oracle"
> sql: server = "192.168.0.101"
> sql: port = "1521"
> sql: login = "szcom"
> sql: password = "szcom"
> sql: radius_db = "acct"
> 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 = yes
> sql: sqltracefile = "/usr/local/var/log/radius/sqltrace.sql"
> sql: deletestalesessions = yes
> sql: num_sql_socks = 5
> sql: sql_user_name = "%{User-Name}"
> sql: authorize_check_query = "SELECT id,UserName,Attribute,Value FROM
radcheck"
> sql: authorize_reply_query = "SELECT id,UserName,Attribute,Value FROM
radreply"
> sql: authorize_group_check_query = "SELECT
radgroupcheck.id,radgroupcheck.Grou"
> sql: authorize_group_reply_query = "SELECT
radgroupreply.id,radgroupreply.Grou"
> sql: authenticate_query = "SELECT Value,Attribute FROM radcheck WHERE
UserName"
> sql: accounting_onoff_query = "UPDATE radacct SET AcctStopTime='%S',
AcctSessi"
> sql: accounting_update_query = "UPDATE radacct SET FramedIPAddress =
'%{Framed"
> sql: accounting_start_query = "INSERT into radacct (RadAcctId,
AcctSessionId, "
> sql: accounting_start_query_alt = "UPDATE radacct SET AcctStartTime =
'%S', Ac"
> sql: accounting_stop_query = "UPDATE radacct SET AcctStopTime = '%S',
AcctSess"
> sql: accounting_stop_query_alt = "INSERT into radacct (RadAcctId,
AcctSessionI"
> sql: connect_failure_retry_delay = 60
> rlm_sql: Driver rlm_sql_oracle loaded and linked
> rlm_sql: Attempting to connect to [EMAIL PROTECTED]:1521/acct
> rlm_sql: Connected new DB handle, #0
> rlm_sql: Connected new DB handle, #1
> rlm_sql: Connected new DB handle, #2
> rlm_sql: Connected new DB handle, #3
> rlm_sql: Connected new DB handle, #4
> Module: Instantiated sql (sql)
> Module: Loaded preprocess
> preprocess: huntgroups = "/usr/local/etc/raddb/huntgroups"
> preprocess: hints = "/usr/local/etc/raddb/hints"
> preprocess: with_ascend_hack = no
> preprocess: ascend_channels_per_line = 23
> preprocess: with_ntdomain_hack = no
> preprocess: with_specialix_jetstream_hack = no
> preprocess: with_cisco_vsa_hack = no
> Module: Instantiated preprocess (preprocess)
> Module: Loaded realm
> realm: format = "suffix"
> realm: delimiter = "@"
> Module: Instantiated realm (suffix)
> Module: Loaded files
> files: usersfile = "/usr/local/etc/raddb/users"
> files: acctusersfile = "/usr/local/etc/raddb/acct_users"
> files: compat = "no"
> Module: Instantiated files (files)
> Module: Loaded detail
> detail: detailfile =
"/usr/local/var/log/radius/radacct/%{Client-IP-Address}/d"
> detail: detailperm = 384
> detail: dirperm = 493
> Module: Instantiated detail (detail)
> Module: Loaded System
> unix: cache = no
> unix: passwd = "/etc/passwd"
> unix: shadow = "(null)"
> unix: group = "/etc/group"
> unix: radwtmp = "/usr/local/var/log/radius/radwtmp"
> unix: usegroup = no
> Module: Instantiated unix (unix)
> Module: Loaded radutmp
> radutmp: filename = "/usr/local/var/log/radius/radutmp"
> radutmp: perm = 384
> radutmp: callerid = yes
> Module: Instantiated radutmp (radutmp)
> main: smux_password = ""
> main: snmp_write_access = no
> SMUX connect try 1
> Can't connect to SNMP agent with SMUX: Connection refused
> Listening on IP address *, ports 1645/udp and 1646/udp, with proxy on
1647/udp.
> Ready to process requests.
> rad_recv: Access-Request packet from host 192.168.0.102:1024, id=34,
length=122
> CHAP-Challenge = "\332$}%\361\370\002_\200\231\274O\2056\264\223"
> CHAP-Password =
"\001\207\213,\311\361<\010\200\351*\027ed\230\334\321"
> User-Name = "Rubby"
> Calling-Station-Id = "00:50:FE:E9:DC:8D"
> NAS-Port-Type = Virtual
> NAS-Port = 16
> NAS-IP-Address = 192.168.0.102
> NAS-Identifier = "AegisOS"
> Framed-Protocol = PPP
> Service-Type = Framed-User
> modcall: entering group authorize
> modcall[authorize]: module "preprocess" returns ok
> modcall[authorize]: module "suffix" returns ok
> users: Matched DEFAULT at 144
> users: Matched DEFAULT at 166
> users: Matched DEFAULT at 178
> modcall[authorize]: module "files" returns ok
> modcall: group authorize returns ok
> rad_check_password: Found Auth-Type SQL
> auth: type "SQL"
> modcall: entering group authtype
> rlm_sql: Reserving sql socket id: 4
> radius_xlat: 'Rubby'
> sql_escape in: 'Rubby'
> sql_escape out: 'Rubby'
> sql_set_user: escaped user --> 'Rubby'
> radius_xlat: 'SELECT Value,Attribute FROM radcheck WHERE UserName =
'Rubby' AN'
> SELECT Value,Attribute FROM radcheck WHERE UserName = 'Rubby' AND (
Attribute =C
> rlm_sql: Released sql socket id: 4
> MASTER: exit on signal (11)
> [root@LSRV1 freeradius-0.3]#
>
>
>
>
> How to solve it,can anyone help me?
> .+-�w��˛���m��˛���m�zm�����y��v+���?�+-�� ��m
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
