Forum Discussion
ecate
10 years agoNew Member
Connect PowerBI Desktop with PostgreSQL
I'm tring to connect power BI to a Posgres 9.4 database installed into the same machine (my windows 10 laptop). I've overcome the error about Npgsql intalling Npgsql.dll with GACutil and modifying t...
Anonymous
9 years agoNot applicable
I run into the problem of certificate when trying to access Managed Postgresql on Azure.
I've tried to install 3.1.8 (there are no option, but installing to GAC is mentioned) and restarted.
ianwukdid you doing anything else? (machine.config? ...)
I still get this:
Details: "An error happened while reading data from the provider: 'TlsClientStream.ClientAlertException: CertificateUnknown: Server certificate was not accepted. The specified hostname was not present in the certificate. at TlsClientStream.TlsClientStream.SendAlertFatal(AlertDescription description, String message) at TlsClientStream.TlsClientStream.ParseCertificateMessage(Byte[] buf, Int32& pos) at TlsClientStream.TlsClientStream.TraverseHandshakeMessages() at TlsClientStream.TlsClientStream.GetInitialHandshakeMessages(Boolean allowApplicationData) at TlsClientStream.TlsClientStream.PerformInitialHandshake(String hostName, X509CertificateCollection clientCertificates, RemoteCertificateValidationCallback remoteCertificateValidationCallback, Boolean checkCertificateRevocation)'"
ianwukdid you do anything else?
Anonymous
9 years agoNot applicable
I was finally able to connect with:
- npgsql 3.1.8 (restart, confirmed they are in gacutils and machine.config)
- https://docs.microsoft.com/en-us/azure/postgresql/concepts-ssl-connection-security
- changed host to <servername>.database.windows.net from <servername>.postgres.database.azure.com.
- (not sure if needed): added the server certificate: https://docs.microsoft.com/en-us/azure/postgresql/concepts-ssl-connection-security