New PostgreSQL Connection user error

Options
violepshe
violepshe Registered Posts: 1 ✭✭✭

Hi!

Some context:

  • I'm running DSS in VirtualBox.
  • I'm running PostgreSQL in WSL2 (Ubuntu for Windows).

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 localhostCREATE DATABASE dku;\c dkuCREATE 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

Tagged:

Answers

  • Sergey
    Sergey Dataiker, Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS Core Concepts Posts: 366 Dataiker
    Options

    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.

Setup Info
    Tags
      Help me…