PostgreSQL connection for Integration With SQL Databases: Password authentication failed

JasperWei
Level 2
PostgreSQL connection for Integration With SQL Databases: Password authentication failed

Hi, 

For the course titled 'Integration With SQL Databases' , I am having issues with the hands-on of configuring the connection between DSS and PostgreSQL: 

 

I've set up the dku_tshirt_admin user connection as guided by the course, and used 'Password' as the password for the connection and am facing this error: FATAL: password authentication failed for user "dku_tshirt_admin" 

 https://academy.dataiku.com/path/core-designer/integration-with-sql-databases-1/500810 

 

Tried googling, looking at the course materials, entering different upper/lower case computations for the 'Password' specified, to no avail. 

 

Can someone help? Thanks. 

Jasper 

0 Kudos
1 Reply
AlexT
Dataiker

Hi,

Can you confirm you have run the steps below to create the database, you will create 2 users matthieu with the password: "Password" and dku_tshirt_admin with the same password. You can verify if this was created correctly by testing from psql command line as well :

PGPASSWORD=Password psql -U matthieu dku

PGPASSWORD=Password psql -U dku_tshirt_admin dku

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

 

0 Kudos