Re: Adding a NAS via SQL

2007-07-28 Thread Paul Lambert
Ram, ty for the response, It doesn't seem to be having an effect until I restart the server. I know I have set this up in the past with no issues, is there anything obvious I could be missing? I will take a look again and if I am still having problems post the server debug etc. Paul. On

Re: Adding a NAS via SQL

2007-07-28 Thread Paul Lambert
OK, I was using 2.0.0 pre1, so decided to go back to 1.1.7. I have attached the output of radiusd -X. From this output, I can see the radius server is reading the NAS table in my MySQL database on startup, but not again after that. The order of events: I started radiusd -X with the entry for

Re: Adding a NAS via SQL

2007-07-28 Thread Peter Nixon
On Fri 27 Jul 2007, Paul Lambert wrote: Hi all, I think I might be being a little dense but when I add a NAS to my SQL database, it doesn't appear to be enabled until I restart my radius server. Yep. Thats to way it's designed to protect against DoS attacks, otherwise every inbound packet

Re: Adding a NAS via SQL

2007-07-28 Thread Paul Lambert
Thanks, I thought I might have been going crazy!!! I however just tried hitting radiusd with a SIGHUP and it really didn't like it Output attached, I just got a segfault when I hit it with the next radius request. Is there a cleaner way to make it re-read the nas list? TIA Paul. On

Re: Adding a NAS via SQL

2007-07-28 Thread Peter Nixon
Paul All of these questions have been discussed MANY times on the list. Please check the archives.. Peter On Sat 28 Jul 2007, Paul Lambert wrote: Thanks, I thought I might have been going crazy!!! I however just tried hitting radiusd with a SIGHUP and it really didn't like it Output

Re: Adding a NAS via SQL

2007-07-28 Thread Paul Lambert
Peter, Please accept my apologies for wasting your time. Paul On 7/28/07, Peter Nixon [EMAIL PROTECTED] wrote: Paul All of these questions have been discussed MANY times on the list. Please check the archives.. Peter On Sat 28 Jul 2007, Paul Lambert wrote: Thanks, I thought I

Re: Adding a NAS via SQL

2007-07-28 Thread Paul Lambert
Hi, I have now taken a look through the archives and I can't see a clean solution for reloading the nas without restarting. I assume this is what you were suggesting I do via cron? Paul. On 7/28/07, Paul Lambert [EMAIL PROTECTED] wrote: Peter, Please accept my apologies for wasting your

Re: Adding a NAS via SQL

2007-07-28 Thread Alan DeKok
Paul Lambert wrote: I have now taken a look through the archives and I can't see a clean solution for reloading the nas without restarting. I assume this is what you were suggesting I do via cron? Yes. Unfortunately, *no* application daemon I've looked at handles HUP very well. Almost

Re: Auth-Type in post-auth SQL insert

2007-07-28 Thread Alan DeKok
Brad Robel-Forrest wrote: I've successfully configured FreeRADIUS to use a SQL driver for authentication checks Huh? SQL doesn't do authentication. If you *can* list sql in the authenticate section, it's because you've edited the source. Don't do that. Is there a runtime variable

Re: Adding a NAS via SQL

2007-07-28 Thread Peter Nixon
On Sat 28 Jul 2007, Paul Lambert wrote: Hi, I have now taken a look through the archives and I can't see a clean solution for reloading the nas without restarting. I assume this is what you were suggesting I do via cron? Yep.. The short answer is that FreeRADIUS does not currently reload the