[RADIATOR] refresh time on clientlistsql

[Mike McCauley]

Hello Alexander,

A recent patch caused a problem that probably would have affected timeouts in 
ClientListSQL . A more recent patch has fixed that. What patch level are you 
at?

Cheers.

On Saturday 09 October 2010 03:24:09 am Alexander Hartmaier wrote:
> Hi Hugh,
>
> we started to use the ClientListSQL feature too but get an Oracle SQL
> timeout error in the logs whenever Radiator tries to refresh the list,
> works on startup.
>
> Any idea why and how we can debug this?
>
> --
> Best regards, Alex
>
> Am Mittwoch, den 22.09.2010, 00:25 +0200 schrieb Hugh Irvine:
> > Hello Alex -
> >
> > See section 5.7.3 in the Radiator 4.7 reference manual ("doc/ref.pdf").
> >
> > regards
> >
> > Hugh
> >
> > On 22 Sep 2010, at 05:01, Martin Burton wrote:
> > > Hi Alex,
> > >
> > > You need to make sure that RefreshPeriod is set in your config file. 
> > > It defaults to 0, which means the SQL query is performed only upon
> > > radiusd start or when it's sent a SIGHUP.
> > >
> > > <ClientListSQL>
> > >     .
> > >     .
> > >     .
> > >     RefreshPeriod 300
> > >     .
> > >     .
> > >     .
> > > </ClientListSQL>
> > >
> > > would cause the the DB to be requeried every 5 minutes for example.
> > >
> > > Hope that helps.
> > >
> > > Cheers,
> > >
> > > Martin.
> > >
> > > On 21/09/2010 19:41, Alex Sharaz wrote:
> > >> Hi all,
> > >>
> > >> I've got a cluster of radius servers all configured to read NAS
> > >> clients from a db2 database. I thought that radiator was supposed to
> > >> periodically refresh its internal list of clients by rereading the
> > >> database.
> > >>
> > >> Yesterday morning I dded a number of clients to the database. by 16:00
> > >> today  the radius servers still hadn't picked up the new clients.  A
> > >> reload caused radiator to reread the client list but it would have
> > >> been nice to have radiator pic up the new clients automagically.
> > >>
> > >> Anyone else seen problems with refreshing client lists?
> > >>
> > >> Rgds
> > >> Alex
> > >>
> > >>
> > >>
> > >>
> > >>
> > >>
> > >> Checked by  Hu-fw-yhman
> > >>
> > >>
> > >>
> > >> _______________________________________________
> > >> radiator mailing list
> > >> radiator at open.com.au
> > >> http://www.open.com.au/mailman/listinfo/radiator
> > >
> > > --
> > > Martin Burton
> > > Senior Systems Administrator               \\\|||///
> > > Special Projects Team                     \\  ^ ^  //
> > > Wellcome Trust Sanger Institute            (  6 6  )
> > > -----------------------------------------oOOo-(_)-oOOo---
> > >
> > >
> > > _______________________________________________
> > > radiator mailing list
> > > radiator at open.com.au
> > > http://www.open.com.au/mailman/listinfo/radiator
> >
> > NB:
> >
> > Have you read the reference manual ("doc/ref.html")?
> > Have you searched the mailing list archive
> > (www.open.com.au/archives/radiator)? Have you had a quick look on Google
> > (www.google.com)?
> > Have you included a copy of your configuration file (no secrets),
> > together with a trace 4 debug showing what is happening?
>
> *"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*
>"* T-Systems Austria GesmbH   Rennweg 97-99, 1030 Wien
> Handelsgericht Wien, FN 79340b
> *"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*
>"* Notice: This e-mail contains information that is confidential and may be
> privileged. If you are not the intended recipient, please notify the sender
> and then delete this e-mail immediately.
> *"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*
>"* _______________________________________________
> radiator mailing list
> radiator at open.com.au
> http://www.open.com.au/mailman/listinfo/radiator



-- 
Mike McCauley                               mikem at open.com.au
Open System Consultants Pty. Ltd
9 Bulbul Place Currumbin Waters QLD 4223 Australia   http://www.open.com.au
Phone +61 7 5598-7474                       Fax   +61 7 5598-7070

Radiator: the most portable, flexible and configurable RADIUS server 
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, 
Platypus, Freeside, TACACS+, PAM, external, Active Directory, EAP, TLS, 
TTLS, PEAP, TNC, WiMAX, RSA, Vasco, Yubikey, MOTP, HOTP, TOTP,
DIAMETER etc. Full source on Unix, Windows, MacOSX, Solaris, VMS, NetWare etc.