[Mapbender-users] Search router configuration
karsten
karsten at terragis.net
Tue Sep 22 09:50:23 PDT 2020
Hi Peter,
first I would like to mention that if you figured all that out all by
yourself that is really impressive !
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).#
That said when looking at the error thrown:
SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "grobovi
-> the database table is not found:
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 ?
Also just to be sure check data base user permissions on all the involved
tables ...
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 ...
Cheers
Karsten
_____
From: Mapbender_users [mailto:mapbender_users-bounces at lists.osgeo.org] On
Behalf Of Petar Sapunar
Sent: Tuesday, September 22, 2020 07:46
To: Mapbender User List
Subject: [Mapbender-users] Search router configuration
Search router configuration
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.
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.
So i heard about mapbender and started using it almost a month ago and i
followed all tutorials.
That being said i managed to visualize all my raster and vector (geoserver
WMS) data.
In my vector data in qgis i used concat function to insert into "source"
field:
<img src="xxxxxxxx" width="100" height="auto">
so mapbender getfeatureinfo now displays images when getting feature info.
(Please include that in the documentation as an option i had to figure that
one on my own)
On the next step i got stuck:
So next was getting SearchRouter and Digitizer to work. This is where i got
stuck.
my config.yml file:
imports:
- { resource: parameters.yml }
- { resource: security.yml }
#Uncomment then next line if you have problems using an oracle database with
mapbender.
# - { resource: oracle.yml }
framework:
#esi: ~
translator: { fallback: %fallback_locale% }
secret: %secret%
router:
resource: "%kernel.root_dir%/config/routing.yml"
strict_requirements: %kernel.debug%
form: true
csrf_protection: true
validation: { enable_annotations: true }
templating: { engines: ['twig'] } #assets_version:
SomeVersionScheme
default_locale: %locale%
session:
cookie_httponly: true
cookie_secure: %cookie_secure%
cookie_lifetime: %cookie_lifetime%
# Twig Configuration
twig:
strict_variables: %kernel.debug%
form_themes:
- MapbenderCoreBundle:form:fields.html.twig
# Doctrine Configuration
doctrine:
dbal:
default_connection: default
connections:
default:
driver: %database_driver%
host: %database_host%
port: %database_port%
dbname: %database_name%
path: %database_path%
user: %database_user%
password: %database_password%
persistent: true
charset: UTF8
logging: %kernel.debug%
profiling: %kernel.debug%
driver: kernel.debug%
PrimostenGIS:
driver: %database2_driver%
host: %database2_host%
port: %database2_port%
dbname: %database2_name%
path: %database2_path%
user: %database2_user%
password: %database2_password%
persistent: true
charset: UTF8
logging: %kernel.debug%
profiling: %kernel.debug%
driver: kernel.debug%
orm:
auto_generate_proxy_classes: %kernel.debug%
auto_mapping: true
# Swiftmailer Configuration
swiftmailer:
transport: %mailer_transport%
host: %mailer_host%
username: %mailer_user%
password: %mailer_password%
spool: { type: memory }
# FOM Manager Configuration
fom_manager:
route_prefix: /manager
# see
https://github.com/mapbender/fom/blob/master/src/FOM/UserBundle/CONFIGURATIO
N.md#extension-configuration
fom_user:
selfregister: false
reset_password: true
max_reset_time: 1
# see
https://github.com/mapbender/owsproxy3/blob/master/CONFIGURATION.md#extensio
n-configuration
ows_proxy3_core:
logging: %ows_proxy3_logging%
obfuscate_client_ip: %ows_proxy3_obfuscate_client_ip%
proxy:
host: %ows_proxy3_host%
port: %ows_proxy3_port%
connecttimeout: %ows_proxy3_connecttimeout%
timeout: %ows_proxy3_timeout%
user: %ows_proxy3_user%
password: %ows_proxy3_password%
checkssl: true
noproxy: %ows_proxy3_noproxy%
my parameters.yml file:
parameters:
### todo: switch to using dsn urls, see
https://www.doctrine-project.org/projects/doctrine-dbal/en/2.9/reference/con
figuration.html#connecting-using-a-url
### To avoid suprises, a DSN can be constructed here from parts, at
least for the shipping default parameters
### Connection definition in config.yml should only use url:
%database_dsn% though
database_driver: pdo_sqlite
database_host: ~
database_port: ~
database_name: ~
database_path: %kernel.root_dir%/db/demo.sqlite
database_user: ~
database_password: ~
#database connection PrimostenGIS
database2_driver: pdo_pgsql
database2_host: xxxx
database2_port: 5432
database2_name: PrimostenGIS
database2_path: ~
database2_user: postgres
database2_password: xxxx
mailer_transport: smtp
mailer_host: localhost
mailer_user: ~
mailer_password: ~
# locale en, de, it, es, ru, nl, pt are available
fallback_locale: en
locale: en
secret: ThisTokenIsNotSoSecretChangeIt
## Legacy branding / versioning params.
## This is no longer used for versioning Mapbender and will never be
updated
## again for a Mapbender release.
## For BC / continuity, you may still use these variables to brand /
version your project.
## For summary information / discussion see
https://github.com/mapbender/mapbender/pull/1012
## For full project branding / versioning options, see code comment:
##
https://github.com/mapbender/mapbender/blob/42e0f8b9a8031118719fc4881a92f0ad
ab4ebacf/src/Mapbender/CoreBundle/DependencyInjection/Compiler/ProvideBrandi
ngPass.php#L17
fom: ~
# framework :
http://symfony.com/doc/2.8/reference/configuration/framework.html#cookie-lif
etime
cookie_secure: false
cookie_lifetime: 3600
# OWSProxy Configuration
# see
https://github.com/mapbender/owsproxy3/blob/master/CONFIGURATION.md#extensio
n-configuration
ows_proxy3_logging: false
ows_proxy3_obfuscate_client_ip: true
ows_proxy3_host: ~
ows_proxy3_port: ~
ows_proxy3_connecttimeout: 60
ows_proxy3_timeout: 90
ows_proxy3_user: ~
ows_proxy3_password: ~
ows_proxy3_noproxy: ~
# default layer order when creating *new* WMS layerset instances
# allowed values are either
# * "standard": Traditional Mapbender behaviour: top-down rendering in
GetCapabilities order;
# also the default if this parameter is not defined
# * "reverse": bottom-up, for QGIS server, ArcGIS etc
# wms.default_layer_order: standard
http://localhost/mapbender/app_dev.php/_profiler/0cb26e?panel=exception
gives me and error:
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(t.id <http://t.id/> ) 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]:
SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "grobovi" does not exist
LINE 1: ...SON(ST_Transform(t."geom", $1::int)) as geom FROM Grobovi t ...
^
500 Internal Server Error - TableNotFoundException
2 linked Exceptions:
* PDOException
<http://localhost/mapbender/app_dev.php/_profiler/0cb26e?panel=exception#tra
ces-link-1> >
* PDOException
<http://localhost/mapbender/app_dev.php/_profiler/0cb26e?panel=exception#tra
ces-link-2> >
Please help me.
Best regards
Petar Sapunar mag.ing.geod.et <http://mag.ing.geod.et/> geoinf.
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campai
gn=sig-email&utm_content=webmail&utm_term=icon> Virus-free.
www.avast.com
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campai
gn=sig-email&utm_content=webmail&utm_term=link>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapbender_users/attachments/20200922/5d97f5e2/attachment-0001.html>
More information about the Mapbender_users
mailing list