Duplicate module "sql sql", in file /etc/freeradius/mods-enabled/sql

[rajabu kitindi]

Thanks Alan

I had these settings in my /etc/freeradius/radiusd.conf file under modules
section.

        $INCLUDE mods-enabled/
        $INCLUDE mods-enabled/sql

This was a root cause. So I commented out $INCLUDE mods-enabled/sql to get
it going.

But this way doesn't seem to be working because I have configured a user
defined module   "chillispot_max_bytes" under instantiate section, and when
I run freeradius -X command, I get an error chillispot_max_bytes is an
unknown module. But actually an include statement at the end of
mods-enabled/sqlcounter including a file which contains this contains this
user-defined module. This is how I did it

$INCLUDE ${modconfdir}/sql/counter/mysql/chillispot.conf

When I  open, $INCLUDE ${modconfdir}/sql/counter/mysql/chillispot.conf I
have

sqlcounter chillispot_max_bytes {
counter_name = Max-Total-Octets
check_name = ChilliSpot-Max-Total-Octets
reply_name = ChilliSpot-Max-Total-Octets
reply_message = "You have reached your bandwidth limit"
sql_module_instance = sql
key = User-Name
reset = never
query = "SELECT IFNULL((SUM(AcctInputOctets + AcctOutputOctets)),0) FROM
radacct WHERE username = 'User-Name' AND UNIX_TIMESTAP(AcctStartTime) +
AcctSessionTime > '%%b'"
}

What would be your opinion, should I just create a chillispot_max_bytes
under /etc/freeradius/mods-enabled/?

Or if you have a working cheat sheet on how to integrate coovachilli with
freeradius, that will be appreciated too.

Thanks
Raj



On Sat, Mar 27, 2021 at 4:44 PM Alan DeKok <aland at deployingradius.com>
wrote:

> On Mar 27, 2021, at 9:34 AM, rajabu kitindi <rkitindi at gmail.com> wrote:
> > My config is just
> >
> > sql {
> >
> > }
>
>   Hmm... I suspect there's something more to it than that.
>
> > I downgraded to version 3.0.20 with same config and its working fine.
>
>   We test the SQL module on every code change, including every version
> that's released.
>
>   If you just do:
>
> $ cd raddb/mods-enabled
> $ ln -s ../mods-available/sql
>
>   And then run the server, it works.
>
>   So what else is going on?  What other changes have you made to your
> configuration?
>
>   Post the *full* debug output, including the exact error message.  It
> will tell you which files, and which line numbers have the duplicate
> modules.
>
>   Alan DeKok.
>
>
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html



-- 
MOTD: When we stop to think, we often miss our opportunity