following the course Integration With SQL Databases: error password authentication

MRvLuijpen
Neuron
Neuron
following the course Integration With SQL Databases: error password authentication

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

 

0 Kudos
3 Replies
Alex_Reutter
Dataiker Alumni

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.  
0 Kudos
Namit
Level 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?

0 Kudos
Alex_Reutter
Dataiker Alumni

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

0 Kudos
Labels (2)