Can't edit PostGIS layer about lizmap-web-client HOT 13 CLOSED

Perfect... it works!!!

from lizmap-web-client.

What are the messages in the console?

from lizmap-web-client.

I have no error log in the console of the LWC panel!
But if I inspect the webpage as soon as I click on add, I have this error:

from lizmap-web-client.

Now in admin => Lizmap logs?

from lizmap-web-client.

Do you mean in ${APACHE_LOG_DIR}/error_lizmap.log ?
If yes, I'll have access to it only next week :-(

from lizmap-web-client.

I mean in https://yourwebsite/admin.php/admin/logs but it might be the same as in error_lizmap.log, I don't remember.

from lizmap-web-client.

So I have no error in the admin control...

from lizmap-web-client.

usually "Error 500" php error aren't logged in lizmap-admin (displayed in admin panel), but in /<LizmapDir>/var/log/errors.log

from lizmap-web-client.

OK, here it is:

2024-03-29 10:40:13 [2] pg_connect(): Unable to connect to PostgreSQL server: definition of service "drosera_db" not found /var/www/lizmap-web-client/lizmap/vendor/jelix/jelix/lib/jelix/plugins/db/pgsql/pgsql.dbconnection.php 168

2024-03-29 10:40:13 [402] Impossible de se connecter sur drosera_db (mauvais host, login ou mot de passe ?) /var/www/lizmap-web-client/lizmap/vendor/jelix/jelix/lib/jelix/plugins/db/pgsql/pgsql.dbconnection.php 184

2024-03-29 10:40:36 [2] pg_connect(): Unable to connect to PostgreSQL server: definition of service "drosera_db" not found /var/www/lizmap-web-client/lizmap/vendor/jelix/jelix/lib/jelix/plugins/db/pgsql/pgsql.dbconnection.php 168

2024-03-29 10:40:36 [402] Impossible de se connecter sur drosera_db (mauvais host, login ou mot de passe ?) /var/www/lizmap-web-client/lizmap/vendor/jelix/jelix/lib/jelix/plugins/db/pgsql/pgsql.dbconnection.php 184

So, how the "definition of service" can be wrong, and being able to load the data, and even check the value of the entities (popup)?

from lizmap-web-client.

Do I need a pg_connect file??? I only use a .pg_service file... I never use a pg_connect file before?

from lizmap-web-client.

Rendering the map, popup info retrieving is performed by QGIS through php but edition is performed by php only

Your pg_service file need to be available for php, can you try to copy it in /etc/postgresql-common/

see : #620 (comment)

from lizmap-web-client.

OK, I don't have access to the server until next week... except on FTP, but I can't load data in this directory!
So I'll try it next week, and give you a feedback! Just to be sure, the group/permission must be www-data:www-data?
If I understand it correctly, I can also point my QGIS server PGSERVICEFILE env to /etc/postgresql-common/.pg_service.conf, so that I have only one pg_service file on my system? Correct?
Thank you very much for your help!

from lizmap-web-client.

refs #1638

from lizmap-web-client.