[Qgis-user] QGIS Server and PostgreSQL projects

[Jorge Gustavo Rocha]

Hi,

It is possible and works pretty well. I do it with dozens of QGIS projects.

I use a rewrite rule in Apache to point to the project on the database.

Check our this can be done is this comment:

https://github.com/qgis/QGIS/issues/31192#issuecomment-756105179

Best regards,

Jorge

On 06/09/24 12:41, User Adminofff via QGIS-User wrote:
> 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

-- 
Jorge Gustavo Rocha
Geomaster, LDA
"Take the open source journey with us"

VAT/NIF: PT 510 906 109
Phone: +351 253 257 173 (landline)
Mobile: +351 910 333 888 (cellular)

Rua Afonso Palmeira, 31, 7 D
4715-278 Braga
PORTUGAL
GPS 41.54627, -8.40432
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20240906/c794ced9/attachment.htm>