[Qgis-developer] QGIS Server - use PGSYSCONFDIR in a server with no postgresql installed

[kimaidou]

Hi all

I have installed QGIS Server in one server (called "map") and PostGreSQL on
another (called "pg" ), both on Ubuntu Server 14.04
I would like to access to database only with PostGreSQL services, so in the
map server, I did the following steps:

* Create a folder /etc/postgresql
* Create a file /etc/postgresql/pg_service.conf  with some credentials
* Install postgresql-client to be able to use psql
* Add a environment variable PGSYSCONFDIR  and export it (plus add it in
/etc/environment ). Variable : PGSYSCONFDIR=/etc/postgresq'l
* Test via psql "service=myservice"  -> I can connect to the database and
get data

When I ask QGIS Server for the GetCapabilities, the layers configured with
this service cannot be added. I get the error : "Service myservice not
found"

So I added the following line in the fcgid.conf file to explicitely tell
Apache (and QGIS Server) to use this value.
FcgidInitialEnv PGSYSCONFDIR "/etc/postgresql"

But nothing works. I even tried to chmod and chown the service file and
folder to let Apache user www-data to read it. I also tried with a quick
and dirty chmod 777 , with no luck.

Has anyone some experience in setting up a Server with no postgresql
installed locally, and use the pg_service.conf file with QGIS Server ?

Thanks a lot for any clue
Michaël
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20151119/881b18ee/attachment.html>