WordPress環境構築におけるMySQLの設定とChef上達のポイント：サーバー管理者のためのChef超入門（終）（1/3 ページ）

package ['httpd', 'httpd-devel', 'mysql', 'mysql-server', 'mysql-devel', 'php', 'php-mysql']  do
  action :install
end
 
filename = "#{node['wordpress']['wp_tar_name']}"
install_dir = "#{node['wordpress']['wp_dir']}"
remote_uri = "#{node['wordpress']['wp_tar_uri']}"
file_checksum = "#{node['wordpress']['wp_tar_sum']}"
httpd_conf_dir = "#{node['wordpress']['httpd_conf_dir']}"
mysql_pw = "#{node['wordpress']['mysql_pw']}"
 
#インストールディレクトリ作成
directory "#{install_dir}" do
  recursive true
  mode 0755
  owner "apache"
  group "apache"
  action :create
end
 
#WordPressダウンロード
remote_file "/tmp/#{filename}" do
  source "#{remote_uri}"
  checksum "#{file_checksum}"
end
 
#WordPress配置
script "install_wordpress" do
  interpreter "bash"
  user        "root"
  code <<-EOL
    install -d #{install_dir}
    tar zxvf /tmp/#{filename} -C #{install_dir}
  EOL
end
 
#httpd.conf配置
template "httpdconf" do
  path "#{httpd_conf_dir}httpd.conf"
  source "httpdconf.erb"
  mode 0644
end
 
#wordpressディレクトリpermission変更
directory "#{install_dir}/wordpress" do
  recursive true
  mode 0755
  owner "apache"
  group "apache"
end
 
service "httpd" do
  action :start
end
 
service "mysqld" do
  action :start
end
 
template "sql-for-wordpress" do
  path "/tmp/wordpress.sql"
  source "wordpress.sql.erb"
  mode 0644
end
 
execute "mysql-create-user" do
    command "mysql -u root -p#{mysql_pw} < /tmp/wordpress.sql"
    action :run
end

default['wordpress']['wp_tar_name'] = 'wordpress-4.2.2-ja.tar.gz'
default['wordpress']['wp_dir'] = '/var/www/ec2.tokyo'
default['wordpress']['wp_tar_uri'] = 'https://ja.wordpress.org/wordpress-4.2.2-ja.tar.gz'
default['wordpress']['wp_tar_sum'] = '7e34ba580aed16c4fd769f033b0e7fa79b7c5813ba52e4496f14da0ac4451373'
default['wordpress']['httpd_conf_dir'] = '/etc/httpd/conf/'
default['wordpress']['vhost_domain'] = 'ec2.tokyo'
default['wordpress']['mysql_pw'] = '[MySQLのrootパスワード]'

CREATE DATABASE wordpress;
GRANT ALL PRIVILEGES ON *.* TO wordpress@"%" IDENTIFIED BY 'wordpress' WITH GRANT OPTION;
FLUSH PRIVILEGES;