You need to add the sql counter for it like:
$INCLUDE ${confdir}/sql.conf
sqlcounter noresetcounter {
counter-name = Max-All-Session-Time
check-name = Max-All-Session
sqlmod-inst = sql
key = User-Name
reset = never
query = "SELECT SUM(AcctSessionTime) FROM radacct WHERE
UserName='%{%k}'"
}
I am adding my radiusd.conf file to: http://jabali.net/~carl/?link=2
as there are other entries that you need to add. You may have to compile
--with-experimental-modules so that you get the sql counters. Others on this
list might be able to enlighten us on that. I tried it with the rlm-sql
counters but they caused a segfault on authentication.
Carl Peterson
On Tuesday 28 December 2004 09:26, Bruno Machado wrote:
> Hi
>
> I tried to use this files but it didnt work. The
> parameter "Max-All-Session" isnt know by the radius.
> What dictionary I need to use? I didnt find this
> keyword at any dictionaries...
> Thanks for any help.
>
> Bruno
>
> --- Carl Peterson <[EMAIL PROTECTED]> escreveu:
> > How would I implement this?
> > What I need is to add something like
> > WISPr-Session-Terminate-Time with a Value
> > of 24 hours from first use after their first use.
> > Of course it needs to be
> > added as soon as they log in the first time, or
> > actually before, perhaps in
> > pre-auth so that their first session isn't
> > indefinite. Any ideas?
> >
> > Carl
> >
> > On Monday 27 December 2004 17:46, Thor Spruyt wrote:
> > > Carl Peterson wrote:
> > > > I am working on writing it as we speak. Current
> >
> > release is
> >
> > > > phpMyPrepaid-0.1.2. It actually works with a
> >
> > MySQL database and
> >
> > > > inserts the users into the radcheck table.
> >
> > Hourly cards work but I
> >
> > > > haven't figured out the post-auth stuff in
> >
> > Freeradius for daily cards
> >
> > > > yet. You can grab the current release off of my
> >
> > development server
> >
> > > > at: http://cpete.com/prepaidAdmin/ I am moving
> >
> > things over to
> >
> > > > http://jabali.net/~carl this week. All new
> >
> > releases, changelogs, etc
> >
> > > > will be hosted there.
> > >
> > > I read something about using Post-Auth for setting
> >
> > expiration date/time.
> >
> > > In my opinion, the Accounting-Start should be used
> >
> > for this purpose, since
> >
> > > an authentication doesn't neccessarily mean a
> >
> > session!
> >
> > -
> > List info/subscribe/unsubscribe? See
> > http://www.freeradius.org/list/users.html
>
> _______________________________________________________
> Yahoo! Acesso Grátis - Instale o discador do Yahoo! agora.
> http://br.acesso.yahoo.com/ - Internet rápida e grátis
>
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
