[Qgis-user] QGIS Server setup <-- PostgreSQL/PostGIS

[Sebastián Meyer]

Hi,

Thanks a lot! Subject cleared!

I'll share my details, Apache config, tests that work and full error log.

Apache qgis.server:6080

PostgreSQL qgis.server:7000

DB structure: proyectos_qgis / qgis_metadata / qgis_projects (projects)

                              / z_project1    / layer n


### Apache config (I left off logs variables only. Maybe some mandatory 
variables I'm missing? No QGIS_AUTH_DB_DIR_PATH or PG_SERVICE_FILE...)
<VirtualHost *:6080>

   ServerAdmin webmaster at qgis.server
   ServerName qgis.server

   DocumentRoot /var/www/html

   # Longer timeout for WPS... default = 40
   FcgidIOTimeout 120

   FcgidInitialEnv LC_ALL "es_AR.UTF-8"
   FcgidInitialEnv PYTHONIOENCODING UTF-8
   FcgidInitialEnv LANG "es_AR.UTF-8"

   SetEnv QGIS_PROJECT_FILE 
"postgresql://user:pass@qgis.server:7000?sslmode=disable&dbname=proyectos_qgis&schema=qgis_metadata&project=z_project1"

   ScriptAlias /cgi-bin/ /usr/lib/cgi-bin/
   <Directory "/usr/lib/cgi-bin/">
     AllowOverride None
     Options +ExecCGI -MultiViews -SymLinksIfOwnerMatch
     Require all granted
   </Directory>

   <IfModule mod_fcgid.c>
     FcgidMaxRequestLen 26214400
     FcgidConnectTimeout 60
     FcgidInitialEnv DISPLAY ":99"
   </IfModule>

</VirtualHost>


### Tested

a- DB access successfully with

sudo -u www-data psql "dbname='proyectos_qgis' host='qgis.server' 
user='user' password='pass' port='7000'"

b- Full project access from QGis Desktop via PostGIS connection to 
z_project1



### Error log to request 
http://qgis.server:6080/cgi-bin/qgis_mapserv.fcgi?MAP=z_project1&SERVICE=WMS&VERSION=1.3.0&REQUEST=GetMap&FORMAT=image/jpeg


18:51:07 INFO Server[5035]: QGIS Server Starting : 3.40.3-Bratislava 
(2a274ab7754)
18:51:07 INFO Server[5035]: QGIS Server Settings:

<snip> LOT OF INFOs </snip>


18:51:07 WARNING Server[5035]: Invalid cache strategy, expecting 
'filesystem', 'periodic' or 'off'. Using 'filesystem' as default.
18:51:07 WARNING Server[5035]: Invalid cache strategy, expecting 
'filesystem', 'periodic' or 'off'. Using 'filesystem' as default.
18:51:07 INFO Server[5035]: Initializing 'filesystem' cache strategy
18:51:07 INFO Server[5035]: Server initialized
18:51:07 INFO ./src/server/qgsserverplugins.cpp[5035]: load library 
/usr/lib/qgispython (3.40.3)
18:51:07 INFO ./src/server/qgsserverplugins.cpp[5035]: Python support 
library loaded successfully.
18:51:08 INFO Server[5035]: No server python plugins are available
18:51:08 INFO Server[5035]: ******************** New request ***************
18:51:08 INFO Server[5035]: Request URL: 
http://qgis.server:6080/cgi-bin/qgis_mapserv.fcgi?MAP=z_project1&SERVICE=WMS&VERSION=1.3.0&REQUEST=GetMap&FORMAT=image/jpeg
18:51:08 INFO Server[5035]: Environment:
18:51:08 INFO Server[5035]: ------------------------------------------------
18:51:08 INFO Server[5035]: SERVER_NAME: qgis.server
18:51:08 INFO Server[5035]: REQUEST_URI: 
/cgi-bin/qgis_mapserv.fcgi?MAP=z_project1&SERVICE=WMS&VERSION=1.3.0&REQUEST=GetMap&FORMAT=image/jpeg
18:51:08 INFO Server[5035]: SCRIPT_NAME: /cgi-bin/qgis_mapserv.fcgi
18:51:08 INFO Server[5035]: REMOTE_ADDR: 172.30.64.19
18:51:08 INFO Server[5035]: SERVER_PORT: 6080
18:51:08 INFO Server[5035]: QUERY_STRING: 
MAP=z_project1&SERVICE=WMS&VERSION=1.3.0&REQUEST=GetMap&FORMAT=image/jpeg
18:51:08 INFO Server[5035]: REQUEST_METHOD: GET
18:51:08 INFO Server[5035]: QGIS_PROJECT_FILE: 
postgresql://user:pass@qgis.server:7000?sslmode=disable&dbname=proyectos_qgis&schema=qgis_metadata&project=z_project1
18:51:08 INFO Server[5035]: SERVER_PROTOCOL: HTTP/1.1
Headers:
------------------------------------------------
"Accept" : 
"text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7"
"Host" :  "qgis.server:6080"
"User-Agent" :  "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 
(KHTML, like Gecko) Chrome/132.0.0.0 Safari/537.36"
18:51:08 INFO Server[5035]: FORMAT:image/jpeg
18:51:08 INFO Server[5035]: MAP:z_project1
18:51:08 INFO Server[5035]: REQUEST:GetMap
18:51:08 INFO Server[5035]: SERVICE:WMS
18:51:08 INFO Server[5035]: VERSION:1.3.0
18:51:08 CRITICAL Server[5035]: Error when loading project file 
'z_project1': Unable to open z_project1
18:51:08 WARNING Server[5035]: <?xml version="1.0" encoding="UTF-8"?>
<ServerException>Project file error. For OWS services: please provide a 
SERVICE and a MAP parameter pointing to a valid QGIS project 
file</ServerException>

18:51:08 INFO Server[5035]: Request finished in 2 ms


TIA,

--

seb