Check out the first Dataiku 8 Deep Dive focusing on Productivity on October 29th Read More

following the course Integration With SQL Databases: error password authentication

Level 3
Level 3
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
1 Reply
Dataiker
Dataiker

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
Labels (2)