Mercurial > gemma

annotate example_conf.toml @ 5590:826e67e959c9 surveysperbottleneckid

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
For BN Overview display id for all doubles
author Thomas Junk <thomas.junk@intevation.de>
date Tue, 05 Apr 2022 13:02:13 +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"