[RADIATOR] Insert Accounting to BD Table.

Wed May 27 03:32:43 CDT 2015

Dears,

Recently we had some change on our network, as we replaced cisco platform with Huawei BRAS, now we’re unable to get prober accounting specially, when customer account are newly created so we can’t get account activation on the first logging in order to calculate Session-timeout, below are the error logs plus the part of the configuration:

################################

<AuthBy SQL>
        AccountingTable DSL_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 (%1) values (%2)
        AuthColumnDef 0,User-Password, check
        AuthColumnDef 1,Expiration, check
        AuthColumnDef 2,Simultaneous-Use, check
        AuthColumnDef 3,Huawei-Domain-Name, reply
        AuthColumnDef 4,GENERIC, reply
AuthSelect select PASSWORD, to_char(EXPIRATION, 'yyyy-mm-dd HH24:MI:SS') Expiration, MAXSESSIONS, EXPIRATION_D "Huawei-Domain-Name" , Session_Timeout   "Session-Timeout" from ITC_ACCOUNTS_H where upper(USERNAME)=upper('%n')
        CachePasswordExpiry 86400
        AddToReply Service-Type=Framed-User, Framed-Protocol=PPP, Framed-MTU=1492, Session-Timeout = "until Expiration"
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");}
        DBSource dbi:ODBC:ORADB
        DBUsername user
  DBAuth password
        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 HUW_POOL
  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>

LOG:

Wed May 27 09:09:39 2015: DEBUG: Handling request with Handler 'Realm=/^(512|1024|2048)\.itc\.net\.sa$/'
Wed May 27 09:09:39 2015: DEBUG:  Deleting session for testhuawei at 2048.itc.net.sa, 87.101.255.184, 33554442
Wed May 27 09:09:39 2015: DEBUG: Handling with Radius::AuthSQL: HUW_POOL
Wed May 27 09:09:39 2015: DEBUG: Handling with Radius::AuthSQL: HUW_POOL
Wed May 27 09:09:39 2015: DEBUG: Query is: 'select PASSWORD, to_char(EXPIRATION, 'yyyy-mm-dd HH24:MI:SS') Expiration, MAXSESSIONS, EXPIRATION_D "Huawei-Domain-Name" , Session_Timeout "Session-Timeout" from ITC_ACCOUNTS_H where upper(USERNAME)=upper('testhuawei at 2048.itc.net.sa')':
Wed May 27 09:09:39 2015: DEBUG: Radius::AuthSQL looks for match with testhuawei at 2048.itc.net.sa [testhuawei at 2048.itc.net.sa]
Wed May 27 09:09:39 2015: DEBUG: Radius::AuthSQL ACCEPT: : testhuawei at 2048.itc.net.sa [testhuawei at 2048.itc.net.sa]
Wed May 27 09:09:39 2015: DEBUG: Session-Timeout="until ValidTo" was specified, but there was no ValidTo or Expiration check item for this user. Ignored.
Wed May 27 09:09:39 2015: DEBUG: AuthBy SQL result: ACCEPT,
Wed May 27 09:09:39 2015: DEBUG: Access accepted for testhuawei at 2048.itc.net.sa<mailto:testhuawei at 2048.itc.net.sa>

Wed May 27 09:09:39 2015: ERR: There is no value named until Expiration for attribute Session-Timeout. Using 0.

Wed May 27 09:09:39 2015: DEBUG: Packet dump:
*** Sending to 87.101.255.184 port 1812 ....

Mohammed Alhaj Ali
Integrated Telecom Co. Ltd.
Tel    : +966(11) 406-2222  Ext.2384
Fax   : +966(11) 406-2221
GSM  :
m.alhaj at itc.sa<mailto:m.alhaj at itc.sa>

[cid:image69148d.JPG at 167f63d9.4e8874a2]<http://www.execloud.net>

www.itc.sa<http://www.itc.sa>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.open.com.au/pipermail/radiator/attachments/20150527/bb1ac8ca/attachment-0001.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image69148d.JPG
Type: image/jpeg
Size: 10518 bytes
Desc: image69148d.JPG
Url : http://www.open.com.au/pipermail/radiator/attachments/20150527/bb1ac8ca/attachment-0001.jpe 