Postgresql 9.6 with dotconnect 7.7.819

[tomisy]

Hello,

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!

[Pinturiccio]

"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?

The PgAdmin tool can connect to the new database instance

Please check whether you use the password for the postgres user in pgAdmin.