Subject Re: [firebird-support] Firebird on Linux - KeepAlive?
Author Steve Wiser
Are you using Classic with xinetd?

-steve

Myles Wakeham wrote:
>
> We have a number of Firebird servers that run on both Windows and Fedora
> Linux boxes. One of the major differences between these server
> environments
> that we have noticed is the security level on Linux in regards to TCP/IP
> client connections on its ports.
>
> A recent update to Linux that our servers got increased the resillience to
> client TCP port connections, by forcing the connection to be dropped
> after a
> certain amount of inactivity (it appears to be about 10 minutes from our
> experience). I've tried to find out from various Linux forums if this is
> something that can be controlled at the server level by port number, but
> haven't had much luck in determining what exactly is policing this.
>
> In the case of Firebird, its causing any software that is a 'client'
> to the
> Firebird server (such as any Delphi applications we write, or IBExpert or
> other 3rd party admin tools) to lock up when the 10 minutes of inactivity
> has occurred. I was thinking that we can't be the only folks being
> affected
> by this, and although some people in the Linux community have told us that
> we should send some form of 'Keep Alive' message from the client to the
> server to stop this, it would appear that this is a bandaid to what
> could be
> simply a setting in Linux security to stop this.
>
> Our experience with products like IBExpert is that when the Linux server
> decides to close the port due to inactivity, the software (at least the
> version we have) is not handling this very well at all, crashing, causing
> exceptions, etc. This may have been addressed with a later update than
> what
> we have but the problem is not limited to that product at all. Its
> going to
> affect any client software we develop that works with Firebird, where the
> user sits idle for 10 minutes and then attempts another query, etc.
>
> What strategies have others used to get around this issue? Is there
> something simple that I need to set that I'm overlooking?
>
> Thanks in advance for any suggestions or advice.
>
> Myles
>
> ===============================
> Myles Wakeham
> Director of Engineering
> Tech Solutions USA, Inc.
> Scottsdale, Arizona USA
> www.techsolusa.com
> Phone +1-480-451-7440
>
>