[Mapbender-users] #Mapbender #SearchRouter #PostgreSQLconnection

Wed Jun 8 23:31:00 PDT 2022

Hello,

please put the parameter n in quotes in parameters.yml

     # database connection "dzrol"
     database2_driver:   pdo_pgsql
     database2_host:     'localhost'
     database2_port:     '5433'
     database2_name:     'dzrol'
     database2_path:     ~
     database2_user:     ******
     database2_password: ******

You have to modify the parameters.yml and conifg.yml file

https://doc.mapbender.org/en/customization/yaml.html#yaml

Then you should empty the cache at app/cache/

Best ist to check with the app_dev.php developer mode whether the 
database is available.

Something like
http://localhost/mapbedner/app_dev.php

https://doc.mapbender.org/en/customization/yaml.html#yaml

See you Astrid

Am 2022-06-08 17:05, schrieb Jörg Thomsen:
> Hello Marcin,
> 
> thanks for your praise!
> Your config looks OK, to be sure:
> 
>  - port 5433 is correct, you are using pgbouncer?
>  - name of the database is dzrol? (parameters.yml)
>  - name of the table is dzrol too (relation: dzrol)
> 
> What's the error you get? Using the network-tools of the browser you
> can have a look at the request and results Mapbender sends and gets
> back from the server. Can find any hints in the Mapbender log-files?
> 
> For testing I would use
> compare: ilike (instead of exact)
> 
> 
> To your 2nd question:
> Do you know 
> https://doc.mapbender.org/en/development/element_generate.html
> You will find there how to create an own working MB-Element in
> general.  The rest should be done with html/javascript, php on
> server-side an a some blood, sweat and tears.
> 
> 
> Am 08.06.22 um 16:29 schrieb Marcin Niemyjski:
>> Hello there,
>> 
>> I have recently started my adventure with Mapbender. From here I 
>> wanted to congratulate you for doing a good job in providing free 
>> geoprocessing solutions.
>> 
>> While creating the geportal I encountered a problem. I would like to 
>> add a Search Router to my geportal but I am having trouble connecting 
>> to a PostgreSQL database. Is it enough if I change database properties 
>> in config parameters.yml file to properties of my database and then 
>> define what I want to search in the Contents tab?
>> 
>> I also have a question about defining checkboxes in Mapbender. I would 
>> like to create a feature using FeatureInfo that displays a graph 
>> created based on data from columns in the database, but the graphs in 
>> the image would only come from columns whose names are marked with 
>> chechboxes. Could you please tell me how I could achieve this 
>> functionality and what I need to learn to do it?
>> 
>> I am also uploading a text file (konfiguracja_Mapbender) showing how I 
>> configured the parameteres.yml, config.yml and search router 
>> configuration files. It would be great if you could check where there 
>> might be a mistake or maybe I am leaving something out.
>> 
>> Best regards,
>> Marcin Niemyjski
>> 
>> 
>> _______________________________________________
>> Mapbender_users mailing list
>> Mapbender_users at lists.osgeo.org
>> https://lists.osgeo.org/mailman/listinfo/mapbender_users
> 
> 
> --
> Viele Grüße,
> Jörg Thomsen
> 
> ---------------------------------------------
> Aufwind durch Wissen!
> Jetzt neu: Web-Seminare und Online-Schulungen
> bei der www.foss-academy.com
> ---------------------------------------------
> 
> Jörg Thomsen
> WhereGroup GmbH
> Bundesallee 23
> 10717 Berlin
> Germany
> 
> Tel: +49 (0)30 / 5130 278 74
> Fax: +49 (0)30 / 5130 278 11
> 
> joerg.thomsen at wheregroup.com
> www.wheregroup.com
> 
> Geschäftsführer:
> Olaf Knopp, Peter Stamm
> Amtsgericht Bonn, HRB 9885
> 
> -------------------------------
> Folgen Sie der WhereGroup auf twitter: 
> http://twitter.com/WhereGroup_com
> _______________________________________________
> Mapbender_users mailing list
> Mapbender_users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/mapbender_users

-- 
Mit freundlichen Grüßen

Astrid Emde
GIS-Consultant

---------------------------------------------
Aufwind durch Wissen!
Jetzt neu: Web-Seminare und Online-Schulungen
bei der www.foss-academy.com
---------------------------------------------

   Astrid Emde
   WhereGroup GmbH
   Eifelstraße 7
   53119 Bonn
   Germany

   Tel: +49(0)228 90 90 38 - 22
   Fax: +49(0)228 90 90 38 - 11

   astrid.emde at wheregroup.com
   www.wheregroup.com

   Meinen PGP Public-Key können Sie unter pgp.mit.edu herunterladen:

https://keys.openpgp.org/vks/v1/by-fingerprint/01F8152D36FC07C25EADDE86C5084ACC1C287CCB
   Signierte und/oder verschlüsselte Nachrichten sind sehr willkommen

   Folgen Sie der WhereGroup auf twitter:
   http://twitter.com/WhereGroup_com

   Geschäftsführer:
   Olaf Knopp, Peter Stamm
   Amtsgericht Bonn, HRB 9885
-------------------------------
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 0x1C287CCB.asc
Type: application/pgp-keys
Size: 1574 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/mapbender_users/attachments/20220609/5461b351/attachment.key>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 228 bytes
Desc: OpenPGP digital signature
URL: <http://lists.osgeo.org/pipermail/mapbender_users/attachments/20220609/5461b351/attachment.sig>