Wrong DB connection during generation of service configuration

[nilskamm]

Hey everyone!
I try to get one of our projects into QWC.
I uploaded the .qgs file into the scan folder and get an error, that the "Layer(s) not valid" for this file, when genearting a new service configuration in the QWC Admin.
In that moment i can find an error in the log of the docker container qwc-docker-qwc-qgis-server-1.
It tries to connect to our postgis database we use in our QGIS clients.
Address and database is right, but it uses the user "www-data" instead of the user configured in our QGIS clients.
I tried to put the right connection into qwc_docker/pg_service.conf - qwc_docker/pg_service-write.conf but it doesn´t change the error message.

Where do i have to configure the database connection to give the file / scan the right credentials?

Thanks a lot!

Let me know, if i can provide any more information!

[manisandro]

How did you configure your PG data source in the QGIS project? Are you using a service name defined in the pg_service.conf or hostname/port/username/password?

[nilskamm]

I don´t realy know. I guess it is hostname/port/username/password.
We startet to use a postgis docker, before we even planned using QWC.
So for my test project i just created a new plaine project.
And added one of our layers by double-clicking it in the "PostgreSQL" section of the "Browser" part in the QGIS client.
I looked for database settings in the project and layer settings but i don´t find anything there.

[manisandro]

I suspect you have an empty username, which means that the username which runs the process is used (i.e. www-data on the server).

[nilskamm]

Hope the words are right, because i have the QGIS client installed in german and translate it as good as i can.
I created the connection by right-click on "PostgreSQL" and "New connection..." in the "Browser" area of the QGIS client.
After adding a name, host, port and database a set ssl-mode "demand" and in "authentification" i chose the tab "configuration" where i created a new configuration with the hostname as name for the configuration, "basic authentication", our username and password. So i guess it doesn´t get the right username out of the configuration. Is there a way to change it to a namespace and could i then put the namespace into the pg_service.conf of QWC?

[manisandro]

In the connection details, you can leave out hostname/port/database/username/password, and instead just specify service to the name of a service in pg_services.conf.

[nilskamm]

I was able to change my QGIS client language to english now. But i cannot find a way to just set a service name. Can you tell me where exactly i can change that? Sorry if that is absolute beginners knowledge. I feel kind a stupid not finding it. 😅

[manisandro]

[nilskamm]

Now i feel even more stupid. ^^
Thanks a lot. I changed to a service and put the information for the service into the pg_service files of the qwc_docker. Now the connection error is not there anymore but my layer is still invalid.

The log of the container qwc-docker-qwc-qgis-server-1 only gives this information:

16:06:45 CRITICAL Server[74]: Error, Layer(s) area_solar_4b06a23d_c367_421e_9d5d_5e0b4d87c642 not valid in project /data/scan/solar.qgs
16:06:45 WARNING Server[74]:
Layer(s) not valid

Is there any way to get more information why it is invalid if it works in QGIS client and the "Test Configuration" in the "QGIS Server" part of the project properties says that the project is valid?

[manisandro]

Try adding QGIS_SERVER_LOG_LEVEL: 0:

  qwc-qgis-server:
    image: docker.io/sourcepole/qwc-qgis-server:3.34
    environment:
      QGIS_SERVER_LOG_LEVEL: 0

[nilskamm]

Thank you for all your help.
With the log level 0 i do not get any further information.
The QWC Admin says "CRITICAL: Could not get WMS GetProjectSettings from http://qwc-qgis-server/ows/scan/solar:
b'\nLayer(s) not valid\n'" and i don´t know how to fix it.
Everything i find on the internet says, that the database connection is the problem, most of the times, when this error occurs. But that is fixed with your solution.
Any idea how to fix that or get more information about this error?

[manisandro]

Did you look at the qgis-server logs?

docker compose logs -f qwc-qgis-server

[nilskamm]

Yes. With the log level 0 it says the following:

