[Qgis-user] QGIS Server and PostgreSQL projects

[User Adminoff]

Hi Alessandro,

This is an interesting feature, but am I see right that it doesn't have 
any access rights restrictions?


Alessandro Pasotti wrote:
>
> 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 <mailto: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 <mailto: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 <mailto: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 <mailto: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 <https://www.qcooperative.net>
> ItOpen: www.itopen.it <http://www.itopen.it>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20240907/b2438c77/attachment.htm>