<html>
<head>
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>Hallo Karsten, <br>
</p>
<p>das ist nun nur noch ein Konfigurationsproblem in Mapbender! Die
Angabe der Standardverbindung "default_connection" sagt dem
Mapbender unter welcher Datenbankverbindung er seine
Mapbender-Konfigurationen findet, d.h. hier sollte die
"default"-Connection auf deine mapbender3-Datenbank stehen. In der
Suche willst du ja nur auf deine ALKIS-Datenbank gehen und dort
suchen. <br>
</p>
<p>Alles ist also korrekt, außer die default_connection. Bitte
ändern auf <font color="#0000ff"><span class="952413913-26032018"><font
face="Arial"><font size="2"><font color="#800000">default_connection:
default </font></font></font></span></font>und dann
nochmal testen (cache-verzeichnis leeren ist auch immer gut... )</p>
<p>Viele Grüße</p>
<p>Charly<br>
</p>
<div class="moz-cite-prefix">Am 26.03.2018 um 16:02 schrieb karsten:<br>
</div>
<blockquote type="cite"
cite="mid:66D4C42698844CD5802A2A24AE809B4E@terragispc">
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
<meta name="GENERATOR" content="MSHTML 11.00.9600.18953">
<div dir="ltr" align="left"><font color="#0000ff">
<div dir="ltr" align="left"><font color="#000080" face="Arial"
size="2"><span class="952413913-26032018">Hallo
allerseits,</span></font></div>
<div dir="ltr" align="left"><font color="#000080" face="Arial"
size="2"><span class="952413913-26032018"></span></font> </div>
<div dir="ltr" align="left"><span class="952413913-26032018"><font
face="Arial"><font color="#000080"><font size="2"><span
class="884244913-26032018">wegen der
Flustückssuche verbleibt allerdings immer noch ein
Problem das ich wohl mit der Konfiguration von
mehreren Datenbanken in MB3 habe. Ich habe die
Konfiguration nach der Beschreibung unter <a
href="https://doc.mapbender3.org/en/book/database.html"
moz-do-not-send="true">https://doc.mapbender3.org/en/book/database.html</a> (
'Using multiple databases') vorgenommen.</span></font></font></font></span></div>
<div dir="ltr" align="left"><span class="952413913-26032018"><font
face="Arial"><font color="#000080"><font size="2"><span
class="884244913-26032018"></span></font></font></font></span> </div>
<div dir="ltr" align="left"><span class="952413913-26032018"><font
face="Arial"><font color="#000080"><font size="2"><span
class="884244913-26032018">Wenn ich nun die Suche
in MB3 projekt ausführe bekomme ich folgenden
Fehler im MB log ( prod.log ):</span></font></font></font></span></div>
<div dir="ltr" align="left"><span class="952413913-26032018"><font
face="Arial"><font color="#000080"><font size="2"><span
class="884244913-26032018"></span></font></font></font></span> </div>
<div dir="ltr" align="left"><span class="952413913-26032018"><font
face="Arial"><font color="#000080"><font size="2"><span
class="884244913-26032018"><em><font
color="#800000">request.CRITICAL: Uncaught PHP
Exception
Symfony\Component\DependencyInjection\Exception\ServiceNotFoundException:
"You have requested a non-existent service
"doctrine.dbal.search_db_connection". Did you
mean this:
"doctrine.dbal.default_connection"?" at
/var/www/mapbender3/app/bootstrap.php.cache
line 2242 {"exception":"[object]
(Symfony\\Component\\DependencyInjection\\Exception\\ServiceNotFoundException(code:
0): You have requested a non-existent service
\"doctrine.dbal.search_db_connection\". Did
you mean this:
\"doctrine.dbal.default_connection\"? at
/var/www/mapbender3/app/bootstrap.php.cache:2242)"}</font></em>
</span></font></font></font></span></div>
<div dir="ltr" align="left"><span class="952413913-26032018"><font
face="Arial"><font color="#000080"><font color="#800000"
size="2"><span class="884244913-26032018"><em></em></span></font></font></font></span> </div>
<div dir="ltr" align="left"><span class="952413913-26032018"><font
face="Arial"><font color="#000080"><font color="#800000"
size="2"><span class="884244913-26032018"><em>Das
bekommen ich wenn ich im Element Suche die
Konfiguration eingebe:</em></span></font></font></font></span></div>
<div dir="ltr" align="left"><span class="952413913-26032018"><font
face="Arial"><font color="#000080"><font color="#800000"
size="2"><span class="884244913-26032018"><em>class:
Mapbender\CoreBundle\Component\SQLSearchEngine<br>
class_options:<br>
connection: search_db</em></span></font></font></font></span></div>
<div dir="ltr" align="left"><span class="952413913-26032018"><font
face="Arial"><font color="#000080"><font color="#800000"
size="2"><span class="884244913-26032018"><em>....</em></span></font></font></font></span></div>
<div dir="ltr" align="left"><span class="952413913-26032018"><font
face="Arial"><font color="#000080"><font color="#800000"
size="2"><span class="884244913-26032018"><em></em></span></font></font></font></span> </div>
<div dir="ltr" align="left"><span class="952413913-26032018"><font
face="Arial"><font color="#000080" size="2"><span
class="884244913-26032018">wenn ich jedoch anstatt
dessen die connection: default verwende bekomme ich
den Fehler das die benöltigte View
public.qry_mb3_ax_flurstueck_suche nicht exitiert</span></font></font></span></div>
<div dir="ltr" align="left"><span class="952413913-26032018"><font
face="Arial"><font color="#000080" size="2"><span
class="884244913-26032018"></span></font></font></span> </div>
<div dir="ltr" align="left"><span class="952413913-26032018"><font
color="#000080" face="Arial" size="2"><span
class="884244913-26032018">Ich denke irgendwie ist
meine search database mit Symfony nicht korrekt
konfiguriert aber was stimmt da nicht ?</span></font></span><span
class="952413913-26032018"><span
class="884244913-26032018"></span></span></div>
<div dir="ltr" align="left"><span class="952413913-26032018"><font
color="#000080" face="Arial" size="2"><span
class="884244913-26032018">Die
Configurationen config.yml und parameters.yml sind
unten zu sehen.</span></font></span></div>
<div dir="ltr" align="left"><span class="952413913-26032018"><font
color="#000080" face="Arial" size="2"><span
class="884244913-26032018"></span></font></span> </div>
<div dir="ltr" align="left"><span class="952413913-26032018"><font
color="#000080" face="Arial" size="2">Viele Grüße</font></span></div>
<div dir="ltr" align="left"><span class="952413913-26032018"><font
color="#000080" face="Arial" size="2">Karsten </font></span></div>
<div><span class="952413913-26032018"><font color="#000080"
face="Arial" size="2"><a href="http://www.terragis.net"
moz-do-not-send="true">www.terragis.net</a></font></span></div>
<div><span class="952413913-26032018"></span> </div>
<div><span class="952413913-26032018"><font color="#800000"
face="Arial" size="2"><span class="884244913-26032018">aus
config.yml :</span></font></span></div>
<div><span class="952413913-26032018"><font color="#800000"
face="Arial" size="2"><span class="884244913-26032018">...</span></font></span></div>
<div><span class="952413913-26032018"><font face="Arial"><font
size="2"><font color="#800000">doctrine:<br>
dbal:<br>
default_connection: search_db<br>
connections:<br>
default:<br>
driver: %database_driver%<br>
host: %database_host%<br>
port: %database_port%<br>
dbname: %database_name%<br>
path: %database_path%<br>
user: %database_user%<br>
password: %database_password%<br>
persistent: true<br>
charset: UTF8<br>
logging: %kernel.debug%<br>
profiling: %kernel.debug%<br>
search_db:<br>
driver: %database2_driver%<br>
host: %database2_host%<br>
port: %database2_port%<br>
dbname: %database2_name%<br>
path: %database2_path%<br>
user: %database2_user%<br>
password: %database2_password%<br>
charset: UTF8<br>
logging: %kernel.debug%<br>
profiling: %kernel.debug%<br>
<span class="884244913-26032018">...</span></font></font></font></span></div>
<div><span class="952413913-26032018"><font face="Arial"><font
size="2"><span class="884244913-26032018"></span></font></font></span> </div>
<div><span class="952413913-26032018"><font face="Arial"><font
size="2"><span class="884244913-26032018"></span></font></font></span> </div>
<div><span class="952413913-26032018"><font face="Arial"><font
color="#008000" size="2"><span
class="884244913-26032018">aus parameters.yml:</span></font></font></span></div>
<div><span class="952413913-26032018"><font face="Arial"><font
color="#008000" size="2"><span
class="884244913-26032018"></span></font></font></span> </div>
<div><span class="952413913-26032018"><font face="Arial"><font
color="#008000" size="2"><span
class="884244913-26032018">parameters:<br>
# database-connection "default"<br>
database_driver: pdo_pgsql<br>
# pdo_sqlite<br>
database_host: localhost<br>
database_port: 5432<br>
database_name: mapbender3<br>
database_path: ~<br>
# %kernel.root_dir%/db/demo.sqlite<br>
database_user: postgres<br>
database_password: xyz</span></font></font></span></div>
<div> </div>
<div><span class="952413913-26032018"><font face="Arial"><font
size="2"><span class="884244913-26032018"><font
color="#008000"> # database-connection
"search_db"<br>
database2_driver: pdo_pgsql<br>
database2_host: localhost<br>
database2_port: 5432<br>
database2_name: gisme2<br>
database2_path: ~<br>
database2_user: postgres<br>
database2_password: xyz</font><br>
</span></font></font></span></div>
</font></div>
<blockquote
cite="mid:F2176AE4E9FFAF45BEA8D84DD6F4AF1A448CDAD9@skrzmxmbx01"
type="cite"><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div class="WordSection1">
<p class="MsoNormal"><span style="FONT-SIZE: 11pt;
FONT-FAMILY: "Calibri","sans-serif";
COLOR: #1f497d"><o:p></o:p></span></p>
</div>
</blockquote>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
NAS mailing list
<a class="moz-txt-link-abbreviated" href="mailto:NAS@lists.osgeo.org">NAS@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/nas">https://lists.osgeo.org/mailman/listinfo/nas</a></pre>
</blockquote>
<br>
</body>
</html>