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
