PostgreSQL connection - authentification error

cmolia

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,

CoreyS

Hi @cmolia
we're actually recommending that you open a support ticket for this. More information on obtaining support can be found here.

Angelo

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