(RADIATOR) Radiator hangs with slow SQL server

[Hugh Irvine]

Hello Ben -

You can try lowering the Timeout value in the AuthBy SQL clause (which 
defaults to 60 seconds).

See section 6.28.4 in the Radiator 3.6 reference manual 
("doc/ref.html").

regards

Hugh


On Wednesday, May 21, 2003, at 06:15 Australia/Melbourne, Ben Browning 
wrote:

> Greetings,
>
> We have an instance of Radiator that serves quite a few clients. On 
> the back end, we have it authing by some kludgy proprietary stuff 
> (long story) which is woprking fine. We also have it accounting to an 
> MS-SQL server.
>
> The service is flawless with the MS-SQL server up and running, and it 
> works fine when the server is down (discarding accting info). The 
> problem is when the server is very very slow- sometimes Radiator hangs 
> the whole session waiting to enter the data into the table.
>
> I know the longterm solution is "Get a faster SQL server", but in the 
> short term what can be done to alleviate this problem?
>
> ---
>    Ben Browning <benb at theriver.com>
>       The River Internet Access Co.
>          WA Operations Manager
> 1-877-88-RIVER  http://www.theriver.com
>
> ===
> 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: have you included a copy of your configuration file (no secrets),
together with a trace 4 debug showing what is happening?

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