[Qgis-user] QGIS server and pg_service.conf

[Thomas Schüttenberg]

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