[RADIATOR] Updating Session Timeout Max-Hourly

[SimonM123]

Hi

If I've posted this twice, I'm sorry - couldn't find the email I sent
yesterday.

We're using the Max-All and Max-Daily session in a customised sql.cfg.


        AuthColumnDef     0,User-Password, check
        AuthColumnDef     1,Max-Daily-Session,check
        AuthColumnDef     2,Session-Timeout,reply


        AuthSelect select PASSWORD, MAXDAILYSESSION, SESSIONTIMEOUT from
SUBSCRIBERS where USERNAME=%0


        AcctTotalQuery SELECT SUM(AcctSessionTime) FROM ACCOUNTING WHERE
UserName=%0

        AcctTotalSinceQuery SELECT SUM(AcctSessionTime - GREATEST((%1 -
UNIX_TIMESTAMP(AcctStartTime)), 0)) FROM ACCOUNTING WHERE UserName=%0 AND
UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > %1

       AcctSQLStatement update SUBSCRIBERS set SESSIONTIMEOUT =
SESSIONTIMEOUT - 0%{AcctTotalSinceQuery} where USERNAME='%n'

The last one I thought might decrease the session timeout on successful auth
but it's not working.

What's the best way to do this?

S

-- 
View this message in context: http://old.nabble.com/Updating-Session-Timeout-Max-Hourly-tp32729878p32729878.html
Sent from the Radiator - General mailing list archive at Nabble.com.