Hello Ferhat,
On Apr 22, 1:54pm, Ferhat Dilman wrote:
> Subject: (RADIATOR) ACCTSESSIONTIME into Another Table
> Hi,
>
> I would like to run the command like this:
>
> AcctSQLStatement update LIMITSUBS \
> set expiredate=sysdate+totaldays,activeor=1,\
> totalsession=totalsession+acctsessiontime \
> where username='%n' and activeor=0
>
> However it does not get the ACCTSESSIONTIME into this SQL statement thus
> gives error.
>
> Any ideas to handle this? I would like to run this command everytime user
> disconnects.
Use %{Acct-Session-Time} in your AcctSQLStatement, and it will be replaced by
the Acct-Session-Time from the incoming request. Dont forget to set
AccountingStopsOnly too, otherwise you will get the statment executed for the
Starts.
--
Mike McCauley [EMAIL PROTECTED]
Open System Consultants Pty. Ltd Unix, Perl, Motif, C++, WWW
24 Bateman St Hampton, VIC 3188 Australia http://www.open.com.au
Phone +61 3 9598-0985 Fax +61 3 9598-0955
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, external, etc etc on Unix, Win95/8, NT, Rhapsody
===
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
