[Lizmap] Lizmap PostgreSQL search

[Arnaud Vandecasteele]

Hi,
Is your lizmap_search in the public schema or in a different one ?
If it is located on a different schema you must add the search_path config.

Do you have any additional information in your lizmap log regarding the
search functionality ?

Regards,

Arnaud



On Tue, May 31, 2022 at 12:45 AM G. Wagner, Wagner-IT <info at wagner-it.de>
wrote:

> 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>
> *Gesendet:* Montag, 30. Mai 2022 22:33
> *An:* G. Wagner, Wagner-IT <info at wagner-it.de>
> *Cc:* 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> 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
> https://lists.osgeo.org/mailman/listinfo/lizmap
>
> _______________________________________________
> Lizmap mailing list
> Lizmap at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/lizmap
>


-- 
--------------------------------------------------------------------
Arnaud Vandecasteele
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/lizmap/attachments/20220531/e736b0d0/attachment.htm>