(RADIATOR) radiator radius help

[Hugh Irvine]

Hello Peter -

You will have to look at a trace 4 debug from Radiator to see whether the 
problem is not receiving accounting stop records (likely), or whether the 
DeleteQuery shown below is failing for some reason (less likely).

regards

Hugh


On Fri, 8 Feb 2002 16:45, Peter Zhu wrote:
> 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.

-- 
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
===
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.