Jorge,
Now in apache logs I find:
WARNING PostGIS[7394]: Connection to database failed
connection to server at "db.qgiscloud.com" (136.243.87.197), port 5432
failed: timeout expired
and in Postgres logs:
postgres LOG: could not receive data from client: Connection timed out
proyectos_qgis
Hi Sebastián,
Can you try without passing MAP on the URL?
Try to get the Capabilities document in first place.
http://qgis.server:6080/cgi-bin/qgis_mapserv.fcgi?SERVICE=WMS&VERSION=1.3.0&REQUEST=GetCapabilities
Regards,
Jorge Gustavo
On 11/02/25 22:52, Sebastián Meyer via QGIS-User wrote:
H
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
##
Hi Sebastián,
This is an example of QGIS_PROJECT_FILE:
"postgresql://geobox:geobox@192.168.1.96:5432?sslmode=disable&dbname=geotuga&schema=qgis&project=world"
The project name is "world" and it is stored in "qgis_projects" table,
in schema "qgis", in the database called "geotuga".
PostgreSQ
Hi,
a follow-up. I tried saving a project in the Public schema of another
database, and when trying to publish it the result was the same.
So I'm stucked with apache.
My doubt is in this connection template for QGIS_PROJECT_FILE
postgresql://localhost:5432?sslmode=disable&dbname=mydb&schema
Hi,
I'm closer now thank you.
What I can't find in the docs is how to specify a database schema where
I stored the projects table.
The URI is (db.schema.table) proyectos_qgis.qgis_metadata.qgis_projects
# Apache webserver config:
SetEnv PG_SERVICE_FILE "/var/www/.pg_service.conf"
SetEnv QGI
Hi,
The parameters you indicate don't exist, but there does exist
QGIS_PROJECT_FILE, see documentation at
https://docs.qgis.org/3.34/en/docs/server_manual/config.html#server-env-variables
The best way to find possible connection problems or configuration
errors is to have a look at the QGIS
