(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 <hugh at open.com.au> 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 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.
>
>
> __________________________________
> 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 radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.