(RADIATOR) query during insert data

budi wibowo bu1d at yahoo.com
Thu Jun 12 02:40:27 CDT 2003


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


More information about the radiator mailing list