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