【AWS】EC2に最新のRedmine4.xを手動でインストールしてみた

sudo yum -y update
sudo yum -y groupinstall "Development Tools"
sudo yum -y install openssl-devel readline-devel zlib-devel curl-devel libyaml-devel libffi-devel
sudo yum -y install mysql mysql-devel
sudo yum -y install httpd httpd-devel
sudo yum -y install ImageMagick ImageMagick-devel ipa-pgothic-fonts

sudo yum install git -y
git clone https://github.com/sstephenson/rbenv.git ~/.rbenv
git clone https://github.com/sstephenson/ruby-build.git ~/.rbenv/plugins/ruby-build

cd ~/.rbenv/plugins/ruby-build
sudo yum -y install gcc-c++ glibc-headers openssl-devel readline libyaml-devel readline-devel zlib zlib-devel libffi-devel libxml2 libxslt libxml2-devel libxslt-devel sqlite-devel

cd ~/.rbenv/plugins/ruby-build

echo 'export RBENV_ROOT=/var/lib/rbenv' >> ~/.bash_profile
echo 'export PATH="$RBENV_ROOT/bin:$PATH"' >> ~/.bash_profile
/var/lib/rbenv/bin/rbenv init
echo 'eval "$(rbenv init -)"' >> ~/.bash_profile

source ~/.bash_profile
rbenv --version
rbenv rehash

rbenv install 2.6.6
rbenv global 2.6.6
ruby -v

cd /home/ec2-user/.rbenv
gem install rails --no-document

yum list installed | grep mariadb
yum list installed | grep mysql
sudo yum localinstall https://dev.mysql.com/get/mysql80-community-release-el7-1.noarch.rpm -y
sudo yum-config-manager --disable mysql80-community
sudo yum-config-manager --enable mysql57-community
yum info mysql-community-server
sudo yum install mysql-community-server -y
mysqld --version

sudo systemctl start mysqld.service
sudo systemctl enable mysqld.service
systemctl status mysqld.service

sudo cat /var/log/mysqld.log | grep password
mysql_secure_installation

Enter password for user root: **********
New password: **********
Re-enter new password: **********
Change the password for root ? ((Press y|Y for Yes, any other key for No) : No
Remove anonymous users? (Press y|Y for Yes, any other key for No) : Yes
Disallow root login remotely? (Press y|Y for Yes, any other key for No) : No
Remove test database and access to it? (Press y|Y for Yes, any other key for No) : Yes
Reload privilege tables now? (Press y|Y for Yes, any other key for No) : Yes

mysql -u root -p**********

mysql> show global variables like 'character%';
mysql> exit

sudo vi /etc/my.cnf

$ sudo vi /etc/my.cnf

[mysqld]
character_set_server=utf8mb4

[client]
default-character-set=utf8mb4

sudo systemctl restart mysqld.service
mysql -u root -p**********

mysql> show global variables like 'character%';
mysql> exit

cd /tmp
wget http://www.redmine.org/releases/redmine-4.1.1.tar.gz
tar zxvf redmine-4.1.1.tar.gz
sudo mv redmine-4.1.1 /var/lib/redmine

mysql -u root -p**********
mysql> show databases;
mysql> CREATE DATABASE redmine‗db DEFAULT CHARACTER SET utf8mb4;
mysql> CREATE USER 'redmine'@'localhost' IDENTIFIED BY '**********';
mysql> GRANT ALL PRIVILEGES ON redmine.* TO 'redmine'@'localhost';
mysql> SHOW DATABASES;

sudo service mysqld stop
sudo service mysqld status
sudo service mysqld start

sudo chown -R apache.apache /var/lib/redmine/

cd /var/lib/redmine/config/
sudo touch database.yml
sudoedit database.yml

deveropment:
adapter: mysql2
database: red
host: localhost
username: redmine
password: "**********"
encoding: utf8mb4

production:
adapter: mysql2
database: red
host: localhost
username: redmine
password: "**********"
encoding: utf8mb4

gem update
gem install bundler
gem -v
bundler -v

sudo chown -R apache.apache /var/lib/redmine/
sudo mkdir -p app/assets/config
sudo touch app/assets/config/manifest.js
sudoedit app/assets/config/manifest.js

//= link_tree ../images
//= link_directory ../javascripts .js
//= link_directory ../stylesheets .css

sudo chown -R ec2-user.ec2-user /var/lib/redmine
bundle install --without development test
sudo chown -R apache.apache /var/lib/redmine/

bundle exec rake generate_secret_token

RAILS_ENV=production bundle exec rake db:migrate

RAILS_ENV=production bundle exec rake redmine:load_default_data

mysql -u root -p
mysql> show tables from redmine;
mysql> exit;

sudo chmod 777 files
sudo chmod 777 log
sudo chmod 777 tmp
sudo chmod 777 tmp/pdf
sudo chmod 777 public/plugin_assets

gem install passenger -N
passenger-install-apache2-module --auto --languages ruby
sudo chmod o+x "/root"
passenger-install-apache2-module --snippet

sudo touch redmine.conf
sudoedit /etc/httpd/conf.d/redmine.conf

LoadModule passenger_module /home/ec2-user/.rbenv/versions/2.6.6/lib/ruby/gems/2.6.0/gems/passenger-6.0.7/buildout/apache2/mod_passenger.so

PassengerRoot /home/ec2-user/.rbenv/versions/2.6.6/lib/ruby/gems/2.6.0/gems/passenger-6.0.7
PassengerDefaultRuby /home/ec2-user/.rbenv/versions/2.6.6/bin/ruby

PassengerMaxPoolSize 20
PassengerMaxInstancesPerApp 4
PassengerPoolIdleTime 864000
PassengerStatThrottleRate 10
Header always unset "X-Powered-By"
Header always unset "X-Runtime"
PassengerSpawnMethod smart
PassengerFriendlyErrorPages off

sudoedit /etc/httpd/conf/httpd.conf
vim /etc/httpd/conf/httpd.conf

DocumentRoot "/var/lib/redmine/public"

sudo systemctl start httpd.service
sudo systemctl enable httpd.service

service httpd configtest
sudo systemctl restart httpd.service

export ORIG_PATH=$PATH
sudo -s -E
export PATH=$ORIG_PATH

cd /var/lib/redmine
bundle exec rails server webrick -e production

sudo mkdir /var/run/passenger-instreg
sudo chown ec2-user.ec2-user /var/run/passenger-instreg
sudo chmod 777 /var/run/passenger-instreg

sudoedit /etc/httpd/conf/httpd.conf

PassengerInstanceRegistryDir /var/run/passenger-instreg

$ sudo chown apache.apache /etc/tmpfiles.d/
$ sudo touch /etc/tmpfiles.d/passenger.conf
$ sudo chmod 777 /etc/tmpfiles.d/passenger.conf
$ sudo chown apache.apache /etc/tmpfiles.d/passenger.conf
$ sudoedit /etc/tmpfiles.d/passenger.conf
# vim /etc/tmpfiles.d/passenger.conf

D /var/run/passenger-instreg 0755 apache apache

cd /home/ec2-user
vim .bash_profile

export PASSENGER_INSTANCE_REGISTRY_DIR=/var/run/passenger-instreg

service httpd configtest
sudo systemctl restart httpd.service

service httpd status

passenger start

passenger stop