[Lizmap] Lizmap PostgreSQL search

[G. Wagner, Wagner-IT]

Hi Arnaud,

 

Thanks for the feedback.

Yes - lizmap_search is in the public schema.

 

Unfortunately, the error log in the backend is empty. Also, after the the debug mode was turned on.

 

The "lizmap/var/config/lizmapLogConfig.ini.php" file looks like this:

 

; debug mode

; on = print debug messages in lizmap/var/log/messages.log

; off = no lizmap debug messages

debugMode=1

; cache root directory where cache files will be stored

; must be writable

cacheRootDirectory="/tmp/"

 

; path to find repositories

;rootRepositories="path"

; Does the server use relative path from root folder? 0/1

;relativeWMSPath=0

 

appName=Lizmap

qgisServerVersion=3.0

wmsMaxWidth=3000

wmsMaxHeight=3000

projectSwitcher=off

relativeWMSPath=0

requestProxyEnabled=0

requestProxyType=http

requestProxyNotForDomain="localhost,127.0.0.1"

uploadedImageMaxWidthHeight=1920

[repository:3]

label="Test DB-Suche"

path="/var/www/lm_test/lizmap/install/test_db_suche/"

allowUserDefinedThemes=0

 

[item:login]

label="User logs in"

logCounter=on

logDetail=on

logIp=on

 

 

In the directory "lizmap/var/log" there is only an empty "errors.log".

 

Are my log settings wrong?

 

Regards,

Günter

 

 

Von: Arnaud Vandecasteele <arnaud.sig at gmail.com> 
Gesendet: Dienstag, 31. Mai 2022 06:25
An: G. Wagner, Wagner-IT <info at wagner-it.de>
Cc: Etienne Trimaille <etienne.trimaille at gmail.com>; Lizmap at lists.osgeo.org
Betreff: Re: [Lizmap] Lizmap PostgreSQL search

 

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 <mailto: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 <mailto:info at wagner-it.de> > 
Gesendet: Montag, 30. Mai 2022 22:38
An: 'Etienne Trimaille' <etienne.trimaille at gmail.com <mailto:etienne.trimaille at gmail.com> >
Cc: 'Lizmap at lists.osgeo.org <mailto:Lizmap at lists.osgeo.org> ' <Lizmap at lists.osgeo.org <mailto: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

_______________________________________________
Lizmap mailing list
Lizmap at lists.osgeo.org <mailto: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/a0fb5faf/attachment-0001.htm>