NAS info + MySQL

[Marcin Jessa]

Hi.

On Mon, 06 Jun 2005 14:48:22 -0400
"Alan DeKok" <aland at ox.org> wrote:

> Marcin Jessa <lists at yazzy.org> wrote:
> > I noticed when I add new NAS servers to SQL on a running radius server, they will not be used before the radius server is restarted.
> > Is that a case or am I mistaken here?
> 
>   You can send a HUP signal to th eserver.
That would require apache to have access to the radius deamon when using a web-based interface.
Even worse, it'd be pretty much impossible to write an secure GUI application to remotely access freeradius and make it reread the data stored in SQL since activating the changes made in the nas table will require sending HUP signal to the server. 
Maybe a wrapper for that could fix it but IMHO it's not a very "elegant" solution.


> > If that's the case, how will restarting radius affect user's
> >  accounting info?
> 
>   It won't.
> 
> > What will happen with the accounting info of an already loged in
> > user, will it get synced when the radius server is started again?
> 
>   What do you mean "get synced"?  If you put the accounting
> information in SQL, the server will have access to it.

I mean, if a user is loged in and the user's accouting information cannot be stored in the database becouse the radius daemon was not accessible by a NAS. 
Will the accounting information from the time when the radius wasn't running get appended to the old information (before radius got HUP'ed) ?

> > Is there a way to make radius automatically read new entries added
> > to the nas table ?
> 
>   Source code modifications.
Can this be added to the todo list?


>   Alan DeKok.
> - 
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html