Re: Keepalives (was Sybase disconnect after idle)

Michelle Dupuis <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <[email protected]>
I installed freetds from rpm (on CentOS 5.7) so not sure if that was compiled in by whomever created the package.

When does .92 come out?
________________________________________
From: [email protected] [[email protected]] On Behalf Of Frediano Ziglio [[email protected]]
Sent: Thursday, February 23, 2012 2:41 PM
To: FreeTDS Development Group
Subject: Re: [freetds] Keepalives (was Sybase disconnect after idle)

2012/2/23 Michelle Dupuis <[email protected]>:
> It looks like the problem is the OS or a firewall is terminating the connection after lengthy idle periods on the client.
>
> A google search turned up a patch to freetds with "keepalive" settings (back in 2008) but I haven't seen mention of it since.
>
> Did this patch make it into freetds 0.91 ?  If so, can I just set "keepalive interval 600" in my freetds.conf ?
>
> Thanks!

>From my code KEEPALIVE is set in 0.91 and 0.92 by these rows in src/tds/net.c

#ifdef SO_KEEPALIVE
        len = 1;
        setsockopt(tds->s, SOL_SOCKET, SO_KEEPALIVE, (const void *)
&len, sizeof(len));
#endif

perhaps for some reasons SO_KEEPALIVE is not defined ??

Frediano
_______________________________________________
FreeTDS mailing list
[email protected]
http://lists.ibiblio.org/mailman/listinfo/freetds
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.