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@deployingradius.com> wrote:
On Mar 27, 2021, at 9:34 AM, rajabu kitindi <rkitindi@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