[Qgis-user] Solved: Getprint working (was: postgis layers not valid )
Amedeo Fadini
amefad at gmail.com
Tue Jul 8 14:56:10 PDT 2025
Hi Etienne,
Installed and configured xvfb but GetPrint gives the correct layout
elements without any of my layer... even OSM layer was blank
Tried a few times and then appeared a small arabic label... Since I'm in
italy I realized that I have to invert axes in the map0:EXTENT parameter
The documentation says.
This parameter specifies the extent for a layout map item as
xmin,ymin,xmax,ymax.
But i forgot to read again the Getmap section that describes axis order.
Thank-you everybody
Amedeo
Il giorno mar 8 lug 2025 alle ore 15:09 Etienne Trimaille <
etienne.trimaille at gmail.com> ha scritto:
> 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 <
> qgis-user at lists.osgeo.org> 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
>> <qgis-user at lists.osgeo.org> 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 <amefad at gmail.com>
>>> 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 listQGIS-User at lists.osgeo.org
>>> 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 jgr at geomaster.pt
>>> _______________________________________________
>>> QGIS-User mailing list
>>> QGIS-User at lists.osgeo.org
>>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
>>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>>>
>> _______________________________________________
>> QGIS-User mailing list
>> QGIS-User at lists.osgeo.org
>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20250708/3794e424/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: cropped-geomaster300x300-1.png
Type: image/png
Size: 33896 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20250708/3794e424/attachment-0001.png>
More information about the QGIS-User
mailing list