Overview

Install Ruby Version Manager (RVM)
- cd /usr/local
- curl -sSL https://rvm.io/mpapis.asc | gpg2 --import -
- curl -sSL https://rvm.io/pkuczynski.asc | gpg2 --import -
- curl -L get.rvm.io | bash -s stable
- source /etc/profile.d/rvm.sh
- rvm reload
- rvm requirements run
- rvm install 2.6
- rvm list
Install web server modules
- yum install -y httpd-devel libcurl-devel apr-devel apr-util-devel mod_ssl
Install graphic design, and video editing modules
- yum install -y ImageMagick ImageMagick-devel
Download redmine-5.0.1 in folder of "/usr/local"
- cd /usr/local
- wget --no-check-certificate https://www.redmine.org/releases/redmine-5.0.1.tar.gz
- tar xvfz redmine-5.0.1.tar.gz
Install bundler and gems defined in the Gemfile file in "/usr/local/redmine-5.0.1/" folder
- cd /usr/local/redmine-5.0.1/
- gem install bundler -v 2.4.22
- gem install mysql2 -v '0.4.10' --source 'https://rubygems.org/'
- bundle install --without development test
- bundle exec rake generate_secret_token
Install MYSQL server
- Note : Before installation, please check whether /usr/lib54/libssl.so.10 file was in place. If not please download from https://rpmfind.net/linux/centos/8-stream/AppStream/x86_64/os/Packages/compat-openssl10-1.0.2o-3.el8.x86_64.rpm and install using 'yum install compat-openssl10-1.0.2o-3.el8.x86_64.rpm'.
- cd /usr/local/
- wget https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.35-1.el8.x86_64.rpm-bundle.tar
- tar -xvf mysql-8.0.35-1.el8.x86_64.rpm-bundle.tar
- yum install mysql-community-{server,client,client-plugins,icu-data-files,common,libs,devel}-*
- systemctl start mysqld
- grep 'temporary password' /var/log/mysqld.log (Note : After installation, please use this command to get the mysql password from log file [Output example : A temporary password is generated for root@localhost: XXXXXXX])
- mysql -uroot -p
- ALTER USER 'root'@'localhost' IDENTIFIED BY '3C0$2Ol3'; (Note : The new root password to be changed to '3C0$2Ol3')
Redmine configuration
- cd /usr/local/redmine-5.0.1/config
- cp database.yml.example database.yml
- vi database.yml (View and edit and save it)
- vi environment.rb (View and edit and save it)
Export Database and convert character set at old server
- Export data from old server
  - mysqldump -ubitnami -p7ddb8931e3 --opt --skip-set-charset --default-character-set=latin1 bitnami_redmine > /home/etpm/redmine.sql
- Convert the exported data from latin character set to utf8mb4 since new version of Mysql is using it
  - perl -i -pe 's/DEFAULT CHARACTER SET latin1/DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci/' /home/etpm/redmine.sql
  - perl -i -pe 's/DEFAULT CHARSET=latin1/DEFAULT CHARSET=utf8mb4 COLLATE utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC/' /home/etpm/redmine.sql
Create Database and import data at new server
- Login to mysql server
  - mysql -uroot -p
- Create database and user privileges after login
  - CREATE DATABASE redmine CHARACTER SET utf8mb4;
  - CREATE USER 'redmine'@'localhost' IDENTIFIED BY '3C0$2Ol3';
  - GRANT ALL PRIVILEGES ON redmine.* TO 'redmine'@'localhost';
- Import data
  - mysql -v -uredmine -p3C0$2Ol3 redmine < redmine.sql
- Rebuild the table structures on new database
  - cd /usr/local/redmine-5.0.1/
  - run bundle exec rake db:migrate
  - run bin/rake redmine:plugins:migrate
Apache configuration for Redmine
- Copy redmine.conf to Apache conf folder (/usr/local/apache-2.4.34/conf)
- Add the follow line in /usr/local/apache-2.4.34/conf/httpd.conf file at the end of file
  - Include conf/redmine.conf
Create passenger_module to be used by Apache
- gem install passenger
- cd /usr/local/rvm/gems/ruby-2.6.6/gems/passenger-6.0.19/bin
- ./passenger-config validate-install
- ./passenger-install-apache2-module
- Note : After successful, the mod_passenger.so will be gerenated at /usr/local/rvm/gems/ruby-2.6.6/gems/passenger-6.0.19/buildout/apache2/

Members

Manager: Chong-Ting

Developer: Chong-Ting

Project

General

Profile

Redmine Migration on Centos 7 (from version 1.00 to 5.0.1)

Overview

Members