Pentaho

 View Only

 Postgres - Peer authentication failed for user

  • Pentaho
  • Pentaho
Sebastian Wierzbicki's profile image
Sebastian Wierzbicki posted 08-24-2018 09:47

Hi!

I am trying to set up Pentaho 8.1 CE serwer on my Debian 8.

i am following the steps of Prepare Your Linux Environment for a Manual Installation - Pentaho Documentation and i run in to a problem.

When i am trying to import

create_quartz_postgresql.sql

problem appears:

FATAL:  Peer authentication failed for user "pentaho_user"

I can't find any solution online, editing the pg_hba file dont work.


#Pentaho
Matthew Casper's profile image
Matthew Casper

Hi Sebastian,

Does your edit to the pg_hba.conf file look like the following:

host    all             all             127.0.0.1/32            md5

Also, I would look to connect as the "postgres" user from the PSQL command line and then run the SQL scripts as the instructions suggest (e.g. \i <your filepath>/data/postgresql/create_quartz_postgresql.sql). 

Here is an example of how to connect which will prompt for the "postgres" users password:  psql -d postgres -U postgres

You must navigate to the location of your "../postgresql/9.x/bin" directory to run that command.

When that script runs it will create the "pentaho_user" and then attempt to connect as the "pentaho_user" prompting for the password that is set in the script itself. 

Lastly, you are not connecting to the server remotely, correct?  If so, then you'll have to also edit the "postgresql.conf" file to allow for TCP/IP connections.

I hope this helps.

Thanks,

Matt Casper

Sebastian Wierzbicki's profile image
Sebastian Wierzbicki

Thank you!

This solution worked.