Configure database for logical replication

[chef.git] / cookbooks / tile / recipes / default.rb

diff --git a/cookbooks/tile/recipes/default.rb b/cookbooks/tile/recipes/default.rb
index d60d52c2c3c238009a47eb11bf5e4d3cdc39a633..7363e410cd3fe945b20463defa6917330d17ab89 100644 (file)
--- a/cookbooks/tile/recipes/default.rb
+++ b/cookbooks/tile/recipes/default.rb
@@ -1,14 +1,14 @@
 #
 #

-# Cookbook Name:: tile
+# Cookbook:: tile

 # Recipe:: default
 #
 # Recipe:: default
 #

-# Copyright 2013, OpenStreetMap Foundation
+# Copyright:: 2013, OpenStreetMap Foundation

 #
 # Licensed under the Apache License, Version 2.0 (the "License");
 # you may not use this file except in compliance with the License.
 # You may obtain a copy of the License at
 #
 #
 # Licensed under the Apache License, Version 2.0 (the "License");
 # you may not use this file except in compliance with the License.
 # You may obtain a copy of the License at
 #

-#     http://www.apache.org/licenses/LICENSE-2.0
+#     https://www.apache.org/licenses/LICENSE-2.0

 #
 # Unless required by applicable law or agreed to in writing, software
 # distributed under the License is distributed on an "AS IS" BASIS,
 #
 # Unless required by applicable law or agreed to in writing, software
 # distributed under the License is distributed on an "AS IS" BASIS,


@@ -17,14 +17,21 @@
 # limitations under the License.
 #
 
 # limitations under the License.
 #
 

+include_recipe "accounts"

 include_recipe "apache"
 include_recipe "git"
 include_recipe "apache"
 include_recipe "git"

+include_recipe "munin"

 include_recipe "nodejs"
 include_recipe "postgresql"
 include_recipe "nodejs"
 include_recipe "postgresql"

+include_recipe "prometheus"
+include_recipe "python"
+include_recipe "tools"

 
 blocks = data_bag_item("tile", "blocks")
 
 blocks = data_bag_item("tile", "blocks")

+web_passwords = data_bag_item("web", "passwords")

 
 apache_module "alias"
 
 apache_module "alias"

+apache_module "cgi"

 apache_module "expires"
 apache_module "headers"
 apache_module "remoteip"
 apache_module "expires"
 apache_module "headers"
 apache_module "remoteip"


@@ -34,10 +41,15 @@ apache_module "tile" do
   conf "tile.conf.erb"
 end
 
   conf "tile.conf.erb"
 end
 

-tilecaches = search(:node, "roles:tilecache")
+ssl_certificate node[:fqdn] do
+  domains [node[:fqdn], "tile.openstreetmap.org", "render.openstreetmap.org"]
+  notifies :reload, "service[apache2]"
+end
+
+tilecaches = search(:node, "roles:tilecache").sort_by { |n| n[:hostname] }

 
 apache_site "default" do
 
 apache_site "default" do

-  action [ :disable ]
+  action [:disable]

 end
 
 apache_site "tile.openstreetmap.org" do
 end
 
 apache_site "tile.openstreetmap.org" do


@@ -49,82 +61,149 @@ template "/etc/logrotate.d/apache2" do
   source "logrotate.apache.erb"
   owner "root"
   group "root"
   source "logrotate.apache.erb"
   owner "root"
   group "root"

-  mode 0644
+  mode "644"

 end
 
 directory "/srv/tile.openstreetmap.org" do
   owner "tile"
   group "tile"
 end
 
 directory "/srv/tile.openstreetmap.org" do
   owner "tile"
   group "tile"

-  mode 0755
+  mode "755"

 end
 
 package "renderd"
 
 end
 
 package "renderd"
 

