Store session on mysql

Ivan Kalik tnt at kalik.net
Thu Oct 1 14:22:08 CEST 2009


> I currently work with the version 2.1.6 without any problem, session
> of my users are stored in the file "radutmp.
>
> I would store them at the same time in mysql, is this possible?

Yes. Configure sql.conf and uncomment sql entries in radiusd.conf and
accounting section of virtusl server you are using (probably default).

> Is there any page where this is documented?

Try SQL HOWTO on the wiki.

> I want to make a script for my squid server then checks against mysql
> search if the user is connected, compare against a file if it exists
> in that list, take the IP address that you assign and freeradius in
> the squid allows internet access.
>
> Suggestions?

Use (ready-made) captive portal instead.

Ivan Kalik
Kalik Informatika ISP




More information about the Freeradius-Users mailing list