Hi,
I'm trying to setup only accounting request proxying for remote OSS systems, as
well to keep accounting messages to be written on SQL database with the
original <AuthBy SQL>. I applied the below configuration, and I had received
the accounting on the remote system, but I loss accounting update on the sql
database table...
Need urgent advice.
Configuration:
################################################################
<AuthBy SQL>
AccountingTable zooomonline.ZOOOM_ACCOUNTING
AcctColumnDef USERNAME,User-Name,%A
AcctColumnDef TIME_STAMP,Timestamp,integer
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-Identifier
AcctColumnDef NASPORT,NAS-Port,integer
AcctColumnDef FRAMEDIPADDRESS,Framed-IP-Address
AcctInsertQuery insert into %0 (ACCOUNT_ID, DATE_TIME, %1) values
(zooomonline.ZOOOM_ACCOUNTING_SEQ.nextval, SYSDATE, %2)
# AddToReply Service-Type=Framed-User, Framed-Protocol=PPP,
Framed-MTU=1492, Session-Timeout = "until Expiration"
AddToReply Service-Type=Framed-User, Framed-Protocol=PPP,
Framed-MTU=1492
AuthColumnDef 0,User-Password, check
# AuthColumnDef 1,Expiration, check
AuthColumnDef 1,Session-Timeout, reply
AuthColumnDef 2,Simultaneous-Use, check
AuthColumnDef 3,GENERIC, reply
# AuthSelect select PASSWORD, to_char(EXPIRATION, 'yyyy-mm-dd
HH24:MI:SS') EXPIRATION, MAXSESSIONS, REPLYATTR, Session_Timeout
"Session-Timeout" from zooomonline.view_zooom_user_auth where
upper(USERNAME)=upper('%n')
AuthSelect select PASSWORD, (Session_Timeout) EXPIRATION, MAXSESSIONS,
REPLYATTR, Session_Timeout "Session-Timeout" from
zooomonline.view_zooom_user_auth where upper(USERNAME)=upper('%n')
CachePasswordExpiry 86400
ConnectionAttemptFailedHook sub {my $self = shift;my $dbsource =
shift;my $dbusername = shift;my $dbauth = shift;$self->log($main::LOG_ERR,
"Could not connect to SQL database with DBI->connect $dbsource, $dbusername,
$dbauth: $@ $DBI::errstr");}
DBAuth zooomonline2009
DBSource dbi:ODBC:DSLPROD
DBUsername zooomonline
DateFormat %b %e, %Y %H:%M
EAPAnonymous anonymous
EAPContextTimeout 1000
EAPFAST_PAC_Lifetime 7776000
EAPFAST_PAC_Reprovision 2592000
EAPTLS_MaxFragmentSize 2048
EAPTLS_PEAPVersion 1
EAPTLS_SessionResumption 1
EAPTLS_SessionResumptionLimit 43200
EAPTLS_VerifyDepth 1
FailureBackoffTime 600
Identifier ZooomAuth
NoConnectionsHook sub { my $self = shift;$self->log($main::LOG_ERR,
"Could not connect to any SQL database. Request is ignored. Backing off for
$self->{FailureBackoffTime} seconds");}
NullPasswordMatchesAny 1
PasswordPrompt password
SIPDigestRealm DefaultSipRealm
Timeout 60
</AuthBy>
Handler Request-Type=Accounting-Request>
AuthByPolicy ContinueAlways
AccountingHandled
<AuthBy RADIUS>
Secret 123456
Host 1.2.3.1
Host 1.2.3.2
AuthPort 1812
AcctPort 1813
IgnoreAccountingResponse
</AuthBy>
</Handler>
Is there's any additional required configuration.
Thank you!
Regards,
_______________________________________________
radiator mailing list
[email protected]
http://www.open.com.au/mailman/listinfo/radiator
