Mercurial > gemma

annotate example_conf.toml @ 5513:68358e4603c8

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Use current axis only for calculating bottleneck areas This is a fixup of rev. cf25b23e3eec, which introduced historic data for the waterway axis but missed to take this into account in the calculation of bottleneck areas, leading to sometimes excessive runtime and bad results due to multiple (almost) equal axis geometries being considered as candidates in the bottleneck stretch. The database migration tries to recalculate all bottleneck areas, while some might fail that did not fail on import. A warning message is emitted for these and the area is left untouched.
author Tom Gottfried <tom@intevation.de>
date Tue, 19 Oct 2021 13:12:39 +0200
parents fb532459eb2e
children 6c17583ff3c1
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
330
fd04bccae6ca Create standard roles as part of the base schema.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
1 # ----------------------------------------------------------------------
fd04bccae6ca Create standard roles as part of the base schema.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
2 # Example configuration for gemma back end
fd04bccae6ca Create standard roles as part of the base schema.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
3 # ----------------------------------------------------------------------
fd04bccae6ca Create standard roles as part of the base schema.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
4
fd04bccae6ca Create standard roles as part of the base schema.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
5 # ----------------------------------------------------------------------
fd04bccae6ca Create standard roles as part of the base schema.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
6 # Basic Setup:
fd04bccae6ca Create standard roles as part of the base schema.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
7
fd04bccae6ca Create standard roles as part of the base schema.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
8 # Host and port to listen on:
481
d68dfbe768e2 Merge example configuration and that used for docker backend
Tom Gottfried <tom@intevation.de>
parents: 480
diff changeset
9 host = "0.0.0.0"
338
dabe189369ad Configuration: Port numbers are integers. Mail port defaults to 465 (SSL).
Sascha L. Teichmann <teichmann@intevation.de>
parents: 330
diff changeset
10 #port = 8000
330
fd04bccae6ca Create standard roles as part of the base schema.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
11
fd04bccae6ca Create standard roles as part of the base schema.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
12 # Where to find the data of the web client (SPA) to serve:
fd04bccae6ca Create standard roles as part of the base schema.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
13 web = "./web"
fd04bccae6ca Create standard roles as part of the base schema.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
14
fd04bccae6ca Create standard roles as part of the base schema.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
15 # File to persist session data:
481
d68dfbe768e2 Merge example configuration and that used for docker backend
Tom Gottfried <tom@intevation.de>
parents: 480
diff changeset
16 sessions = "/tmp/gemma_session.data"
330
fd04bccae6ca Create standard roles as part of the base schema.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
17
2639
0db742c7813d Make session timeout configurable
Tom Gottfried <tom@intevation.de>
parents: 2243
diff changeset
18 # Duration until sessions expire if not renewed
0db742c7813d Make session timeout configurable
Tom Gottfried <tom@intevation.de>
parents: 2243
diff changeset
19 #session-timeout = "3h"
0db742c7813d Make session timeout configurable
Tom Gottfried <tom@intevation.de>
parents: 2243
diff changeset
20
330
fd04bccae6ca Create standard roles as part of the base schema.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
21 # ----------------------------------------------------------------------
fd04bccae6ca Create standard roles as part of the base schema.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
22 # Database:
fd04bccae6ca Create standard roles as part of the base schema.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
23
fd04bccae6ca Create standard roles as part of the base schema.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
24 # DB connection configuration:
2778
7ebd4154894e Adopt container names to fix GeoServer startup
Tom Gottfried <tom@intevation.de>
parents: 2639
diff changeset
25 db-host = "gemma-db"
517
7e45aaec7081 Consolidate configuration parameters.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 481
diff changeset
26 #db-name = "gemma"
7e45aaec7081 Consolidate configuration parameters.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 481
diff changeset
27 #db-port = 5432
7e45aaec7081 Consolidate configuration parameters.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 481
diff changeset
28 #db-ssl = "prefer"
7e45aaec7081 Consolidate configuration parameters.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 481
diff changeset
29 db-user = "meta_login"
7e45aaec7081 Consolidate configuration parameters.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 481
diff changeset
30 db-password = "geo2Serv"
330
fd04bccae6ca Create standard roles as part of the base schema.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
31
fd04bccae6ca Create standard roles as part of the base schema.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
32 # ----------------------------------------------------------------------
fd04bccae6ca Create standard roles as part of the base schema.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
33 # Mail setup:
fd04bccae6ca Create standard roles as part of the base schema.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
34
fd04bccae6ca Create standard roles as part of the base schema.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
35 # SMTP connection configuration:
fd04bccae6ca Create standard roles as part of the base schema.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
36 #mail-host = "localhost"
fd04bccae6ca Create standard roles as part of the base schema.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
37 #mail-password = "SECRET"
338
dabe189369ad Configuration: Port numbers are integers. Mail port defaults to 465 (SSL).
Sascha L. Teichmann <teichmann@intevation.de>
parents: 330
diff changeset
38 #mail-port = 465
330
fd04bccae6ca Create standard roles as part of the base schema.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
39 #mail-user = "gemma"
fd04bccae6ca Create standard roles as part of the base schema.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
40
fd04bccae6ca Create standard roles as part of the base schema.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
41 # Client data to use:
fd04bccae6ca Create standard roles as part of the base schema.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
42 #mail-from = "noreplay@localhost"
fd04bccae6ca Create standard roles as part of the base schema.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
43 #mail-helo = "localhost"
480
0fcbdb4539d1 Update example configuration
Tom Gottfried <tom@intevation.de>
parents: 338
diff changeset
44
0fcbdb4539d1 Update example configuration
Tom Gottfried <tom@intevation.de>
parents: 338
diff changeset
45 # ----------------------------------------------------------------------
0fcbdb4539d1 Update example configuration
Tom Gottfried <tom@intevation.de>
parents: 338
diff changeset
46 # OGC services setup:
0fcbdb4539d1 Update example configuration
Tom Gottfried <tom@intevation.de>
parents: 338
diff changeset
47
0fcbdb4539d1 Update example configuration
Tom Gottfried <tom@intevation.de>
parents: 338
diff changeset
48 # Connection to GeoServer instance for internal OGC services
2778
7ebd4154894e Adopt container names to fix GeoServer startup
Tom Gottfried <tom@intevation.de>
parents: 2639
diff changeset
49 geoserver-url = "http://gemma-geoserver:8080/geoserver"
480
0fcbdb4539d1 Update example configuration
Tom Gottfried <tom@intevation.de>
parents: 338
diff changeset
50 #geoserver-user = "admin"
0fcbdb4539d1 Update example configuration
Tom Gottfried <tom@intevation.de>
parents: 338
diff changeset
51 #geoserver-password = "geoserver"
0fcbdb4539d1 Update example configuration
Tom Gottfried <tom@intevation.de>
parents: 338
diff changeset
52
949
d11f1211b4e6 Update example configuration
Tom Gottfried <tom@intevation.de>
parents: 517
diff changeset
53 # Clean GeoServer setup on startup
950
7fc47ac98520 Do not clean GeoServer by default!
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 949
diff changeset
54 # Persisting this is mainly useful in some dev setups.
7fc47ac98520 Do not clean GeoServer by default!
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 949
diff changeset
55 # Cleaning up the GeoServer should be done with
7fc47ac98520 Do not clean GeoServer by default!
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 949
diff changeset
56 # an explicit --geoserver-clean on the command line.
7fc47ac98520 Do not clean GeoServer by default!
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 949
diff changeset
57 #geoserver-clean = true
949
d11f1211b4e6 Update example configuration
Tom Gottfried <tom@intevation.de>
parents: 517
diff changeset
58
4624
209b10f7bb2c Add config for GeoServer database session startup SQL
Tom Gottfried <tom@intevation.de>
parents: 3582
diff changeset
59 # geoserver-startup-sql can be used to add SQL commands to GeoServers database
209b10f7bb2c Add config for GeoServer database session startup SQL
Tom Gottfried <tom@intevation.de>
parents: 3582
diff changeset
60 # session start script. See
209b10f7bb2c Add config for GeoServer database session startup SQL
Tom Gottfried <tom@intevation.de>
parents: 3582
diff changeset
61 # https://docs.geoserver.org/stable/en/user/data/database/sqlsession.html
209b10f7bb2c Add config for GeoServer database session startup SQL
Tom Gottfried <tom@intevation.de>
parents: 3582
diff changeset
62 # Note that the commands will be executed as the user configured as 'db-user'.
209b10f7bb2c Add config for GeoServer database session startup SQL
Tom Gottfried <tom@intevation.de>
parents: 3582
diff changeset
63 # This can be used for example to set query planer configurations that fix
209b10f7bb2c Add config for GeoServer database session startup SQL
Tom Gottfried <tom@intevation.de>
parents: 3582
diff changeset
64 # bad query plans during GeoServer accessing the published layers.
209b10f7bb2c Add config for GeoServer database session startup SQL
Tom Gottfried <tom@intevation.de>
parents: 3582
diff changeset
65 # Currently, the published layer 'bottlenecks_geoserver' is known to trigger
209b10f7bb2c Add config for GeoServer database session startup SQL
Tom Gottfried <tom@intevation.de>
parents: 3582
diff changeset
66 # inefficient nested loop joins due to underestimation of the number of entries
209b10f7bb2c Add config for GeoServer database session startup SQL
Tom Gottfried <tom@intevation.de>
parents: 3582
diff changeset
67 # in the bottlenecks table. Hence the example setting:
209b10f7bb2c Add config for GeoServer database session startup SQL
Tom Gottfried <tom@intevation.de>
parents: 3582
diff changeset
68 geoserver-startup-sql = "SET enable_nestloop TO off"
209b10f7bb2c Add config for GeoServer database session startup SQL
Tom Gottfried <tom@intevation.de>
parents: 3582
diff changeset
69
480
0fcbdb4539d1 Update example configuration
Tom Gottfried <tom@intevation.de>
parents: 338
diff changeset
70 # Proxy settings for external OGC services
0fcbdb4539d1 Update example configuration
Tom Gottfried <tom@intevation.de>
parents: 338
diff changeset
71 #proxy-key = "SECRET"
0fcbdb4539d1 Update example configuration
Tom Gottfried <tom@intevation.de>
parents: 338
diff changeset
72 #proxy-prefix = "http://localhost:8000"
1644
eadf84bb0e98 New config variable 'external-url'.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 950
diff changeset
73 #
eadf84bb0e98 New config variable 'external-url'.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 950
diff changeset
74
eadf84bb0e98 New config variable 'external-url'.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 950
diff changeset
75 # Server is known on the outside as:
eadf84bb0e98 New config variable 'external-url'.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 950
diff changeset
76 # external-url = "http://localhost:8000"
480
0fcbdb4539d1 Update example configuration
Tom Gottfried <tom@intevation.de>
parents: 338
diff changeset
77
0fcbdb4539d1 Update example configuration
Tom Gottfried <tom@intevation.de>
parents: 338
diff changeset
78 # ----------------------------------------------------------------------
0fcbdb4539d1 Update example configuration
Tom Gottfried <tom@intevation.de>
parents: 338
diff changeset
79 # CORS setup:
0fcbdb4539d1 Update example configuration
Tom Gottfried <tom@intevation.de>
parents: 338
diff changeset
80
0fcbdb4539d1 Update example configuration
Tom Gottfried <tom@intevation.de>
parents: 338
diff changeset
81 #allowed-origins = "http://example.com"
2243
783c1454ab47 schemadir entry in example config
Thomas Junk <thomas.junk@intevation.de>
parents: 1644
diff changeset
82
3581
9114097964d7 Update example config
Tom Gottfried <tom@intevation.de>
parents: 3106
diff changeset
83 # ----------------------------------------------------------------------
9114097964d7 Update example config
Tom Gottfried <tom@intevation.de>
parents: 3106
diff changeset
84 # SOAP/XML-based importer setup:
9114097964d7 Update example config
Tom Gottfried <tom@intevation.de>
parents: 3106
diff changeset
85
3582
317d176ef38c GM import: Try three times when timeouts happen on SOAP service. Increase SOAP timeout to 3 minutes.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 3581
diff changeset
86 # soap-timeout = "3m"
3581
9114097964d7 Update example config
Tom Gottfried <tom@intevation.de>
parents: 3106
diff changeset
87
2243
783c1454ab47 schemadir entry in example config
Thomas Junk <thomas.junk@intevation.de>
parents: 1644
diff changeset
88 # Schema for "Testclient imports"
783c1454ab47 schemadir entry in example config
Thomas Junk <thomas.junk@intevation.de>
parents: 1644
diff changeset
89 # schema-dirs = "$PATH_TO_SCHEMATA"
3106
d68d8b137072 added new option to example_conf.toml
Thomas Junk <thomas.junk@intevation.de>
parents: 2778
diff changeset
90 # published-config ="$PATH/pub-config.json"
5338
f8e7f043d968 Fixed example_conf.toml for new report-path.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5337
diff changeset
91 # report-path = "$PATH_TO_XSLX_AND_YAML_PAIRS"
5494
fb532459eb2e Added new config params to example config.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5338
diff changeset
92
fb532459eb2e Added new config params to example config.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5338
diff changeset
93 # File to log to. Default empty -> stderr
fb532459eb2e Added new config params to example config.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5338
diff changeset
94 # log-file = ""
fb532459eb2e Added new config params to example config.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5338
diff changeset
95 # Level of logging. Possible values: trace, debug, info, warn, error, fatal.
fb532459eb2e Added new config params to example config.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5338
diff changeset
96 # log-level = "info"