Ok I have found the problem.
Under
authorize {
....
noresetcounter
sql
..... }
and it should be in different order
first sql and then noresetcounter.
Thank you very much for your help and time.
Reagrds,
Bartosz
----- Original Message -----
From: "Julius Igugu" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, July 07, 2004 1:40 PM
Subject: Re: rlm_sqlcounter question
> raddb/sqlcounter.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}'"
> }
>
> -------- SNIP --------
>
> radiusd.conf
>
> -------- SNIP --------
> modules {
> # some other stuff here
> #
> $INCLUDE ${confdir}/sql.conf
> $INCLUDE ${confdir}/sqlcounter.conf
> # some other stuff here
> }
>
> authorize {
> #
> # some other stuff here
> #
> # Enforce daily limits on time spent logged in.
> # daily
> noresetcounter
> #
> # some other stuff here
> #
> }
> ------- SNIP --------
>
> I think that's all I changed to get it working.
>
> --- Bartosz Jozwiak <[EMAIL PROTECTED]> wrote:
> > Yes I have set Max-All-Session to 60 seconds
> > in mysql radcheck.
> > I use 1.0.0pre3 on Debian (Woody)
> >
> > Please could you provide me your configuration files so I can compare
> > it.
> > It will be very heplful. Becuase I cannot find anything eals... :(
> >
> > Bartosz
> >
> >
> > > Sorry, you don't set the Sessiun-Timeout, you set the
> > Mas-All-Session,
> > > the server calculates the session-timeout.
> > >
> > > Do this:
> > >
> > > > INSERT into radcheck VALUES
> > > ('','test0001','Max-All-Session','54000',':=');
> > >
> > > Where 'test0001' is the username and '54000' is the number of
> > seconds
> > > of total online time.
> > >
> > >
> > > --- Bartosz Jozwiak <[EMAIL PROTECTED]> wrote:
> > > >
> > > >
> > > >
> > > > > Did you set 'Session-Timeout := ???' for the account?
> > > >
> > > > I have tryed it just now with Session-Timeout and I have tryed
> > > > without.
> > > > Still the same problem.
> > > >
> > > > >
> > > > > And did you follow the instructions in doc/rlm_sqlcounter?
> > > >
> > > > Yes I have followed instructions from doc/rlm_sqlcounter.
> > > > I have searched archives and a lot of peoples has problem with
> > the
> > > > same
> > > > error
> > > > but there is no solution.
> > > > Can somebody help ? Please...
> > > >
> > > > Bartosz
> > > >
> > > > >
> > > > > --- Bartosz Jozwiak <[EMAIL PROTECTED]> wrote:
> > > > > > Ok I have managed to configure rlm_sqlcounter but I get
> > > > > > fallowing error while login:
> > > > > >
> > > > > > rlm_sqlcounter: Entering module authorize code
> > > > > > rlm_sqlcounter: Could not find Check item value pair
> > > > > > modcall[authorize]: module "noresetcounter" returns noop
> > for
> > > > > > request 0
> > > > > >
> > > > > > How I can fix it ?
> > > > > > I have seen it in archives of mailing list but I could not
> > solve
> > > > the
> > > > > > problem.
> > > > > >
> > > > > > Bartosz
> > > > > >
> > > > > > > > I would like to set up following configuration:
> > > > > > > >
> > > > > > > > I am trying to set up prepaid solution for dialup
> > customers.
> > > > > > > > Some accounts in radius should be allowed to login (total
> > > > time on
> > > > > > line)
> > > > > > > > for
> > > > > > > > 60 minutes.
> > > > > > > > Some accounts in should be configured to login (total
> > time on
> > > > > > line) 30
> > > > > > > > minutes.
> > > > > > > > This "time on-line" should never be cleard or renew (no
> > dail,
> > > > no
> > > > > > monthly
> > > > > > > > etc...).
> > > > > > > > But when customer whats to by more "time on-line" I can
> > > > change it
> > > > > > in
> > > > > > > > database (recharge his account)
> > > > > > > >
> > > > > > > > Is such a configuration possible with rlm_sqlcounter ?
> > > > > > > yes it is possible. my advise for you to read more of
> > > > > > rlm_sqlcounter and
> > > > > > > other
> > > > > > > freeradius attributes.more help are existing with the
> > mailling
> > > > > > list, just
> > > > > > > dig more of it.
> > > > > > > //milver
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > -
> > > > > > > List info/subscribe/unsubscribe? See
> > > > > > http://www.freeradius.org/list/users.html
> > > > > > >
> > > > > >
> > > > > >
> > > > > > -
> > > > > > List info/subscribe/unsubscribe? See
> > > > > > http://www.freeradius.org/list/users.html
> > > > > >
> > > > >
> > > > >
> > > > > =====
> > > > > Julius Igugu
> > > > > SouthWork Co. Ltd.
> > > > >
> > > > >
> > > > >
> > > > > __________________________________
> > > > > Do you Yahoo!?
> > > > > Yahoo! Mail - 50x more storage than other providers!
> > > > > http://promotions.yahoo.com/new_mail
> > > > >
> > > > > -
> > > > > List info/subscribe/unsubscribe? See
> > > > http://www.freeradius.org/list/users.html
> > > > >
> > > >
> > > >
> > > > -
> > > > List info/subscribe/unsubscribe? See
> > > > http://www.freeradius.org/list/users.html
> > > >
> > >
> > >
> > > =====
> > > Julius Igugu
> > > SouthWork Co. Ltd.
> > >
> > >
> > >
> > > __________________________________
> > > Do you Yahoo!?
> > > Yahoo! Mail is new and improved - Check it out!
> > > http://promotions.yahoo.com/new_mail
> > >
> > > -
> > > List info/subscribe/unsubscribe? See
> > http://www.freeradius.org/list/users.html
> > >
> >
> >
> > -
> > List info/subscribe/unsubscribe? See
> > http://www.freeradius.org/list/users.html
> >
>
>
> =====
> Julius Igugu
> SouthWork Co. Ltd.
>
>
>
> __________________________________
> Do you Yahoo!?
> New and Improved Yahoo! Mail - Send 10MB messages!
> http://promotions.yahoo.com/new_mail
>
> -
> List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html
>
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
