herokuでWordpressを無料で公開する

参考サイト

大変勉強になりました。ありがとうございます。
https://blog.mah-lab.com/2013/05/01/wordpress-on-heroku/

前提条件

クレジットカードをherokuに登録しておかないとmysqlのアドオンが使えません
登録しても無料範囲内なら課金されないので、登録しましょう。

herokuコマンドインストール

brew install heroku
heroku autocomplete --refresh-cache

arecore-officialを作る想定

アプリの作成(PHPのビルドパック）

heroku create arecore-official -s cedar -b heroku/php

mysqlのアドオン

heroku addons:add cleardb:ignite -a arecore-official

アプリにmysqlのURLを設定する

これでURLを調べる

heroku config -a arecore-official | grep CLEARDB_DATABASE_URL

heroku config:add DATABASE_URL='mysql://useraaaa:[e-mail]/heroku_dbnamedddd?reconnect=true' -a arecore-official

いったん確認

heroku open -a arecore-official

リポジトリの設定

アプリ名と同じ名前でリポジトリを作成

ghq get https://github.com/noracorn/arecore-official.git

Wordpressをダウンロードして、中身をコミット

git add .
git push origin master

herokuのリモートリポジトリを入れる

heroku git:remote -a arecore-official

確認

git remote -v

wordpressの設定

cp wp-config-sample.php wp-config.php
heroku config -a arecore-official | grep CLEARDB_DATABASE_URL

この内容をかみくだいて入れる

DATABASE_URL='mysql://useraaaa:[e-mail]/heroku_dbnamedddd?reconnect=true' -a arecore-official

wp-config.phpに

AUTH_KEYなどの設定は以下を入れる
ここにアクセスして生成する

https://api.wordpress.org/secret-key/1.1/salt/

git add .
git commit

htaccessでパーマリンクの設定

.htaccess

<IfModule mod_rewrite.c>
RewriteEngine On
RewriteBase /
RewriteRule ^index\.php$ - [L]
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule . /index.php [L]
</IfModule>

mkdir conf
vi nginx.conf.erb

# setting worker_processes to CPU core count
worker_processes      1;
daemon off;
 
events {
  worker_connections  1024;
}
 
http {
  include             mime.types;
  default_type        application/octet-stream;
  sendfile            on;
  server_tokens       off;
  keepalive_timeout   65;
  access_log          off;
  error_log           logs/error.log;
  proxy_max_temp_file_size  0;
  #fastcgi_max_temp_file_size  0;
  limit_conn_zone $binary_remote_addr zone=phplimit:1m; # define a limit bucket for PHP-FPM
  # don't use server listen port in redirects.
  port_in_redirect off;
 
  # set $https only when SSL is actually used.
  map $http_x_forwarded_proto $my_https {
    default off;
    https on;
  }
 
  upstream php_fpm {
    server unix:/tmp/php-fpm.socket;
  }
 
  root              /app/;
  index             index.php index.html index.htm;
 
  server {
    listen            <%= ENV['PORT'] %>;
    server_name       _;
 
    # Some basic cache-control for static files to be sent to the browser
    location ~* \.(?:ico|css|js|gif|jpeg|jpg|png)$ {
      expires         max;
      add_header      Pragma public;
      add_header      Cache-Control "public, must-revalidate, proxy-revalidate";
    }
 
    # Deny hidden files (.htaccess, .htpasswd, .DS_Store).
    location ~ /\. {
      deny            all;
      access_log      off;
      log_not_found   off;
    }
 
    # Deny /favicon.ico
    location = /favicon.ico {
      access_log      off;
      log_not_found   off;
    }
 
    # Deny /robots.txt
    location = /robots.txt {
      allow           all;
      log_not_found   off;
      access_log      off;
    }
 
    # Status. /status.html uses /status
    location ~ ^/(status|ping)$ {
      include         fastcgi_params;
      fastcgi_param   HTTPS $my_https if_not_empty;
      fastcgi_pass    php_fpm;
      fastcgi_param   SCRIPT_FILENAME $document_root$fastcgi_script_name;
    }
 
    location /server-status {
      stub_status on;
      access_log   off;
    }
 
    location / {
      # wordpress fancy rewrites
      if (-f $request_filename) {
        break;
      }
      if (-d $request_filename) {
        break;
      }
 
      rewrite         ^(.+)$ /index.php?q=$1 last;
 
      # Add trailing slash to */wp-admin requests.
      rewrite         /wp-admin$ $scheme://$host$uri/ permanent;
 
    #  # redirect to feedburner.
    #  # if ($http_user_agent !~ FeedBurner) {
    #  #   rewrite ^/feed/?$ http://feeds.feedburner.com/feedburner-feed-id last;
    #  # }
    }
 
    include /app/conf/nginx.d/*.conf;
 
    location ~ .*\.php$ {
      try_files $uri =404;
      limit_conn phplimit 5; # limit to 5 concurrent users to PHP per IP.
      include         fastcgi_params;
      fastcgi_param   HTTPS $my_https if_not_empty;
      fastcgi_pass    php_fpm;
      fastcgi_param   SCRIPT_FILENAME $document_root$fastcgi_script_name;
    }
  }
}

herokuで公開

git push heroku master
heroku open -a arecore-official