[Mapbender-users] Search router configuration
Petar Sapunar
jaganacb at gmail.com
Tue Sep 22 07:45:46 PDT 2020
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/CONFIGURATION.md#extension-configuration
fom_user:
selfregister: false
reset_password: true
max_reset_time: 1
# see
https://github.com/mapbender/owsproxy3/blob/master/CONFIGURATION.md#extension-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/configuration.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/42e0f8b9a8031118719fc4881a92f0adab4ebacf/src/Mapbender/CoreBundle/DependencyInjection/Compiler/ProvideBrandingPass.php#L17
fom: ~
# framework :
http://symfony.com/doc/2.8/reference/configuration/framework.html#cookie-lifetime
cookie_secure: false
cookie_lifetime: 3600
# OWSProxy Configuration
# see
https://github.com/mapbender/owsproxy3/blob/master/CONFIGURATION.md#extension-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) 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#traces-link-1>
- PDOException »
<http://localhost/mapbender/app_dev.php/_profiler/0cb26e?panel=exception#traces-link-2>
Please help me.
Best regards
Petar Sapunar mag.ing.geod.et geoinf.
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=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_campaign=sig-email&utm_content=webmail&utm_term=link>
<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapbender_users/attachments/20200922/093fad0f/attachment-0001.html>
More information about the Mapbender_users
mailing list