-service "renderd" do
-  action [ :enable, :start ]
-  supports :status => false, :restart => true, :reload => false
+systemd_service "renderd" do
+  description "Mapnik rendering daemon"
+  after "postgresql.service"
+  wants "postgresql.service"
+  user "www-data"
+  exec_start "/usr/bin/renderd -f"
+  runtime_directory "renderd"
+  standard_error "null"
+  private_tmp true
+  private_devices true
+  private_network true
+  protect_system "full"
+  protect_home true
+  no_new_privileges true
+  restart "on-failure"

 end
 
 end
 

-directory node[:tile][:tile_directory] do
-  owner "tile"
-  group "www-data"
-  mode 0775
+service "renderd" do
+  action [:enable, :start]
+  subscribes :restart, "systemd_service[renderd]"

 end
 
 end
 

-if node[:tile][:tile_directory] != "/srv/tile.openstreetmap.org/tiles"
-  link "/srv/tile.openstreetmap.org/tiles" do
-    to node[:tile][:tile_directory]
-  end
+directory "/srv/tile.openstreetmap.org/tiles" do
+  owner "tile"
+  group "tile"
+  mode "755"

 end
 
 template "/etc/renderd.conf" do
   source "renderd.conf.erb"
   owner "root"
   group "root"
 end
 
 template "/etc/renderd.conf" do
   source "renderd.conf.erb"
   owner "root"
   group "root"

-  mode 0644
-  notifies :reload, resources(:service => "apache2")
-  notifies :restart, resources(:service => "renderd")
+  mode "644"
+  notifies :reload, "service[apache2]"
+  notifies :restart, "service[renderd]"

 end
 
 remote_directory "/srv/tile.openstreetmap.org/html" do
   source "html"
   owner "tile"
   group "tile"
 end
 
 remote_directory "/srv/tile.openstreetmap.org/html" do
   source "html"
   owner "tile"
   group "tile"

-  mode 0755
+  mode "755"

   files_owner "tile"
   files_group "tile"
   files_owner "tile"
   files_group "tile"

-  files_mode 0644
+  files_mode "644"
+end
+
+template "/srv/tile.openstreetmap.org/html/index.html" do
+  source "index.html.erb"
+  owner "tile"
+  group "tile"
+  mode "644"
+end
+
+package %w[
+  python3-cairo
+  python3-mapnik
+  python3-setuptools
+]
+
+python_package "pyotp" do
+  python_version "3"
+end
+
+package %w[
+  fonts-noto-cjk
+  fonts-noto-hinted
+  fonts-noto-unhinted
+  fonts-hanazono
+  ttf-unifont
+]
+
+["NotoSansArabicUI-Regular.ttf", "NotoSansArabicUI-Bold.ttf"].each do |font|
+  remote_file "/usr/share/fonts/truetype/noto/#{font}" do
+    action :create_if_missing
+    source "https://github.com/googlei18n/noto-fonts/raw/master/hinted/#{font}"
+    owner "root"
+    group "root"
+    mode "644"
+  end

 end
 
 directory "/srv/tile.openstreetmap.org/cgi-bin" do
   owner "tile"
   group "tile"
 end
 
 directory "/srv/tile.openstreetmap.org/cgi-bin" do
   owner "tile"
   group "tile"

-  mode 0755
+  mode "755"

 end
 
 template "/srv/tile.openstreetmap.org/cgi-bin/export" do
   source "export.erb"
   owner "tile"
   group "tile"
 end
 
 template "/srv/tile.openstreetmap.org/cgi-bin/export" do
   source "export.erb"
   owner "tile"
   group "tile"

-  mode 0755
-  variables :blocks => blocks
+  mode "755"
+  variables :blocks => blocks, :totp_key => web_passwords["totp_key"]
+end
+
+template "/srv/tile.openstreetmap.org/cgi-bin/debug" do
+  source "debug.erb"
+  owner "tile"
+  group "tile"
+  mode "755"
+end
+
+template "/etc/cron.hourly/export" do
+  source "export.cron.erb"
+  owner "root"
+  group "root"
+  mode "755"

 end
 
 directory "/srv/tile.openstreetmap.org/data" do
   owner "tile"
   group "tile"
 end
 
 directory "/srv/tile.openstreetmap.org/data" do
   owner "tile"
   group "tile"

