Connection resets on PgSqlAlerter.Start() without SSL options

Connection resets on PgSqlAlerter.Start() without SSL options

Postby belidzs » Wed 19 Mar 2014 23:35

I'm using dotConnect for PostgreSQL 5.0.449.0 with PostgreSQL server 9.1.
I have a PgSqlDataSet which connects to my server through a shared PgSqlConnection. This connection is shared with a PgSqlAlerter component. My alerter's list is preloaded during design time with a few alerts and another one is amended after the PgSqlConnection is successfully opened. The alerter is only started for the first time after this supplemental alert is added. This is where the unexpected behaviour occurs.
At this point dbMonitor show a new connection request with almost the same parameters, only SslOptions are not copied. This results in a fatal error since my server is configured to refuse non-SSL connections. Disabling connection pooling doesn't help, a new connection is opened anyways.

Code: Select all
  2014.03.20. 0:26:27 n/a dotConnect for PostgreSQL monitoring is started Complete
  2014.03.20. 0:26:27 0,717 Open connection: "User Id=Y;Password=X;Host=0.0.0.0;Database=Z;Unicode=True;Character Set=UTF8;Pooling=True;SSLMode=Allow;" Complete
  2014.03.20. 0:26:27 0,000 Connect: "User Id=Y;Password=X;Host=0.0.0.0;Database=Z;Unicode=True;Character Set=UTF8;Pooling=True;SSLMode=Allow" Complete
  2014.03.20. 0:26:28 0,031 Execute: SELECT version() Complete
  2014.03.20. 0:26:28 0,016 Execute: show integer_datetimes Complete
  2014.03.20. 0:26:28 0,015 Execute: show bytea_output Complete
  2014.03.20. 0:26:28 0,016 Execute: SET autocommit=true Complete
  2014.03.20. 0:26:28 0,015 Execute: SET datestyle=ISO ; SET client_encoding='UTF8' Complete
  2014.03.20. 0:26:28 0,016 Execute: SELECT oid FROM pg_type WHERE typname like 'geometry' Complete
  2014.03.20. 0:26:28 0,016 Prepare: SET ROLE Y Complete
  2014.03.20. 0:26:28 0,015 Execute: SET ROLE Y Complete
 
  (log entries omitted) -> application executes PgSqlAlerter.Start() here
 
  2014.03.20. 0:26:36 0,000 Creating pool with connections string: "User Id=Y;Password=X;Host=0.0.0.0;Database=Z;Unicode=True;Character Set=UTF8;Pooling=True;SSLMode=Disable" Complete
  2014.03.20. 0:26:36 0,000 Creating object Complete
  2014.03.20. 0:26:36 0,000 Creating pool with connections string: "User Id=Y;Password=X;Host=0.0.0.0;Database=Z;Unicode=True;Character Set=UTF8;Connection Timeout=0;Pooling=True;SSLMode=Disable" Complete
  2014.03.20. 0:26:36 0,000 Creating object Complete
  2014.03.20. 0:26:36 n/a Open connection: "User Id=Y;Password=X;Host=0.0.0.0;Database=Z;Unicode=True;Character Set=UTF8;Connection Timeout=0;Pooling=True;SSLMode=Disable;" Pending
  2014.03.20. 0:26:36 0,000 Connect: "User Id=Y;Password=X;Host=0.0.0.0;Database=Z;Unicode=True;Character Set=UTF8;Connection Timeout=0;Pooling=True;SSLMode=Disable" Complete
  2014.03.20. 0:26:37 0,000 Disconnect Complete
belidzs
 
Posts: 29
Joined: Wed 30 Sep 2009 12:07

Re: Connection resets on PgSqlAlerter.Start() without SSL options

Postby Pinturiccio » Fri 21 Mar 2014 14:17

We have reproduced the issue. We will investigate it and post here about the results as soon as possible.
Pinturiccio
Devart Team
 
Posts: 2020
Joined: Wed 02 Nov 2011 09:44

Re: Connection resets on PgSqlAlerter.Start() without SSL options

Postby Pinturiccio » Wed 26 Mar 2014 11:51

We have fixed the bug with 'SSL Mode' parameter value not passed to a PgSqlAlerter object connection. We will post here when the corresponding build of dotConnect for PostgreSQL is available for download.
Pinturiccio
Devart Team
 
Posts: 2020
Joined: Wed 02 Nov 2011 09:44

Re: Connection resets on PgSqlAlerter.Start() without SSL options

Postby belidzs » Wed 26 Mar 2014 11:54

Thanks. Will you fix this bug retrospectively in v5 as well?
belidzs
 
Posts: 29
Joined: Wed 30 Sep 2009 12:07

Re: Connection resets on PgSqlAlerter.Start() without SSL options

Postby Pinturiccio » Wed 26 Mar 2014 13:49

We don't make patches. New functionality and bug fixes are included into new builds of dotConnect for PostgreSQL.
If you have a valid subscription for dotConnect for PostgreSQL, you can download the latest version of dotConnect for PostgreSQL from Registered Users' Area.
The subscription is valid during one year since the purchase of dotConnect for PostgreSQL or renewing the subscription.
If your subscription is not valid, you have to renew your subscription and download the latest version of dotConnect for PostgreSQL.
Pinturiccio
Devart Team
 
Posts: 2020
Joined: Wed 02 Nov 2011 09:44

Re: Connection resets on PgSqlAlerter.Start() without SSL options

Postby Pinturiccio » Thu 27 Mar 2014 14:58

New build of dotConnect for PostgreSQL 7.3.125 is available for download now!
It can be downloaded from http://www.devart.com/dotconnect/postgresql/download.html (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to http://forums.devart.com/viewtopic.php?t=29241
Pinturiccio
Devart Team
 
Posts: 2020
Joined: Wed 02 Nov 2011 09:44


Return to dotConnect for PostgreSQL