alienoid wrote:
> Hello freeradius-users,
hi,
> RH7.2 + freeradius-0.6 + Oracle
>
> I've compiled freeradius with --with-experimantal-modules and set up
> it with sql auth/acct.
>
> In radiusd.conf wrote:
>
> sqlcounter hourlycounter {
> counter-name = SQL_Max_Hour_Session_Timeout
> check-name = SQL_Max_Hour
> sqlmod_inst = sql
> key = User-Name
> query = "SELECT SUM(AcctSessionTime) FROM radacct WHERE
> username='%{%k}'"
> reset = none
> }
may be 'reset = never',
if not, didn't you forget to put hourlycounter in the authorization
section ?
> I did so (tried to convert) with table radcheck:
> test User-Password xxxx :=
> test SQL_Max_Hour 36000 >
> test Auth-Type Reject :=
i think the operator should be ':=' instead of '>' ...
cheers,
@+
--
DouRiX \\\|///
___ \\ - - // ____ ___ __
| _ oOOo_@ @_oOOo| _ \(_) \/ /
| | | |/ _(_) | | | |_| ) |\ /
| |_| | (_) | |_| | _ <| |/ \
|____/ \___/ \_Ooooo| \_\_/_/\_\
f u cn rd ths u r usng unx
ooooO ) /
( ) (_/
\ (
\_)
[Never be afraid to try something new. Remember, amateurs built the
ark,
and professionals built the Titanic.]
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
