[Qgis-user] QGIS Server and PostgreSQL projects

[Abel Gonzalez]

But as I understand Landing pages only works for Linux?

Best regards!
Abel

Den fre 6 sep. 2024 16:35Alessandro Pasotti <apasotti at gmail.com> skrev:

>
> Another possibility:
> https://docs.qgis.org/3.34/en/docs/server_manual/catalog.html
>
> You will need co configure an env variable:
> QGIS_SERVER_LANDING_PAGE_PROJECTS_PG_CONNECTIONS
>
> all projects stored in the connections above will be listed in the catalog.
>
>
> On Fri, Sep 6, 2024 at 4:26 PM Abel Gonzalez via QGIS-User <
> qgis-user at lists.osgeo.org> wrote:
>
>> Hi! I just installed QGIS server on my windows server under Apache HTTPD
>> and postgres in the sabe server and works fine.  There after if you want to
>> show the qgis projects on a map you should install QGIS Web Client or
>> Lizmap. In order to serve WMS, WFS , etc qgis project should no be saved on
>> postgis, otherwise will require extra configuration.
>> Good luck!
>> Abel
>>
>> Den fre 6 sep. 2024 16:09User Adminofff via QGIS-User <
>> qgis-user at lists.osgeo.org> skrev:
>>
>>> Hi,
>>>
>>> I'm trying to make QGIS Server to serve projects from PostgreSQL
>>> database on the web.
>>> Could anyone tell me please, is it possible to do that, or I can serve
>>> only files?
>>>
>>> The general workflow should look like this:
>>>
>>> 1. Operators with QGIS Desktop are connecting to PostgreSQL, and
>>> create/modify projects in it.
>>> No files are involved. This part works, I was able to save test project
>>> on one system, and open it on the other.
>>>
>>> 2. After finishing project creation/modification, Operators send a link
>>> to it to the consumers/implementors.
>>> The idea is to be able to view the project in a browser on any device.
>>> No editing is needed, at least at this moment.
>>> I've installed QGIS Server on the same host as PostgreSQL, set
>>> nginx/related stuff, and tested that it successfully serves file project.
>>> Then I've tried to get the project from database. qgis user, under which
>>> QGIS server is run, was allowed passwordless connection to PostgreSQL via
>>> localhost.
>>>
>>> Having test URL for file like this
>>>
>>> https://domain.com/qgisserver/cgi-bin/qgis_mapserv.fcgi?LAYERS=countries&SERVICE=WMS&VERSION=1.3.0&REQUEST=GetMap&CRS=EPSG:4326&WIDTH=400&HEIGHT=200&BBOX=-90,-180,90,180&MAP=/home/qgis/projects/world.qgs
>>>
>>> I've replaced file path with naive PostgreSQL URL like this
>>>
>>> https://domain.com/qgisserver/cgi-bin/qgis_mapserv.fcgi?LAYERS=countries&SERVICE=WMS&VERSION=1.3.0&REQUEST=GetMap&CRS=EPSG:4326&WIDTH=400&HEIGHT=200&BBOX=-90,-180,90,180&MAP=postgresql://127.0.0.1:5432?sslmode=disable&dbname=qgis&schema=world&project=world
>>> But got this error:
>>>
>>> <ServerException>
>>> Project file error. For OWS services: please provide a SERVICE and a MAP
>>> parameter pointing to a valid QGIS project file
>>> </ServerException>
>>>
>>> The error says that QGIS Server wants file, no mentions about database.
>>> On other hand, documentation below says that for MAP parameter either
>>> file path or PostgreSQL URL is needed, so it should work?
>>>
>>>
>>> https://docs.qgis.org/3.34/en/docs/server_manual/config.html#qgis-server-envvar
>>> QGIS_PROJECT_FILE
>>> The .qgs or .qgz project file, normally passed as a parameter in the
>>> query string (with MAP), you can also set it as an environment variable
>>> (for example by using mod_rewrite Apache module).
>>>
>>> **Note that you may also indicate a project stored in PostgreSQL**, e.g.
>>> postgresql://localhost:5432?sslmode=disable&dbname=mydb&schema=myschema&project=myproject
>>> or inside a geopackage file, e.g.
>>> geopackage:/path/to/geopackage/file.gpkg?projectName=myProjectName.
>>>
>>>
>>> Searching in the Internet for the error above, I've found this bug
>>> report
>>> https://github.com/qgis/QGIS/issues/31192
>>>
>>> From which I've got the idea to encode PostgreSQL URL in test URL, but
>>> it didn't work with the same error as above.
>>> Also, it looks like report author is connecting with QGIS Desktop to
>>> QGIS Server, not browser, so this is not my case?
>>> Also-also, as I've stuck with nginx for unrelated to QGIS reasons, I
>>> cannot test proposed there Apache rewrite magic.
>>>
>>> I've tried to see if there is anything useful in QGIS Server logs, but
>>> there are no any related messages in them.
>>> I've set QGIS_SERVER_LOG_PROFILE to true, but that didn't change
>>> anything. I see my request to QGIS server only in nginx logs, but nothing
>>> in QGIS Server logs, and no even failed connection attempts in PostgreSQL
>>> logs.
>>>
>>> So, is there any way to have PostreSQL projects served via QGIS Server,
>>> or I can use only files?
>>> _______________________________________________
>>> 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
>>
>
>
> --
> Alessandro Pasotti
> QCooperative:  www.qcooperative.net
> ItOpen:   www.itopen.it
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20240906/0cc51013/attachment-0001.htm>