(RADIATOR) How to make to SQL querys out of one ClearNasQuery?

[Hugh Irvine]

Hello Toomas -

If your database supports stored procedures, you could use that.

Otherwise you can set up a Handler for this specific case, and use multiple 
AcctSQLQueries in an AuthBy SQL clause.

regards

Hugh


On Wed, 13 Mar 2002 23:43, Toomas Kärner wrote:
> Hi,
>
> My problem is that I cant find a way to execute two SQL querys because of
> single accounting-on or accounting-off packet. Wher the box goes down or
> comes up everything works with session database (it get's cleared) but I
> want to have that  message also in the user accounting log table. We are
> planning to start counting time and  then if the box goes down and  I have
> only start records then, I can't count anything because that message is not
> in the log. As I tried and as it was writen in here ";" between the querys
> doesn't help. Only way to do it is in some sord of PreClientHook but I'm
> afraid of the impact to preformance (because this is executed on every
> incomeing packet - the longer it is .... the slower it is ....).
>
>
> Rgds.
>
> Toomas Kärner
>
>
> ===
> 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.

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

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