[RADIATOR] refresh time on clientlistsql

[Alexander Hartmaier]

Hi Mike,

I've just done this as a workaround but still think Radiator should
close the database connection between refresh intervals.

Why don't you want to use CPAN modules?
You can ship known working versions bundled with Radiator.

--
Best regards, Alex


On Thu, 2010-10-28 at 23:31 +0200, Mike McCauley wrote:
> Hello Alexander,
>
> maybe you could reduce the RefreshPeriod in your ClientListSQL to less than an
> hour (or whatever the retain time is in the firewall is) so the SQL session
> stays up?
>
> Cheers.
>
> On Friday 29 October 2010 12:36:02 am Alexander Hartmaier wrote:
> > Still happens with newest DBI and DBD::Oracle.
> > I assume radiator doesn't close the db connection and a firewall removes
> > it from its state table which leads to dropped packets after an hour
> > when radiator tries to use the db connection again.
> >
> > You might want to look into DBIx::Connector which handles some problems
> > automatically.
>
>
>


*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*
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.
*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*