I can not adjust SearchRouter. Please help

classic Classic list List threaded Threaded
15 messages Options
Den
Reply | Threaded
Open this post in threaded view
|

I can not adjust SearchRouter. Please help

Den
Good day!

I'm new to Mapbender. Learn how to create customize and publish applications but can not configure the search for their data.

There search_db database. It table in which one field with values - picckad. The values of the numbers but the field type is Text. (I tried to give the field of type Integer)
The database was created in PgAdmin and data loaded into it from a SHP file through Qgis

config.yml Files and parameters.yml look like

config.yml

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%
               
          charset:  UTF8
               
          logging: %kernel.debug%
               
          profiling: %kernel.debug%
           
       search_db:
               
         driver:   %database2_driver%
               
         host:     %database2_host%
               
         port:     %database2_port%
               
         dbname:   %database2_name%
               
         path:     %database2_path%
               
         user:     %database2_user%
               
         password: %database2_password%
               
         charset:  UTF8
               
         logging: %kernel.debug%
               
         profiling: %kernel.debug%

parameters.yml

parameters:
   
           database_driver:   pdo_pgsql
   
           database_host:     localhost
   
           database_port:     5432
   
           database_name:     mapbender3
   
           database_path:     ~
   
           database_user:     postgres
   
           database_password: n36rp21
   
   
           database2_driver:  pdo_pgsql
   
           database2_host:    localhost
   
           database2_port:    5432
   
           database2_name:    search_db
   
           database2_path:     ~
   
           database2_user:    postgres
   
           database2_password: n36rp21


route-configuration in the configuration area

class: Mapbender\CoreBundle\Component\SQLSearchEngine
class_options:
    connection: search_db
    relation: picckad (это таблица public.)
    attributes:
        - picnum
    geometry_attribute: geom
form:
    picnum:
        type: text
        options:
            required: true
        compare: exact
results:
    view: table
    count: true
    headers:
        picnum: Name
    callback:
        event: click
        options:
            buffer: 10
            minScale: null
            maxScale: null

The result is - No results found.

The debugger Google hrome found this:

Deprecated: Automatically populating $HTTP_RAW_POST_DATA is deprecated and will be removed in a future version. To avoid this warning set 'always_populate_raw_post_data' to '-1' in php.ini and use the php://input stream instead. in Unknown on line 0

Warning: Cannot modify header information - headers already sent in Unknown on line 0

Mapbender version 3.0.5.3

Failed to start the session because headers have already been sent by "" at line 0.



What am I doing wrong?
Reply | Threaded
Open this post in threaded view
|

Re: I can not adjust SearchRouter. Please help

Charlotte Toma
Hello, 
the parameters.yml needs the name of the connection , like this: 

parameters.yml

