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

[Hugh Irvine]

Hello Rabbie -

I will need to see more supporting information to be able to say 
anything sensible.

This includes a copy of the configuration file (no secrets) together 
with a trace 4 debug showing what is happening.

regards

Hugh


On Monday, November 4, 2002, at 10:59 AM, Rabbie Zalaf wrote:

> 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.
>
>

NB: I am travelling this week, so there may be delays in our 
correspondence.

-- 
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.