[RADIATOR] ::Accounting Request Proxying for Remote OSS Systems::

[Mohammed Alhaj Ali]

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,