Hi Team,
We are unable to use the SV Server 5.4.1 after upgrading AWS RDS PostgreSQL engine version to 14.7. it throws the below error.
Error:
InitializeDatabase DB exception occurred. To install product regardless of the database error, please, run installer with parameter IGNORE_DB_ERROR="true". For post-installation steps follow instructions in Field Guide. / Npgsql.Tls.ClientAlertException: CertificateUnknown: Server certificate was not accepted. Chain status: A certificate chain processed, but terminated in a root certificate which is not trusted by the trust provider.
But we have the RDS root certificate already imported to the Windows Server Certificate Manager trust store.and the SV Server setup was working fine before the PostgreSQL engine version upgrade.
The SV connection string looks like the below.
Connection string: 'Host=rdsdbinstancename;Database=sampledb;Username=svadmin;Password=*****;Port=5401;sslmode=Require;timeout=10;
We thought the issue might be related to DB_Properties sslmode=Require, So we try to use the different values recommended in the below documentation.
PostgreSQL: Documentation: 15: 34.19. SSL Support
As per the PostgreSQL documentation the sslmode=Require , should be updated to sslmode=verify-ca or sslmode=verify-full but if we set these parameters it throws the below error
Couldn't set sslmode
Parameter name: sslmode
Connection string: 'Host=rdsdbinstancename;Database=sampledb;Username=svadmin;Password=*****;Port=5401;sslmode=verify-full;timeout=10;
OS: Windows Server 2019
We are unable to use the SV Server , request your help Jakub Karel Moulik
Thanks,