Hello All.
We are trying to use a Microsoft DBI proxy to keep track of how many users
are online.
However, on Sunday night when the MSSQL server died, the proxy RADIUS server
would start getting "No reply" to every request and not forward any of them
on.
Here is a small extract from the Proxy RADIUS.
<SessionDatabase SQL>
Identifier flowonline
DBSource
dbi:Proxy:hostname=203..xxx.xxx.xxx;port=9993;dsn=dbi:ODBC:MSSQL
DBUsername xxxxxxx
DBAuth xxxxxxx
AddQuery insert into flowONLINE (USERNAME, NASIDENTIFIER, NASPORT, \
ACCTSESSIONID, FRAMEDADDRESS, AccInputOctets, AccOutputOctets, \
SERVICETYPE,NASPortDNIS,REALM,callerid) values ('%n', '%N',
%{NAS-Port},'%{Acct-Session-Id}', \
'%{Framed-IP-Address}','%{Acct-Input-Octets}','%{Acct-Output-Octets}', \
'%{Service-Type}','%{Called-Station-Id}','%R','%{Calling-Station-Id}')
DeleteQuery delete from flowONLINE where USERNAME='%n' and \
NASIDENTIFIER='%N' and NASPORT='%{NAS-Port}'
ClearNasQuery delete from flowONLINE where NASIDENTIFIER='%N'
CountQuery select NASIDENTIFIER, NASPORT, ACCTSESSIONID from flowONLINE \
where USERNAME='%n'
</SessionDatabase>
Thanks.
Rabbie.
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
