[Qgis-user] QGIS server and pg_service.conf

[Thomas Schüttenberg]

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