AnsweredAssumed Answered

Pentaho on Ubuntu

Question asked by Fred de Klein Employee on May 23, 2018
Latest reply on May 23, 2018 by Gotn O'Guts

Hi, when installing Pentaho (no matter which version) on Ubuntu, I get the following error messages at the end of the installation, presumably based on the Postgresql server

Postgresql_error_messages.jpg

Any ideas? ... this does not happen when I install it on Fedora

 

Your help much appreciated

 

This has now been sorted

You have to edit postgresql.conf file and change line with 'listen_addresses'.

This file you can find in the /etc/postgresql/9.3/main directory.

Default Ubuntu config have allowed only localhost (or 127.0.0.1) interface, which is sufficient for using, when every PostgreSQL client work on the same computer, as PostgreSQL server. If you want connect PostgreSQL server from other computers, you have change this config line in this way:

listen_addresses = '*'

Then you have edit pg_hba.conf file, too. In this file you have set, from which computers you can connect to this server and what method of authentication you can use. Usually you will need similar line:

host all         all         192.168.1.0/24 md5

Please, read comments in this file...

EDIT:

After the editing postgresql.conf and pg_hba.conf you have to restart postgresql server.

Outcomes