FreeRADIUS and Postgres annoyance

Santiago Balaguer García santiagoawa at
Tue Aug 29 13:11:06 CEST 2006

Anyway, in some aspect freeradius can improve.
I use nas table and it works fine. Obviously, I must reboot my RADIAS 
servers when I insert a new NAS client and it is a problem.

I afirm that 'realm' table is userless. I trid to configure lot of times 
without success.

>From: "Gregory J. Marsh" <marshg at>
>Reply-To: marshg at,        FreeRadius users mailing 
>list<freeradius-users at>
>To: "'FreeRadius users mailing list'" 
><freeradius-users at>
>Subject: RE: FreeRADIUS and Postgres annoyance
>Date: Tue, 8 Aug 2006 11:24:24 -0400
>I have the nas table working.  Here's what you might need to know:
>1) You don't configure it in radiusd.conf, you configure it in sql.conf --
>look at the last few lines of the sample.
>2) The documentation is wrong.  Look at the sql query and the schema of the
>table.  They don't agree.  I wrote my query to match my needs and made the
>schema match that.
>3) You must still have at least one entry in the clients.conf file.  I just
>put in a dummy for the local machine.
>4) On boot, FreeRadius starts before PostgreSQL is ready sometimes.  So, I
>put a delay in the FreeRadius start.  I'll do something better later.
>Now if I can get the radius.log written to sql instead of a file, I'll be
>100% sql which is what I really need.
>-----Original Message-----
>From: at
>[ at]
>On Behalf Of Joe Warren-Meeks
>Sent: Tuesday, August 08, 2006 9:53 AM
>To: FreeRadius users mailing list
>Subject: Re: FreeRADIUS and Postgres annoyance
>Sorry guys, my fault.. mainly permissions problems on the relevant
>tables in postgres.
>Although I haven't got the nas table working yet though, so pointers
>there will help..
>(moral of the story, tcpdump -w out.dmp -A -nvi eth0 -s0 port 5432
>plus ethereal is a good thing.)
>   -- joe.
>Joe Warren-Meeks                       T: +44 (0) 208 962 0007
>Aggregator Ltd.                        M: +44 (0) 7789 176 078
>Unit 62/63 Pall Mall Deposit           F: +44 (0) 208 962 0008
>124-128 Barlby Road, London W10 6BL
>PGP:        361F 78D0 56F5 8D7F 2639  947D 71E2 8811 F825 64CC
>List info/subscribe/unsubscribe? See
>List info/subscribe/unsubscribe? See 

Acepta el reto MSN Premium: Protección para tus hijos en internet. 
Descárgalo y pruébalo 2 meses gratis.

More information about the Freeradius-Users mailing list