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