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

[kimaidou]

Hi Andreas,

It worked like a charm with your exact configuration.

I will remove the env.conf file to see if it still works without this conf.
If so, this would mean the pg_service.conf file situated in
/etc/postgresql/ could not be read. Probably wrong permissions on the
folder /etc/postgresql.

Thanks again for your help

I add a todo to remember adding this in QGIS Server documentation.

Regards
Michaël

2015-11-19 13:59 GMT+01:00 Neumann, Andreas <a.neumann at carto.net>:

> Hi,
>
> Here are the properties of my pg_service.conf file:
>
> -rw-r--r-- 1 root root 809 Aug 13  2014 /etc/pg_service.conf
>
> Andreas
>
> On 2015-11-19 13:52, kimaidou wrote:
>
> Thanks Andreas for your help.
>
> I also think fcgid.conf is the "winner", but I will try your configuration
> ( move pg_service.conf to /etc/ and add the setenv in Apache env.conf ).
> Could you please give me the result of
>
> ls -lh /etc/pg_service.conf
>
> command, so that I completely mimic your configuration ?
>
> Cheers,
> Michaël
>
> 2015-11-19 13:00 GMT+01:00 Neumann, Andreas <a.neumann at carto.net>:
>
>> Hi Michaël,
>>
>> This works for me.
>>
>> My pg_service.conf file is at /etc/pg_service.conf
>>
>> And in the Apache configuration it is specified in two files:
>>
>> /etc/apache2/mods-enabled/env.conf :
>>
>> SetEnv PGSYSCONFDIR "/etc"
>>
>> and in
>>
>> /etc/apache2/mods-enabled/fcgid.conf
>>
>> FcgidInitialEnv PGSYSCONFDIR "/etc"
>>
>> I am not sure which one is really used or has precedence - I suspect it
>> is the fcgid.conf file.
>>
>> Hope you get this working,
>>
>> Andreas
>>
>> On 2015-11-19 12:17, kimaidou wrote:
>>
>> 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
>> _______________________________________________
>> Qgis-developer mailing list
>> Qgis-developer at lists.osgeo.org
>> List info: http://lists.osgeo.org/mailman/listinfo/qgis-developer
>> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-developer
>>
>>
>>
>>
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20151119/7528a392/attachment.html>