[Qgis-user] QGIS server and pg_service.conf

[Thomas Schüttenberg]

Update:
in the apache configuration for a QGIS server 3.2 (on windows) a pg_service.conf must be set with: 
FcgidInitialEnv PGSERVICEFILE \\\\[server]\\dings\\bums\\pgconf\\pg_service.conf 
not with SetEnv ... (2.18)

This aspect has to be corrected in the documentation[1], if it is not os specific, I think.

[1] https://docs.qgis.org/testing/en/docs/training_manual/qgis_server/install.html

happy QGISing
Thomas


> Thomas Schüttenberg <thomas at qgis.de> hat am 9. Oktober 2018 um 15:23 geschrieben:
> 
> 
> Hi again,
> 
> in further tests - now with QGIS server 3.2.3 - the SetEnv PGSERVICEFILE resp. PGSYSCONFDIR configuration of my httpd-vhosts.conf did not work as it did in QGIS 2.18.24  (see below) :-(
> 
> I tried several notations of the file path an also put pg_service.conf on the local machine. No effect. QGIS 3.2.3 Desktop is fine with the service file connection.
> 
> NB: the authentication system has not been used, as supposed here https://lists.osgeo.org/pipermail/qgis-user/2018-September/041021.html 
> 
> clueless (again)
> Thomas
> 
> > Thomas Schüttenberg <thomas at qgis.de> hat am 8. Oktober 2018 um 11:20 geschrieben:
> > 
> > 
> > Hi!
> > Picking up my earlier thread on pg_service.conf in QGIS server [https://lists.osgeo.org/pipermail/qgis-user/2018-September/041014.html] I can gladly tell you that I figured it out!
> > 
> > As said, setting the environment variables on the operating system(s) was ok, but I missed to define it ALSO in the apache configuration (httpd-vhosts.conf), as it is stated in the documentation: 
> > https://docs.qgis.org/2.18/en/docs/user_manual/working_with_ogc/ogc_server_support.html#connection-to-service-file 
> > https://docs.qgis.org/2.18/en/docs/training_manual/qgis_server/install.html 
> > 
> > After fiddeling with the UNC for the path to the service file (between unix/linux doc and windows machine) it both worked on win 7 64bit with 
> > SetEnv PGSERVICEFILE \\\\[server]\\dings\\bums\\pgconf\\pg_service.conf
> > or
> > SetEnv PGSYSCONFDIR \\\\[server]\\dings\\bums\\pgconf\\
> > 
> > (This tread was also very helpful http://osgeo-org.1560.x6.nabble.com/pg-services-on-Windows-td5284889.html )
> > 
> > happy QGISing!
> > Thomas