meta data for this page
  •  
Book Creator
 Add this page to your book
Book Creator
 Remove this page from your book  

 Manage book(0 page(s))
 Help

This is an old revision of the document!

Migration from 9 to 10

Current version 9.0.4 (Mysql2)

New system

Install Debian 9.11 !!!.

Refer to instruction https://www.openproject.org/download-and-installation/ to install OP.

/etc/apt/sources.list.d/openproject.list
# deb https://dl.packager.io/srv/deb/opf/openproject/stable/10/debian 10 main
deb https://dl.packager.io/srv/deb/opf/openproject/stable/9/debian 9 main
apt-get update
apt-cache policy openproject
apt-get install openproject=9.0.4-1570023722.b1f1184d.stretch
</codE>
 
<code bash>
sudo openproject configure

Choose:

  • Install a new PostgreSQL server and database locally
  • Install apache2 server
  • Install new memcached server

Now we have running OP9.0.4 with PGSql.

import backup

All backup parts are simply compressed directories and can be unpacked. Only database dump need to be imported.

import mysql dump

apt-get install mysql-server
mysql<code>
<code sql>
CREATE USER 'openproject'@'localhost' IDENTIFIED BY 'password';
CREATE DATABASE openproject CHARACTER SET utf8mb4;
GRANT ALL PRIVILEGES ON openproject.* TO 'openproject'@'localhost';
\q

Configure openproject for mysql:

  • store original postgresql somewhere: 
    openproject config:get DATABASE_URL
  • openproject config:set MYSQL_DATABASE_URL="mysql2://openproject:password@127.0.0.1:3306/openproject"
  • openproject config:set DATABASE_URL="mysql2://openproject:password@127.0.0.1:3306/openproject"
  • openproject run rake db:create:all

Restore backup dump: 

zcat mysql-dump-20191211011301.sql.gz | mysql -u openproject -p openproject

Restart service: 

systemctl restart openproject

Set database URL to previously created postgresql database: 

openproject config:set DATABASE_URL=postgres://openproject:...@127.0.0.1:45432/openproject

Migrate database: 

sudo openproject run ./docker/mysql-to-postgres/bin/migrate-mysql-to-postgres

Remove mysql: 

apt-get remove mysql-server
openproject config:unset MYSQL_DATABASE_URL

Restart service: 

systemctl restart openproject

Upgrade OP to 10

/etc/apt/sources.list.d/openproject.list
deb https://dl.packager.io/srv/deb/opf/openproject/stable/9/debian 9 main
deb https://dl.packager.io/srv/deb/opf/openproject/stable/10/debian 9 main
apt-get update
apt-cache policy openproject
apt-get install openproject=10.0.0-1569215906.69231eeb.stretch
sudo openproject configure
 
apt-get upgrade
sudo openproject configure