Re: (RADIATOR) query during insert data

[Hugh Irvine]

Hello Budi -

Can you please send me a copy of your configuration file (no secrets) 
together with a trace 4 debug from Radiator showing what is happening. 
I will also need to see a copy of the relevant SQL records.

In general you should test your SQL queries interactively with whatever 
tools are available with your database before trying to use them in the 
Radiator configuration file.

regards

Hugh

On Thursday, Jun 12, 2003, at 17:40 Australia/Melbourne, budi wibowo 
wrote:

i have tried to add this
AcctSQLStatement update set
time_bill=ceiling(%{Acct-Session-Time}/30)
or
AcctSQLStatement update set
time_bill=ceiling('%{Acct-Session-Time}'/30)
after that i make call for 5 seconds
then check at mysql and got 0 it should be 1
any idea?

rgds

budi

--- Hugh Irvine <[EMAIL PROTECTED]> wrote:
Hello Boed -

You should have a look at the AuthBy SQL clause in
section 6.28 in the
Radiator 3.6 reference manual.
	"doc/ref.html"

You can use the AuthSQLStatement to insert during
authentication and
you can use the AcctSQLStatement to insert during
accounting (you can
also have multiple instances).
regards

Hugh

On Wednesday, Jun 11, 2003, at 18:55
Australia/Melbourne, budi wibowo
wrote:
can i do mysql query during data insertion?
i have read a litle about SessionDatabase keyword
but
the information is not detail enough
any idea?
rgds

boed



__________________________________
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync
to Outlook(TM).
http://calendar.yahoo.com
===
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.

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 [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.


__________________________________
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com

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 [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.