[Lizmap] Lizmap PostgreSQL search

[G. Wagner, Wagner-IT]

lizmap/var/config/profiles.ini.php:

 

[jdb:search]

driver="pgsql"

database=xxxx       # here is the table lizmap_search included

host=localhost

user=xxxxx

password=xxxxx

 

The database is located on the same server

 

 

Von: G. Wagner, Wagner-IT <info at wagner-it.de> 
Gesendet: Montag, 30. Mai 2022 22:38
An: 'Etienne Trimaille' <etienne.trimaille at gmail.com>
Cc: 'Lizmap at lists.osgeo.org' <Lizmap at lists.osgeo.org>
Betreff: AW: [Lizmap] Lizmap PostgreSQL search

 

no, the users are not stored in a PG database. Access data to the DB are still in the QGIS file.

 

Von: Etienne Trimaille <etienne.trimaille at gmail.com <mailto:etienne.trimaille at gmail.com> > 
Gesendet: Montag, 30. Mai 2022 22:33
An: G. Wagner, Wagner-IT <info at wagner-it.de <mailto:info at wagner-it.de> >
Cc: Lizmap at lists.osgeo.org <mailto:Lizmap at lists.osgeo.org> 
Betreff: Re: [Lizmap] Lizmap PostgreSQL search

 

Hi,

 

How is done the access to the database ? (is your Lizmap users stored in PG already or not)

https://docs.lizmap.com/current/en/publish/configuration/spatial_search.html#configure-access

 

Le lun. 30 mai 2022 à 22:19, G. Wagner, Wagner-IT <info at wagner-it.de <mailto:info at wagner-it.de> > a écrit :

Hi,

 

I still miss the very simple and perfomant search with the "QuickFinder Plugin" from QGIS 2.x. That's why I still have some projects running with QGIS Server 2.18 and Lizmap 3.3.

 

Now I try again with the SQL search. The creation of the extension, function and the entries in the profiles.ini.php are clear.

Then I create a database with the specified columns [1]. But is this only one database for all possible searches of different projects? And there are all geometries included?

 

A "SELECT * FROM lizmap_search LIMIT 1;" is indeed successful from the PgAdmin or also from the QGIS DB management. But in the Lizmap client I get no search results.

Is there an example, maybe even with sample database?

 

Or is there still hope for a new QuickFinder plugin? I would also like to participate financially.

 

Regards,

Günter

 

 

[1] https://docs.lizmap.com/3.5/en/publish/configuration/spatial_search.html

 

 

 

_______________________________________________
Lizmap mailing list
Lizmap at lists.osgeo.org <mailto:Lizmap at lists.osgeo.org> 
https://lists.osgeo.org/mailman/listinfo/lizmap

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/lizmap/attachments/20220530/019b6557/attachment.htm>