[RADIATOR] coping with a slow database server

[Hugh Irvine]

Hello David -

You can use "AccountingHandled" in your Realm or Handler.

See section 5.17.10 in the Radiator 4.4 reference manual ("doc/ 
ref.pdf").

You can also try the new "FarmSize n" parameter in Radiator 4.4.

See section 5.4.39 in the manual.

You can also run two instances of Radiator, one for authentication and  
the other for accounting.

regards

Hugh


On 22 Jun 2009, at 23:42, David J Craigon wrote:

> Hello,
>
> I run Radiator as an accounting server. I use AuthBySQL and an
> AcctSQLStatement. I am suffering with my database server being slow
> and hopeless, which in the short term I can't do anything about.
>
> Now, as a understand it the order of packets from my router is...
>
> Radiator receives accounting request
> Radiator writes to database
> Radiator send accounting accept.
>
> If the database query is slow, we suffer from the accounting accept
> taking a long time. This upsets my routers.
>
> Is there any way I can do:
>
> Radiator receives accounting request
> Radiator send accounting accept.
> Radiator writes to database later
>
> I've seen a few mailing list posts about this in the past, but nothing
> that seems to do what I want.
>
> David
> _______________________________________________
> radiator mailing list
> radiator at open.com.au
> http://www.open.com.au/mailman/listinfo/radiator



NB:

Have you read the reference manual ("doc/ref.html")?
Have you searched the mailing list archive (www.open.com.au/archives/radiator)?
Have you had a quick look on Google (www.google.com)?
Have you included a copy of your configuration file (no secrets),
together with a trace 4 debug showing what is happening?
Have you checked the RadiusExpert wiki:
http://www.open.com.au/wiki/index.php/Main_Page

-- 
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows, MacOS X.
Includes support for reliable RADIUS transport (RadSec),
and DIAMETER translation agent.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
-
CATool: Private Certificate Authority for Unix and Unix-like systems.