-  mode 0755
+  mode "755"

 end
 
 end
 

-node[:tile][:data].each do |name,data|
+package "mapnik-utils"
+
+node[:tile][:data].each_value do |data|

   url = data[:url]
   file = "/srv/tile.openstreetmap.org/data/#{File.basename(url)}"
   url = data[:url]
   file = "/srv/tile.openstreetmap.org/data/#{File.basename(url)}"

-  directory = "/srv/tile.openstreetmap.org/data/#{data[:directory]}"

 
 

-  directory directory do
-    owner "tile"
-    group "tile"
-    mode 0755
+  if data[:directory]
+    directory = "/srv/tile.openstreetmap.org/data/#{data[:directory]}"
+
+    directory directory do
+      owner "tile"
+      group "tile"
+      mode "755"
+    end
+  else
+    directory = "/srv/tile.openstreetmap.org/data"

   end
 
   if file =~ /\.tgz$/
   end
 
   if file =~ /\.tgz$/


@@ -150,51 +229,113 @@ node[:tile][:data].each do |name,data|
 
     execute file do
       action :nothing
 
     execute file do
       action :nothing

-      command "unzip -qq #{file} -d #{directory}"
+      command "unzip -qq -o #{file} -d #{directory}"

       user "tile"
       group "tile"
     end
   end
 
       user "tile"
       group "tile"
     end
   end
 

-  if data[:processed]
-    original = "#{directory}/#{data[:original]}"
-    processed = "#{directory}/#{data[:processed]}"
-
-    package "gdal-bin"
-
-    execute processed do
-      action :nothing
-      command "ogr2ogr #{processed} #{original}"
-      user "tile"
-      group "tile"
-      subscribes :run, resources(:execute => file), :immediately
-    end
+  execute "#{file}_shapeindex" do
+    action :nothing
+    command "find #{directory} -type f -iname '*.shp' -print0 | xargs -0 --no-run-if-empty shapeindex --shape_files"
+    user "tile"
+    group "tile"
+    subscribes :run, "execute[#{file}]", :immediately

   end
 
   remote_file file do
   end
 
   remote_file file do

-    action :create_if_missing 
+    if data[:refresh]
+      action :create
+      use_conditional_get true
+      ignore_failure true
+    else
+      action :create_if_missing
+    end
+

     source url
     owner "tile"
     group "tile"
     source url
     owner "tile"
     group "tile"

-    mode 0644
-    notifies :run, resources(:execute => file), :immediately
-    notifies :restart, resources(:service => "renderd")
+    mode "644"
+    backup false
+    notifies :run, "execute[#{file}]", :immediately
+    notifies :restart, "service[renderd]"

   end
 end
 
 nodejs_package "carto"
   end
 end
 
 nodejs_package "carto"

-nodejs_package "millstone"
+
+systemd_service "update-lowzoom@" do
+  description "Low zoom tile update service for %i layer"
+  user "tile"
+  exec_start "/bin/bash /usr/local/bin/update-lowzoom-%i"
+  private_tmp true
+  private_devices true
+  private_network true
+  protect_system "full"
+  protect_home true
+  no_new_privileges true
+  restart "on-failure"
+end

 
 directory "/srv/tile.openstreetmap.org/styles" do
   owner "tile"
   group "tile"
 
 directory "/srv/tile.openstreetmap.org/styles" do
   owner "tile"
   group "tile"

-  mode 0755
+  mode "755"

 end
 
 end
 

