[Zoo-discuss] Kernel with database support

[Fenoy Gerald]

Dear Rakesh,
you may use the ‘password’ key in your database section to make your user authenticating to the db backend.

Nevertheless, as you said that yo can connect to the db from the psql command line tool, I suppose that the other keys in the database section may be wrong also.

From the machine where you are able to connect the db from the command line, I suppose that your client uses the unix domain socket rather than ip address. So, you should make sure that you have set the host key to the full path to the unix domain socket rather than an IP address.

I hope this helps you to solve the issue.

Best regards,

> Le 23 juin 2016 à 15:30, rakesh prithiviraj <rakeshuk at outlook.com> a écrit :
> 
> Hi,
> 
> I have 2 virtual machines: one with Postgres instance and another machine with Zoo-kernel.
> I compiled zoo-kernel with "--with-db-backend" option and also created "zoo_project" database in postgres, added [database] section to the main.cfg.
> 
> Also from the zoo-kernel machine, I can connect to the  "zoo_project" database from command line (psql) without supplying password (enabled passwordless login as per https://www.postgresql.org/docs/current/static/libpq-pgpass.html)
> 
> Now when I run a WPS job, I get the following error in a file "servicename_jobid_error.log"
> 
> ERROR 1: PQconnectdb failed.
> fe_sendauth: no password supplied
> 
> I am now wondering how to configure password so that zoo-kernel can use it for DB connection.
> 
> Thanks
> Rakesh
> 
> 
> _______________________________________________
> Zoo-discuss mailing list
> Zoo-discuss at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/zoo-discuss



Gérald Fenoy
http://wiki.osgeo.org/wiki/User:Djay