<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);" class="elementToProof">
Hello,</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
as you suggested I corrected the parameters file, so now it looks the way below:</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof ContentPasted0">
<a href="https://pastecode.io/s/e0ab3z92" id="LPlnk881377">https://pastecode.io/s/e0ab3z92</a></div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof ContentPasted0">
I've also corrected the config.yml:</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof ContentPasted0 ContentPasted1">
<a href="https://pastecode.io/s/8jytc37y" id="LPlnk250525">https://pastecode.io/s/8jytc37y</a> so it can use the second database - PostgreSQL.</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof ContentPasted0 ContentPasted1">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof ContentPasted0 ContentPasted1">
It worked! (Thanks Astrid!)</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof ContentPasted0 ContentPasted1">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof ContentPasted0 ContentPasted1">
However Digitizer seems to work but only in developer mode. I'm able to create and edit points, lines and polygons
<span id="🙂">🙂</span></div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof ContentPasted0 ContentPasted1">
<span id="🙂">(Mapbender in developer mode returns no errors)<br>
</span></div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof ContentPasted0 ContentPasted1">
In localhost or by using Domen to connect I receive error 500. In localhost I was able to retrieve some more log from console:</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof ContentPasted0 ContentPasted1 ContentPasted2">
<a href="https://pasteboard.co/ZwYUvDQGr2vK.png" id="LPlnkOWALinkPreview">https://pasteboard.co/ZwYUvDQGr2vK.png</a></div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof ContentPasted0 ContentPasted1 ContentPasted2">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof ContentPasted0 ContentPasted1 ContentPasted2">
Any suggestions?</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof ContentPasted0 ContentPasted1 ContentPasted2">
Best,
<div>Marcin</div>
<br>
</div>
<div class="_Entity _EType_OWALinkPreview _EId_OWALinkPreview _EReadonly_0"></div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<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> Tuesday, August 1, 2023 4:56 PM<br>
<b>To:</b> Mapbender User List <mapbender_users@lists.osgeo.org><br>
<b>Subject:</b> Re: [Mapbender-users] relation "mb_core_application" does not exist while trying to set up digitizer</font>
<div> </div>
</div>
<div class="BodyFragment"><font size="2"><span style="font-size:11pt;">
<div class="PlainText">Hello Marcin,<br>
<br>
you created an empty PostgreSQL database for Mapbender.<br>
<br>
This database is empty at the beginning and you have to create the table <br>
structure for Mapbender see<br>
<br>
<a href="https://doc.mapbender.org/en/installation/installation_ubuntu.html#optional">https://doc.mapbender.org/en/installation/installation_ubuntu.html#optional</a><br>
<br>
You have to run the commands to setup the structure.<br>
<br>
If you have an application in your former installation with sqlite you <br>
could export it and import it again.<br>
<br>
Afterwards you should refer to a second database connection for your <br>
geodata (mapbender and the geodata are not in one database).<br>
<br>
Check the workshop bundle for some example.<br>
<br>
<a href="https://github.com/mapbender/mapbender-workshop/blob/master/app/config/parameters.yml">https://github.com/mapbender/mapbender-workshop/blob/master/app/config/parameters.yml</a><br>
<a href="https://github.com/mapbender/mapbender-workshop/blob/master/app/config/config.yml#L63">https://github.com/mapbender/mapbender-workshop/blob/master/app/config/config.yml#L63</a><br>
<br>
You also find a database backup that you could use with the examples<br>
<a href="https://github.com/mapbender/mapbender-workshop/blob/master/geobasis.backup">https://github.com/mapbender/mapbender-workshop/blob/master/geobasis.backup</a><br>
<br>
See you Astrid<br>
<br>
Am 2023-08-01 16:46, schrieb Marcin Niemyjski:<br>
> Hello,<br>
> <br>
> I'm trying to set up the digitizer according to the instructions<br>
> provided in<br>
> <a href="https://doc.mapbender.org/en/functions/editing/digitizer/digitizer_configuration.html#setting-up-of-digitizer">
https://doc.mapbender.org/en/functions/editing/digitizer/digitizer_configuration.html#setting-up-of-digitizer</a><br>
> [1].<br>
> <br>
> I have already set up the sidepane element definition based on the<br>
> instructions (I changed the connection to "default"). Then, in<br>
> parameters.yaml, I overwrote the default database connection<br>
> parameters with those of my PostgreSQL database.<br>
> <br>
> config.yaml -> remains the same<br>
> <br>
> parameters.yaml ->https://pastecode.io/s/2n9mt2ro<br>
> <br>
> Mapbender successfully connects to the database, but I encountered the<br>
> following error in developer mode:<br>
> <br>
> '''<br>
> An exception occurred while executing 'SELECT t0.id AS id_1, t0.title<br>
> AS title_2, t0.slug AS slug_3, t0.description AS description_4,<br>
> t0.template AS template_5, t0.map_engine_code AS map_engine_code_6,<br>
> t0.persistent_view AS persistent_view_7, t0.published AS published_8,<br>
> t0.screenshot AS screenshot_9, t0.extra_assets AS extra_assets_10,<br>
> t0.updated AS updated_11, t0.custom_css AS custom_css_12 FROM<br>
> mb_core_application t0 ORDER BY t0.title ASC':<br>
> <br>
> SQLSTATE[42P01]: Undefined table: 7 ERROR: relation<br>
> "mb_core_application" does not exist<br>
> LINE 1: ...S updated_11, t0.custom_css AS custom_css_12 FROM<br>
> mb_core_ap...<br>
> ^<br>
> '''<br>
> <br>
> Do you have any suggestions on how to overcome this issue? I've<br>
> checked that over user struggled with same issue:<br>
> <a href="https://marc.info/?l=mapbender-users&m=151602993622690&w=2">https://marc.info/?l=mapbender-users&m=151602993622690&w=2</a> [2]<br>
> <br>
> Best regards,<br>
> <br>
> Marcin<br>
> <br>
> <br>
> Links:<br>
> ------<br>
> [1] <br>
> <a href="https://doc.mapbender.org/en/functions/editing/digitizer/digitizer_configuration.html#setting-up-of-digitizer">
https://doc.mapbender.org/en/functions/editing/digitizer/digitizer_configuration.html#setting-up-of-digitizer</a><br>
> [2] <a href="https://marc.info/?l=mapbender-users&m=151602993622690&w=2">
https://marc.info/?l=mapbender-users&m=151602993622690&w=2</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>
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>