-node[:tile][:styles].each do |name,details|
-  directory = "/srv/tile.openstreetmap.org/styles/#{name}"
+node[:tile][:styles].each do |name, details|
+  style_directory = "/srv/tile.openstreetmap.org/styles/#{name}"
+  tile_directory = "/srv/tile.openstreetmap.org/tiles/#{name}"
+
+  template "/usr/local/bin/update-lowzoom-#{name}" do
+    source "update-lowzoom.erb"
+    owner "root"
+    group "root"
+    mode "755"
+    variables :style => name
+  end

 
 

-  git directory do
+  service "update-lowzoom@#{name}" do
+    action :disable
+    supports :restart => true
+  end
+
+  directory tile_directory do
+    owner "tile"
+    group "tile"
+    mode "755"
+  end
+
+  details[:tile_directories].each do |directory|
+    directory directory[:name] do
+      owner "www-data"
+      group "www-data"
+      mode "755"
+    end
+
+    directory[:min_zoom].upto(directory[:max_zoom]) do |zoom|
+      directory "#{directory[:name]}/#{zoom}" do
+        owner "www-data"
+        group "www-data"
+        mode "755"
+      end
+
+      link "#{tile_directory}/#{zoom}" do
+        to "#{directory[:name]}/#{zoom}"
+        owner "tile"
+        group "tile"
+      end
+    end
+  end
+
+  file "#{tile_directory}/planet-import-complete" do
+    action :create_if_missing
+    owner "tile"
+    group "tile"
+    mode "444"
+  end
+
+  git style_directory do

     action :sync
     repository details[:repository]
     revision details[:revision]
     action :sync
     repository details[:repository]
     revision details[:revision]


@@ -202,26 +343,28 @@ node[:tile][:styles].each do |name,details|
     group "tile"
   end
 
     group "tile"
   end
 

-  link "#{directory}/data" do
+  link "#{style_directory}/data" do

     to "/srv/tile.openstreetmap.org/data"
     owner "tile"
     group "tile"
   end
 
     to "/srv/tile.openstreetmap.org/data"
     owner "tile"
     group "tile"
   end
 

-  execute "#{directory}/project.mml" do
-    command "carto project.mml > project.xml"
-    cwd directory
+  execute "#{style_directory}/project.mml" do
+    action :nothing
+    command "carto -a 3.0.0 project.mml > project.xml"
+    cwd style_directory

     user "tile"
     group "tile"
     user "tile"
     group "tile"

-    not_if do
-      File.exist?("#{directory}/project.xml") and
-      File.mtime("#{directory}/project.xml") >= File.mtime("#{directory}/project.mml")
-    end
-    notifies :restart, resources(:service => "renderd")
+    subscribes :run, "git[#{style_directory}]"
+    notifies :restart, "service[renderd]", :immediately
+    notifies :restart, "service[update-lowzoom@#{name}]"

   end
 end
 
   end
 end
 

-package "postgis"
+postgresql_version = node[:tile][:database][:cluster].split("/").first
+postgis_version = node[:tile][:database][:postgis]
+
+package "postgresql-#{postgresql_version}-postgis-#{postgis_version}"

 
 postgresql_user "jburgess" do
   cluster node[:tile][:database][:cluster]
 
 postgresql_user "jburgess" do
   cluster node[:tile][:database][:cluster]


@@ -251,13 +394,13 @@ postgresql_extension "postgis" do
   database "gis"
 end
 
   database "gis"
 end
 

-[ "geography_columns",
-  "planet_osm_nodes",
-  "planet_osm_rels",
-  "planet_osm_ways",
-  "raster_columns", 
-  "raster_overviews", 
-  "spatial_ref_sys" ].each do |table|
+postgresql_extension "hstore" do
+  cluster node[:tile][:database][:cluster]
+  database "gis"
+  only_if { node[:tile][:database][:hstore] }
+end
+
+%w[geography_columns planet_osm_nodes planet_osm_rels planet_osm_ways raster_columns raster_overviews spatial_ref_sys].each do |table|

   postgresql_table table do
     cluster node[:tile][:database][:cluster]
     database "gis"
   postgresql_table table do
     cluster node[:tile][:database][:cluster]
     database "gis"


