meta data for this page
Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
linux:sw:openproject:migrate [2019/12/11 11:11] niziak [Upgrade OP to 10] |
linux:sw:openproject:migrate [2019/12/30 09:29] (current) niziak sw:linux:openproject:migrate renamed to linux:sw:openproject:migrate |
||
---|---|---|---|
Line 9: | Line 9: | ||
Refer to instruction [[https://www.openproject.org/download-and-installation/]] to install OP. | Refer to instruction [[https://www.openproject.org/download-and-installation/]] to install OP. | ||
- | <file /etc/apt/sources.list.d/openproject.list> | + | <code bash>apt-get install apt-transport-https</code> |
+ | |||
+ | <file | /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/10/debian 10 main | ||
deb https://dl.packager.io/srv/deb/opf/openproject/stable/9/debian 9 main | deb https://dl.packager.io/srv/deb/opf/openproject/stable/9/debian 9 main | ||
Line 18: | Line 20: | ||
apt-cache policy openproject | apt-cache policy openproject | ||
apt-get install openproject=9.0.4-1570023722.b1f1184d.stretch | apt-get install openproject=9.0.4-1570023722.b1f1184d.stretch | ||
- | </codE> | + | </code> |
<code bash> | <code bash> | ||
Line 29: | Line 31: | ||
Now we have running OP9.0.4 with PGSql. | Now we have running OP9.0.4 with PGSql. | ||
+ | |||
+ | |||
+ | ===== install pgloader ===== | ||
+ | |||
+ | refer to [[https://www.openproject.org/operations/migration-guides/migrating-packaged-openproject-database-postgresql/]] | ||
+ | <code bash> | ||
+ | wget -qO- https://dl.packager.io/srv/opf/pgloader-ccl/key | sudo apt-key add - | ||
+ | sudo wget -O /etc/apt/sources.list.d/pgloader-ccl.list \ | ||
+ | https://dl.packager.io/srv/opf/pgloader-ccl/master/installer/debian/9.repo | ||
+ | sudo apt-get update | ||
+ | sudo apt-get install pgloader-ccl | ||
+ | </code> | ||
===== import backup ===== | ===== import backup ===== | ||
- | All backup parts are simply compressed directories and can be unpacked. | + | All backup parts are simply compressed directories and can be unpacked (or simply rsynced from another host). |
Only database dump need to be imported. | Only database dump need to be imported. | ||
+ | Rsync command: | ||
+ | <code bash> | ||
+ | rsync -r -a -v -e ssh root@REMOTE:/var/db/openproject/files/ /var/db/openproject/files | ||
+ | </code> | ||
===== import mysql dump ===== | ===== import mysql dump ===== | ||
Line 41: | Line 59: | ||
</code> | </code> | ||
- | <code bash>mysql<code> | + | <code bash>mysql</code> |
<code sql> | <code sql> | ||
CREATE USER 'openproject'@'localhost' IDENTIFIED BY 'password'; | CREATE USER 'openproject'@'localhost' IDENTIFIED BY 'password'; | ||
Line 87: | Line 105: | ||
apt-cache policy openproject | apt-cache policy openproject | ||
apt-get install openproject=10.0.0-1569215906.69231eeb.stretch | apt-get install openproject=10.0.0-1569215906.69231eeb.stretch | ||
+ | sudo openproject configure | ||
+ | |||
+ | apt-get upgrade | ||
+ | sudo openproject configure | ||
</code> | </code> | ||