Reduce WAL expiry to 14 days

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

diff --git a/cookbooks/dev/recipes/default.rb b/cookbooks/dev/recipes/default.rb
index 13a6f96326834c9f6438a2a87f9cd1e62598e8ad..80b80586b419a0c31be19ac6f1a662e8952c98d5 100644 (file)
--- a/cookbooks/dev/recipes/default.rb
+++ b/cookbooks/dev/recipes/default.rb
@@ -24,22 +24,25 @@ include_recipe "apache"
 include_recipe "passenger"
 include_recipe "git"
 include_recipe "mysql"
 include_recipe "passenger"
 include_recipe "git"
 include_recipe "mysql"

+include_recipe "nodejs"

 include_recipe "postgresql"
 include_recipe "postgresql"

+include_recipe "python"

 
 

-package "php-apc"
+package "php"
+package "php-cgi"
+package "php-cli"
+package "php-curl"

 package "php-db"
 package "php-db"

-package "php-cgiwrap"
+package "php-fpm"
+package "php-imagick"
+package "php-mcrypt"
+package "php-mysql"

 package "php-pear"
 package "php-pear"

+package "php-pgsql"
+package "php-sqlite3"

 
 

-package "php5-cgi"
-package "php5-cli"
-package "php5-curl"
-package "php5-fpm"
-package "php5-imagick"
-package "php5-mcrypt"
-package "php5-mysql"
-package "php5-pgsql"
-package "php5-sqlite"
+package "pngcrush"
+package "pngquant"

 
 package "python"
 package "python-argparse"
 
 package "python"
 package "python-argparse"


@@ -48,39 +51,45 @@ package "python-cheetah"
 package "python-dateutil"
 package "python-magic"
 package "python-psycopg2"
 package "python-dateutil"
 package "python-magic"
 package "python-psycopg2"

+package "python-gdal"

 
 

-easy_install_package "geojson"
+nodejs_package "svgo"
+
+python_package "geojson"

 
 apache_module "env"
 apache_module "expires"
 
 apache_module "env"
 apache_module "expires"

+apache_module "headers"

 apache_module "proxy"
 apache_module "proxy_fcgi"
 apache_module "rewrite"
 apache_module "proxy"
 apache_module "proxy_fcgi"
 apache_module "rewrite"

+apache_module "suexec"
+apache_module "userdir"

 apache_module "wsgi"
 
 apache_module "wsgi"
 

+package "apache2-suexec-pristine"
+

 gem_package "sqlite3"
 
 gem_package "rails" do
   version "3.0.9"
 end
 
 gem_package "sqlite3"
 
 gem_package "rails" do
   version "3.0.9"
 end
 

-service "php5-fpm" do
-  provider Chef::Provider::Service::Upstart
-  action [ :enable, :start ]
-  supports :status => true, :restart => true, :reload => true
+service "php7.0-fpm" do
+  action [:enable, :start]

 end
 
 end
 

-template "/etc/php5/fpm/pool.d/default.conf" do
+template "/etc/php/7.0/fpm/pool.d/default.conf" do

   source "fpm-default.conf.erb"
   owner "root"
   group "root"
   source "fpm-default.conf.erb"
   owner "root"
   group "root"

-  mode 0644
-  notifies :reload, "service[php5-fpm]"
+  mode 0o644
+  notifies :reload, "service[php7.0-fpm]"

 end
 
 end
 

-file "/etc/php5/fpm/pool.d/www.conf" do
+file "/etc/php/7.0/fpm/pool.d/www.conf" do

   action :delete
   action :delete

-  notifies :reload, "service[php5-fpm]"
+  notifies :reload, "service[php7.0-fpm]"

 end
 
 package "phppgadmin"
 end
 
 package "phppgadmin"


@@ -89,7 +98,7 @@ template "/etc/phppgadmin/config.inc.php" do
   source "phppgadmin.conf.erb"
   owner "root"
   group "root"
   source "phppgadmin.conf.erb"
   owner "root"
   group "root"

-  mode 0644
+  mode 0o644

 end
 
 file "/etc/apache2/conf.d/phppgadmin" do
 end
 
 file "/etc/apache2/conf.d/phppgadmin" do