@@ -266,11 +409,7 @@ end
   end
 end
 
   end
 end
 

-[ "geometry_columns", 
-  "planet_osm_line", 
-  "planet_osm_point", 
-  "planet_osm_polygon", 
-  "planet_osm_roads" ].each do |table|
+%w[geometry_columns planet_osm_line planet_osm_point planet_osm_polygon planet_osm_roads].each do |table|

   postgresql_table table do
     cluster node[:tile][:database][:cluster]
     database "gis"
   postgresql_table table do
     cluster node[:tile][:database][:cluster]
     database "gis"


@@ -284,102 +423,190 @@ postgresql_munin "gis" do
   database "gis"
 end
 
   database "gis"
 end
 

-#if node[:tile][:node_file]
-#  file node[:tile][:node_file] do
-#    owner "tile"
-#    group "tile"
-#    mode 0664
-#  end
-#end
-
-package "osm2pgsql"
-package "osmosis"
+directory File.dirname(node[:tile][:database][:node_file]) do
+  owner "root"
+  group "root"
+  mode "755"
+  recursive true
+end

 
 

-package "ruby"
-package "rubygems"
+file node[:tile][:database][:node_file] do
+  owner "tile"
+  group "www-data"
+  mode "660"
+end

 
 

-package "libproj-dev"
-package "libxml2-dev"
-package "libpq-dev"
+directory "/var/log/tile" do
+  owner "tile"
+  group "tile"
+  mode "755"
+end

 
 

-gem_package "proj4rb"
-gem_package "libxml-ruby"
-gem_package "pg"
+package %w[
+  osm2pgsql
+  ruby
+  osmium-tool
+  pyosmium
+  python3-pyproj
+]

 
 

-remote_directory "/usr/local/lib/site_ruby" do
-  source "ruby"
+remote_directory "/usr/local/bin" do
+  source "bin"

   owner "root"
   group "root"
   owner "root"
   group "root"

-  mode 0755
+  mode "755"

   files_owner "root"
   files_group "root"
   files_owner "root"
   files_group "root"

-  files_mode 0644
+  files_mode "755"

 end
 
 template "/usr/local/bin/expire-tiles" do
   source "expire-tiles.erb"
   owner "root"
   group "root"
 end
 
 template "/usr/local/bin/expire-tiles" do
   source "expire-tiles.erb"
   owner "root"
   group "root"

-  mode 0755
+  mode "755"

 end
 
 directory "/var/lib/replicate" do
   owner "tile"
   group "tile"
 end
 
 directory "/var/lib/replicate" do
   owner "tile"
   group "tile"

-  mode 0755
+  mode "755"

 end
 
 end
 

-directory "/var/log/replicate" do
+directory "/var/lib/replicate/expire-queue" do

   owner "tile"
   owner "tile"

-  group "tile"
-  mode 0755
-end
-
-template "/var/lib/replicate/configuration.txt" do
-  source "replicate.configuration.erb"
-  owner "tile"
-  group "tile"
-  mode 0644
+  group "www-data"
+  mode "775"

 end
 
 template "/usr/local/bin/replicate" do
   source "replicate.erb"
   owner "root"
   group "root"
 end
 
 template "/usr/local/bin/replicate" do
   source "replicate.erb"
   owner "root"
   group "root"

-  mode 0755
+  mode "755"
+  variables :postgresql_version => postgresql_version.to_f

 end
 
 end
 

