Store session on mysql

[Michel Bulgado]

On Thu, 2009-10-01 at 13:22 +0100, Ivan Kalik wrote:
> > 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
> 
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Hello Ivan 

I set the parameters sql.conf database mysql In this case, I am
currently doing the accounting on it. 

I went to this uncommented radiusd.conf and $ INCLUDE sql.conf 

and the accounting section in my virtual server is: 

- radutmp and sql 

only need to add in the section "session"? 

In which table stores the session when the user connects? 

to set my script to check my squid server from which the user is
connected and take the IP address that I assign my nas? 

the stored user name and IP address assigned by the NAS in the database?