Tjyylli

Can the van der Waals coefficients be negative in the van der Waals equation for real gases?

Help Recreating a Table

Why doesn't the university give past final exams' answers?

Why did Israel vote against lifting the American embargo on Cuba?

How was Lagrange appointed professor of mathematics so early?

Why aren't these two solutions equivalent? Combinatorics problem

What helicopter has the most rotor blades?

Should man-made satellites feature an intelligent inverted "cow catcher"?

Weaponising the Grasp-at-a-Distance spell

Proving inequality for positive definite matrix

How is an IPA symbol that lacks a name (e.g. ɲ) called?

Like totally amazing interchangeable sister outfit accessory swapping or whatever

What is the definining line between a helicopter and a drone a person can ride in?

Does the Pact of the Blade warlock feature allow me to customize the properties of the pact weapon I create?

Why do people think Winterfell crypts is the safest place for women, children & old people?

Who's this lady in the war room?

“Since the train was delayed for more than an hour, passengers were given a full refund.” – Why is there no article before “passengers”?

Does traveling In The United States require a passport or can I use my green card if not a US citizen?

Is there a verb for listening stealthily?

What is the ongoing value of the Kanban board to the developers as opposed to management

Suing a Police Officer Instead of the Police Department

tabularx column has extra padding at right?

Normal Operator || T^2|| = ||T||^2

Does using the Inspiration rules for character defects encourage My Guy Syndrome?

How to set up signed SSL Root and Leaf certificates on Ubuntu 18.10 Postgresql 11 Database and Windows 10 Power BI plus PostgreSQL?

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}

0

I have Power BI and PostgreSQL 11 installed on Windows 10 and my primary PostgreSQL 11 database on Ubuntu 18.10 Linux. I edited the postgresql.conf and pg_hba.conf files correctly to the IP Adresses my Windows 10 computer uses with PostgreSQL 11 and Power BI to connect to my PostgreSQL 11 Ubuntu database. However, I got errors in Power BI while I could manually connect via command line.

After troubleshooting with Microsoft Support, I was told:

This indicates that the Postgresql server does not have its certificates configured and therefore cant connect to PowerBI. To allow the client to verify the identity of the server, place a root certificate on the client and a leaf certificate signed by the root certificate on the server. To allow the server to verify the identity of the client, place a root certificate on the server and a leaf certificate signed by the root certificate on the client. One or more intermediate certificates (usually stored with the leaf certificate) may be used.

However, I am confused by the tutorials at

• 
  https://www.postgresql.org/docs/current/libpq-ssl.html and


• 
  https://www.gab.lc/articles/postgresql_with_ssl/.

I can't tell what steps need to be done on my Ubuntu PC and what steps need to be done on my Windows PC. I don't know if special steps are needed to configure Power BI with the certificates. How do I set up my bidirectional certificates?

Can someone offer a very detailed tutorial, tell me 'how' to read a tutorial, or explain the steps in an answer please?

windows-10 ubuntu ssl certificate postgresql

share|improve this question

edited 2 hours ago

Humble-Data-22

asked 6 hours ago

Humble-Data-22Humble-Data-22

83

add a comment | 

0

I have Power BI and PostgreSQL 11 installed on Windows 10 and my primary PostgreSQL 11 database on Ubuntu 18.10 Linux. I edited the postgresql.conf and pg_hba.conf files correctly to the IP Adresses my Windows 10 computer uses with PostgreSQL 11 and Power BI to connect to my PostgreSQL 11 Ubuntu database. However, I got errors in Power BI while I could manually connect via command line.

After troubleshooting with Microsoft Support, I was told:

This indicates that the Postgresql server does not have its certificates configured and therefore cant connect to PowerBI. To allow the client to verify the identity of the server, place a root certificate on the client and a leaf certificate signed by the root certificate on the server. To allow the server to verify the identity of the client, place a root certificate on the server and a leaf certificate signed by the root certificate on the client. One or more intermediate certificates (usually stored with the leaf certificate) may be used.

However, I am confused by the tutorials at

• 
  https://www.postgresql.org/docs/current/libpq-ssl.html and


• 
  https://www.gab.lc/articles/postgresql_with_ssl/.

I can't tell what steps need to be done on my Ubuntu PC and what steps need to be done on my Windows PC. I don't know if special steps are needed to configure Power BI with the certificates. How do I set up my bidirectional certificates?

Can someone offer a very detailed tutorial, tell me 'how' to read a tutorial, or explain the steps in an answer please?

windows-10 ubuntu ssl certificate postgresql

share|improve this question

edited 2 hours ago

Humble-Data-22

asked 6 hours ago

Humble-Data-22Humble-Data-22

83

add a comment | 

I have Power BI and PostgreSQL 11 installed on Windows 10 and my primary PostgreSQL 11 database on Ubuntu 18.10 Linux. I edited the postgresql.conf and pg_hba.conf files correctly to the IP Adresses my Windows 10 computer uses with PostgreSQL 11 and Power BI to connect to my PostgreSQL 11 Ubuntu database. However, I got errors in Power BI while I could manually connect via command line.

After troubleshooting with Microsoft Support, I was told:

This indicates that the Postgresql server does not have its certificates configured and therefore cant connect to PowerBI. To allow the client to verify the identity of the server, place a root certificate on the client and a leaf certificate signed by the root certificate on the server. To allow the server to verify the identity of the client, place a root certificate on the server and a leaf certificate signed by the root certificate on the client. One or more intermediate certificates (usually stored with the leaf certificate) may be used.

However, I am confused by the tutorials at

• 
  https://www.postgresql.org/docs/current/libpq-ssl.html and


• 
  https://www.gab.lc/articles/postgresql_with_ssl/.

I can't tell what steps need to be done on my Ubuntu PC and what steps need to be done on my Windows PC. I don't know if special steps are needed to configure Power BI with the certificates. How do I set up my bidirectional certificates?

Can someone offer a very detailed tutorial, tell me 'how' to read a tutorial, or explain the steps in an answer please?

windows-10 ubuntu ssl certificate postgresql

share|improve this question

edited 2 hours ago

Humble-Data-22

asked 6 hours ago

Humble-Data-22Humble-Data-22

83

share|improve this question

edited 2 hours ago

Humble-Data-22

asked 6 hours ago

Humble-Data-22Humble-Data-22

83

share|improve this question

edited 2 hours ago

Humble-Data-22

asked 6 hours ago

Humble-Data-22Humble-Data-22

83

asked 6 hours ago

Humble-Data-22Humble-Data-22

83

asked 6 hours ago

Humble-Data-22Humble-Data-22

83