[Zoo-discuss] Kernel with database support

[rakesh prithiviraj]

Some more info. 
If the password contains "$" symbol, it is not parsed correctly by Zoo. The behaviour is it drops all the characters in the password after $ including $.  I tested setting a simple password without special characters and i could see entry in zoo_project database when i submit WPS job.
Thanks

From: rakeshuk at outlook.com
To: gerald.fenoy at geolabs.fr; zoo-discuss at lists.osgeo.org
Date: Thu, 23 Jun 2016 15:51:04 +0100
Subject: Re: [Zoo-discuss] Kernel with database support




Dear Gerald
I dumped the "conf" and i found the password is set to "ft3pu," and this is not same as what i have configured in main.cfg. It is clear that special characters in the password interfere with the parsing.
Can you please check this.
regards

From: rakeshuk at outlook.com
To: gerald.fenoy at geolabs.fr; zoo-discuss at lists.osgeo.org
Date: Thu, 23 Jun 2016 15:35:58 +0100
Subject: Re: [Zoo-discuss] Kernel with database support





No luck :(
1. Connecting via psql works ftep at vm-04:~$  psql -h 192.168.3.85 -d zoo_project -U ftep-userpsql (9.3.13, server 9.3.5)Type "help" for help.
zoo_project=>

2. main.cfg [database] section[database]dbname=zoo_projectport=5432user=ftep-userhost=192.168.3.85type=PGschema=publicpassword=<my password goes here>
I made sure there is no typo in the password. I directly copied the password from .pgpass to main.cfg.
When i submit a WPS job, i see the following in the postgres logs:FATAL:  password authentication failed for user "ftep-user"DETAIL:  Connection matched pg_hba.conf line 129: "host zoo_project     ftep-user       192.168.3.0/24  md5     "
And the following in the error file created by ZOOERROR 1: PQconnectdb failed.FATAL:  password authentication failed for user "ftep-user"
Note that my password has following special characters: $ ! .I hope this is not creating trouble. Is zoo using psql to connect or some other client? 
regards 

> Subject: Re: [Zoo-discuss] Kernel with database support
> From: gerald.fenoy at geolabs.fr
> Date: Thu, 23 Jun 2016 15:41:27 +0200
> CC: zoo-discuss at lists.osgeo.org
> To: rakeshuk at outlook.com
> 
> 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
> 
 		 	   		  

_______________________________________________
Zoo-discuss mailing list
Zoo-discuss at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/zoo-discuss 		 	   		  

_______________________________________________
Zoo-discuss mailing list
Zoo-discuss at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/zoo-discuss 		 	   		  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/zoo-discuss/attachments/20160623/9d05b672/attachment-0001.html>