(RADIATOR) "No reply" when online table fails.

[Rabbie Zalaf]

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 radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.