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 <[email protected]>: > 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 <[email protected]>: > >> 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 >> [email protected] >> List info: http://lists.osgeo.org/mailman/listinfo/qgis-developer >> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-developer >> >> >> >> > > >
_______________________________________________ Qgis-developer mailing list [email protected] List info: http://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-developer
