[Mapbender-users] #Mapbender #SearchRouter #PostgreSQLconnection

Thu Jun 9 07:16:47 PDT 2022

Hello again,

thanks to your advice I managed to make it work. After correcting parameters (putting them in quotes) and emptying cache I had to install php-pgsql driver and everything started working like a charm 🙂

Big thanks again,
Marcin
________________________________
From: Mapbender_users <mapbender_users-bounces at lists.osgeo.org> on behalf of Astrid Emde (WhereGroup) <astrid.emde at wheregroup.com>
Sent: Thursday, June 9, 2022 8:31 AM
To: Mapbender User List <mapbender_users at lists.osgeo.org>
Subject: Re: [Mapbender-users] #Mapbender #SearchRouter #PostgreSQLconnection

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<http://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<http://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<http://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<http://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 --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapbender_users/attachments/20220609/8e311c9a/attachment-0001.htm>