search

NaturalGIS / qgis_server_and_lizmap_on_windows

Easy install/deploy QGIS Server and Lizmap Web Client on MS Windows
16 stars 10 forks source link

error en herramienta de seleccion y herramienta de tabla #7

Closed betikitio closed 12 months ago

betikitio commented 1 year ago

Da un error debido a que la version de php no es compatible con autentificacion SCRAM

2023-03-10 14:32:21 127.0.0.1 warning 2023-03-10 14:32:21 [2] pg_connect(): Unable to connect to PostgreSQL server: SCRAM authentication requires libpq version 10 or above F:\webserver\www\lizmap\lib\jelix\plugins\db\pgsql\pgsql.dbconnection.php 155

2023-03-10 14:32:21 127.0.0.1 error 2023-03-10 14:32:21 [402] error durante la conexión 127.0.0.1 F:\webserver\www\lizmap\lib\jelix\plugins\db\pgsql\pgsql.dbconnection.php 172

2023-03-10 14:32:21 127.0.0.1 warning 2023-03-10 14:32:21 [2] pg_connect(): Unable to connect to PostgreSQL server: SCRAM authentication requires libpq version 10 or above F:\webserver\www\lizmap\lib\jelix\plugins\db\pgsql\pgsql.dbconnection.php 155

2023-03-10 14:32:21 127.0.0.1 error 2023-03-10 14:32:21 [402] error durante la conexión 127.0.0.1 F:\webserver\www\lizmap\lib\jelix\plugins\db\pgsql\pgsql.dbconnection.php 172

Si activo en el pg el modo de conexion md5 no carga las capas.

gioman commented 1 year ago

@betikitio php has been updated to 8.2

jonnyforestGIS commented 12 months ago

@betikitio try to update the odbc client driver of PostgreSQL on your machine. This is not a PHP problem.

Installing the most recent new odbc driver for Postgresql can fix this problem. You can use the stack builder of EntrepriseDB or install directly the driver. This is related to the libpq.dll from your current version of your odbc driver client PostgreSQL installation.

This installation that I recommend will only upgrade the odbc client driver, not the Postgresql server itself.

If you have Stack Builder of PostgreSQL installation you can look for a new version of ODBC driver for PostgreSQL. If not you can do 2 things:

You can use this (Necessary to create a free account to download) https://www.enterprisedb.com/software-downloads-postgres#edb-connectors

or directly from the PostgreSQL site: https://ftp.postgresql.org/pub/odbc/versions/msi/psqlodbc_13_02_0000-x64-1.zip

I hope this helps you. If not read more in: https://www.cybertec-postgresql.com/en/from-md5-to-scram-sha-256-in-postgresql/

Remember revert SCRAM authentication to MD5 reduces the security of the authentication. I recommend not doing this if it is a production environment.

Cheers.