[Mapbender-users] (no subject)

Petar Sapunar jaganacb at gmail.com
Tue Sep 22 07:44:50 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/cbceb9b4/attachment.html>


More information about the Mapbender_users mailing list