Title: Multiple STOP records with AS5300

Hi

We use Cisco AS 5300 (Ver. 12.0.5 T 2) and Radiator 2.14 (AuthBy SQL).
When I look to the acounting data I see for most of the session's multiple stop records. In cisco I have 60 sec. timeout for acct and as retransit value 2.

Any clue?

Best Regards
Lutfi

PS: My network is 100Tx

<<radora_cfg.txt>>

LogDir          /var/radius
Foreground
LogStdout
Trace   3
DbDir   /usr/local/etc/
DictionaryFile %D/dictionary
PidFile /tmp/radiusd.pid
AuthPort        1645
AcctPort        1646
RewriteUsername tr/-A-Za-z0-9\.\@//cd
SnmpgetProg /usr/local/bin/snmpget
# You will probably want to change this to suit your site.

<Client DEFAULT>
        Secret  mysecret
#       DupInterval 0
#       IgnoreAcctSignature
        SNMPCommunity community
NasType Cisco
</Client>

<Realm DEFAULT>
MaxSessions 1
<AuthBy SQL>
DBSource dbi:Oracle:radora
DBUsername **uname**
DBAuth ***secret***
AuthSelect select PASSWORD,CHECKATTR,REPLYATTR || SESSIONFILTER || \
SESSIONFILTERVALUE || to_char(TOTALSESSION) from SUBSCRIBERS,SESSIONFILTERS \
        where USERNAME='%U' AND \
(EXPIREDATE > SYSDATE OR EXPIREDATE IS NULL ) AND \
        subscribers.SESSIONFILTERID = sessionfilters.SESSIONFILTERID


AccountingStopsOnly
AccountingTable ACCOUNTING
               AcctColumnDef   USERNAME,User-Name
               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
               AcctColumnDef   ACCTTERMINATECAUSE,Ascend-Disconnect-Cause,integer
               AcctColumnDef   NASIDENTIFIER,NAS-IP-Address
               AcctColumnDef   NASPORT,NAS-Port,integer
               AcctColumnDef   FRAMEDADDRESS,Framed-IP-Address
               AcctColumnDef   CALLERID,Calling-Station-Id
               AcctColumnDef   DATARATE,Ascend-Data-Rate,integer
               AcctColumnDef   XMITRATE,Ascend-Xmit-Rate,integer
               AcctColumnDef   CLIENTDNIS,Called-Station-Id     
               AcctColumnDef   LOGDATE,Timestamp,integer-date
</AuthBy>
</Realm>

<SessionDatabase SQL>
DBSource dbi:Oracle:radora
DBUsername **uname**
DBAuth ***secret***
AddQuery insert into RADONLINE (USERNAME,NASIDENTIFIER,NASPORT,\
        ACCTSESSIONID,TIME_STAMP,FRAMEDIPADDRESS,NASPORTTYPE,\
        SERVICETYPE) values 
('%U','%{NAS-IP-Address}',%{NAS-Port},'%{Acct-Session-Id}',\
%{Timestamp},'%{Framed-IP-Address}','%{NAS-Port-Type}','%{Framed-Protocol}')
</SessionDatabase>

Reply via email to