donate: add db inc

diff --git a/cookbooks/donate/recipes/default.rb b/cookbooks/donate/recipes/default.rb
index e1f64904b2c8ae2bacb6a7672761b31cd20c82ea..bf1d46419f236d13f0b9a1136036eb65c2b14950 100644 (file)
--- a/cookbooks/donate/recipes/default.rb
+++ b/cookbooks/donate/recipes/default.rb
@@ -26,6 +26,7 @@ include_recipe "git"
 if node[:lsb][:release].to_f >= 16.04
   package "php"
   package "php-cli"
+  package "php-curl"
   package "php-mysql"
   package "php-gd"
 
@@ -33,6 +34,7 @@ if node[:lsb][:release].to_f >= 16.04
 else
   package "php5"
   package "php5-cli"
+  package "php5-curl"
   package "php5-mysql"
   package "php5-gd"
 
@@ -72,6 +74,13 @@ directory "/srv/donate.openstreetmap.org/data" do
   mode 0o755
 end
 
+template "/srv/donate.openstreetmap.org/scripts/db-connect.inc.php" do
+  source "db-connect.inc.php.erb"
+  owner "root"
+  group "donate"
+  mode 0o640
+end
+
 apache_site "donate.openstreetmap.org" do
   template "apache.erb"
 end
@@ -81,7 +90,7 @@ template "/etc/cron.d/osmf-donate" do
   owner "root"
   group "root"
   mode 0o600
-  variables :passwords => passwords
+  variables :database_password => database_password
 end
 
 template "/etc/cron.daily/osmf-donate-backup" do
@@ -89,5 +98,5 @@ template "/etc/cron.daily/osmf-donate-backup" do
   owner "root"
   group "root"
   mode 0o750
-  variables :passwords => passwords
+  variables :database_password => database_password
 end

diff --git a/cookbooks/donate/templates/default/db-connect.inc.php.erb b/cookbooks/donate/templates/default/db-connect.inc.php.erb
new file mode 100644 (file)
index 0000000..b2d2a6f
--- /dev/null
+++ b/cookbooks/donate/templates/default/db-connect.inc.php.erb
@@ -0,0 +1,4 @@
+<?php
+$_DB_H = mysql_connect('localhost','donate','<%= @database_password %>');
+mysql_select_db('donate', $_DB_H);
+mysql_query('SET NAMES \'utf8\'', $_DB_H);