[Mapbender-users] #Mapbender #SearchRouter #PostgreSQLconnection

Fri Jun 10 05:22:06 PDT 2022

Great! Thanks for your feedback and enjoy working with Mapbender.

See you Astrid Emde

Am 2022-06-09 16:16, schrieb Marcin Niemyjski:
> 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 [1]
>> ---------------------------------------------
>> 
>> 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 [2]
>> 
>> 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 [1]
> ---------------------------------------------
> 
>    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 [2]
> 
>    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
> -------------------------------
> 
> Links:
> ------
> [1] http://www.foss-academy.com
> [2] http://www.wheregroup.com

-- 
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/20220610/2d98ce9d/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/20220610/2d98ce9d/attachment.sig>