@@ -103,93 +112,108 @@ end
 search(:accounts, "*:*").each do |account|
   name = account["id"]
   details = node[:accounts][:users][name] || {}
 search(:accounts, "*:*").each do |account|
   name = account["id"]
   details = node[:accounts][:users][name] || {}

+
+  next unless %w[user administrator].include?(details[:status])
+
+  user_home = details[:home] || account["home"] || "#{node[:accounts][:home]}/#{name}"
+
+  next unless File.directory?("#{user_home}/public_html")
+

   port = 7000 + account["uid"].to_i
 
   port = 7000 + account["uid"].to_i
 

-  if ["user","administrator"].include?(details[:status])
-    user_home = details[:home] || account["home"] || "#{node[:accounts][:home]}/#{name.to_s}"
-
-    if File.directory?("#{user_home}/public_html")
-      template "/etc/php5/fpm/pool.d/#{name}.conf" do
-        source "fpm.conf.erb"
-        owner "root"
-        group "root"
-        mode 0644
-        variables :user => name, :port => port
-        notifies :reload, "service[php5-fpm]"
-      end
+  template "/etc/php/7.0/fpm/pool.d/#{name}.conf" do
+    source "fpm.conf.erb"
+    owner "root"
+    group "root"
+    mode 0o644
+    variables :user => name, :port => port
+    notifies :reload, "service[php7.0-fpm]"
+  end

 
 

-      apache_site "#{name}.dev.openstreetmap.org" do
-        template "apache.user.erb"
-        directory "#{user_home}/public_html"
-        variables :user => name, :port => port
-      end
-    end
+  apache_site "#{name}.dev.openstreetmap.org" do
+    template "apache.user.erb"
+    directory "#{user_home}/public_html"
+    variables :user => name, :port => port
+  end
+
+  template "/etc/sudoers.d/#{name}" do
+    source "sudoers.user.erb"
+    owner "root"
+    group "root"
+    mode 0o440
+    variables :user => name

   end
 end
 
   end
 end
 

-if node[:postgresql][:clusters][:"9.1/main"]
+if node[:postgresql][:clusters][:"9.5/main"]

   postgresql_user "apis" do
   postgresql_user "apis" do

-    cluster "9.3/main"
+    cluster "9.5/main"

   end
 
   end
 

-  node[:dev][:rails].each do |name,details|
+  template "/usr/local/bin/cleanup-rails-assets" do
+    cookbook "web"
+    source "cleanup-assets.erb"
+    owner "root"
+    group "root"
+    mode 0o755
+  end
+
+  node[:dev][:rails].each do |name, details|

     database_name = details[:database] || "apis_#{name}"
     site_name = "#{name}.apis.dev.openstreetmap.org"
     database_name = details[:database] || "apis_#{name}"
     site_name = "#{name}.apis.dev.openstreetmap.org"

-    site_aliases = details[:aliases] || []

     rails_directory = "/srv/#{name}.apis.dev.openstreetmap.org"
     rails_directory = "/srv/#{name}.apis.dev.openstreetmap.org"

-    secret_key_base = details[:secret_key_base] || SecureRandom.base64(96)

 
 

-    node.set[:dev][:rails][name][:secret_key_base] = secret_key_base
+    if details[:repository]
+      site_aliases = details[:aliases] || []
+      secret_key_base = details[:secret_key_base] || SecureRandom.base64(96)

 
 

-    postgresql_database database_name do
-      cluster "9.3/main"
-      owner "apis"
-    end
+      node.normal[:dev][:rails][name][:secret_key_base] = secret_key_base

 
 

-    postgresql_extension "#{database_name}_btree_gist" do
-      cluster "9.3/main"
-      database database_name
-      extension "btree_gist"
-    end
-
-    rails_port site_name do
-      ruby node[:passenger][:ruby_version]
-      directory rails_directory
-      user "apis"
-      group "apis"
-      repository details[:repository]
-      revision details[:revision]
-      database_port node[:postgresql][:clusters][:"9.3/main"][:port]
-      database_name database_name
-      database_username "apis"
-      run_migrations true
-    end
+      postgresql_database database_name do
+        cluster "9.5/main"
+        owner "apis"
+      end

 
 

