cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Regular Visitor

Certificate issue when connecting a PostgreSQL database to an On-Premise Enterprise Gateway

Hi all, 

 

I've been having trouble connecting to PostgreSQL using the On-Premise Enterprise Gateway without ODBC. On the same machine as the gateway, I have installed Power BI and connected to the PostgreSQL database without any issues (thanks to the instructions here:https://community.powerbi.com/t5/Integrations-with-Files-and/Connecting-to-PostgresSQL-hosted-on-AWS...), but when setting up a new data source for the gateway I encounter the following error:   

 

Unable to connect: We encountered an error while trying to connect to data-warehouse-dev.csgxzpfrma4x.eu-west-1.rds.amazonaws.com. Details: "We could not register this data source for all gateway instances within this cluster. Please find more details below about specific errors for each gateway instance."Hide details

Activity ID:f570a8d6-a779-4331-8d0d-8d582d7e5521
Request ID:d2e75334-1418-8c11-8697-34952dd0543f
Cluster URI:https://wabi-north-europe-redirect.analysis.windows.net
Status code:400
Error Code:DMTS_PublishDatasourceToClusterErrorCode
Time:Mon Feb 05 2018 16:11:56 GMT+0000 (GMT Standard Time)
Version:13.0.4164.188
bboxx-ldn:Cannot connect to the mashup data source. See error details for more information.
Underlying error code:-2147467259
Underlying error message:An error happened while reading data from the provider: '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. . at Npgsql.Tls.TlsClientStream.ParseCertificateMessage(Byte[] buf, Int32& pos) at Npgsql.Tls.TlsClientStream.TraverseHandshakeMessages() at Npgsql.Tls.TlsClientStream.<GetInitialHandshakeMessages>d__43.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Npgsql.Tls.TlsClientStream.<PerformInitialHandshake>d__72.MoveNext()'
DM_ErrorDetailNameCode_UnderlyingHResult:-2147467259
Microsoft.Data.Mashup.ValueError.DataSourceKind:PostgreSQL
Microsoft.Data.Mashup.ValueError.DataSourcePath:****.rds.amazonaws.com;DataWarehouseDev
Microsoft.Data.Mashup.ValueError.Reason:DataSource.Error

 

Has anyone else successfully connected an On-Premise Enterprise Gateway to a PostgreSQL source without ODBC? Any suggestions for overcoming this error would be very welcome! 

1 ACCEPTED SOLUTION
Regular Visitor

Okay - solved this 

The issue was that I had only installed the certificates in the local account on the Enterprise Gateway server, and not on the Computer account. This is an option you have to select when adding the certificates snap-in in mmc.

The solution was found here: https://social.technet.microsoft.com/Forums/windowsserver/en-US/85f2cdbf-f316-40a2-968b-ab823bffc947...

View solution in original post

4 REPLIES 4
Regular Visitor

Okay - solved this 

The issue was that I had only installed the certificates in the local account on the Enterprise Gateway server, and not on the Computer account. This is an option you have to select when adding the certificates snap-in in mmc.

The solution was found here: https://social.technet.microsoft.com/Forums/windowsserver/en-US/85f2cdbf-f316-40a2-968b-ab823bffc947...

View solution in original post

Microsoft
Microsoft

@nathanh,

Do you use the latest version of Power BI Desktop(2.55.5010.521) and latest version of gateway?

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@v-yuezhe-msft

 

Hi Lydia,

 

any idea for my problem?

I think would solve most of the certificate issues with Postres.

 

Best

Patrick

Frequent Visitor

I have the same problem with a PostgreSQL instance on Compose (IBM Cloud).

 

https://community.powerbi.com/t5/Integrations-with-Files-and/Connecting-to-PostgresSQL-hosted-on-AWS...

 

I cannot get a certificate with the full hostname (already talked to IBM).

Is there any option to disable the certificate check? (e.g. via regedit)

 

Best

Patrick

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors