following the course Integration With SQL Databases: error password authentication

MRvLuijpen
MRvLuijpen Partner, L2 Admin, L2 Designer, Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Neuron 2020, Neuron, Dataiku DSS Adv Designer, Registered, Dataiku DSS Developer, Neuron 2021, Neuron 2022, Frontrunner 2022 Finalist, Frontrunner 2022 Winner, Frontrunner 2022 Participant, Neuron 2023 Posts: 107 Neuron

Hello.

I am following the steps in order to create a PostgreSQL database connection according to these steps: https://academy.dataiku.com/integration-with-sql-databases-1/500814

However, I get a password authentication, while I am sure the password is exactly the same as the example in the previous step: https://academy.dataiku.com/integration-with-sql-databases-1/500810

What am I doing wrongly here?

I have included the backlog

Thanks in advance

Marc Robert

DSS 7.0.3

Answers

  • Alex_Reutter
    Alex_Reutter Alpha Tester, Dataiker Alumni, Dataiku DSS Core Designer Posts: 105 ✭✭✭✭✭✭✭

    Hi Marc,

    There are several pieces of information that define the connection. From the log, it's not possible to tell exactly which one is incorrect:

    • Host. Is the PostgreSQL database on the same machine as DSS? If not, this setting should point at the host for PostgreSQL, and not localhost
    • Database. Be certain it exists in the db; you can check from within the db
    • Port. 5432 is the default port for PostgreSQL, but you'll want to be certain that's what it's running on
    • User. Be certain that you can log in as this user, with the following password, in the db
    • Password.
  • Namit
    Namit Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS Core Concepts, Registered Posts: 1 ✭✭✭✭

    Hi @Alex_Reutter

    New to the platform
    I'm trying to connect my psql windows on my machine to the dataiku instance but some how i'm getting this message

    authentification par mot de passe échouée pour l'utilisateur « dataiku »

    can you please guide me how to establish a connection with my windows psql and also change the error log from French to English?

  • Alex_Reutter
    Alex_Reutter Alpha Tester, Dataiker Alumni, Dataiku DSS Core Designer Posts: 105 ✭✭✭✭✭✭✭

    Hi @Namit
    , what step are you at when getting this message? If you can include a screenshot, that might help.

Setup Info
    Tags
      Help me…