parameters:
    default:
           database_driver:   pdo_pgsql
    
           database_host:     localhost
    
           database_port:     5432
    
           database_name:     mapbender3
    
           database_path:     ~
    
           database_user:     postgres
    
           database_password: [don't show your passwords!]
    
    search_db:
           database2_driver:  pdo_pgsql
    
           database2_host:    localhost
    
           database2_port:    5432
    
           database2_name:    search_db
    
           database2_path:     ~
    
           database2_user:    postgres
    
           database2_password: [don't show your passwords!]


Your connection is missing parameters: 
doc.mapbender3.org/en/bundles/Mapbender/CoreBundle/elements/search_router.html

class: Mapbender\CoreBundle\Component\SQLSearchEngine
class_options:
    connection: search_db
    relation: picckad (это таблица public.) this looks wrong --> is this your table name? # Relation to select from, you can use subqueries 
    attributes:
        - picnum
        - gid
 geometry_attribute: geom
form:
    picnum:
        type: text
        options:
            required: true
            label: Name
        compare: ilike   #both sides are considered as result
results:
    view: table
    count: true
    headers:
        picnum: Name
        gid: ID
    callback:
        event: click
        options:
            buffer: 10
            minScale: null
            maxScale: null


Try this : ) 
I hope it works now

Am 11.11.2016 um 13:07 schrieb Den:
Good day!

I'm new to Mapbender. Learn how to create customize and publish applications
but can not configure the search for their data.

There search_db database. It table in which one field with values - picckad.
The values of the numbers but the field type is Text. (I tried to give the
field of type Integer)
The database was created in PgAdmin and data loaded into it from a SHP file
through Qgis

config.yml Files and parameters.yml look like

config.yml

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%
                
          charset:  UTF8
                
          logging: %kernel.debug%
                
          profiling: %kernel.debug%
            
       search_db:
                
         driver:   %database2_driver%
                
         host:     %database2_host%
                
         port:     %database2_port%
                
         dbname:   %database2_name%
                
         path:     %database2_path%
                
         user:     %database2_user%
                
         password: %database2_password%
                
         charset:  UTF8
                
         logging: %kernel.debug%
                
         profiling: %kernel.debug%

parameters.yml

parameters:
    
           database_driver:   pdo_pgsql
    
           database_host:     localhost
    
           database_port:     5432
    
           database_name:     mapbender3
    
           database_path:     ~
    
           database_user:     postgres
    
           database_password: n36rp21
    
    
           database2_driver:  pdo_pgsql
    
           database2_host:    localhost
    
           database2_port:    5432
    
           database2_name:    search_db
    
           database2_path:     ~
    
           database2_user:    postgres
    
           database2_password: n36rp21


route-configuration in the configuration area

class: Mapbender\CoreBundle\Component\SQLSearchEngine
class_options:
    connection: search_db
    relation: picckad (это таблица public.)
    attributes:
        - picnum
    geometry_attribute: geom
form:
    picnum:
        type: text
        options:
            required: true
        compare: exact
results:
    view: table
    count: true
    headers:
        picnum: Name
    callback:
        event: click
        options:
            buffer: 10
            minScale: null
            maxScale: null

The result is - No results found.

The debugger Google hrome found this:

Deprecated: Automatically populating $HTTP_RAW_POST_DATA is deprecated and
will be removed in a future version. To avoid this warning set
'always_populate_raw_post_data' to '-1' in php.ini and use the php://input
stream instead. in Unknown on line 0

Warning: Cannot modify header information - headers already sent in Unknown
on line 0

Mapbender version 3.0.5.3

Failed to start the session because headers have already been sent by "" at
line 0.



What am I doing wrong?



--
View this message in context: http://osgeo-org.1560.x6.nabble.com/I-can-not-adjust-SearchRouter-Please-help-tp5295321.html
Sent from the mapbender-users mailing list archive at Nabble.com.
_______________________________________________
Mapbender_users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapbender_users

-- 
Mit freundlichen Grüßen

Charlotte Toma
GIS-Consultant

********************************************
Where2B Konferenz 2016
15. Dezember 2016 in Bonn
www.where2b-conference.com
******************************************** 

 Charlotte Toma
 WhereGroup GmbH & Co.KG
 Eifelstraße 7
 53119 Bonn
 Germany

 Fon: +49(0)228 90 90 38 - 24
 Fax: +49(0)228 90 90 38 - 11

 [hidden email]
 www.wheregroup.com

 Folgen Sie der WhereGroup auf twitter: http://twitter.com/WhereGroup_com

Amtsgericht Bonn, HRA 6788
-------------------------------
Komplementärin:
WhereGroup Verwaltungs GmbH
vertreten durch:
Olaf Knopp, Peter Stamm
------------------------------- 

_______________________________________________
Mapbender_users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapbender_users
Reply | Threaded
Open this post in threaded view
|

Re: I can not adjust SearchRouter. Please help

Charlotte Toma

I forgot something!

If your schema is public, the you can say "relation: public.piccad".

    relation: picckad (это таблица public.) this looks wrong --> is this your table name? # Relation to select from, you can use subqueries

Am 11.11.2016 um 13:17 schrieb Charlotte Toma:
Hello, 
the parameters.yml needs the name of the connection , like this: 

parameters.yml

parameters:
    default:
           database_driver:   pdo_pgsql
    
           database_host:     localhost
    
           database_port:     5432
    
           database_name:     mapbender3
    
           database_path:     ~
    
           database_user:     postgres
    
           database_password: [don't show your passwords!]
    
    search_db:
           database2_driver:  pdo_pgsql
    
           database2_host:    localhost
    
           database2_port:    5432
    
           database2_name:    search_db
    
           database2_path:     ~
    
           database2_user:    postgres
    
           database2_password: [don't show your passwords!]


Your connection is missing parameters: 
doc.mapbender3.org/en/bundles/Mapbender/CoreBundle/elements/search_router.html

class: Mapbender\CoreBundle\Component\SQLSearchEngine
class_options:
    connection: search_db
    relation: picckad (это таблица public.) this looks wrong --> is this your table name? # Relation to select from, you can use subqueries 
    attributes:
        - picnum
        - gid
 geometry_attribute: geom
form:
    picnum:
        type: text
        options:
            required: true
            label: Name
        compare: ilike   #both sides are considered as result
results:
    view: table
    count: true
    headers:
        picnum: Name
        gid: ID
    callback:
        event: click
        options:
            buffer: 10
            minScale: null
            maxScale: null


Try this : ) 
I hope it works now

Am 11.11.2016 um 13:07 schrieb Den:
Good day!

I'm new to Mapbender. Learn how to create customize and publish applications
but can not configure the search for their data.

There search_db database. It table in which one field with values - picckad.
The values of the numbers but the field type is Text. (I tried to give the
field of type Integer)
The database was created in PgAdmin and data loaded into it from a SHP file
through Qgis

config.yml Files and parameters.yml look like

config.yml

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%
                
          charset:  UTF8
                
          logging: %kernel.debug%
                
          profiling: %kernel.debug%
            
       search_db:
                
         driver:   %database2_driver%
                
         host:     %database2_host%
                
         port:     %database2_port%
                
         dbname:   %database2_name%
                
         path:     %database2_path%
                
         user:     %database2_user%
                
         password: %database2_password%
                
         charset:  UTF8
                
         logging: %kernel.debug%
                
         profiling: %kernel.debug%

parameters.yml

parameters:
    
           database_driver:   pdo_pgsql
    
           database_host:     localhost
    
           database_port:     5432
    
           database_name:     mapbender3
    
           database_path:     ~
    
           database_user:     postgres
    
           database_password: n36rp21
    
    
           database2_driver:  pdo_pgsql
    
           database2_host:    localhost
    
           database2_port:    5432
    
           database2_name:    search_db
    
           database2_path:     ~
    
           database2_user:    postgres
    
           database2_password: n36rp21


route-configuration in the configuration area

class: Mapbender\CoreBundle\Component\SQLSearchEngine
class_options:
    connection: search_db
    relation: picckad (это таблица public.)
    attributes:
        - picnum
    geometry_attribute: geom
form:
    picnum:
        type: text
        options:
            required: true
        compare: exact
results:
    view: table
    count: true
    headers:
        picnum: Name
    callback:
        event: click
        options:
            buffer: 10
            minScale: null
            maxScale: null

The result is - No results found.

The debugger Google hrome found this:

Deprecated: Automatically populating $HTTP_RAW_POST_DATA is deprecated and
will be removed in a future version. To avoid this warning set
'always_populate_raw_post_data' to '-1' in php.ini and use the php://input
stream instead. in Unknown on line 0

Warning: Cannot modify header information - headers already sent in Unknown
on line 0

Mapbender version 3.0.5.3

Failed to start the session because headers have already been sent by "" at
line 0.



What am I doing wrong?



--
View this message in context: http://osgeo-org.1560.x6.nabble.com/I-can-not-adjust-SearchRouter-Please-help-tp5295321.html
Sent from the mapbender-users mailing list archive at Nabble.com.
_______________________________________________
Mapbender_users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapbender_users

-- 
Mit freundlichen Grüßen

Charlotte Toma
GIS-Consultant

********************************************
Where2B Konferenz 2016
15. Dezember 2016 in Bonn
www.where2b-conference.com
******************************************** 

 Charlotte Toma
 WhereGroup GmbH & Co.KG
 Eifelstraße 7
 53119 Bonn
 Germany

 Fon: +49(0)228 90 90 38 - 24
 Fax: +49(0)228 90 90 38 - 11

 [hidden email]
 www.wheregroup.com

 Folgen Sie der WhereGroup auf twitter: http://twitter.com/WhereGroup_com

Amtsgericht Bonn, HRA 6788
-------------------------------
Komplementärin:
WhereGroup Verwaltungs GmbH
vertreten durch:
Olaf Knopp, Peter Stamm
------------------------------- 


_______________________________________________
Mapbender_users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapbender_users

-- 
Mit freundlichen Grüßen

Charlotte Toma
GIS-Consultant

********************************************
Where2B Konferenz 2016
15. Dezember 2016 in Bonn
www.where2b-conference.com
******************************************** 

 Charlotte Toma
 WhereGroup GmbH & Co.KG
 Eifelstraße 7
 53119 Bonn
 Germany

 Fon: +49(0)228 90 90 38 - 24
 Fax: +49(0)228 90 90 38 - 11

 [hidden email]
 www.wheregroup.com

 Folgen Sie der WhereGroup auf twitter: http://twitter.com/WhereGroup_com

Amtsgericht Bonn, HRA 6788
-------------------------------
Komplementärin:
WhereGroup Verwaltungs GmbH
vertreten durch:
Olaf Knopp, Peter Stamm
------------------------------- 

_______________________________________________
Mapbender_users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapbender_users
Den
Reply | Threaded
Open this post in threaded view
|

Re: I can not adjust SearchRouter. Please help

Den
This post was updated on .
I did so
parameters:
    default:
           database_driver:   pdo_pgsql
   
           database_host:     localhost
   
           database_port:     5432
   
           database_name:     mapbender3
   
           database_path:     ~
   
           database_user:     postgres
   
           database_password: n36rp21
   
    search_db:
           database2_driver:  pdo_pgsql
   
           database2_host:    localhost
   
           database2_port:    5432
   
           database2_name:    search_db
   
           database2_path:     ~
   
           database2_user:    postgres
   
           database2_password: n36rp21

As a result, at start app_dev got it

ParameterNotFoundException: You have requested a non-existent parameter "database_driver".


PS: passwords do not matter do not pay attention

Reply | Threaded
Open this post in threaded view
|

Re: I can not adjust SearchRouter. Please help

Charlotte Toma
Delete your cache at mapbender3/application/app/cache

sudo rm -Rf app/cache/*



Am 11.11.2016 um 13:59 schrieb Den:
I did so
parameters:
    default:
           database_driver:   pdo_pgsql
    
           database_host:     localhost
    
           database_port:     5432
    
           database_name:     mapbender3
    
           database_path:     ~
    
           database_user:     postgres
    
           database_password: n36rp21
    
    search_db:
           database2_driver:  pdo_pgsql
    
           database2_host:    localhost
    
           database2_port:    5432
    
           database2_name:    search_db
    
           database2_path:     ~
    
           database2_user:    postgres
    
           database2_password: n36rp21

As a result, at start app_dev got it

ParameterNotFoundException: You have requested a non-existent parameter
"database_driver".





--
View this message in context: http://osgeo-org.1560.x6.nabble.com/I-can-not-adjust-SearchRouter-Please-help-tp5295321p5295331.html
Sent from the mapbender-users mailing list archive at Nabble.com.
_______________________________________________
Mapbender_users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapbender_users

-- 
Mit freundlichen Grüßen

Charlotte Toma
GIS-Consultant

********************************************
Where2B Konferenz 2016
15. Dezember 2016 in Bonn
www.where2b-conference.com
******************************************** 

 Charlotte Toma
 WhereGroup GmbH & Co.KG
 Eifelstraße 7
 53119 Bonn
 Germany

 Fon: +49(0)228 90 90 38 - 24
 Fax: +49(0)228 90 90 38 - 11

 [hidden email]
 www.wheregroup.com

 Folgen Sie der WhereGroup auf twitter: http://twitter.com/WhereGroup_com

Amtsgericht Bonn, HRA 6788
-------------------------------
Komplementärin:
WhereGroup Verwaltungs GmbH
vertreten durch:
Olaf Knopp, Peter Stamm
------------------------------- 

_______________________________________________
Mapbender_users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapbender_users
Reply | Threaded
Open this post in threaded view
|

Re: I can not adjust SearchRouter. Please help

Astrid Emde (WhereGroup)
Hello Den,

have a look at the documentation "How to add a new database"

http://doc.mapbender3.org/en/book/database.html#using-multiple-databases

Make sure that the spaces in your yaml configuration are right set.

Astrid

Am 2016-11-11 14:08, schrieb Charlotte Toma:

> Delete your cache at mapbender3/application/app/cache
>
> sudo rm -Rf app/cache/*
>
> Am 11.11.2016 um 13:59 schrieb Den:
>
>> I did so
>> parameters:
>> default:
>> database_driver: pdo_pgsql
>>
>> database_host: localhost
>>
>> database_port: 5432
>>
>> database_name: mapbender3
>>
>> database_path: ~
>>
>> database_user: postgres
>>
>> database_password: n36rp21
>>
>> search_db:
>> database2_driver: pdo_pgsql
>>
>> database2_host: localhost
>>
>> database2_port: 5432
>>
>> database2_name: search_db
>>
>> database2_path: ~
>>
>> database2_user: postgres
>>
>> database2_password: n36rp21
>>
>> As a result, at start app_dev got it
>>
>> ParameterNotFoundException: You have requested a non-existent
>> parameter
>> "database_driver".
>>
>> --
>> View this message in context:
>>
> http://osgeo-org.1560.x6.nabble.com/I-can-not-adjust-SearchRouter-Please-help-tp5295321p5295331.html
>> [1]
>> Sent from the mapbender-users mailing list archive at Nabble.com.
>> _______________________________________________
>> Mapbender_users mailing list
>> [hidden email]
>> http://lists.osgeo.org/mailman/listinfo/mapbender_users [2]
>
> --
> Mit freundlichen Grüßen
>
> Charlotte Toma
> GIS-Consultant
>
> ********************************************
> Where2B Konferenz 2016
> 15. Dezember 2016 in Bonn
> www.where2b-conference.com [3]
> ********************************************
>
>  Charlotte Toma
>  WhereGroup GmbH & Co.KG
>  Eifelstraße 7
>  53119 Bonn
>  Germany
>
>  Fon: +49(0)228 90 90 38 - 24
>  Fax: +49(0)228 90 90 38 - 11
>
>  [hidden email]
>  www.wheregroup.com [4]
>
>  Folgen Sie der WhereGroup auf twitter:
> http://twitter.com/WhereGroup_com [5]
>
> Amtsgericht Bonn, HRA 6788
> -------------------------------
> Komplementärin:
> WhereGroup Verwaltungs GmbH
> vertreten durch:
> Olaf Knopp, Peter Stamm
> -------------------------------
>
>
> Links:
> ------
> [1]
> http://osgeo-org.1560.x6.nabble.com/I-can-not-adjust-SearchRouter-Please-help-tp5295321p5295331.html
> [2] http://lists.osgeo.org/mailman/listinfo/mapbender_users
> [3] http://www.where2b-conference.com
> [4] http://www.wheregroup.com
> [5] http://twitter.com/WhereGroup_com
>
> _______________________________________________
> Mapbender_users mailing list
> [hidden email]
> http://lists.osgeo.org/mailman/listinfo/mapbender_users

--
Mit freundlichen Grüßen

Astrid Emde
GIS-Consultant

********************************************
Where2B Konferenz 2016
15. Dezember 2016 in Bonn
www.where2b-conference.com
********************************************

  Astrid Emde
  WhereGroup GmbH & Co.KG
  Eifelstraße 7
  53119 Bonn
  Germany

  Fon: +49(0)228 90 90 38 - 22
  Fax: +49(0)228 90 90 38 - 11

  [hidden email]
  www.wheregroup.com

  Folgen Sie der WhereGroup auf twitter:
http://twitter.com/WhereGroup_com

Amtsgericht Bonn, HRA 6788
-------------------------------
Komplementärin:
WhereGroup Verwaltungs GmbH
vertreten durch:
Olaf Knopp, Peter Stamm
-------------------------------
  pgp-public key:
  http://pgp.mit.edu:11371/pks/lookup?search=0x06DA52D72D515284
  Signierte und/oder verschlüsselte Nachrichten sind sehr willkommen
  Signed and/or encrypted mail is highly appreciated
_______________________________________________
Mapbender_users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapbender_users
Den
Reply | Threaded
Open this post in threaded view
|

Re: I can not adjust SearchRouter. Please help

Den
Thank you for your participation! Not expected.

My server is collected on Vbox virtual machine. Operating System Win7 pro 32 bit.

at http: //localhost/mapbender3/config.php I see

Welcome!
Welcome to your new Symfony project.
This script will guide you through the basic configuration of your project.
You can also do the same by editing the 'app / config / parameters.yml' file directly.

However, at the address http: //localhost/mapbender3/app_dev.php/_configurator/ I see one of the lines of such

ERROR - Uncaught PHP Exception Symfony \ Component \ HttpKernel \ Exception \ NotFoundHttpException: "No route found for" GET / _configurator / "" at C: \ Server \ bin \ mapbender3 \ app \ cache \ dev \ classes.php line 1887

Nevertheless, everything works.

Maybe this is the problem? If so what is this error and how to fix it?

Cleaning the cache did not help.

However, despite the above error Mapbender works.
Den
Reply | Threaded
Open this post in threaded view
|

Re: I can not adjust SearchRouter. Please help

Den
Having worked with settings and having transferred all folders of the server to the root directory C: received the following -

http://localhost/mapbender3/config.php 

Welcome!
Welcome to your new Symfony project.
This script will guide you through the basic configuration of your project. You can also do the same by editing the ‘app/config/parameters.yml’ file directly.
Your configuration looks good to run Symfony.

Configure your Symfony Application online
Bypass configuration and go to the Welcome page

http://localhost/mapbender3/app_dev.php

Whoops, looks like something went wrong.

1/1ParameterNotFoundException: You have requested a non-existent parameter "fallback_locale".

in C:\mapbender3\vendor\symfony\symfony\src\Symfony\Component\DependencyInjection\ParameterBag\ParameterBag.php line 96
at ParameterBag->get('fallback_locale') in C:\mapbender3\vendor\symfony\symfony\src\Symfony\Component\DependencyInjection\ParameterBag\ParameterBag.php line 216
at ParameterBag->resolveString('%fallback_locale%', array()) in C:\mapbender3\vendor\symfony\symfony\src\Symfony\Component\DependencyInjection\ParameterBag\ParameterBag.php line 187
at ParameterBag->resolveValue('%fallback_locale%', array()) in C:\mapbender3\vendor\symfony\symfony\src\Symfony\Component\DependencyInjection\ParameterBag\ParameterBag.php line 177
at ParameterBag->resolveValue(array('fallback' => '%fallback_locale%'), array()) in C:\mapbender3\vendor\symfony\symfony\src\Symfony\Component\DependencyInjection\ParameterBag\ParameterBag.php line 177
at ParameterBag->resolveValue(array('translator' => array('fallback' => '%fallback_locale%'), 'secret' => '%secret%', 'router' => array('resource' => '%kernel.root_dir%/config/routing.yml', 'strict_requirements' => '%kernel.debug%'), 'form' => true, 'csrf_protection' => true, 'validation' => array('enable_annotations' => true), 'templating' => array('engines' => array('twig')), 'default_locale' => '%locale%', 'session' => array('cookie_httponly' => true, 'cookie_secure' => '%cookie_secure%', 'cookie_lifetime' => '%cookie_lifetime%')), array()) in C:\mapbender3\vendor\symfony\symfony\src\Symfony\Component\DependencyInjection\ParameterBag\ParameterBag.php line 177
at ParameterBag->resolveValue(array(array('translator' => array('fallback' => '%fallback_locale%'), 'secret' => '%secret%', 'router' => array('resource' => '%kernel.root_dir%/config/routing.yml', 'strict_requirements' => '%kernel.debug%'), 'form' => true, 'csrf_protection' => true, 'validation' => array('enable_annotations' => true), 'templating' => array('engines' => array('twig')), 'default_locale' => '%locale%', 'session' => array('cookie_httponly' => true, 'cookie_secure' => '%cookie_secure%', 'cookie_lifetime' => '%cookie_lifetime%')), array('router' => array('resource' => '%kernel.root_dir%/config/routing_dev.yml'), 'profiler' => array('only_exceptions' => false)))) in C:\mapbender3\vendor\symfony\symfony\src\Symfony\Component\DependencyInjection\Compiler\MergeExtensionConfigurationPass.php line 44
at MergeExtensionConfigurationPass->process(object(ContainerBuilder)) in C:\mapbender3\vendor\symfony\symfony\src\Symfony\Component\HttpKernel\DependencyInjection\MergeExtensionConfigurationPass.php line 39
at MergeExtensionConfigurationPass->process(object(ContainerBuilder)) in C:\mapbender3\vendor\symfony\symfony\src\Symfony\Component\DependencyInjection\Compiler\Compiler.php line 108
at Compiler->compile(object(ContainerBuilder)) in C:\mapbender3\vendor\symfony\symfony\src\Symfony\Component\DependencyInjection\ContainerBuilder.php line 572
at ContainerBuilder->compile() in C:\mapbender3\app\bootstrap.php.cache line 2521
at Kernel->initializeContainer() in C:\mapbender3\app\bootstrap.php.cache line 2300
at Kernel->boot() in C:\mapbender3\app\bootstrap.php.cache line 2331
at Kernel->handle(object(Request)) in C:\mapbender3\web\app_dev.php line 28

http://localhost/mapbender3/app.php

Normally loaded Mapbender page. Authorization works.

config.yml contents

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%
               
   charset:  UTF8
               
   logging: %kernel.debug%
               
   profiling: %kernel.debug%
           
search_db:
               
   driver:   %database2_driver%
               
   host:     %database2_host%
               
   port:     %database2_port%
               
   dbname:   %database2_name%
               
   path:     %database2_path%
               
   user:     %database2_user%
               
   password: %database2_password%
               
   charset:  UTF8
               
   logging: %kernel.debug%
               
   profiling: %kernel.debug%
   
orm:
        auto_generate_proxy_classes: %kernel.debug%
        auto_mapping: true

and parameters.yml

parameters:
   
   default:
   
     database_driver:   pdo_pgsql
   
     database_host:     localhost
   
     database_port:     5432
   
     database_name:     mapbender3
   
     database_path:     ~
   
     database_user:     postgres
   
     database_password: n36rp21

   
   
   search_db:
   
     database2_driver:   pdo_pgsql
   
     database2_host:     localhost
   
     database2_port:     5432
   
     database2_name:     search_db
   
     database2_path:     ~
   
     database2_user:     postgres
   
     database2_password: n36rp21

configuration
Oracle Virtualbox, Win7 32bit Pro, Apache/2.4.23 (Win32) PHP/5.6.26.

PHPinfo

pdo_pgsql

PDO Driver for PostgreSQL enabled
PostgreSQL(libpq) Version 9.4.5
Module version 1.0.2
Revision $Id: 0e858dd2051ca8c2fd3c781909a0670ab5fecd36 $

pgsql

PostgreSQL Support enabled
PostgreSQL(libpq) Version 9.4.5
PostgreSQL(libpq) 9.4.5 (win32)
Multibyte character support enabled
SSL support enabled
Active Persistent Links 0
Active Links 0
Directive Local Value Master Value
pgsql.allow_persistent On On
pgsql.auto_reset_persistent Off Off
pgsql.ignore_notice Off Off
pgsql.log_notice Off Off
pgsql.max_links Unlimited Unlimited
pgsql.max_persistent Unlimited Unlimited

I have no confidence that will earn search if there is an error in the app_dev mode.

You couldn't clear a situation or prompt at least where to look for an error?
Reply | Threaded
Open this post in threaded view
|

Re: I can not adjust SearchRouter. Please help

Charlotte Toma

Hello there,


1/1ParameterNotFoundException: You have requested a non-existent parameter
"fallback_locale".

Is the following parameter in your parameters.yml set correct? 

[db connections... please don't show your passwords....]

    # locale en, de, it, es, ru, nl, pt are available
    fallback_locale:   en
    locale:            en
    secret:            ThisTokenIsNotSoSecretChangeIt




Am 15.11.2016 um 14:59 schrieb Den:
Having worked with settings and having transferred all folders of the server
to the root directory C: received the following -

http://localhost/mapbender3/config.php 

Welcome!
Welcome to your new Symfony project.
This script will guide you through the basic configuration of your project.
You can also do the same by editing the ‘app/config/parameters.yml’ file
directly.
Your configuration looks good to run Symfony.

Configure your Symfony Application online
Bypass configuration and go to the Welcome page

http://localhost/mapbender3/app_dev.php

Whoops, looks like something went wrong.

1/1ParameterNotFoundException: You have requested a non-existent parameter
"fallback_locale".

in
C:\mapbender3\vendor\symfony\symfony\src\Symfony\Component\DependencyInjection\ParameterBag\ParameterBag.php
line 96
at ParameterBag->get('fallback_locale') in
C:\mapbender3\vendor\symfony\symfony\src\Symfony\Component\DependencyInjection\ParameterBag\ParameterBag.php
line 216
at ParameterBag->resolveString('%fallback_locale%', array()) in
C:\mapbender3\vendor\symfony\symfony\src\Symfony\Component\DependencyInjection\ParameterBag\ParameterBag.php
line 187
at ParameterBag->resolveValue('%fallback_locale%', array()) in
C:\mapbender3\vendor\symfony\symfony\src\Symfony\Component\DependencyInjection\ParameterBag\ParameterBag.php
line 177
at ParameterBag->resolveValue(array('fallback' => '%fallback_locale%'),
array()) in
C:\mapbender3\vendor\symfony\symfony\src\Symfony\Component\DependencyInjection\ParameterBag\ParameterBag.php
line 177
at ParameterBag->resolveValue(array('translator' => array('fallback' =>
'%fallback_locale%'), 'secret' => '%secret%', 'router' => array('resource'
=> '%kernel.root_dir%/config/routing.yml', 'strict_requirements' =>
'%kernel.debug%'), 'form' => true, 'csrf_protection' => true, 'validation'
=> array('enable_annotations' => true), 'templating' => array('engines' =>
array('twig')), 'default_locale' => '%locale%', 'session' =>
array('cookie_httponly' => true, 'cookie_secure' => '%cookie_secure%',
'cookie_lifetime' => '%cookie_lifetime%')), array()) in
C:\mapbender3\vendor\symfony\symfony\src\Symfony\Component\DependencyInjection\ParameterBag\ParameterBag.php
line 177
at ParameterBag->resolveValue(array(array('translator' => array('fallback'
=> '%fallback_locale%'), 'secret' => '%secret%', 'router' =>
array('resource' => '%kernel.root_dir%/config/routing.yml',
'strict_requirements' => '%kernel.debug%'), 'form' => true,
'csrf_protection' => true, 'validation' => array('enable_annotations' =>
true), 'templating' => array('engines' => array('twig')), 'default_locale'
=> '%locale%', 'session' => array('cookie_httponly' => true, 'cookie_secure'
=> '%cookie_secure%', 'cookie_lifetime' => '%cookie_lifetime%')),
array('router' => array('resource' =>
'%kernel.root_dir%/config/routing_dev.yml'), 'profiler' =>
array('only_exceptions' => false)))) in
C:\mapbender3\vendor\symfony\symfony\src\Symfony\Component\DependencyInjection\Compiler\MergeExtensionConfigurationPass.php
line 44
at MergeExtensionConfigurationPass->process(object(ContainerBuilder)) in
C:\mapbender3\vendor\symfony\symfony\src\Symfony\Component\HttpKernel\DependencyInjection\MergeExtensionConfigurationPass.php
line 39
at MergeExtensionConfigurationPass->process(object(ContainerBuilder)) in
C:\mapbender3\vendor\symfony\symfony\src\Symfony\Component\DependencyInjection\Compiler\Compiler.php
line 108
at Compiler->compile(object(ContainerBuilder)) in
C:\mapbender3\vendor\symfony\symfony\src\Symfony\Component\DependencyInjection\ContainerBuilder.php
line 572
at ContainerBuilder->compile() in C:\mapbender3\app\bootstrap.php.cache line
2521
at Kernel->initializeContainer() in C:\mapbender3\app\bootstrap.php.cache
line 2300
at Kernel->boot() in C:\mapbender3\app\bootstrap.php.cache line 2331
at Kernel->handle(object(Request)) in C:\mapbender3\web\app_dev.php line 28

http://localhost/mapbender3/app.php

Normally loaded Mapbender page. Authorization works.

config.yml contents

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%
                
   charset:  UTF8
                
   logging: %kernel.debug%
                
   profiling: %kernel.debug%
            
search_db:
                
   driver:   %database2_driver%
                
   host:     %database2_host%
                
   port:     %database2_port%
                
   dbname:   %database2_name%
                
   path:     %database2_path%
                
   user:     %database2_user%
                
   password: %database2_password%
                
   charset:  UTF8
                
   logging: %kernel.debug%
                
   profiling: %kernel.debug%
    
orm:
        auto_generate_proxy_classes: %kernel.debug%
        auto_mapping: true

and parameters.yml

parameters:
   
   default:
    
     database_driver:   pdo_pgsql
    
     database_host:     localhost
    
     database_port:     5432
    
     database_name:     mapbender3
    
     database_path:     ~
    
     database_user:     postgres
    
     database_password: n36rp21

    
   
   search_db:
    
     database2_driver:   pdo_pgsql
    
     database2_host:     localhost
    
     database2_port:     5432
    
     database2_name:     search_db
    
     database2_path:     ~
    
     database2_user:     postgres
    
     database2_password: n36rp21

configuration 
Oracle Virtualbox, Win7 32bit Pro, Apache/2.4.23 (Win32) PHP/5.6.26.

PHPinfo

pdo_pgsql

PDO Driver for PostgreSQL	enabled
PostgreSQL(libpq) Version	9.4.5
Module version	1.0.2
Revision	$Id: 0e858dd2051ca8c2fd3c781909a0670ab5fecd36 $

pgsql

PostgreSQL Support	enabled
PostgreSQL(libpq) Version	9.4.5
PostgreSQL(libpq)	9.4.5 (win32)
Multibyte character support	enabled
SSL support	enabled
Active Persistent Links	0
Active Links	0
Directive	Local Value	Master Value
pgsql.allow_persistent	On	On
pgsql.auto_reset_persistent	Off	Off
pgsql.ignore_notice	Off	Off
pgsql.log_notice	Off	Off
pgsql.max_links	Unlimited	Unlimited
pgsql.max_persistent	Unlimited	Unlimited

I have no confidence that will earn search if there is an error in the
app_dev mode.

You couldn't clear a situation or prompt at least where to look for an
error?



--
View this message in context: http://osgeo-org.1560.x6.nabble.com/I-can-not-adjust-SearchRouter-Please-help-tp5295321p5295856.html
Sent from the mapbender-users mailing list archive at Nabble.com.
_______________________________________________
Mapbender_users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapbender_users

-- 
Mit freundlichen Grüßen

Charlotte Toma
GIS-Consultant

********************************************
Where2B Konferenz 2016
15. Dezember 2016 in Bonn
www.where2b-conference.com
******************************************** 

 Charlotte Toma
 WhereGroup GmbH & Co.KG
 Eifelstraße 7
 53119 Bonn
 Germany

 Fon: +49(0)228 90 90 38 - 24
 Fax: +49(0)228 90 90 38 - 11

 [hidden email]
 www.wheregroup.com

 Folgen Sie der WhereGroup auf twitter: http://twitter.com/WhereGroup_com

Amtsgericht Bonn, HRA 6788
-------------------------------
Komplementärin:
WhereGroup Verwaltungs GmbH
vertreten durch:
Olaf Knopp, Peter Stamm
------------------------------- 

_______________________________________________
Mapbender_users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapbender_users
Den
Reply | Threaded
Open this post in threaded view
|

Re: I can not adjust SearchRouter. Please help

Den
This post was updated on .
Here complete contents of my file parameters.yml  at the moment

parameters:
   default:
    database_driver:   pdo_pgsql
    database_host:     localhost
    database_port:     5432
    database_name:     mapbender3
    database_path:     ~
    database_user:     postgres
    database_password: TopSecret
   
   search_db:
    database2_driver:   pdo_pgsql
    database2_host:     localhost
    database2_port:     5432
    database2_name:     search_db
    database2_path:     ~
    database2_user:     postgres
    database2_password: TopSecret

    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

    fom:
        server_name:   Mapbender3
        server_version: 3.0.5.3
        server_logo:   bundles/mapbendercore/image/logo_mb3.png

    # framework : http://symfony.com/doc/2.1/reference/configuration/framework.html#cookie-lifetime
    cookie_secure: false
    cookie_lifetime: 3600

# OWSProxy 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: ~


PS: Postgresql version postgresql-9.6.0-rc1-windows,   postgis_2_3_pg96

     Also I noted that in assembly of mapbender3 for windows there is no exact way of mapbender3/application/app/cache. And folders with the name Cache a little. What precisely you meant for cleaning?
Den
Reply | Threaded
Open this post in threaded view
|

Re: I can not adjust SearchRouter. Please help

Den
Good afternoon once again.
My epic proceeds, I decided to use the disk OSGeo with the set Mapbender and examples.

I want to use a search configuration from this FOSS4G2016_Mapbender3_Workshop_searchrouter file.
As far as I understood to me it is necessary to change config.yml so

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%        
 charset:  UTF8        
 logging: %kernel.debug%        
 profiling: %kernel.debug%
           
osm_local:
 driver:   %database2_driver%    
 host:     %database2_host%      
 port:     %database2_port%  
 dbname:   %database2_name%            
 path:     %database2_path%          
 user:     %database2_user%        
 password: %database2_password%            
 charset:  UTF8        
 logging: %kernel.debug%        
 profiling: %kernel.debug%
orm:  
 auto_generate_proxy_classes: %kernel.debug%
 auto_mapping: true

and parameters.yml so

parameters:
   
default:
database_driver:   pdo_pgsql
database_host:     localhost
database_port:     5432
database_name:     mapbender3.0.5.3
database_path:     ~
database_user:     user
database_password: user
   
osm_local:
database2_driver:  
pdo_pgsql
database2_host:     localhost
database2_port:     5432
database2_name:     osm_local
database2_path:     ~
database2_user:    
user
database2_password: user

I made it and re-recorded files on address/var/www/html/mapbender3/app/config

During copying paid attention that their contents visually didn't change and the size of files exchanged.
As a result after restarting of the Apache system gave an error message. I returned back files but Mapbender all the same isn't launched.

My questions: whether contents of files are correct? how it is correct to re-record them? In ubuntu I am also a beginner.
Den
Reply | Threaded
Open this post in threaded view
|

Re: I can not adjust SearchRouter. Please help

Den
This post was updated on .
In reply to this post by Den
Good afternoon!

At me it turned out to launch SearchRouter. My error consisted in accidental use of TAB but not SPAСE
in the config.yml and parameters.yml files. It can't be done categorically.
I recommend to add it to a manual. The tool earned on Lubuntu OSGeo-Live 10.0. On Windows it wasn't succeeded to launch but errors weren't any more. Possibly a problem in connection to the database.
I used the osm_local database and a configuration taken from the FOSS4G2016_Mapbender3_Workshop_searchrouter.txt file
After that everything turned out. Tried to add the data to osm_local basis and to look for according to them - also works.
But I faced a problem - everything works under app_dev. When I try to launch through app - No results found.
As far as I understand here matter in a server configuration. Prompt how to launch under app?
Reply | Threaded
Open this post in threaded view
|

Re: I can not adjust SearchRouter. Please help

Charlotte Toma

Hello, 

if you have problems with the configuration of the searchrouter or digitizer YAML then you can use this side: http://www.yamllint.com/ to validate your text.

Can you show us your url? Something like this works: http://localhost/mapbender3/app_dev.php and this doesn't: http://localhost/mapbender3/app.php ? Nothing in the logs?


-- 
Mit freundlichen Grüßen

Charlotte Toma
GIS-Consultant

********************************************
Where2B Konferenz 2016
15. Dezember 2016 in Bonn
www.where2b-conference.com
******************************************** 

 Charlotte Toma
 WhereGroup GmbH & Co.KG
 Eifelstraße 7
 53119 Bonn
 Germany

 Fon: +49(0)228 90 90 38 - 24
 Fax: +49(0)228 90 90 38 - 11

 [hidden email]
 www.wheregroup.com

 Folgen Sie der WhereGroup auf twitter: http://twitter.com/WhereGroup_com

Amtsgericht Bonn, HRA 6788
-------------------------------
Komplementärin:
WhereGroup Verwaltungs GmbH
vertreten durch:
Olaf Knopp, Peter Stamm
------------------------------- 
Am 01.12.2016 um 14:41 schrieb Den:
Good afternoon!

At me it turned out to launch SearchRouter. My error consisted in accidental
use of TAB but not SPASE
in the config.yml and parameters.yml files. It can't be done categorically.
I recommend to add it to a manual. The tool earned on Lubuntu OSGeo-Live
10.0. On Windows it wasn't succeeded to launch but errors weren't any more.
Possibly a problem in connection to the database.
I used the osm_local database and a configuration taken from the
FOSS4G2016_Mapbender3_Workshop_searchrouter.txt file
After that everything turned out. Tried to add the data to osm_local basis
and to look for according to them - also works.
But I faced a problem - everything works under app_dev. When I try to launch
through app - No results found.
As far as I understand here matter in a server configuration. Prompt how to
launch under app?



--
View this message in context: http://osgeo-org.1560.x6.nabble.com/I-can-not-adjust-SearchRouter-Please-help-tp5295321p5298233.html
Sent from the mapbender-users mailing list archive at Nabble.com.
_______________________________________________
Mapbender_users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapbender_users


_______________________________________________
Mapbender_users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapbender_users
Den
Reply | Threaded
Open this post in threaded view
|

Re: I can not adjust SearchRouter. Please help

Den

That's right,

It works - http: //localhost/mapbender3/app_dev.php

This does not work -
http: //localhost/mapbender3/app.php

Here logs Apache

127.0.0.1 - - [01/Dec/2016:21:29:05 +0300] "POST /mapbender3/app.php/application/testmap/element/102/0-186e3037-2090-5827-4bda-3b45bac4794d/autocomplete HTTP/1.1" 500 726 "http://127.0.0.1/mapbender3/app.php/application/testmap" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:50.0) Gecko/20100101 Firefox/50.0"
127.0.0.1 - - [01/Dec/2016:21:29:07 +0300] "POST /mapbender3/app.php/application/testmap/element/102/0-186e3037-2090-5827-4bda-3b45bac4794d/search HTTP/1.1" 500 726 "http://127.0.0.1/mapbender3/app.php/application/testmap" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:50.0) Gecko/20100101 Firefox/50.0"

[Thu Dec 01 20:46:13.436283 2016] [mpm_prefork:notice] [pid 1142] AH00171: Graceful restart requested, doing restart
[Thu Dec 01 20:46:15.389113 2016] [core:warn] [pid 1142] AH00114: Useless use of AllowOverride in line 7 of /etc/apache2/sites-enabled/istsos.conf/istsos.conf.
AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 127.0.1.1. Set the 'ServerName' directive globally to suppress this message


These lines in logs made me suspicious.

As for YAML this question I have already grasped. Thank you for the resource to check
Den
Reply | Threaded
Open this post in threaded view
|

Re: I can not adjust SearchRouter. Please help

Den
Hello,

I have found the reason. Everything worked. Thank you for your advice and support. I repeat once again - a very powerful framework.
No Do you have any plans to search through the WFS and WFS-T? It would solve a lot of problems.