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.NB: I am travelling this week, so there may be delays in our correspondence.
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.
--
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 [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
