And still... no success... logs shows...
[LOG]
rlm_sql: Released sql socket id: 4
modcall[authorize]: module "sql" returns ok
rlm_counter: Entering module authorize code
rlm_counter: Could not find Check item value pair
modcall[authorize]: module "counter" returns noop
users: Matched DEFAULT at 144
users: Matched DEFAULT at 173
modcall[authorize]: module "files" returns ok
[LOG]
do I still have to touch some of the configs?
----- Original Message -----
From: "Kostas Kalevras" <[EMAIL PROTECTED]>
To: "Ker Ruben Ramos" <[EMAIL PROTECTED]>
Sent: Friday, December 28, 2001 1:29 AM
Subject: Re: using rlm_counter and sql
> On Fri, 28 Dec 2001, Ker Ruben Ramos wrote:
>
> > I tried something what you told me... but at no success... when starting
> > radiusd...
> > [LOG]
> > Fri Dec 28 13:30:52 2001 : Error: /opt/usr/local/etc/raddb/users[206]:
Parse
> > error (check) for entry DEFAULT: Unknown attribute Max-Monthly-Session
> > Fri Dec 28 13:30:52 2001 : Error: Errors reading
> > /opt/usr/local/etc/raddb/users
> > Fri Dec 28 13:30:52 2001 : Error: radiusd.conf[463]: files: Module
> > instantiation failed.
> > [LOG]
>
> Try doing this in radiusd.conf:
>
> authorize{
> counter
> files
> }
>
> Meaning, put files after counter. I made a mistake in my previous mail
>
> --
> kkalev
>
> >
> > ----- Original Message -----
> > From: "Ker Ruben Ramos" <[EMAIL PROTECTED]>
> > To: "Ker Ruben Ramos" <[EMAIL PROTECTED]>
> > Sent: Friday, December 28, 2001 12:26 PM
> > Subject: Fw: using rlm_counter and sql
> >
> >
> > >
> > > ----- Original Message -----
> > > From: "Kostas Kalevras" <[EMAIL PROTECTED]>
> > > To: <[EMAIL PROTECTED]>
> > > Sent: Thursday, December 27, 2001 1:11 PM
> > > Subject: Re: using rlm_counter and sql
> > >
> > >
> > > > On Fri, 28 Dec 2001, Ker Ruben Ramos wrote:
> > > >
> > > > > as what it is... mysql queries do values are using '=' .. not
> > greater(>)
> > > or
> > > > > less(<) than.. right?
> > > > >
> > > >
> > > > You can also use the check-name config directive. This directive
defines
> > > an
> > > > attribute containing the maximum allowed limit (monthly,weekly etc).
> > That
> > > way
> > > > you can add this attribute in the users file (to match all users) or
in
> > > the user
> > > > entries in sql (after applying the patch).
> > > >
> > > > radiusd.conf:
> > > >
> > > > counter {
> > > > filename = ${raddbdir}/db.counter
> > > > key = User-Name
> > > > count-attribute = Acct-Session-Time
> > > > reset = "daily"
> > > > counter-name = Daily-Session-Time
> > > > check-name = Max-Daily-Session
> > > > ^^^^^^^^^^^^
> > > >
> > > > authorize{
> > > > [...]
> > > > files
> > > > counter
> > > > }
> > > >
> > > > users file:
> > > >
> > > > DEFAULT Auth-Type := SQL, Max-Daily-Session = 36000
> > > >
> > > > Just make sure that the counter initialization directives are before
> > > rlm_files
> > > > (users file) module. That way rlm_counter can add the
Max-Daily-Session
> > to
> > > the
> > > > freeradius schema and have rlm_files know about it.
> > > >
> > > > --
> > > > kkalev
> > > >
> > > >
> > > > -
> > > > List info/subscribe/unsubscribe? See
> > > http://www.freeradius.org/list/users.html
> > >
> >
> >
> >
> >
> > -
> > List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html
> >
>
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html