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>
