<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 11.00.9600.19597"></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=451093716-22092020><FONT color=#000080
size=2 face=Arial>Hi Peter,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=451093716-22092020><FONT color=#000080
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=451093716-22092020><FONT color=#000080
size=2 face=Arial>first I would like to mention that if you figured all that out
all by yourself that is really impressive !</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=451093716-22092020><FONT color=#000080
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=451093716-22092020><FONT color=#000080
size=2 face=Arial>I have been using MapBender for quite a long time but have not
much experience with the search router (got it to work for ne project) and
digitizer (have not used it).#</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=451093716-22092020><FONT color=#000080
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=451093716-22092020><FONT color=#000080
size=2 face=Arial>That said when looking at the error
thrown:</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=451093716-22092020><FONT color=#000080
size=2 face=Arial><FONT color=#000000>SQLSTATE[42P01]: Undefined table: 7 ERROR:
relation "grobovi<BR>-> the database table is not
found:</FONT></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=451093716-22092020><FONT size=2
face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=451093716-22092020><FONT color=#000080
size=2 face=Arial>Check into why that table can not be found. Check
the naming of the table and if it is in a different database schema
(other public) e.g. mycoolschema.grobovi ?</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=451093716-22092020><FONT color=#000080
size=2 face=Arial>Also just to be sure check data base user permissions on all
the involved tables ...</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=451093716-22092020><FONT color=#000080
size=2 face=Arial>As one starting point to solve it maybe insert the
missing point coordinate pairs from the grobovi data into that query and run it
manually on the database and tweak it until it is working
...</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=451093716-22092020><FONT color=#000080
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=451093716-22092020><FONT color=#000080
size=2 face=Arial>Cheers</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=451093716-22092020><FONT color=#000080
size=2 face=Arial>Karsten</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=451093716-22092020><FONT color=#000080
size=2 face=Arial></FONT></SPAN> </DIV><BR>
<DIV lang=en-us class=OutlookMessageHeader dir=ltr align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B> Mapbender_users
[mailto:mapbender_users-bounces@lists.osgeo.org] <B>On Behalf Of </B>Petar
Sapunar<BR><B>Sent:</B> Tuesday, September 22, 2020 07:46<BR><B>To:</B>
Mapbender User List<BR><B>Subject:</B> [Mapbender-users] Search router
configuration<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV dir=ltr>
<DIV dir=ltr>Search router configuration
<DIV><BR></DIV>
<DIV>Hello people. I need your help. I am new to mapbender. First of all i am
not a programmer so feel free to treat me like i dont know anything about
servers and databases. </DIV>
<DIV><BR></DIV>
<DIV><BR></DIV>
<DIV>2-3 months ago i started taking aerial images of small
county in Croatia. It took me two weeks (6 batteries a day)
with phantom 4 advanced to take all photos (about 25000). I made
ortomosaics using AGISOFT and processed 25 TIFFs with ybcbr pyramids.
Made my own apache geoserver and published it online using NOIP virtual
static address.</DIV>
<DIV><BR></DIV>
<DIV>So i heard about mapbender and started using
it almost a month ago and i followed all tutorials.<BR></DIV>
<DIV>That being said i managed to visualize all my raster and vector (geoserver
WMS) data. </DIV>
<DIV>In my vector data in qgis i used concat function to insert into "source"
field:</DIV>
<DIV><img src="xxxxxxxx" width="100" height="auto"></DIV>
<DIV>so mapbender getfeatureinfo now displays images when getting feature
info. </DIV>
<DIV>(Please include that in the documentation as an option i had to figure that
one on my own)</DIV>
<DIV><BR></DIV>
<DIV>On the next step i got stuck:</DIV>
<DIV><BR></DIV>
<DIV>So next was getting SearchRouter and Digitizer to work. This is where
i got stuck.</DIV>
<DIV>my config.yml file:</DIV>
<DIV><BR></DIV>
<DIV><FONT color=#ff0000 size=1>imports:<BR> - { resource:
parameters.yml }<BR> - { resource: security.yml }<BR>#Uncomment
then next line if you have problems using an oracle database with
mapbender.<BR># - { resource: oracle.yml }<BR><BR>framework:<BR>
#esi: ~<BR>
translator: { fallback: %fallback_locale% }<BR>
secret: %secret%<BR>
router:<BR> resource:
"%kernel.root_dir%/config/routing.yml"<BR>
strict_requirements: %kernel.debug%<BR> form:
true<BR> csrf_protection: true<BR>
validation: { enable_annotations: true }<BR>
templating: { engines: ['twig'] } #assets_version:
SomeVersionScheme<BR> default_locale: %locale%<BR>
session:<BR> cookie_httponly: true<BR>
cookie_secure: %cookie_secure%<BR>
cookie_lifetime: %cookie_lifetime%<BR><BR><BR># Twig
Configuration<BR>twig:<BR> strict_variables:
%kernel.debug%<BR> form_themes:<BR> -
MapbenderCoreBundle:form:fields.html.twig<BR><BR># Doctrine
Configuration<BR>doctrine:<BR> dbal:<BR>
default_connection: default<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>
driver: kernel.debug%<BR>
PrimostenGIS:<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>
persistent: true<BR>
charset: UTF8<BR>
logging: %kernel.debug%<BR>
profiling: %kernel.debug%
<BR> driver:
kernel.debug% <BR>
orm:<BR> auto_generate_proxy_classes:
%kernel.debug%<BR> auto_mapping: true<BR><BR>#
Swiftmailer Configuration<BR>swiftmailer:<BR> transport:
%mailer_transport%<BR> host:
%mailer_host%<BR> username: %mailer_user%<BR>
password: %mailer_password%<BR> spool: {
type: memory }<BR><BR># FOM Manager Configuration<BR>fom_manager:<BR>
route_prefix: /manager<BR><BR># see <A
href="https://github.com/mapbender/fom/blob/master/src/FOM/UserBundle/CONFIGURATION.md#extension-configuration"
target=_blank>https://github.com/mapbender/fom/blob/master/src/FOM/UserBundle/CONFIGURATION.md#extension-configuration</A><BR>fom_user:<BR>
selfregister: false<BR> reset_password: true<BR>
max_reset_time: 1<BR><BR># see <A
href="https://github.com/mapbender/owsproxy3/blob/master/CONFIGURATION.md#extension-configuration"
target=_blank>https://github.com/mapbender/owsproxy3/blob/master/CONFIGURATION.md#extension-configuration</A><BR>ows_proxy3_core:<BR>
logging: %ows_proxy3_logging%<BR> obfuscate_client_ip:
%ows_proxy3_obfuscate_client_ip%<BR> proxy:<BR>
host: %ows_proxy3_host%<BR> port:
%ows_proxy3_port%<BR> connecttimeout:
%ows_proxy3_connecttimeout%<BR> timeout:
%ows_proxy3_timeout%<BR> user:
%ows_proxy3_user%<BR> password:
%ows_proxy3_password%<BR> checkssl: true<BR>
noproxy: %ows_proxy3_noproxy%<BR><BR></FONT></DIV>
<DIV>my parameters.yml file:</DIV>
<DIV><BR></DIV>
<DIV><FONT color=#ff00ff>parameters:<BR>### todo: switch to using dsn urls,
see <A
href="https://www.doctrine-project.org/projects/doctrine-dbal/en/2.9/reference/configuration.html#connecting-using-a-url"
target=_blank>https://www.doctrine-project.org/projects/doctrine-dbal/en/2.9/reference/configuration.html#connecting-using-a-url</A><BR>###
To avoid suprises, a DSN can be constructed here from
parts, at least for the shipping default parameters<BR>###
Connection definition in config.yml should only use url: %database_dsn%
though<BR><BR> database_driver: pdo_sqlite<BR>
database_host: ~<BR> database_port:
~<BR> database_name: ~<BR>
database_path: %kernel.root_dir%/db/demo.sqlite<BR>
database_user: ~<BR> database_password:
~<BR>#database connection PrimostenGIS<BR> database2_driver:
pdo_pgsql<BR> database2_host: xxxx<BR>
database2_port: 5432<BR> database2_name:
PrimostenGIS<BR> database2_path: ~<BR>
database2_user: postgres<BR>
database2_password: xxxx<BR><BR> mailer_transport:
smtp<BR> mailer_host:
localhost<BR> mailer_user: ~<BR>
mailer_password: ~<BR><BR> # locale en, de, it, es, ru, nl,
pt are available<BR> fallback_locale: en<BR>
locale: en<BR> secret:
ThisTokenIsNotSoSecretChangeIt<BR><BR> ## Legacy branding /
versioning params.<BR> ## This is no longer used for versioning
Mapbender and will never be updated<BR> ## again for a Mapbender
release.<BR> ## For BC / continuity, you may still use these
variables to brand / version your project.<BR> ## For summary
information / discussion see <A
href="https://github.com/mapbender/mapbender/pull/1012"
target=_blank>https://github.com/mapbender/mapbender/pull/1012</A><BR>
## For full project branding / versioning options, see code
comment:<BR> ## <A
href="https://github.com/mapbender/mapbender/blob/42e0f8b9a8031118719fc4881a92f0adab4ebacf/src/Mapbender/CoreBundle/DependencyInjection/Compiler/ProvideBrandingPass.php#L17"
target=_blank>https://github.com/mapbender/mapbender/blob/42e0f8b9a8031118719fc4881a92f0adab4ebacf/src/Mapbender/CoreBundle/DependencyInjection/Compiler/ProvideBrandingPass.php#L17</A><BR>
fom: ~<BR><BR> # framework : <A
href="http://symfony.com/doc/2.8/reference/configuration/framework.html#cookie-lifetime"
target=_blank>http://symfony.com/doc/2.8/reference/configuration/framework.html#cookie-lifetime</A><BR>
cookie_secure: false<BR> cookie_lifetime: 3600<BR><BR>#
OWSProxy Configuration<BR># see <A
href="https://github.com/mapbender/owsproxy3/blob/master/CONFIGURATION.md#extension-configuration"
target=_blank>https://github.com/mapbender/owsproxy3/blob/master/CONFIGURATION.md#extension-configuration</A><BR>
ows_proxy3_logging: false<BR>
ows_proxy3_obfuscate_client_ip: true<BR> ows_proxy3_host:
~<BR> ows_proxy3_port: ~<BR>
ows_proxy3_connecttimeout: 60<BR> ows_proxy3_timeout: 90<BR>
ows_proxy3_user: ~<BR> ows_proxy3_password: ~<BR>
ows_proxy3_noproxy: ~<BR><BR> # default layer order when
creating *new* WMS layerset instances<BR> # allowed values are
either<BR> # * "standard": Traditional Mapbender behaviour:
top-down rendering in GetCapabilities order;<BR> #
also the default if this parameter is not
defined<BR> # * "reverse": bottom-up, for QGIS server, ArcGIS
etc<BR># wms.default_layer_order: standard</FONT><BR></DIV>
<DIV><FONT color=#ff00ff><BR></FONT></DIV>
<DIV><A
href="http://localhost/mapbender/app_dev.php/_profiler/0cb26e?panel=exception"
target=_blank>http://localhost/mapbender/app_dev.php/_profiler/0cb26e?panel=exception</A><FONT
color=#ff00ff><BR></FONT></DIV>
<DIV>gives me and error:</DIV>
<DIV><BR></DIV>
<DIV>
<H1
style="FONT-SIZE: 21px; FONT-FAMILY: Helvetica,Arial,sans-serif; FONT-WEIGHT: normal; MARGIN: 0px 0px 12px">An
exception occurred while executing 'SELECT t."id", t."fid", t."source",
ST_AsGeoJSON(ST_Transform(t."geom", ?::int)) as geom FROM Grobovi t WHERE
(LOWER(<A href="http://t.id/" target=_blank>t.id</A>) LIKE LOWER(?)) AND
(ST_Transform(ST_SetSRID(ST_MakeBox2D(ST_Point(?, ?), ST_Point(?, ?)), ?),
ST_Srid(t."geom")) && t."geom")' with params [3765, "%1%", 453116,
4826755, 463251, 4828604, 3765]:<BR><BR>SQLSTATE[42P01]: Undefined table: 7
ERROR: relation "grobovi" does not exist<BR>LINE 1:
...SON(ST_Transform(t."geom", $1::int)) as geom FROM Grobovi t ...<BR>^</H1>
<DIV style="FONT-SIZE: 14px; FONT-FAMILY: Helvetica,Arial,sans-serif"><SPAN
style="FONT-WEIGHT: 700">500</SPAN> Internal Server Error - <ABBR
title=Doctrine\DBAL\Exception\TableNotFoundException
style="BORDER-BOTTOM: 1px dotted">TableNotFoundException</ABBR></DIV>
<DIV
style="FONT-SIZE: 14px; FONT-FAMILY: Helvetica,Arial,sans-serif; MARGIN-TOP: 1em"><SPAN
style="FONT-WEIGHT: 700">2</SPAN> linked Exceptions:
<UL>
<LI style="MARGIN-BOTTOM: 10px; MARGIN-LEFT: 15px"><ABBR
title=Doctrine\DBAL\Driver\PDOException
style="BORDER-BOTTOM: 1px dotted">PDOException</ABBR> <A
style="COLOR: rgb(33,139,195); BACKGROUND-COLOR: transparent; text-decoration-line: none"
href="http://localhost/mapbender/app_dev.php/_profiler/0cb26e?panel=exception#traces-link-1"
target=_blank>»</A>
<LI style="MARGIN-BOTTOM: 10px; MARGIN-LEFT: 15px"><ABBR title=PDOException
style="BORDER-BOTTOM: 1px dotted">PDOException</ABBR> <A
style="COLOR: rgb(33,139,195); BACKGROUND-COLOR: transparent; text-decoration-line: none"
href="http://localhost/mapbender/app_dev.php/_profiler/0cb26e?panel=exception#traces-link-2"
target=_blank>»</A></LI></UL>
<DIV><BR></DIV>
<DIV><BR></DIV>
<DIV><BR></DIV>
<DIV>Please help me.</DIV>
<DIV><BR></DIV>
<DIV>Best regards</DIV>
<DIV>Petar Sapunar <A href="http://mag.ing.geod.et/"
target=_blank>mag.ing.geod.et</A> geoinf.</DIV></DIV></DIV></DIV><BR
class=gmail-Apple-interchange-newline></DIV>
<DIV id=DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2><BR>
<TABLE style="BORDER-TOP: #d3d4de 1px solid">
<TBODY>
<TR>
<TD style="WIDTH: 55px; PADDING-TOP: 13px"><A
href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=icon"
target=_blank><IMG style="HEIGHT: 29px; WIDTH: 46px" alt=""
src="https://ipmcdn.avast.com/images/icons/icon-envelope-tick-round-orange-animated-no-repeat-v1.gif"
width=46 height=29 NOSEND="1"></A></TD>
<TD
style="FONT-SIZE: 13px; FONT-FAMILY: Arial,Helvetica,sans-serif; WIDTH: 470px; COLOR: #41424e; PADDING-TOP: 12px; LINE-HEIGHT: 18px">Virus-free.
<A style="COLOR: #4453ea"
href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=link"
target=_blank>www.avast.com</A> </TD></TR></TBODY></TABLE><A
href="#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2" height="1"
width="1"></A></DIV></BODY></HTML>