-template "/etc/init.d/replicate" do
-  source "replicate.init.erb"
-  owner "root"
-  group "root"
-  mode 0755
+systemd_service "expire-tiles" do
+  description "Tile dirtying service"
+  type "simple"
+  user "www-data"
+  exec_start "/usr/local/bin/expire-tiles"
+  standard_output "null"
+  private_tmp true
+  private_devices true
+  protect_system "full"
+  protect_home true
+  no_new_privileges true
+end
+
+systemd_path "expire-tiles" do
+  description "Tile dirtying trigger"
+  directory_not_empty "/var/lib/replicate/expire-queue"
+end
+
+service "expire-tiles.path" do
+  action [:enable, :start]
+  subscribes :restart, "systemd_path[expire-tiles]"
+end
+
+systemd_service "replicate" do
+  description "Rendering database replication service"
+  after "postgresql.service"
+  wants "postgresql.service"
+  user "tile"
+  exec_start "/usr/local/bin/replicate"
+  private_tmp true
+  private_devices true
+  protect_system "full"
+  protect_home true
+  no_new_privileges true
+  restart "on-failure"

 end
 
 service "replicate" do
 end
 
 service "replicate" do

-  action [ :enable, :start ]
-  supports :restart => true
-  subscribes :restart, resources(:template => "/usr/local/bin/replicate")
-  subscribes :restart, resources(:template => "/etc/init.d/replicate")
+  action [:enable, :start]
+  subscribes :restart, "template[/usr/local/bin/replicate]"
+  subscribes :restart, "systemd_service[replicate]"

 end
 
 template "/etc/logrotate.d/replicate" do
   source "replicate.logrotate.erb"
   owner "root"
   group "root"
 end
 
 template "/etc/logrotate.d/replicate" do
   source "replicate.logrotate.erb"
   owner "root"
   group "root"

-  mode 0644
+  mode "644"
+end
+
+template "/usr/local/bin/render-lowzoom" do
+  source "render-lowzoom.erb"
+  owner "root"
+  group "root"
+  mode "755"
+end
+
+systemd_service "render-lowzoom" do
+  description "Render low zoom tiles"
+  user "tile"
+  exec_start "/usr/local/bin/render-lowzoom"
+  private_tmp true
+  private_devices true
+  private_network true
+  protect_system "full"
+  protect_home true
+  no_new_privileges true
+end
+
+systemd_timer "render-lowzoom" do
+  description "Render low zoom tiles"
+  on_calendar "Sun *-*~07/1 01:00:00"
+end
+
+service "render-lowzoom.timer" do
+  action [:enable, :start]
+end
+
+package "liblockfile-simple-perl"
+package "libfilesys-df-perl"
+
+template "/usr/local/bin/cleanup-tiles" do
+  source "cleanup-tiles.erb"
+  owner "root"
+  group "root"
+  mode "755"
+end
+
+tile_directories = node[:tile][:styles].collect do |_, style|
+  style[:tile_directories].collect { |directory| directory[:name] }
+end.flatten.sort.uniq
+
+tile_directories.each do |directory|
+  label = directory.gsub("/", "-")
+
+  cron_d "cleanup-tiles#{label}" do
+    minute "0"
+    user "www-data"
+    command "ionice -c 3 /usr/local/bin/cleanup-tiles #{directory}"
+    mailto "admins@openstreetmap.org"
+  end

 end
 
 munin_plugin "mod_tile_fresh"
 end
 
 munin_plugin "mod_tile_fresh"

+munin_plugin "mod_tile_latency"

 munin_plugin "mod_tile_response"
 munin_plugin "mod_tile_zoom"
 
 munin_plugin "renderd_processed"
 munin_plugin "renderd_queue"
 munin_plugin "mod_tile_response"
 munin_plugin "mod_tile_zoom"
 
 munin_plugin "renderd_processed"
 munin_plugin "renderd_queue"

+munin_plugin "renderd_queue_time"

 munin_plugin "renderd_zoom"
 munin_plugin "renderd_zoom_time"
 
 munin_plugin "renderd_zoom"
 munin_plugin "renderd_zoom_time"
 

-munin_plugin "replication_delay" do
-  conf "munin.erb"
+munin_plugin "replication_delay"
+
+prometheus_collector "modtile" do
+  interval "1m"

 end
 
 end
 

+prometheus_collector "renderd" do
+  interval "1m"
+end