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,
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
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