15:44:22 INFO Server[74]: ******************** New request ***************
15:44:22 INFO Server[74]: Request URL: http://qwc-qgis-server/ows/qwc_demo?map=/data/qwc_demo.qgs&SERVICE=WMS&VERSION=1.3.0&REQUEST=GetProjectSettings&CLEARCACHE=1
15:44:22 INFO Server[74]: Environment:
15:44:22 INFO Server[74]: ------------------------------------------------
15:44:22 INFO Server[74]: SERVER_NAME: qwc-qgis-server
15:44:22 INFO Server[74]: REQUEST_URI: /ows/qwc_demo?SERVICE=WMS&VERSION=1.3.0&REQUEST=GetProjectSettings&CLEARCACHE=1
15:44:22 INFO Server[74]: SCRIPT_NAME: /cgi-bin/qgis_mapserv.fcgi
15:44:22 INFO Server[74]: REMOTE_ADDR: 172.18.0.5
15:44:22 INFO Server[74]: SERVER_PORT: 80
15:44:22 INFO Server[74]: QUERY_STRING: map=/data/qwc_demo.qgs&SERVICE=WMS&VERSION=1.3.0&REQUEST=GetProjectSettings&CLEARCACHE=1
15:44:22 INFO Server[74]: REQUEST_METHOD: GET
15:44:22 INFO Server[74]: SERVER_PROTOCOL: HTTP/1.1
Headers:
------------------------------------------------
"Accept" :  "*/*"
"Host" :  "qwc-qgis-server"
"User-Agent" :  "python-requests/2.31.0"
15:44:22 INFO Server[74]: CLEARCACHE:1
15:44:22 INFO Server[74]: MAP:/data/qwc_demo.qgs
15:44:22 INFO Server[74]: REQUEST:GetProjectSettings
15:44:22 INFO Server[74]: SERVICE:WMS
15:44:22 INFO Server[74]: VERSION:1.3.0
15:44:22 WARNING Server[74]: Found WMS capabilities document in cache
15:44:22 INFO Server[74]: Request finished in 2 ms
127.0.0.1:80 172.18.0.5 - - [10/Feb/2025:15:44:22 +0000] "GET /ows/qwc_demo?SERVICE=WMS&VERSION=1.3.0&REQUEST=GetProjectSettings&CLEARCACHE=1 HTTP/1.1" 200 4030 "-" "python-requests/2.31.0"
15:44:22 INFO Server[74]: ******************** New request ***************
15:44:22 INFO Server[74]: Request URL: http://qwc-qgis-server/ows/scan/solar?map=/data/scan/solar.qgs&SERVICE=WMS&VERSION=1.3.0&REQUEST=GetProjectSettings&CLEARCACHE=1
15:44:22 INFO Server[74]: Environment:
15:44:22 INFO Server[74]: ------------------------------------------------
15:44:22 INFO Server[74]: SERVER_NAME: qwc-qgis-server
15:44:22 INFO Server[74]: REQUEST_URI: /ows/scan/solar?SERVICE=WMS&VERSION=1.3.0&REQUEST=GetProjectSettings&CLEARCACHE=1
15:44:22 INFO Server[74]: SCRIPT_NAME: /cgi-bin/qgis_mapserv.fcgi
15:44:22 INFO Server[74]: REMOTE_ADDR: 172.18.0.5
15:44:22 INFO Server[74]: SERVER_PORT: 80
15:44:22 INFO Server[74]: QUERY_STRING: map=/data/scan/solar.qgs&SERVICE=WMS&VERSION=1.3.0&REQUEST=GetProjectSettings&CLEARCACHE=1
15:44:22 INFO Server[74]: REQUEST_METHOD: GET
15:44:22 INFO Server[74]: SERVER_PROTOCOL: HTTP/1.1
Headers:
------------------------------------------------
"Accept" :  "*/*"
"Host" :  "qwc-qgis-server"
"User-Agent" :  "python-requests/2.31.0"
15:44:22 INFO Server[74]: CLEARCACHE:1
15:44:22 INFO Server[74]: MAP:/data/scan/solar.qgs
15:44:22 INFO Server[74]: REQUEST:GetProjectSettings
15:44:22 INFO Server[74]: SERVICE:WMS
15:44:22 INFO Server[74]: VERSION:1.3.0
15:44:22 CRITICAL Server[74]: Error, Layer(s) area_solar_4b06a23d_c367_421e_9d5d_5e0b4d87c642 not valid in project /data/scan/solar.qgs
15:44:22 WARNING Server[74]: <?xml version="1.0" encoding="UTF-8"?>
<ServerException>Layer(s) not valid</ServerException>

15:44:22 INFO Server[74]: Request finished in 184 ms
127.0.0.1:80 172.18.0.5 - - [10/Feb/2025:15:44:22 +0000] "GET /ows/scan/solar?SERVICE=WMS&VERSION=1.3.0&REQUEST=GetProjectSettings&CLEARCACHE=1 HTTP/1.1" 500 310 "-" "python-requests/2.31.0"

For me it just says, that the layer is not valid or do i miss something?

[manisandro]

Ok, so you see that the layer with id area_solar_4b06a23d_c367_421e_9d5d_5e0b4d87c642 is invalid. What is the data source of this layer?

[nilskamm]

The data source is the database i was able to connect via servicename.

"Original source URI: service='servicename' sslmode=require authcfg=XXXXXxx key='id' srid=XXXXX type=Polygon checkPrimaryKeyUnicity='1' table="areas"."area-solar" (geom)"

[manisandro]

Is servicename defined in the pg_service.conf which is mounted into the qwc-qgis-server container? Does it is specify all required information to connect to the database?

sslmode=require: Any self-signed certificates?