-    template "#{rails_directory}/config/initializers/setup.rb" do
-      source "rails.setup.rb.erb"
-      owner "apis"
-      group "apis"
-      mode 0644
-      variables :site => site_name
-      notifies :touch, "file[#{rails_directory}/tmp/restart.txt]"
-    end
+      postgresql_extension "#{database_name}_btree_gist" do
+        cluster "9.5/main"
+        database database_name
+        extension "btree_gist"
+      end

 
 

-    apache_site site_name do
-      template "apache.rails.erb"
-      variables :name => site_name, :aliases => site_aliases, :secret_key_base => secret_key_base
-    end
-  end
+      rails_port site_name do
+        ruby node[:passenger][:ruby_version]
+        directory rails_directory
+        user "apis"
+        group "apis"
+        repository details[:repository]
+        revision details[:revision]
+        database_port node[:postgresql][:clusters][:"9.5/main"][:port]
+        database_name database_name
+        database_username "apis"
+        run_migrations true
+      end

 
 

-  Dir.glob("/srv/*.apis.dev.openstreetmap.org").each do |rails_directory|
-    name = File.basename(rails_directory, ".apis.dev.openstreetmap.org")
+      template "#{rails_directory}/config/initializers/setup.rb" do
+        source "rails.setup.rb.erb"
+        owner "apis"
+        group "apis"
+        mode 0o644
+        variables :site => site_name
+        notifies :run, "execute[#{rails_directory}]"
+      end

 
 

-    unless node[:dev][:rails].include?(name) and node[:dev][:rails][name].include?(:repository)
-      database_config = YAML.load_file("#{rails_directory}/config/database.yml")
-      database_name = database_config["production"]["database"]
-      site_name = "#{name}.apis.dev.openstreetmap.org"
+      ssl_certificate site_name do
+        domains [site_name] + site_aliases
+        notifies :reload, "service[apache2]"
+      end

 
       apache_site site_name do
 
       apache_site site_name do

-        action [ :delete ]
+        template "apache.rails.erb"
+        variables :name => site_name, :aliases => site_aliases, :secret_key_base => secret_key_base
+      end
+    else
+      apache_site site_name do
+        action [:delete]

       end
 
       directory rails_directory do
       end
 
       directory rails_directory do


@@ -197,37 +221,42 @@ if node[:postgresql][:clusters][:"9.1/main"]
         recursive true
       end
 
         recursive true
       end
 

-      file "/etc/cron.daily/rails-#{name}" do
+      file "/etc/cron.daily/rails-#{site_name.tr('.', '-')}" do

         action :delete
       end
 
       postgresql_database database_name do
         action :drop
         action :delete
       end
 
       postgresql_database database_name do
         action :drop

-        cluster "9.3/main"
+        cluster "9.5/main"

       end
 
       end
 

-      node[:dev][:rails][name].delete(:secret_key_base)
+      node.normal[:dev][:rails].delete(name)

     end
   end
 
   directory "/srv/apis.dev.openstreetmap.org" do
     owner "apis"
     group "apis"
     end
   end
 
   directory "/srv/apis.dev.openstreetmap.org" do
     owner "apis"
     group "apis"

-    mode 0755
+    mode 0o755

   end
 
   template "/srv/apis.dev.openstreetmap.org/index.html" do
     source "apis.html.erb"
     owner "apis"
     group "apis"
   end
 
   template "/srv/apis.dev.openstreetmap.org/index.html" do
     source "apis.html.erb"
     owner "apis"
     group "apis"

-    mode 0644
+    mode 0o644
+  end
+
+  ssl_certificate "apis.dev.openstreetmap.org" do
+    domains "apis.dev.openstreetmap.org"
+    notifies :reload, "service[apache2]"

   end
 
   apache_site "apis.dev.openstreetmap.org" do
     template "apache.apis.erb"
   end
 
   end
 
   apache_site "apis.dev.openstreetmap.org" do
     template "apache.apis.erb"
   end
 

-  node[:postgresql][:clusters].each do |name,details|
+  node[:postgresql][:clusters].each_key do |name|

     postgresql_munin name do
       cluster name
       database "ALL"
     postgresql_munin name do
       cluster name
       database "ALL"