[Qgis-user] QGIS server : Serve Postgis data ?

[celati Laurent]

Good afternoon,
Following to my previous message, I'm sharing my error. I am unable to
serve a project containing postgis tables. For a first test, I'm just
trying to serve one of the tables contained in my project. Here is the URL
that I defined and tested. I tried to define max and min coordinates (BBOX)
in the spatial reference system in 2154 (Lambert 93).

* http://SERVEUR/cgi-bin/qgis_mapserv.fcgi?MAP=/home/qgis/projects/cigeo_forages.qgs&LAYERS=Cigeo_Zios_Po&SERVICE=WMS&VERSION=1.3.0&REQUEST=GetMap&CRS=EPSG:2154&WIDTH=400&HEIGHT=200&BBOX=865347.7454,6820554.3899,886533.8979,6833234.8104
<http://SERVEUR/cgi-bin/qgis_mapserv.fcgi?MAP=/home/qgis/projects/cigeo_forages.qgs&LAYERS=Cigeo_Zios_Po&SERVICE=WMS&VERSION=1.3.0&REQUEST=GetMap&CRS=EPSG:2154&WIDTH=400&HEIGHT=200&BBOX=865347.7454,6820554.3899,886533.8979,6833234.8104>*

Please read below the error message : Internal Server Error



*The server encountered an internal error or misconfiguration and was
unable to complete your request.Please contact the server administrator at
webmaster at localhost to inform them of the time this error occurred, and the
actions you performed just before this error.More information about this
error may be available in the server error log.*
If someone has any idea? To be complete, since the beginning of my tests, I
have never had a log file generated in /var/log/qgis...This folder has been
always remained empty
Thanks a lot.

Le lun. 27 mars 2023 à 11:48, celati Laurent <laurent.celati at gmail.com> a
écrit :

> Good morning,
> I have just (finally) validated the installation of Qgis server on our
> Debian server.
> I manage to serve/broadcast the .qgs project and the data made available
> by the community (world.qgs project). These are shp files.
> In parallel with the installation of Lizmap or QWC2, I would like to test
> this time the fact to serve of qgis projects containing postgis tables from
> our database. How to do this ? Especially for the definition of the URL?
> How to define in the URL the sources of the postgis tables? The URL notably
> has a LAYERS&...
> How for example to publish all the postgis tables contained in a project,
> without having to specify each of them in the URL?
> Thank you so much.
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20230327/2c14642e/attachment.htm>