Postgresql 9.6 with dotconnect 7.7.819

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
Posts: 1
Joined: Wed 25 Jan 2017 07:41

Postgresql 9.6 with dotconnect 7.7.819

Post by tomisy » Wed 25 Jan 2017 08:22


I'm using Postgres 9.0 with dotconnect 7.3.447 and SSL encription. It works fine without any problems.
I am trying to intoduce the Postgresql 9.6 with dotConnect 7.7.819 with SSL encryption. I have been installed the sql 9.6 and I made the SSL configuration on server-side. The PgAdmin tool can connect to the new database instance, but my sw cannot with this connection string:

Code: Select all

User Id=postgres;Host=localhost;Database=*******;Unicode=True;Connection Timeout=0;Default Command Timeout=0;Initial Schema=public;SSLMode=Prefer;SSL CA Cert=file://C:\Users\postgres\AppData\Roaming\postgresql\root.crt;SSL Cert=file://C:\Users\postgres\AppData\Roaming\postgresql\postgresql.crt;SSL Key=file://C:\Users\postgres\AppData\Roaming\postgresql\postgresql.key;Validate Connection=True
After circa 3min timeout i get this message:"Authentication failed in ssql mode."
The postgresql.conf Security block looks like this:

Code: Select all

# - Security and Authentication -

#authentication_timeout = 1min		# 1s-600s
ssl = on				# (change requires restart)
ssl_ciphers = 'ALL:!ADH:!LOW:!EXP:!MD5:@STRENGTH'	# allowed SSL ciphers
#ssl_ciphers = 'HIGH:MEDIUM:+3DES:!aNULL' # allowed SSL ciphers
#ssl_ciphers = 'AES256-SHA'
					# (change requires restart)
ssl_prefer_server_ciphers = on		# (change requires restart)
#ssl_ecdh_curve = 'prime256v1'		# (change requires restart)
ssl_cert_file = 'server.crt'		# (change requires restart)
ssl_key_file = 'server.key'		# (change requires restart)
ssl_ca_file = 'root.crt'			# (change requires restart)
ssl_crl_file = 'root.crl'			# (change requires restart)
#password_encryption = on
#db_user_namespace = off
#row_security = on

One more interesting thig: When shutting down the 9.6 service and starting the 9.0, then it work fine again. Maybe the problem is with the configuration of the server?

Thank you for your help!

Devart Team
Posts: 2125
Joined: Wed 02 Nov 2011 09:44

Re: Postgresql 9.6 with dotconnect 7.7.819

Post by Pinturiccio » Fri 27 Jan 2017 16:19

tomisy wrote:"Authentication failed in ssql mode."
This error message means that SSL authentication is ok, but PostgreSQL authentication has failed. You did not specify the password parameter in your connection. Does your postgres user have a password?
tomisy wrote:The PgAdmin tool can connect to the new database instance
Please check whether you use the password for the postgres user in pgAdmin.

Post Reply