Hello Julio -
Thanks for sending the files.
There are a couple of things that I notice straight away.
The first is a very large number of errors with the communication with
the Oracle database. This should be addressed first of all so you have
a stable communication channel with no errors. The usual cause of
problems like this is the versions of either the DBI module or the
DBD-Oracle module. You should check the CPAN site and either upgrade or
downgrade until you find a stable combination.
The second is a configuration issue which is your use of Fork in your
AuthBy RADIUS clauses. You should not use Fork in an AuthBy RADIUS
clause. This may also be contributing the Oracle communications
problems.
Note that the AuthBy RADIUS clause operates asynchronously in any case,
so Fork is not required.
regards
Hugh
On 06/11/2003, at 4:37 AM, Julio Cesar Pinto wrote:
Hi Hung,
Ok, our config file is a little complex, but the summary is the
following:
Foreground
Trace 4
### CONFIGURATION ###
LogDir /home/radius/log/%{GlobalVar:RadiusIP}
LogFile %L/radiator.log
DbDir /home/radius/etc/conf
DictionaryFile %D/dictionary.ifx
PidFile %L/radius.pid
BindAddress %{GlobalVar:RadiusIP}
AuthPort 1812
AcctPort 1813
### CONFIGURATION ###
#ACCT_RADIUS_CL
AuthBy RADIUS
Fork
AcctPort 1646
NoForwardAuthentication
Host 216.241.*.*
Identifier ACCT_RADIUS_CL
LocalAddress %{GlobalVar:RadiusIP}
Retries 3
RetryTimeout 30
Secret **
/AuthBy
#ACCT_RADIUS_AR
AuthBy RADIUS
Fork
AcctPort 1646
NoForwardAuthentication
Host 200.61.*.*
Identifier ACCT_RADIUS_AR
LocalAddress %{GlobalVar:RadiusIP}
Retries 3
RetryTimeout 30
Secret *
/AuthBy
#DB Clients
ClientListSQL
DBAuth ***
DBSource DBI:Oracle:ORACLE.DOMAIN.COM
DBUsername usersql
GetClientQuery select NASIDENTIFIER,SECRET from RADCLIENTLIST
/ClientListSQL
# VE RAS 200.62.10.25 is a USR TotalControl which sends bad signatures
(fg - 9/10/2003)
Client 200.62.10.25
Secret ***
IgnoreAcctSignature
/Client
#Sesscion RADONLINE
SessionDatabase SQL
AddQuery insert into RADONLINE (USERNAME, NASIDENTIFIER,
NASPORT,ACCTSESSIONID, TIMESTAMP, FRAMEDIPADDRESS, NASPORTTYPE,
SERVICETYPE,CALL
ERID,CLIENTPORTDNIS,IFX_VISP_ID,IFX_COUNTRY_ID) values ('%u', '%N',
0%{NAS-Port},'%{Acct-Session-Id}', to_date('%d %m %Y %H:%M:%S', 'DD MM
HH24:MI:SS'), '%{Framed-IP-Address}','%{NAS-Port-Type}',
'%{Service-Type}','%{Calling-Station-Id}','%{Called-Station-
Id}','%{Ifx-Vis
p-Id}','%{Ifx-Country-Id}')
ClearNasQuery delete from RADONLINE where NASIDENTIFIER='%N'
CountNasSessionsQuery select ACCTSESSIONID from RADONLINE where
NASIDENTIFIER='%N'
CountQuery select NASIDENTIFIER, NASPORT, ACCTSESSIONID from
RADONLINE where USERNAME='%u
DBAuth ***
DBSource DBI:Oracle:ORACLE.DOMAIN.COM
DBUsername usersql
DeleteQuery delete from RADONLINE where NASIDENTIFIER='%N' and
NASPORT=0%{NAS-Port}
Identifier SESSIONID_0
/SessionDatabase
#PROMISCUE
AuthBy TEST
Identifier PROMISCUO
/AuthBy
#AA_SQL_LOCAL
AuthBy SQL
DBAuth **
DBSource DBI:Oracle:ORACLE.DOMAIN.COM
DBUsername usersql
AuthSelect select PASSWORD, TO_CHAR(EXPIRATION,'-MM-DD'),
CHECKATTR, REPLYATTR from SUBSCRIBERS where USERNAME='%n' and
ACTIVE=1
AuthColumnDef 0, User-Password, check
AuthColumnDef 1, Expiration, check
AuthColumnDef 2, GENERIC, check
AuthColumnDef 3, GENERIC, reply
AccountingTable ACCOUNTING%Y%m
AcctColumnDef USERNAME,User-Name
AcctColumnDef ACCTSTATUSTYPE,Acct-Status-Type
AcctColumnDef ACCTDELAYTIME,Acct-Delay-Time,integer
AcctColumnDef ACCTINPUTOCTETS,Acct-Input-Octets,integer
AcctColumnDef ACCTOUTPUTOCTETS,Acct-Output-Octets,integer
AcctColumnDef ACCTSESSIONID,Acct-Session-Id
AcctColumnDef ACCTSESSIONTIME,Acct-Session-Time,integer
AcctColumnDef ACCTTERMINATECAUSE,Acct-Terminate-Cause
AcctColumnDef NASIDENTIFIER,NAS-IP-Address
AcctColumnDef NASPORT,NAS-Port,integer
AcctColumnDef FRAMEDIPADDRESS,Framed-IP-Address
AcctColumnDef FRAMEDIPNETMASK,Framed-IP-Netmask
AcctColumnDef ASCENDDATARATE,Ascend-Data-Rate,integer
AcctColumnDef
ASCENDDISCONNECTCAUSE,Ascend-Disconnect-Cause,integer
AcctColumnDef
ASCENDPRESESSIONTIME,Ascend-PreSession-Time,integer
AcctColumnDef CALLERID,Calling-Station-Id
AcctColumnDef CLIENTPORTDNIS,Called-Station-Id
AcctColumnDef IFX_VISP_ID,Ifx-Visp-Id
AcctColumnDef IFX_CONN_STAT,Ifx-Conn-Stat,integer
AcctColumnDef IFX_TEST,Ifx-Test,integer
AcctColumnDef IFX_COUNTRY_ID,Ifx-Country-Id
AcctColumnDef TIMESTAMP,Timestamp,formatted-date,to_date('%e %m
%Y %H:%M:%S', 'DD MM HH24:MI:SS')
AcctColumnDef CLASS,Class
AccountingStopsOnly
NoDefault
IgnoreAuthentication
Identifier AA_SQL_LOCAL
AcctFailedLogFileName %L/FailedSqlAccounting.log
AddToReplyIfNotExist
