{"id":1056,"date":"2014-08-24T17:55:13","date_gmt":"2014-08-24T08:55:13","guid":{"rendered":"http:\/\/lovelinux.mydns.jp\/?p=1056"},"modified":"2014-08-26T12:36:46","modified_gmt":"2014-08-26T03:36:46","slug":"centos7-redmine%e3%82%92%e3%82%a4%e3%83%b3%e3%82%b9%e3%83%88%e3%83%bc%e3%83%ab%e3%81%97%e3%80%81nginx%e3%81%ae%e3%82%b5%e3%83%96%e3%83%95%e3%82%a9%e3%83%ab%e3%83%80%e3%81%a7%e5%85%ac%e9%96%8b%e3%81%99","status":"publish","type":"post","link":"https:\/\/lovelinux.mydns.jp\/?p=1056","title":{"rendered":"CentOS7\u306bRedmine\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3001nginx\u306e\u30b5\u30d6\u30d5\u30a9\u30eb\u30c0\u3067\u516c\u958b\u3059\u308b\u3002"},"content":{"rendered":"

CentOS7\u306bRedmine\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3001nginx\u306e\u30b5\u30d6\u30d5\u30a9\u30eb\u30c0\u3067\u516c\u958b\u3059\u308b\u65b9\u6cd5\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002
\nnginx\u3068\u306e\u9023\u643a\u306fpassenger\u3092\u7528\u3044\u307e\u3059\u3002nginx\u306f\u8aac\u660e\u306e\u9014\u4e2d\u3067passenger\u9023\u643a\u306e\u305f\u3081\u306b
\n\u30b3\u30f3\u30d1\u30a4\u30eb\u3057\u307e\u3059\u306e\u3067\u3001nginx\u81ea\u4f53\u304c\u4e8b\u524d\u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3055\u308c\u3066\u3044\u308b\u5fc5\u8981\u306f\u3042\u308a\u307e\u305b\u3093\u3002<\/p>\n

\u65e2\u306bnginx\u3092yum\u7b49\u3067\u5c0e\u5165\u6e08\u307f\u306e\u5834\u5408\u306f\u3001\u8a2d\u5b9a\u30d5\u30a1\u30a4\u30eb\u306e\u5834\u6240\u304c \/etc\u914d\u4e0b\u304b\u3089
\n\u30bd\u30fc\u30b9\u30b3\u30f3\u30d1\u30a4\u30eb\u3067\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b \/opt\/nginx \u914d\u4e0b\u306b\u5909\u66f4\u306b\u306a\u308a\u307e\u3059\u306e\u3067\u3001
\n\u8a2d\u5b9a\u30d5\u30a1\u30a4\u30eb\u306e\u30de\u30fc\u30b8\u306f\u3054\u81ea\u8eab\u3067\u304a\u306d\u304c\u3044\u3057\u307e\u3059\u3002<\/p>\n

\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u306b\u5fc5\u8981\u306a\u8af8\u30d1\u30c3\u30b1\u30fc\u30b8\u5c0e\u5165<\/p>\n

[bash]
\n$ sudo yum groupinstall “Development Tools” <\/p>\n

$ sudo yum -y install mysql mysql-server <\/p>\n

$ sudo yum -y install openssl-devel readline-devel zlib-devel curl-devel libyaml-devel mysql-devel icu4c libicu-devel libxml2 libxml2-devel libxslt libxslt-devel<\/p>\n

$ sudo gem install bundler –no-rdoc –no-ri
\n[\/bash]<\/p>\n

mysql\u306e\u8d77\u52d5\u3068\u81ea\u52d5\u8d77\u52d5\u8a2d\u5b9a<\/h3>\n

[bash]
\nsudo systemctl start mariadb
\nsudo systemctl enable mariadb
\n[\/bash]<\/p>\n

mysql \u30d1\u30b9\u30ef\u30fc\u30c9\u8a2d\u5b9a\u3068\u3001\u8a2d\u5b9a\u8abf\u6574<\/h3>\n

$ mysqladmin -u root password ‘mynewpassword’<\/p>\n

$ mysql -uroot -pxxxx<\/p>\n

\u6587\u5b57\u30b3\u30fc\u30c9\u306e\u78ba\u8a8d\u3092\u3059\u308b\u3068\u3001\u4e00\u90e8\u304c latin1\u306b\u306a\u3063\u3066\u3044\u307e\u3059\u3002
\n\u3053\u308c\u3092 utf8\u306b\u5909\u66f4\u3057\u307e\u3059\u3002<\/p>\n

[bash]
\nMariaDB [(none)]> show variables like ‘character_set%’
\n -> ;
\n+————————–+—————————-+
\n| Variable_name | Value |
\n+————————–+—————————-+
\n| character_set_client | utf8 |
\n| character_set_connection | utf8 |
\n| character_set_database | latin1 |
\n| character_set_filesystem | binary |
\n| character_set_results | utf8 |
\n| character_set_server | latin1 |
\n| character_set_system | utf8 |
\n| character_sets_dir | \/usr\/share\/mysql\/charsets\/ |
\n+————————–+—————————-+
\n8 rows in set (0.00 sec)<\/p>\n

[\/bash]<\/p>\n

[bash]
\n$ sudo nano \/etc\/my.cnf.d\/server.cnf
\n[\/bash]<\/p>\n

[diff]
\n# this is read by the standalone daemon and embedded servers
\n[server]<\/p>\n

# this is only for the mysqld standalone daemon
\n[mysqld]
\n+ character-set-server=utf8\u3000\u3000<< \u3053\u306e\u884c\u3092\u8ffd\u8a18\n\n[\/diff]\n\nmysql\u3092\u518d\u8d77\u52d5\u3057\u3001\u8a2d\u5b9a\u304c\u53cd\u6620\u3055\u308c\u3066\u3044\u308b\u78ba\u8a8d\u3002\n[bash]\n$ sudo systemctl restart mariadb\n[\/bash]\n\n\n[bash]\nmysql -uroot -pxxxx\n[\/bash]\n\n\nlatin1\u304cutf8\u306b\u306a\u3063\u3066\u3044\u308b\u306e\u3092\u78ba\u8a8d\u3002\n[bash]\nMariaDB [(none)]> show variables like ‘character_set%’;
\nERROR 2006 (HY000): MySQL server has gone away
\nNo connection. Trying to reconnect…
\nConnection id: 2
\nCurrent database: *** NONE ***<\/p>\n

+————————–+—————————-+
\n| Variable_name | Value |
\n+————————–+—————————-+
\n| character_set_client | utf8 |
\n| character_set_connection | utf8 |
\n| character_set_database | utf8 |
\n| character_set_filesystem | binary |
\n| character_set_results | utf8 |
\n| character_set_server | utf8 |
\n| character_set_system | utf8 |
\n| character_sets_dir | \/usr\/share\/mysql\/charsets\/ |
\n+————————–+—————————-+
\n8 rows in set (0.00 sec)<\/p>\n

[\/bash]<\/p>\n

redmine\u7528\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u4f5c\u6210 <\/h3>\n

[bash]
\nmysql -uroot -p
\nmysql> create database db_redmine default character set utf8;
\nmysql> grant all on db_redmine.* to user_redmine@localhost identified by ‘********’;
\nmysql> flush privileges;
\nmysql> exit;<\/p>\n

[\/bash]<\/p>\n

\u6700\u65b0\u306eredmine\u53d6\u5f97\u3068\u3001\u5c55\u958b<\/h3>\n

\u4ee5\u4e0b\u306eURL\u3088\u308a\u6700\u65b0\u7248\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u307e\u3059\u3002\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u5148\u306f
\n\/var\/lib\/redmine\u3068\u3057\u307e\u3059\u3002<\/p>\n


\nhttp:\/\/www.redmine.org\/projects\/redmine\/wiki\/Download<\/a><\/p>\n

[bash]
\n$ tar xvzf redmine-2.5.2.tar.gz
\n$ mv redmine-2.5.2 redmine<\/p>\n

$ sudo mv redmine \/var\/lib\/
\n$ sudo chown nobody:nobody \/var\/lib\/redmine -R<\/p>\n<\/h3>\n

redmine\u8a2d\u5b9a\u30d5\u30a1\u30a4\u30eb\u306e\u8abf\u6574<\/h3>\n

[bash]
\n$ sudo nano \/var\/lib\/redmine\/config\/database.yml<\/p>\n

[\/bash]<\/p>\n

\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u540d\u3001\u30e6\u30fc\u30b6\u30fc\u540d\u3068\u30d1\u30b9\u30ef\u30fc\u30c9\u306f \u4e0a\u8a18\u3067\u4f5c\u6210\u3057\u305fDB\u306e\u8a2d\u5b9a\u306b\u5408\u308f\u305b\u3066\u304f\u3060\u3055\u3044\u3002
\n[bash]<\/p>\n

production:
\n adapter: mysql2
\n database: db_redmine
\n host: localhost
\n username: user_redmine
\n password: “xxxxxx”
\n encoding: utf8<\/p>\n

[\/bash]<\/p>\n

\u30e1\u30fc\u30eb\u9001\u4fe1\u306a\u3069\u306e\u8a2d\u5b9a\u3092\u8abf\u6574\u3057\u307e\u3059\u3002
\n[bash]
\n$ sudo nano \/var\/lib\/redmine\/config\/configuration.yml<\/p>\n

[\/bash]<\/p>\n

[bash]
\nproduction:
\n email_delivery:
\n delivery_method: :smtp
\n smtp_settings:
\n address: “localhost”
\n port: 25
\n domain: ‘example.com’<\/p>\n

rmagick_font_path: \/usr\/share\/fonts\/ipa-pgothic\/ipagp.ttf<\/p>\n

[\/bash]<\/p>\n

redmine\u306b\u5fc5\u8981\u306agem\u7fa4\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/h3>\n

[bash]
\n$ sudo gem install bundler<\/p>\n

$ sudo \/usr\/local\/bin\/bundle install –without development test
\n[\/bash]<\/p>\n

secret_token\u4f5c\u6210\u3068DB\u30de\u30a4\u30b0\u30ec\u30fc\u30b7\u30e7\u30f3\u5b9f\u884c<\/h3>\n

[bash]
\n$ sudo \/usr\/local\/bin\/bundle exec \/usr\/local\/bin\/rake generate_secret_token<\/p>\n

$ sudo RAILS_ENV=production \/usr\/local\/bin\/bundle exec \/usr\/local\/bin\/rake db:migrate<\/p>\n

[\/bash]<\/p>\n

passenger\u306egem\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/h3>\n

[bash]
\n$ sudo gem install passenger
\n[\/bash]<\/p>\n

nginx\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\uff08passenger\u9023\u643a\u7528\u306b\u30b3\u30f3\u30d1\u30a4\u30eb\uff09<\/h3>\n

\u4ee5\u4e0b\u306e\u30b3\u30de\u30f3\u30c9\u3092\u6253\u3064\u3068\u3044\u308d\u3044\u308d\u51fa\u3066\u304d\u307e\u3059\u304c\u3001\u9069\u5f53\u306b\u9078\u629e\u3057\u3066\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3066\u304f\u3060\u3055\u3044\u3002
\n\/opt\/nginx\u3000\u914d\u4e0b\u306bnginx\u304c\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3055\u308c\u307e\u3059\u3002<\/p>\n

[bash]
\n$ sudo \/usr\/local\/bin\/passenger-install-nginx-module <\/p>\n

[\/bash]<\/p>\n

\/opt\/nginx \u30d5\u30a9\u30eb\u30c0\u6a29\u9650\u8abf\u6574<\/h4>\n

[bash]
\n$ sudo chown nobody:nobody \/opt\/nginx -R
\n$ sudo chmod 775 \/opt\/nginx -R
\n[\/bash]<\/p>\n

\u30d5\u30a1\u30a4\u30a2\u30fc\u30a6\u30a9\u30fc\u30eb\u8a2d\u5b9a<\/h3>\n

\u52d5\u4f5c\u78ba\u8a8d\u306e\u524d\u306b\u30d5\u30a1\u30a4\u30a2\u30fc\u30a6\u30a9\u30fc\u30eb\u304c\u30c7\u30d5\u30a9\u3067\u304b\u304b\u3063\u3066\u3044\u308b\u306e\u3067http\u3092\u901a\u3059\u3088\u3046\u306b\u5909\u66f4\u3059\u308b\u3002<\/p>\n

\u307e\u305a\u78ba\u8a8d\u3002
\n[bash]
\n$ sudo firewall-cmd –list-all<\/p>\n

public (default, active)
\n interfaces: virbr0 wlp2s0
\n sources:
\n services: dhcpv6-client ssh
\n ports:
\n masquerade: no
\n forward-ports:
\n icmp-blocks:
\n rich rules:<\/p>\n

[\/bash]<\/p>\n

ssh\u3068dhcp\u3057\u304b\u6709\u52b9\u3058\u3083\u306a\u3044\u306e\u3067\u3001http\u3092\u8ffd\u52a0\u3059\u308b\u3002
\n\u305d\u306e\u524d\u306b\u3069\u3093\u306a\u30b5\u30fc\u30d3\u30b9\u304c\u5b9a\u7fa9\u3055\u308c\u3066\u3044\u3066\u3001\u4eca\u3069\u308c\u304c public\u3067\u6709\u52b9\u304b\u30c1\u30a7\u30c3\u30af\u3059\u308b\u65b9\u6cd5\u3002<\/p>\n

[bash]
\n\u203b\u5b9a\u7fa9\u3055\u308c\u3066\u3044\u308b\u30b5\u30fc\u30d3\u30b9\u4e00\u89a7
\n$ sudo firewall-cmd –get-services<\/p>\n

\u203bpublic\u306e\u30b5\u30fc\u30d3\u30b9\u78ba\u8a8d
\n$ sudo firewall-cmd –list-service –zone=public <\/p>\n

[\/bash]<\/p>\n

nginx\u306a\u306e\u3067\u3000http\u30b5\u30fc\u30d3\u30b9\u3092\u8ffd\u52a0\u3057\u3066\u307f\u308b<\/p>\n

[bash]
\n\u203b\u30b5\u30fc\u30d3\u30b9\u3092\u8ffd\u52a0\u3059\u308b
\n$ sudo firewall-cmd –add-service=http –zone=public<\/p>\n

\u203b\u6052\u4e45\u7684\u306b\u30b5\u30fc\u30d3\u30b9\u3092\u8ffd\u52a0\u3059\u308b
\n$ sudo firewall-cmd –add-service=http –zone=public –permanent<\/p>\n

[\/bash]<\/p>\n

\u30d5\u30a1\u30a4\u30a2\u30fc\u30a6\u30a9\u30fc\u30eb\u518d\u8d77\u52d5
\n[bash]
\n$ sudo firewall-cmd –reload
\n[\/bash]<\/p>\n

http\u304c\u6709\u52b9\u306b\u306a\u3063\u3066\u3044\u308b\u304b\u78ba\u8a8d
\n[bash]
\n$ sudo firewall-cmd –list-all<\/p>\n

public (default, active)
\n interfaces: virbr0 wlp2s0
\n sources:
\n services: dhcpv6-client http ssh
\n ports:
\n masquerade: no
\n forward-ports:
\n icmp-blocks:
\n rich rules:<\/p>\n

[\/bash]<\/p>\n

nginx\u306e\u8a2d\u5b9a\u78ba\u8a8d\u3068\u3001\u8d77\u52d5<\/h3>\n

-t \u30aa\u30d7\u30b7\u30e7\u30f3\u3067\u8a2d\u5b9a\u30d5\u30a1\u30a4\u30eb\u3092\u30c1\u30a7\u30c3\u30af\u3057\u3001OK\u306a\u3089\u3070\u3001\u4e00\u65e6\u8d77\u52d5\u3057\u3066\u307f\u3066\u3001\u30d6\u30e9\u30a6\u30b6\u30fc\u3067 http:\/\/localhost \u3068\u3057\u3066\u3001nginx\u306e\u30c8\u30c3\u30d7\u30da\u30fc\u30b8\u304c\u958b\u3051\u308c\u3070OK\u3002<\/p>\n

[bash]
\n$ sudo \/opt\/nginx\/sbin\/nginx -t
\nnginx: the configuration file \/opt\/nginx\/conf\/nginx.conf syntax is ok
\nnginx: configuration file \/opt\/nginx\/conf\/nginx.conf test is successful<\/p>\n

[\/bash]<\/p>\n

nginx\u8d77\u52d5<\/h4>\n

[bash]
\n$ sudo \/opt\/nginx\/sbin\/nginx
\n[\/bash]<\/p>\n

\u505c\u6b62\u306f<\/p>\n

[bash]
\n$ ps aux |grep nginx
\n[\/bash]<\/p>\n

\u3068\u3057\u3066\u3001nginx: master process \u3068\u306a\u308b\u30d7\u30ed\u30bb\u30b9ID\u3092\u6bba\u3059\u3068\u6b62\u3081\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n

[bash]
\n$ sudo kill pid
\n[\/bash]<\/p>\n

nginx\u7528\u3000\u30b5\u30fc\u30d3\u30b9\u8d77\u52d5\u30d5\u30a1\u30a4\u30eb\u4f5c\u6210<\/h3>\n

$ sudo nano \/usr\/lib\/systemd\/system\/nginx.service <\/p>\n

[bash]<\/p>\n

[Unit]
\nDescription=nginx – high performance web server
\nDocumentation=http:\/\/nginx.org\/en\/docs\/
\nAfter=network.target remote-fs.target nss-lookup.target<\/p>\n

[Service]
\nType=forking
\nPIDFile=\/opt\/nginx\/logs\/nginx.pid
\nExecStartPre=\/opt\/nginx\/sbin\/nginx -t -c \/opt\/nginx\/conf\/nginx.conf
\nExecStart=\/opt\/nginx\/sbin\/nginx -c \/opt\/nginx\/conf\/nginx.conf
\nExecReload=\/bin\/kill -s HUP $MAINPID
\nExecStop=\/bin\/kill -s QUIT $MAINPID
\nPrivateTmp=true<\/p>\n

[Install]
\nWantedBy=multi-user.target<\/p>\n

[\/bash]<\/p>\n

\u30c7\u30fc\u30e2\u30f3\u30ea\u30ed\u30fc\u30c9\u3001nginx\u8d77\u52d5<\/h3>\n

[bash]<\/p>\n

$ sudo systemctl daemon-reload
\n$ sudo systemctl start nginx
\n$ sudo systemctl enable nginx<\/p>\n

[\/bash]<\/p>\n

nginx\u52d5\u4f5c\u78ba\u8a8d<\/h4>\n

\u30b5\u30fc\u30d0\u30fc\u306eIP\u306b\u30d6\u30e9\u30a6\u30b6\u30fc\u3067\u63a5\u7d9a\u3067 nginx\u306ewelcompage\u304c\u8868\u793a\u3055\u308c\u308c\u3070\u3001nginx\u306e\u52d5\u4f5c\u306fOK<\/p>\n

http:\/\/192.168.x.x<\/p>\n

SELinux\u3092\u7121\u52b9\u5316<\/h3>\n

[bash]
\n$ sudo nano \/etc\/sysconfig\/selinux
\n[\/bash]<\/p>\n

[bash]
\n-SELINUX=enforcing
\n+SELINUX=disabled
\n[\/bash]<\/p>\n

\u4e00\u65e6\u30ea\u30d6\u30fc\u30c8\u3057\u3066\u304f\u3060\u3055\u3044
\n[bash]
\n$ sudo reboot
\n[\/bash]<\/p>\n

nginx passenger\u9023\u643a\u8a2d\u5b9a<\/h3>\n

passenger\u306e\u5834\u6240\u306f\u3001\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u6642\u306b\u81ea\u52d5\u7684\u306b\u7d44\u307f\u8fbc\u307e\u308c\u3066\u3044\u308b\u306e\u3067\u3001\u305d\u306e\u4ed6\u306e\u9805\u76ee\u306e\u8abf\u6574\u3002<\/p>\n

http:\/\/www.myhost.jp\/redmine \u3067\u516c\u958b\u3059\u308b\u3002<\/p>\n

[bash]
\n$ sudo nano \/opt\/nginx\/conf\/nginx.conf
\n[\/bash]<\/p>\n

\u4ee5\u4e0b\u306e\u90e8\u5206\u3092\u8ffd\u8a18<\/p>\n

[diff mark=”2″]
\n+ user nobody;
\n+ pid \/opt\/nginx\/logs\/nginx.pid;<\/p>\n

\u301c\u7701\u7565\u301c
\n server {
\n listen 80;
\n server_name localhost;<\/p>\n

\u301c\u7701\u7565\u301c<\/p>\n

+ location ~ ^\/redmine {
\n+ root \/var\/lib\/redmine\/public;
\n+ passenger_base_uri \/redmine;
\n+ passenger_app_root \/var\/lib\/redmine;
\n+ passenger_enabled on;
\n+ rails_env production;
\n+ access_log logs\/redmine_access.log ;
\n+ error_log logs\/redmine_error.log ;
\n+ }<\/p>\n

[\/diff]<\/p>\n

redmine \u52d5\u4f5c\u78ba\u8a8d<\/h3>\n

http:\/\/example.com\/redmine \u3078\u30a2\u30af\u30bb\u30b9\u3002
\n\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u30c8\u30c3\u30d7\u30da\u30fc\u30b8\u304c\u51fa\u3066\u304f\u308c\u3070\u3000\u6210\u529f\u3002<\/p>\n

\"Screenshot-Redmine<\/a><\/p>\n

\u30ed\u30b0\u30a4\u30f3\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u3001\u30c7\u30d5\u30a9\u30eb\u30c8\u7ba1\u7406\u8005\u30e6\u30fc\u30b6\u30fc
\nadmin \/ admin \u3067\u30ed\u30b0\u30a4\u30f3\u51fa\u6765\u308c\u3070OK\u3067\u3059\u3002<\/p>\n

\"Screenshot-Redmine<\/a><\/p>\n

\u4ee5\u4e0a<\/p>\n","protected":false},"excerpt":{"rendered":"

CentOS7\u306bRedmine\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3001nginx\u306e\u30b5\u30d6\u30d5\u30a9\u30eb\u30c0\u3067\u516c\u958b\u3059\u308b\u65b9\u6cd5\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002 nginx\u3068\u306e\u9023\u643a\u306fpassenger\u3092\u7528\u3044\u307e\u3059\u3002nginx\u306f\u8aac\u660e\u306e\u9014\u4e2d\u3067passenger\u9023\u643a\u306e\u305f\u3081\u306b \u30b3\u30f3\u30d1\u30a4\u30eb\u3057\u307e\u3059\u306e\u3067\u3001nginx\u81ea\u4f53\u304c\u4e8b\u524d\u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3055\u308c\u3066\u3044\u308b\u5fc5\u8981\u306f\u3042\u308a\u307e\u305b\u3093\u3002 \u65e2\u306bnginx\u3092yum\u7b49\u3067\u5c0e\u5165\u6e08\u307f\u306e\u5834\u5408\u306f\u3001\u8a2d\u5b9a\u30d5\u30a1\u30a4\u30eb\u306e\u5834\u6240\u304c \/etc\u914d\u4e0b\u304b\u3089 \u30bd\u30fc\u30b9\u30b3\u30f3\u30d1\u30a4\u30eb\u3067\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b \/opt\/nginx \u914d\u4e0b\u306b\u5909\u66f4\u306b\u306a\u308a\u307e\u3059\u306e\u3067\u3001 \u8a2d\u5b9a\u30d5\u30a1\u30a4\u30eb\u306e\u30de\u30fc\u30b8\u306f\u3054\u81ea\u8eab\u3067\u304a\u306d\u304c\u3044\u3057\u307e\u3059\u3002 \u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u306b\u5fc5\u8981\u306a\u8af8\u30d1\u30c3\u30b1\u30fc\u30b8\u5c0e\u5165 [bash] $ sudo yum groupinstall “Development Tools” $ sudo yum -y install mysql mysql-server $ sudo yum -y install openssl-devel readline-devel zlib-devel curl-devel libyaml-devel mysql-devel icu4c libicu-devel libxml2 libxml2-devel libxslt libxslt-devel $ sudo gem install bundler –no-rdoc –no-ri [\/bash] mysql\u306e\u8d77\u52d5\u3068\u81ea\u52d5\u8d77\u52d5\u8a2d\u5b9a [bash] sudo systemctl start mariadb sudo systemctl enable mariadb [\/bash] mysql \u30d1\u30b9\u30ef\u30fc\u30c9\u8a2d\u5b9a\u3068\u3001\u8a2d\u5b9a\u8abf\u6574 $ mysqladmin -u root password ‘mynewpassword’ $ mysql -uroot -pxxxx \u6587\u5b57\u30b3\u30fc\u30c9\u306e\u78ba\u8a8d\u3092\u3059\u308b\u3068\u3001\u4e00\u90e8\u304c latin1\u306b\u306a\u3063\u3066\u3044\u307e\u3059\u3002 \u3053\u308c\u3092 utf8\u306b\u5909\u66f4\u3057\u307e\u3059\u3002 [bash] MariaDB [(none)]> show variables like ‘character_set%’ -> ; +————————–+—————————-+ | Variable_name | Value | +————————–+—————————-+ | character_set_client | utf8 | | character_set_connection | utf8 | | character_set_database | latin1 | | character_set_filesystem | binary | | character_set_results | utf8 | | character_set_server | latin1 | | character_set_system | utf8 | | character_sets_dir | \/usr\/share\/mysql\/charsets\/ | +————————–+—————————-+ 8 rows in set (0.00 sec) [\/bash] [bash] $ sudo nano \/etc\/my.cnf.d\/server.cnf [\/bash] [diff] # this is read by the standalone daemon and embedded servers [server] # this is only for the mysqld standalone daemon [mysqld] + character-set-server=utf8\u3000\u3000 show variables like ‘character_set%’; ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect… Connection id: 2 Current database: *** NONE *** +————————–+—————————-+ | Variable_name | Value | +————————–+—————————-+ | character_set_client | utf8 | | character_set_connection | utf8 | | character_set_database | utf8 | | character_set_filesystem | binary | | character_set_results | utf8 | | character_set_server | utf8 | | character_set_system | utf8 | | character_sets_dir | \/usr\/share\/mysql\/charsets\/ | +————————–+—————————-+ 8 rows in set (0.00 sec) [\/bash] redmine\u7528\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u4f5c\u6210 [bash] mysql -uroot -p mysql> create database db_redmine default character set utf8; mysql> grant all on db_redmine.* to user_redmine@localhost identified by ‘********’; mysql> flush privileges; mysql> exit; [\/bash] \u6700\u65b0\u306eredmine\u53d6\u5f97\u3068\u3001\u5c55\u958b \u4ee5\u4e0b\u306eURL\u3088\u308a\u6700\u65b0\u7248\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u307e\u3059\u3002\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u5148\u306f \/var\/lib\/redmine\u3068\u3057\u307e\u3059\u3002 http:\/\/www.redmine.org\/projects\/redmine\/wiki\/Download [bash] $ tar xvzf redmine-2.5.2.tar.gz $ mv redmine-2.5.2 redmine $ sudo mv redmine \/var\/lib\/ $ sudo…<\/p>\n","protected":false},"author":1,"featured_media":1061,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[4],"tags":[25,51,13,26],"class_list":{"0":"post-1056","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-4","8":"tag-centos","9":"tag-centos7","10":"tag-nginx","11":"tag-redmine"},"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/lovelinux.mydns.jp\/index.php?rest_route=\/wp\/v2\/posts\/1056","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/lovelinux.mydns.jp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/lovelinux.mydns.jp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/lovelinux.mydns.jp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/lovelinux.mydns.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1056"}],"version-history":[{"count":6,"href":"https:\/\/lovelinux.mydns.jp\/index.php?rest_route=\/wp\/v2\/posts\/1056\/revisions"}],"predecessor-version":[{"id":1071,"href":"https:\/\/lovelinux.mydns.jp\/index.php?rest_route=\/wp\/v2\/posts\/1056\/revisions\/1071"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/lovelinux.mydns.jp\/index.php?rest_route=\/wp\/v2\/media\/1061"}],"wp:attachment":[{"href":"https:\/\/lovelinux.mydns.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1056"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/lovelinux.mydns.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1056"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/lovelinux.mydns.jp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1056"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}