PostgreSQL connection - authentification error
Hello,
For the online course 'Integration With SQL Databases', I'm struggling to set up the PostgreSQL connection with DSS.
As guided by the course, on pgAdmin I executed the following queries in the database dku:
CREATE SCHEMA dku_churn;
CREATE USER clara WITH PASSWORD 'Password';
GRANT ALL PRIVILEGES ON SCHEMA dku_churn TO clara;
CREATE SCHEMA dku_tshirt;
CREATE USER dku_tshirt_admin WITH PASSWORD 'Password';
GRANT ALL PRIVILEGES ON SCHEMA dku_tshirt TO dku_tshirt_admin;
In Dataiku DSS, on the Connections tab, I've tried every combination I could think of, see in attachments the settings screenshots. Adding ssl parameters in advanced properties doesn't seem to help.
Error technical details:
- Error type:org.postgresql.util.PSQLException
Thank you in advance,
Answers
-
CoreyS Dataiker Alumni, Dataiku DSS Core Designer, Dataiku DSS Core Concepts, Registered Posts: 1,149 ✭✭✭✭✭✭✭✭✭Hi @cmolia
we're actually recommending that you open a support ticket for this. More information on obtaining support can be found here. -
I'm getting a similar authetication error in that part of the tutorial although I haven't tried to set any JDBC properties:
FATAL: password authentication failed for user "dku_tshirt_admin"
Also, looking at this page (https://doc.dataiku.com/dss/latest/connecting/sql/postgresql.html), looks like Postgres comes with JDBC drivers installed already in DSS so nothing more is required. Also checked my local DATA_DIR and found the files here: /home/dataiku/dataiku-dss-10.0.2/lib/ivy/jdbc-postgresql
