Socket not connected error on SSL connections

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
jkucera
Posts: 10
Joined: Wed 27 Jun 2007 08:39

Socket not connected error on SSL connections

Post by jkucera » Mon 27 Jul 2009 19:33

I have found strange behaviour with SSL connections (using the last version of Postgresql provider). I connect to a remote Postgresql server and without SSL it works fine. Whet I turn the SSL on, it works only if I work "very quickly", ie when I do make some sort of database communication every few seconds. If I am idle for some 10 seconds or even less, the error "Socket not connected" appears. This behaviour occurs when using connection pooling. Without it, it works fine, but the overall performace is slow due to the fact that I use connecion.open, some action, connection.close approach.
It seems to me that normal connections are kept alive while SSL are not. Is it a bug or a matter of tweaking the pool or TCPIP stack?
Thanks for reply.

Shalex
Site Admin
Posts: 8239
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Wed 29 Jul 2009 13:47

We have reproduced the problem. We will investigate it and notify you about the results as soon as possible.

Shalex
Site Admin
Posts: 8239
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Fri 31 Jul 2009 12:30

As a temporary workaround, please add to your connection string the Connection Timeout=0; entry.

Shalex
Site Admin
Posts: 8239
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Tue 11 Aug 2009 08:01

The "SSL socket not connected" bug is fixed in the latest 4.55.39 version of dotConnect for PostgreSQL. Please try it.

Post Reply