You should have a warning like this in QGIS Server logs (increase debug level maybe) :
[WRN] (from Qgis) PostGIS: Connection to database failed definition of service « name of your service » not found Next step is make GetPrint working... maybe I'll post another question > tomorrow :-) Look at XVFB https://docs.qgis.org/3.40/en/docs/server_manual/getting_started.html#xvfb Le mar. 8 juil. 2025 à 10:43, Amedeo Fadini via QGIS-User < [email protected]> a écrit : > Hi jorge, > thank you very much your advice wer useful: > > yes I checked permission of .pg_service.conf file and parent dir, same > thing happens also putting the file in other locations and chown-ing the > file to www-data. > > Not sure where QGIS server should log in this configuration (there's a > sysadmin that manage installation in the server i will ask him to make a > separate log) > but I found something in syslog. > > It seems that thte variable PGSERVICEFILE is not evaluated. > I've solved commenting the line and putting configuration in the > system-wide pgservice.conf location /etc/postgresql.common > > Next step is make GetPrint working... maybe I'll post another question > tomorrow :-) > > amefad > > Il giorno lun 7 lug 2025 alle ore 23:12 Jorge Gustavo Rocha via QGIS-User < > [email protected]> ha scritto: > >> Hi Amedeo, >> >> Is the www-data user able to read the pg service file? If you didn't >> change the permissions, /home/ubuntu/.pg_service.conf is only readable by >> ubuntu user. >> >> Can you check the qgis server logs to see what is going on? >> >> Best regards, >> >> Jorge >> Às 21:05 de 07/07/25, Amedeo Fadini via QGIS-User escreveu: >> >> Errata corrige, the demo project works, the sqlite file was with wrong >> permission. >> Still doesn't load postgis layer >> >> Amedeo >> >> Il giorno lun 7 lug 2025 alle ore 21:54 Amedeo Fadini <[email protected]> >> ha scritto: >> >>> Hi everybody, >>> >>> I'm upgrading a project based on QGIS server and moved all stuff to new >>> server with Ubuntu 24, QGIS 3.40 LTR postgresql 16. >>> Webserver is nginx, QGIS server is configured on spawn-fcgi with single >>> socket follwing the qgis manual >>> >>> https://docs.qgis.org/3.40/en/docs/server_manual/getting_started.html#spawn-fcgi >>> The project use two layers from postgis, the connection is configured >>> with pg service >>> >>> Connecting on ssh with x.forwarding the project loads without any error >>> and works fine >>> >>> Calling the qgis server getcapabilities or get projectsettings it raise >>> the error >>> <ServerException>Layer(s) not valid</ServerException> >>> Setting QGIS_SERVER_IGNORE_BAD_LAYERS=true getcapabilities works but >>> postgis layer are not published or not showed in Getmap request. >>> >>> Any clue? Where can I find more detailed erro log? >>> >>> even the demo project world.qgs gives balnk image in getmap request. Am >>> I misisng a local Xserver or gui configuration? >>> >>> Below is my nginx conf and systemd/system/qgis-server.service >>> >>> Thank you >>> >>> Amedeo Fadini >>> >>> --- >>> server { >>> listen 80; >>> server_name <my server name>; >>> >>> location /qgis/ { >>> include fastcgi_params; >>> fastcgi_param SCRIPT_FILENAME /usr/lib/cgi-bin/qgis_mapserv.fcgi; >>> #fastcgi_param QGIS_DEBUG 1; >>> fastcgi_param QGIS_SERVER_LOG_STDERR 1; >>> #fastcgi_param QGIS_SERVER_LOG_LEVEL 0; >>> fastcgi_param QGIS_SERVER_LOG_LEVEL 2; >>> #fastcgi_param PGSERVICEFILE /home/ubuntu/.pg_service.conf; >>> #fastcgi_param QGIS_PROJECT_FILE >>> /home/ubuntu/fiduciali_qgis/fiduciali.qgs; >>> fastcgi_pass unix:/var/run/qgisserver.socket; >>> } >>> } >>> >>> >>> --- >>> >>> [Unit] >>> Description=QGIS server >>> After=network.target >>> >>> [Service] >>> ;; set env var as needed >>> ;Environment="LANG=en_EN.UTF-8" >>> ;Environment="QGIS_SERVER_PARALLEL_RENDERING=1" >>> ;Environment="QGIS_SERVER_MAX_THREADS=12" >>> Environment="QGIS_SERVER_LOG_LEVEL=0" >>> Environment="QGIS_SERVER_LOG_STDERR=1" >>> Environment="PGSERVICEFILE=/home/ubuntu/.pg_service.conf" >>> ;Environment="QGIS_PROJECT_FILE=/var/www/qgis_projects/world.qgs" >>> Environment="QGIS_PROJECT_FILE=/var/www/qgis_projects/fiduciali.qgs" >>> Environment="QGIS_SERVER_IGNORE_BAD_LAYERS=true" >>> ;; or use a file: >>> ;EnvironmentFile=/etc/qgis-server-env >>> >>> ExecStart=spawn-fcgi -s /var/run/qgisserver.socket -U www-data -G >>> www-data -n /usr/lib/cgi-bin> >>> >>> [Install] >>> WantedBy=multi-user.target >>> >> >> _______________________________________________ >> QGIS-User mailing [email protected] >> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user >> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user >> >> -- >> * Geomaster, LDA * >> * VENHA DESCOBRIR O CAMINHO DO OPEN SOURCE CONNOSC * >> >> Rua Afonso Palmeira, 31, 7 D >> 4715-278 Braga >> VAT/NIF 510 906 109 >> Phone +351 253 257 173 >> Site geomaster.pt >> GPS 41.54627, -8.40432 >> [image: Logo] >> ------------------------------ >> >> Jorge Gustavo Rocha >> CTO >> >> Mobile +351 910 333 888 >> Email [email protected] >> _______________________________________________ >> 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 >> > _______________________________________________ > 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 >
_______________________________________________ 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
