<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Hello again,</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
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
<span id="🙂">🙂</span></div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Big thanks again,</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Marcin<br>
</div>
<div id="appendonsend"></div>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b> Mapbender_users <mapbender_users-bounces@lists.osgeo.org> on behalf of Astrid Emde (WhereGroup) <astrid.emde@wheregroup.com><br>
<b>Sent:</b> Thursday, June 9, 2022 8:31 AM<br>
<b>To:</b> Mapbender User List <mapbender_users@lists.osgeo.org><br>
<b>Subject:</b> Re: [Mapbender-users] #Mapbender #SearchRouter #PostgreSQLconnection</font>
<div> </div>
</div>
<div class="BodyFragment"><font size="2"><span style="font-size:11pt;">
<div class="PlainText">Hello,<br>
<br>
please put the parameter n in quotes in parameters.yml<br>
<br>
# database connection "dzrol"<br>
database2_driver: pdo_pgsql<br>
database2_host: 'localhost'<br>
database2_port: '5433'<br>
database2_name: 'dzrol'<br>
database2_path: ~<br>
database2_user: ******<br>
database2_password: ******<br>
<br>
You have to modify the parameters.yml and conifg.yml file<br>
<br>
<a href="https://doc.mapbender.org/en/customization/yaml.html#yaml">https://doc.mapbender.org/en/customization/yaml.html#yaml</a><br>
<br>
Then you should empty the cache at app/cache/<br>
<br>
Best ist to check with the app_dev.php developer mode whether the <br>
database is available.<br>
<br>
Something like<br>
<a href="http://localhost/mapbedner/app_dev.php">http://localhost/mapbedner/app_dev.php</a><br>
<br>
<a href="https://doc.mapbender.org/en/customization/yaml.html#yaml">https://doc.mapbender.org/en/customization/yaml.html#yaml</a><br>
<br>
See you Astrid<br>
<br>
Am 2022-06-08 17:05, schrieb Jörg Thomsen:<br>
> Hello Marcin,<br>
> <br>
> thanks for your praise!<br>
> Your config looks OK, to be sure:<br>
> <br>
> - port 5433 is correct, you are using pgbouncer?<br>
> - name of the database is dzrol? (parameters.yml)<br>
> - name of the table is dzrol too (relation: dzrol)<br>
> <br>
> What's the error you get? Using the network-tools of the browser you<br>
> can have a look at the request and results Mapbender sends and gets<br>
> back from the server. Can find any hints in the Mapbender log-files?<br>
> <br>
> For testing I would use<br>
> compare: ilike (instead of exact)<br>
> <br>
> <br>
> To your 2nd question:<br>
> Do you know <br>
> <a href="https://doc.mapbender.org/en/development/element_generate.html">https://doc.mapbender.org/en/development/element_generate.html</a><br>
> You will find there how to create an own working MB-Element in<br>
> general. The rest should be done with html/javascript, php on<br>
> server-side an a some blood, sweat and tears.<br>
> <br>
> <br>
> Am 08.06.22 um 16:29 schrieb Marcin Niemyjski:<br>
>> Hello there,<br>
>> <br>
>> I have recently started my adventure with Mapbender. From here I <br>
>> wanted to congratulate you for doing a good job in providing free <br>
>> geoprocessing solutions.<br>
>> <br>
>> While creating the geportal I encountered a problem. I would like to <br>
>> add a Search Router to my geportal but I am having trouble connecting <br>
>> to a PostgreSQL database. Is it enough if I change database properties <br>
>> in config parameters.yml file to properties of my database and then <br>
>> define what I want to search in the Contents tab?<br>
>> <br>
>> I also have a question about defining checkboxes in Mapbender. I would <br>
>> like to create a feature using FeatureInfo that displays a graph <br>
>> created based on data from columns in the database, but the graphs in <br>
>> the image would only come from columns whose names are marked with <br>
>> chechboxes. Could you please tell me how I could achieve this <br>
>> functionality and what I need to learn to do it?<br>
>> <br>
>> I am also uploading a text file (konfiguracja_Mapbender) showing how I <br>
>> configured the parameteres.yml, config.yml and search router <br>
>> configuration files. It would be great if you could check where there <br>
>> might be a mistake or maybe I am leaving something out.<br>
>> <br>
>> Best regards,<br>
>> Marcin Niemyjski<br>
>> <br>
>> <br>
>> _______________________________________________<br>
>> Mapbender_users mailing list<br>
>> Mapbender_users@lists.osgeo.org<br>
>> <a href="https://lists.osgeo.org/mailman/listinfo/mapbender_users">https://lists.osgeo.org/mailman/listinfo/mapbender_users</a><br>
> <br>
> <br>
> --<br>
> Viele Grüße,<br>
> Jörg Thomsen<br>
> <br>
> ---------------------------------------------<br>
> Aufwind durch Wissen!<br>
> Jetzt neu: Web-Seminare und Online-Schulungen<br>
> bei der <a href="http://www.foss-academy.com">www.foss-academy.com</a><br>
> ---------------------------------------------<br>
> <br>
> Jörg Thomsen<br>
> WhereGroup GmbH<br>
> Bundesallee 23<br>
> 10717 Berlin<br>
> Germany<br>
> <br>
> Tel: +49 (0)30 / 5130 278 74<br>
> Fax: +49 (0)30 / 5130 278 11<br>
> <br>
> joerg.thomsen@wheregroup.com<br>
> <a href="http://www.wheregroup.com">www.wheregroup.com</a><br>
> <br>
> Geschäftsführer:<br>
> Olaf Knopp, Peter Stamm<br>
> Amtsgericht Bonn, HRB 9885<br>
> <br>
> -------------------------------<br>
> Folgen Sie der WhereGroup auf twitter: <br>
> <a href="http://twitter.com/WhereGroup_com">http://twitter.com/WhereGroup_com</a><br>
> _______________________________________________<br>
> Mapbender_users mailing list<br>
> Mapbender_users@lists.osgeo.org<br>
> <a href="https://lists.osgeo.org/mailman/listinfo/mapbender_users">https://lists.osgeo.org/mailman/listinfo/mapbender_users</a><br>
<br>
-- <br>
Mit freundlichen Grüßen<br>
<br>
Astrid Emde<br>
GIS-Consultant<br>
<br>
---------------------------------------------<br>
Aufwind durch Wissen!<br>
Jetzt neu: Web-Seminare und Online-Schulungen<br>
bei der <a href="http://www.foss-academy.com">www.foss-academy.com</a><br>
---------------------------------------------<br>
<br>
Astrid Emde<br>
WhereGroup GmbH<br>
Eifelstraße 7<br>
53119 Bonn<br>
Germany<br>
<br>
Tel: +49(0)228 90 90 38 - 22<br>
Fax: +49(0)228 90 90 38 - 11<br>
<br>
astrid.emde@wheregroup.com<br>
<a href="http://www.wheregroup.com">www.wheregroup.com</a><br>
<br>
Meinen PGP Public-Key können Sie unter pgp.mit.edu herunterladen:<br>
<br>
<a href="https://keys.openpgp.org/vks/v1/by-fingerprint/01F8152D36FC07C25EADDE86C5084ACC1C287CCB">https://keys.openpgp.org/vks/v1/by-fingerprint/01F8152D36FC07C25EADDE86C5084ACC1C287CCB</a><br>
Signierte und/oder verschlüsselte Nachrichten sind sehr willkommen<br>
<br>
Folgen Sie der WhereGroup auf twitter:<br>
<a href="http://twitter.com/WhereGroup_com">http://twitter.com/WhereGroup_com</a><br>
<br>
Geschäftsführer:<br>
Olaf Knopp, Peter Stamm<br>
Amtsgericht Bonn, HRB 9885<br>
-------------------------------</div>
</span></font></div>
</body>
</html>