Postgresql 9.6 with dotconnect 7.7.819
Posted: 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:
After circa 3min timeout i get this message:"Authentication failed in ssql mode."
The postgresql.conf Security block looks like this:
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!
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
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
Thank you for your help!