Postgresql 9.6 with dotconnect 7.7.819

Postgresql 9.6 with dotconnect 7.7.819

Postby tomisy » Wed 25 Jan 2017 08:22

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!
tomisy
 
Posts: 1
Joined: Wed 25 Jan 2017 07:41

Re: Postgresql 9.6 with dotconnect 7.7.819

Postby 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.
Pinturiccio
Devart Team
 
Posts: 1982
Joined: Wed 02 Nov 2011 09:44


Return to dotConnect for PostgreSQL