#
include_recipe "accounts"
-include_recipe "munin"
include_recipe "prometheus"
-
-if node[:nominatim][:api_flavour] == "php"
- include_recipe "php::fpm"
-end
+include_recipe "postgresql"
+include_recipe "python"
+include_recipe "nginx"
+include_recipe "git"
+include_recipe "fail2ban"
basedir = data_bag_item("accounts", "nominatim")["home"]
-email_errors = data_bag_item("accounts", "lonvia")["email"]
+project_directory = "#{basedir}/planet-project"
+bin_directory = "#{basedir}/bin"
+cfg_directory = "#{basedir}/etc"
+ui_directory = "#{basedir}/ui"
+qa_data_directory = "#{basedir}/qa-data"
directory basedir do
owner "nominatim"
recursive true
end
+[basedir, bin_directory, cfg_directory, project_directory, ui_directory].each do |path|
+ directory path do
+ owner "nominatim"
+ group "nominatim"
+ mode "755"
+ end
+end
+
+if node[:nominatim][:flatnode_file]
+ directory File.dirname(node[:nominatim][:flatnode_file]) do
+ recursive true
+ end
+end
+
+directory "#{bin_directory}/maintenance" do
+ owner "nominatim"
+ group "nominatim"
+ mode "775"
+end
+
## Log directory setup
directory node[:nominatim][:logdir] do
mode "664"
end
-file "#{node[:nominatim][:logdir]}/update.log" do
- action :create_if_missing
- owner "nominatim"
- group "adm"
- mode "664"
-end
-
-## Postgresql
-
-include_recipe "postgresql"
+### Postgresql
postgresql_version = node[:nominatim][:dbcluster].split("/").first
postgis_version = node[:nominatim][:postgis]
postgresql_user user do
cluster node[:nominatim][:dbcluster]
superuser true
- only_if { node[:nominatim][:state] != "slave" }
end
end
postgresql_user "nominatim" do
cluster node[:nominatim][:dbcluster]
superuser true
- only_if { node[:nominatim][:state] != "slave" }
end
postgresql_user "www-data" do
cluster node[:nominatim][:dbcluster]
- only_if { node[:nominatim][:state] != "slave" }
-end
-
-postgresql_munin "nominatim" do
- cluster node[:nominatim][:dbcluster]
- database node[:nominatim][:dbname]
end
-directory "#{basedir}/tablespaces" do
- owner "postgres"
- group "postgres"
- mode "700"
-end
-
-# NOTE: tablespaces must be exactly in the same location on each
-# Nominatim instance when replication is in use. Therefore
-# use symlinks to canonical directory locations.
-node[:nominatim][:tablespaces].each do |name, location|
- directory location do
- owner "postgres"
- group "postgres"
- mode "700"
- recursive true
- end
-
- link "#{basedir}/tablespaces/#{name}" do
- to location
- end
-
- postgresql_tablespace name do
- cluster node[:nominatim][:dbcluster]
- location "#{basedir}/tablespaces/#{name}"
- end
-end
-
-## Nominatim backend
-
-include_recipe "git"
-include_recipe "python"
+### Nominatim
python_directory = "#{basedir}/venv"
package %w[
build-essential
- cmake
- g++
- libboost-dev
- libboost-system-dev
- libboost-filesystem-dev
- libexpat1-dev
- zlib1g-dev
- libbz2-dev
- libpq-dev
- libproj-dev
- liblua5.3-dev
- libluajit-5.1-dev
libicu-dev
- nlohmann-json3-dev
- lua5.3
- python3-pyosmium
- python3-psycopg2
- python3-dotenv
- python3-psutil
- python3-jinja2
- python3-icu
- python3-datrie
- python3-yaml
- python3-sqlalchemy-ext
- python3-geoalchemy2
- python3-asyncpg
python3-dev
pkg-config
+ osm2pgsql
ruby
ruby-file-tail
ruby-pg
ruby-webrick
]
-if node[:nominatim][:api_flavour] == "php"
- package %w[
- php-pgsql
- php-intl
- ]
-elsif node[:nominatim][:api_flavour] == "python"
-
- python_virtualenv python_directory do
- interpreter "/usr/bin/python3"
- end
-
- python_package "SQLAlchemy" do
- python_virtualenv python_directory
- version "2.0.20"
- end
-
- python_package "PyICU" do
- python_virtualenv python_directory
- version "2.10.2"
- end
-
- python_package "psycopg[binary]" do
- python_virtualenv python_directory
- version "3.1.10"
- end
-
- python_package "psycopg2-binary" do
- python_virtualenv python_directory
- version "2.9.7"
- end
-
- python_package "python-dotenv" do
- python_virtualenv python_directory
- version "0.21.0"
- end
-
- python_package "pygments" do
- python_virtualenv python_directory
- version "2.16.1"
- end
-
- python_package "PyYAML" do
- python_virtualenv python_directory
- version "6.0.1"
- end
-
- python_package "falcon" do
- python_virtualenv python_directory
- version "3.1.1"
- end
-
- python_package "uvicorn" do
- python_virtualenv python_directory
- version "0.23.2"
- end
-
- python_package "gunicorn" do
- python_virtualenv python_directory
- version "21.0.1"
- end
+python_virtualenv python_directory do
+ interpreter "/usr/bin/python3"
end
-source_directory = "#{basedir}/src/nominatim"
-build_directory = "#{basedir}/src/build"
-project_directory = "#{basedir}/planet-project"
-bin_directory = "#{basedir}/bin"
-cfg_directory = "#{basedir}/etc"
-ui_directory = "#{basedir}/ui"
-qa_bin_directory = "#{basedir}/src/Nominatim-Data-Analyser"
-qa_data_directory = "#{basedir}/qa-data"
-
-[basedir, "#{basedir}/src", cfg_directory, bin_directory, build_directory, project_directory].each do |path|
- directory path do
- owner "nominatim"
- group "nominatim"
- mode "755"
- recursive true
- end
-end
-
-directory "#{bin_directory}/maintenance" do
- owner "nominatim"
- group "nominatim"
- mode "775"
+# These are updated during the database update.
+python_package "nominatim-db" do
+ python_virtualenv python_directory
+ extra_index_url node[:nominatim][:pip_index]
end
-if node[:nominatim][:flatnode_file]
- directory File.dirname(node[:nominatim][:flatnode_file]) do
- recursive true
- end
+python_package "nominatim-api" do
+ python_virtualenv python_directory
+ extra_index_url node[:nominatim][:pip_index]
end
remote_directory "#{project_directory}/static-website" do
purge false
end
-# Normally syncing via chef is a bad idea because syncing might involve
-# an update of database functions which should not be done while an update
-# is ongoing. Therefore we sync in between update cycles. There is an
-# exception for slaves: they get DB function updates from the master, so
-# only the source code needs to be updated, which chef may do.
-git source_directory do
- action node[:nominatim][:state] == "slave" ? :sync : :checkout
- repository node[:nominatim][:repository]
- revision node[:nominatim][:revision]
- enable_submodules true
- user "nominatim"
- group "nominatim"
- not_if { node[:nominatim][:state] != "slave" && File.exist?("#{source_directory}/README.md") }
- notifies :run, "execute[compile_nominatim]"
-end
-
-remote_file "#{source_directory}/data/country_osm_grid.sql.gz" do
- action :create_if_missing
- source "https://nominatim.org/data/country_grid.sql.gz"
- owner "nominatim"
- group "nominatim"
- mode "644"
-end
-
-execute "compile_nominatim" do
- action :nothing
- user "nominatim"
- cwd build_directory
- command "cmake -D WITH_LUAJIT=ON #{source_directory} && make"
- notifies :run, "execute[install_nominatim]"
-end
-
-execute "install_nominatim" do
- action :nothing
- cwd build_directory
- command "make install"
-end
-
-# Project directory
-
template "#{project_directory}/.env" do
source "nominatim.env.erb"
owner "nominatim"
group "nominatim"
mode "664"
- variables :base_url => node[:nominatim][:state] == "off" ? node[:fqdn] : "nominatim.openstreetmap.org",
+ variables :base_url => "nominatim.openstreetmap.org",
:dbname => node[:nominatim][:dbname],
:flatnode_file => node[:nominatim][:flatnode_file],
:log_file => "#{node[:nominatim][:logdir]}/query.log",
- :tokenizer => node[:nominatim][:config][:tokenizer],
- :forward_dependencies => node[:nominatim][:config][:forward_dependencies],
:pool_size => node[:nominatim][:api_pool_size],
:query_timeout => node[:nominatim][:api_query_timeout],
:request_timeout => node[:nominatim][:api_request_timeout]
end
-remote_file "#{project_directory}/wikimedia-importance.sql.gz" do
+remote_file "#{project_directory}/secondary_importance.sql.gz" do
action :create_if_missing
- source "https://nominatim.org/data/wikimedia-importance.sql.gz"
+ source "https://nominatim.org/data/wikimedia-secondary-importance.sql.gz"
+ owner "nominatim"
+ group "nominatim"
+ mode "644"
+end
+
+remote_file "#{project_directory}/wikimedia-importance.csv.gz" do
+ action :create_if_missing
+ source "https://nominatim.org/data/wikimedia-importance.csv.gz"
owner "nominatim"
group "nominatim"
mode "644"
end
end
-if node[:nominatim][:api_flavour] == "php"
- node[:nominatim][:fpm_pools].each do |name, data|
- php_fpm name do
- port data[:port]
- pm data[:pm]
- pm_max_children data[:max_children]
- pm_start_servers 20
- pm_min_spare_servers 10
- pm_max_spare_servers 20
- pm_max_requests 10000
- prometheus_port data[:prometheus_port]
- end
- end
-elsif node[:nominatim][:api_flavour] == "python"
- systemd_service "nominatim" do
- description "Nominatim running as a gunicorn application"
- user "www-data"
- group "www-data"
- working_directory project_directory
- standard_output "append:#{node[:nominatim][:logdir]}/gunicorn.log"
- standard_error "inherit"
- exec_start "#{python_directory}/bin/gunicorn --max-requests 200000 -b unix:/run/gunicorn-nominatim.openstreetmap.org.sock -w #{node[:nominatim][:api_workers]} -k uvicorn.workers.UvicornWorker nominatim.server.falcon.server:run_wsgi"
- exec_reload "/bin/kill -s HUP $MAINPID"
- environment :PYTHONPATH => "/usr/local/lib/nominatim/lib-python/"
- kill_mode "mixed"
- timeout_stop_sec 5
- private_tmp true
- requires "nominatim.socket"
- after "network.target"
- end
+systemd_service "nominatim" do
+ description "Nominatim running as a gunicorn application"
+ user "www-data"
+ group "www-data"
+ working_directory project_directory
+ standard_output "append:#{node[:nominatim][:logdir]}/gunicorn.log"
+ standard_error "inherit"
+ exec_start "#{python_directory}/bin/gunicorn --max-requests 200000 -b unix:/run/gunicorn-nominatim.openstreetmap.org.sock -w #{node[:nominatim][:api_workers]} -k uvicorn.workers.UvicornWorker 'nominatim_api.server.falcon.server:run_wsgi()'"
+ exec_reload "/bin/kill -s HUP $MAINPID"
+ kill_mode "mixed"
+ timeout_stop_sec 5
+ private_tmp true
+ requires "nominatim.socket"
+ after "network.target"
+end
- systemd_socket "nominatim" do
- description "Gunicorn socket for Nominatim"
- listen_stream "/run/gunicorn-nominatim.openstreetmap.org.sock"
- socket_user "www-data"
- end
+systemd_socket "nominatim" do
+ description "Gunicorn socket for Nominatim"
+ listen_stream "/run/gunicorn-nominatim.openstreetmap.org.sock"
+ socket_user "www-data"
end
ssl_certificate node[:fqdn] do
notifies :reload, "service[nginx]"
end
-include_recipe "nginx"
-
nginx_site "default" do
action [:delete]
end
mode "644"
end
-# Updates
+### Import, update and maintenance scripts
%w[nominatim-update
- nominatim-update-source
- nominatim-update-refresh-db
nominatim-update-data
+ nominatim-update-refresh-db
nominatim-daily-maintenance].each do |fname|
template "#{bin_directory}/#{fname}" do
source "#{fname}.erb"
group "nominatim"
mode "554"
variables :bindir => bin_directory,
- :srcdir => source_directory,
- :builddir => build_directory,
:projectdir => project_directory,
- :qabindir => qa_bin_directory,
+ :venvprefix => "#{python_directory}/bin/",
:qadatadir => qa_data_directory
end
end
description "Update the Nominatim database"
exec_start "#{bin_directory}/nominatim-update"
restart "on-success"
- standard_output "append:#{node[:nominatim][:logdir]}/update.log"
+ standard_output "journal"
standard_error "inherit"
working_directory project_directory
end
end
systemd_timer "nominatim-update-maintenance-trigger" do
- action node[:nominatim][:state] != "off" ? :create : :delete
+ action :create
description "Schedule daily maintenance tasks for Nominatim DB"
on_calendar "*-*-* 02:03:00 UTC"
end
service "nominatim-update-maintenance-trigger" do
- action node[:nominatim][:state] != "off" ? :enable : :disable
+ action :enable
end
-# Nominatim UI
+## Nominatim UI
git ui_directory do
action :sync
mode "664"
end
-# Nominatim QA
+## Nominatim QA
if node[:nominatim][:enable_qa_tiles]
- package "python3-geojson"
-
- git qa_bin_directory do
- repository node[:nominatim][:qa_repository]
- revision node[:nominatim][:qa_revision]
- enable_submodules true
- user "nominatim"
- group "nominatim"
- notifies :run, "execute[compile_qa]"
- end
-
- execute "compile_qa" do
- action :nothing
- user "nominatim"
- cwd "#{qa_bin_directory}/clustering-vt"
- command "make"
+ python_package "nominatim-data-analyser" do
+ python_virtualenv python_directory
+ extra_index_url node[:nominatim][:pip_index]
end
directory qa_data_directory do
recursive true
end
- template "#{qa_bin_directory}/analyser/config/config.yaml" do
+ template "#{project_directory}/qa-config.yaml" do
source "qa_config.erb"
owner "nominatim"
group "nominatim"
nginx_site "qa-tiles.nominatim" do
template "nginx-qa-tiles.erb"
- directory build_directory
+ directory qa_data_directory
variables :qa_data_directory => qa_data_directory
end
-
-end
-
-# Replication
-
-cron_d "nominatim-clean-db" do
- action node[:nominatim][:state] == "master" ? :create : :delete
- minute "5"
- hour "*/4"
- user "postgres"
- command "#{bin_directory}/clean-db-nominatim"
- mailto email_errors
-end
-
-if node[:nominatim][:state] == "master"
- postgresql_user "replication" do
- cluster node[:nominatim][:dbcluster]
- password data_bag_item("nominatim", "passwords")["replication"]
- replication true
- end
-
- directory node[:rsyncd][:modules][:archive][:path] do
- owner "postgres"
- group "postgres"
- mode "700"
- end
-
- template "#{bin_directory}/clean-db-nominatim" do
- source "clean-db-nominatim.erb"
- owner "nominatim"
- group "nominatim"
- mode "755"
- variables :archive_dir => node[:rsyncd][:modules][:archive][:path],
- :update_stop_file => "#{basedir}/status/updates_disabled",
- :streaming_clients => search(:node, "nominatim_state:slave").map { |slave| slave[:fqdn] }.join(" ")
- end
end
-# Maintenance
-
-cron_d "nominatim-backup" do
- action (node[:nominatim][:enable_backup] && node[:nominatim][:state] != "off") ? :create : :delete
- minute "0"
- hour "3"
- day "1"
- user "nominatim"
- command "#{bin_directory}/backup-nominatim"
- mailto email_errors
-end
-
-cron_d "nominatim-vacuum-db" do
- action node[:nominatim][:state] != "off" ? :create : :delete
- minute "20"
- hour "0"
- user "postgres"
- command "#{bin_directory}/vacuum-db-nominatim"
- mailto email_errors
-end
-
-%w[backup-nominatim vacuum-db-nominatim].each do |fname|
- template "#{bin_directory}/#{fname}" do
- source "#{fname}.erb"
- owner "nominatim"
- group "nominatim"
- mode "755"
- variables :db => node[:nominatim][:dbname]
- end
-end
-
-# Logging
+## Logging and monitoring
template "/etc/logrotate.d/nominatim" do
source "logrotate.nominatim.erb"
mode "644"
end
-# Monitoring
-
-munin_plugin_conf "nominatim" do
- template "munin.erb"
- variables :db => node[:nominatim][:dbname],
- :querylog => "#{node[:nominatim][:logdir]}/query.log"
-end
-
-munin_plugin "nominatim_importlag" do
- target "#{source_directory}/munin/nominatim_importlag"
-end
-
-munin_plugin "nominatim_query_speed" do
- target "#{source_directory}/munin/nominatim_query_speed_querylog"
-end
-
-munin_plugin "nominatim_requests" do
- target "#{source_directory}/munin/nominatim_requests_querylog"
-end
-
prometheus_exporter "nominatim" do
port 8082
user "www-data"
]
end
-include_recipe "fail2ban"
-
frontend_addresses = frontends.collect { |f| f.ipaddresses(:role => :external) }
fail2ban_jail "nominatim_limit_req" do