(RADIATOR) radiator radius help

[Peter Zhu]

Hello,

I try to add current connected users to table vop_onlineusers, but when
the user disconnected, this user is still at the to table
vop_onlineusers. Can you help.
the following is configuration file :

<SessionDatabase SQL>
 Identifier SQLSDB
 DBSource dbi:ODBC:IACBS
 DBUsername xxxxx
 DBAuth  xxxxx
CountQuery select VOP_NO, NASPORTID, USERNAME from VOP_ONLINEUSERS where
USERNAME='%u'
DeleteQuery delete from VOP_ONLINEUSERS where username='%u'
AddQuery insert into VOP_ONLINEUSERS (VOP_NO, USERNAME, NASPORTID,
DNISID, IPADDRESS, CALLERID, SESSIONID, STARTTIME) values ('%m', '%u',
'%{NAS-Port}', '%{Called-Station-Id}', '%{Framed-IP-Address}',
'%{Calling-Station-Id}', '%{Acct-Session-Id}', '%o')
</SessionDatabase>


<Realm DEFAULT>
# Accepts a username in an email address form ie: user at host.com
 RewriteUsername s/^([^@]+).*/$1/
# Converts Username to all lowercase, not currently required.
# RewriteUsername tr/[A-Z]/[a-z]/
 AcctLogFileName %L/accounting/%Y-%m/detail.%d
 SessionDatabase SQLSDB
 MaxSessions 1
 <AuthBy SQL>
  DBSource dbi:ODBC:IACBS
  DBUsername xxxxx
  DBAuth  xxxxxx
  AuthSelect select ACCESS_PASSWD,CHECKATTR, REPLYATTR from ACCOUNTS
where USERNAME='%n'


  AccountingTable VOP_ACCOUNTING

  AcctColumnDef LOGDATE,Timestamp,integer-date,%e/%m/%Y
  ......
  .....
  AcctColumnDef SESSIONID,Acct-Session-Id
  AcctColumnDef CALLED_NO,Called-Station-Id
  AcctColumnDef XMIT_RATE,Ascend-Xmit-Rate,integer
  Timeout 60
  FailureBackoffTime 30
 </AuthBy>
</Realm>


thanks,

peter zhu from uniware

===
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.