X-Git-Url: https://git.openstreetmap.org/chef.git/blobdiff_plain/ae7c3c728ad4b1a4a1c71715a43e1f0d44a5289b..d4db2d890308157f77aa84154ef18fffeb8c61f0:/cookbooks/db/recipes/base.rb diff --git a/cookbooks/db/recipes/base.rb b/cookbooks/db/recipes/base.rb index f92a6ea0b..6efbde328 100644 --- a/cookbooks/db/recipes/base.rb +++ b/cookbooks/db/recipes/base.rb @@ -21,15 +21,11 @@ include_recipe "accounts" include_recipe "git" include_recipe "postgresql" include_recipe "python" +include_recipe "ruby" passwords = data_bag_item("db", "passwords") wal_secrets = data_bag_item("db", "wal-secrets") -ruby_version = node[:passenger][:ruby_version] -db_version = node[:db][:cluster].split("/").first -pg_config = "/usr/lib/postgresql/#{db_version}/bin/pg_config" -function_directory = "/srv/www.openstreetmap.org/rails/db/functions/#{db_version}" - postgresql_munin "openstreetmap" do cluster node[:db][:cluster] database "openstreetmap" @@ -37,59 +33,91 @@ end directory "/srv/www.openstreetmap.org" do group "rails" - mode 0o2775 + mode "2775" end rails_port "www.openstreetmap.org" do - ruby ruby_version directory "/srv/www.openstreetmap.org/rails" user "rails" group "rails" repository "https://git.openstreetmap.org/public/rails.git" revision "live" + build_assets false database_host "localhost" database_name "openstreetmap" database_username "openstreetmap" database_password passwords["openstreetmap"] - gpx_dir "/store/rails/gpx" -end - -directory function_directory do - owner "rails" - group "rails" - mode 0o755 end -execute function_directory do - action :nothing - command "make BUNDLE=bundle#{ruby_version} PG_CONFIG=#{pg_config} DESTDIR=#{function_directory}" - cwd "/srv/www.openstreetmap.org/rails/db/functions" - user "rails" - group "rails" - subscribes :run, "directory[#{function_directory}]" - subscribes :run, "git[/srv/www.openstreetmap.org/rails]" -end +package %w[ + cmake + libosmium2-dev + libprotozero-dev + libboost-filesystem-dev + libboost-program-options-dev + libbz2-dev + zlib1g-dev + libexpat1-dev + libyaml-cpp-dev + libpqxx-dev +] -link "/usr/lib/postgresql/#{db_version}/lib/libpgosm.so" do - to "#{function_directory}/libpgosm.so" - owner "root" +git "/opt/osmdbt" do + action :sync + repository "https://github.com/openstreetmap/osmdbt.git" + revision "v0.5" + depth 1 + user "root" group "root" end -package "lzop" +node[:postgresql][:versions].each do |db_version| + directory "/opt/osmdbt/build-#{db_version}" do + owner "root" + group "root" + mode "755" + end + + execute "/opt/osmdbt/build-#{db_version}" do + action :nothing + command "cmake -DPG_CONFIG=/usr/lib/postgresql/#{db_version}/bin/pg_config .." + cwd "/opt/osmdbt/build-#{db_version}" + user "root" + group "root" + subscribes :run, "directory[/opt/osmdbt/build-#{db_version}]" + subscribes :run, "git[/opt/osmdbt]" + end -python_package "wal-e" do - python_version "3" + execute "/opt/osmdbt/build-#{db_version}/postgresql-plugin/Makefile" do + action :nothing + command "make" + cwd "/opt/osmdbt/build-#{db_version}/postgresql-plugin" + user "root" + group "root" + subscribes :run, "execute[/opt/osmdbt/build-#{db_version}]" + end + + link "/usr/lib/postgresql/#{db_version}/lib/osm-logical.so" do + to "/opt/osmdbt/build-#{db_version}/postgresql-plugin/osm-logical.so" + owner "root" + group "root" + end end -python_package "boto" do - python_version "3" +package "lzop" + +remote_file "/usr/local/bin/wal-g" do + action :create + source "https://github.com/wal-g/wal-g/releases/download/v2.0.1/wal-g-pg-ubuntu-20.04-amd64" + owner "root" + group "root" + mode "755" end -template "/usr/local/bin/openstreetmap-wal-e" do - source "wal-e.erb" +template "/usr/local/bin/openstreetmap-wal-g" do + source "wal-g.erb" owner "root" group "postgres" - mode 0o750 + mode "750" variables :s3_key => wal_secrets["s3_key"] end