Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Hi!
Some context:
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
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.