New PostgreSQL Connection user error

violepshe
Level 1
New PostgreSQL Connection user error

Hi!

Some context:

  • I'm running DSS in VirtualBox.
  • I'm running PostgreSQL in WSL2 (Ubuntu for Windows).

I was guiding myself to learn to make a connection to postgresql with this tutorial:

https://academy.dataiku.com/integration-with-sql-databases-1/500809

Specifically, I did this part from the tutorial exactly as explained:

 

psql -h localhost
CREATE DATABASE dku;
\c dku
CREATE SCHEMA dku_churn;
CREATE USER matthieu WITH PASSWORD 'Password';
GRANT ALL PRIVILEGES ON SCHEMA dku_churn TO matthieu;
CREATE SCHEMA dku_tshirt;
CREATE USER dku_tshirt_admin WITH PASSWORD 'Password';
GRANT ALL PRIVILEGES ON SCHEMA dku_tshirt TO dku_tshirt_admin;
\q

 

And I verified that the database and users were created, however still an error appears when I try to make the connection (image attached) in Dataiku.

Do I need to modify firewall rules?

I checked and both Ubuntu (WSL2) and VirtualBox use 127.0.0.1, but I'm not sure if I understood right that part.


Operating system used: Windows

0 Kudos
1 Reply
sergeyd
Dataiker

Hi @violepshe ,

FATAL: Password authentication failed for user means that DSS was able to reach Postgresql instance so that's not a firewall issue. You will need to check pg_hba.conf on Postgres side to see if you have correct auth used there for local connections. 

Please note this is not DSS issue but rather plain Postgres auth one. 

0 Kudos