Re: hang with mysql in execute

2005-03-24 Thread Chris Masters
Hi All, The 'proper' solution IMO is Peter's first suggestion. The firewall is doing it's job and forced wrapper timeouts can be a bit of a bodge. We're lowering the inactivity timeout on our data source servers (MySQL and openLDAP - we're seeing the same thing on both connections) to around 5 mi

Re: hang with mysql in execute

2005-03-23 Thread Chris Masters
n just hung. > > I've emailed my work mate to find out if he found a > work around. Perhaps a > post on perl monks is what's required here. > > HTH > Cheers > Tony > > >From: Chris Masters <[EMAIL PROTECTED]> > >To: dbi-users@perl.org > >

Re: hang with mysql in execute

2005-03-23 Thread Chris Masters
Is the lack of response because this is a stupid question related to an extensively documented problem or does no one else have experience of this issue? Anyone? Thanks, Chris --- Chris Masters <[EMAIL PROTECTED]> wrote: > Hi All, > > A firewall is terminating my connecti

hang with mysql in execute

2005-03-19 Thread Chris Masters
Hi All, A firewall is terminating my connection with a mysql database after a period of inactivity. I've used the following code (with ref to cpan docs and connect) and it still causes a hang. ### my $result = 0; my $alarm = 0; eval { #set alar