Top Menu

Jump to content
Home
    Modules
      • Projects
      • Activity
      • Work packages
      • Gantt charts
      • Calendars
      • Team planners
      • Boards
      • News
    • Getting started
    • Introduction video
      Welcome to OpenProject Community
      Get a quick overview of project management and team collaboration with OpenProject. You can restart this video from the help menu.

    • Help and support
    • Upgrade to Enterprise edition
    • User guides
    • Videos
    • Shortcuts
    • Community forum
    • Enterprise support

    • Additional resources
    • Data privacy and security policy
    • Digital accessibility (DE)
    • OpenProject website
    • Security alerts / Newsletter
    • OpenProject blog
    • Release notes
    • Report a bug
    • Development roadmap
    • Add and edit translations
    • API documentation
  • Sign in
      Forgot your password?

      or sign in with your existing account

      Google

Side Menu

  • Overview
  • Activity
    Activity
  • Roadmap
  • Work packages
    Work packages
  • Gantt charts
    Gantt charts
  • Calendars
    Calendars
  • Team planners
    Team planners
  • Boards
    Boards
  • News
  • Forums

Content

Support Installation & Updates
  1. OpenProject
  2. Forums
  3. Support Installation & Updates
  4. Upgrade from 5.0.20 to latest - docker issue

Upgrade from 5.0.20 to latest - docker issue

Added by Grzegorz Żyła over 2 years ago

We have been using OP 5.0.20 compiled with git on postgresql 9.2 for 7 years.

I want to upgrade to the latest version. I have read everything about migration, I found a script to migrate from pre-8 from mysql to postgres (https://github.com/opf/openproject/blob/dev/script/migration/migrate-from-pre-8.sh).

I started the machine on Ubuntu 22, installed dockers op7 (openproject / community: 7), op8, etc. 

Unfortunately, the op7 docker does not start, it reports an error:
root @ optest: / home / eclsoft # docker run --name op7 openproject / community: 7
/ usr / src / app / docker / entrypoint: line 19: /tmp/tmp.FXHv0oMA3c: Permission denied

Thus, I cannot migrate to version 7 :(
How to solve it?


Replies (4)

RE: Upgrade from 5.0.20 to latest - docker issue - Added by Grzegorz Żyła over 2 years ago

Ok, i will check this solution.

Permission errors when trying to start the OP7 container

If you run into permission errors trying to start the OP7 container, you might have advanced tmpfs protections in place. Disable them temporarily with sudo sysctl fs.protected_regular=0 (https://askubuntu.com/questions/1250974)

RE: Upgrade from 5.0.20 to latest - docker issue - Added by Grzegorz Żyła over 2 years ago

Uff, it works!

RE: Upgrade from 5.0.20 to latest - docker issue - Added by Grzegorz Żyła over 2 years ago

Ok, so i did it! :)

  1. Install OS - I chose ubuntu 22
  2. Install OP from apt - https://www.openproject.org/docs/installation-and-operations/installation/packaged/
  3. Install docker
  4. Next - https://askubuntu.com/questions/1250974/user-root-cant-write-to-file-in-tmp-owned-by-someone-else-in-20-04-but-can-in - to run docker with OPv7
  5. Look at the script https://github.com/opf/openproject/blob/dev/script/migration/migrate-from-pre-8.sh
  6. Backup OPv5, database and files.
  7. If your OP run on MySQL then you are at home, use script from #5, if not, read next points.

What i did to migrate:

  1. I have completed points 1 to 6
  2. openproject configure, install psqlv13, then stop openproject
  3. create database openproject on postgresql v13
  4. get database url - openproject config:get DATABASE_URL
  5. restore db from backup OPv5 - pg_restore --clean --if-exists -h localhost -p 45432 -U op -d yourbackupfile
  6. run dockers: docker run -d --name op7 openproject/community:7  docker run -d --name op8 openproject/community:8  docker run -d --name op10 openproject/community:10
  7. reconfigure psql to listen from all host
  8. start migrating

docker exec -it op7 /bin/sh -c "DATABASE_URL=put_here_your_database_url_point_4 bundle exec rake db:migrate"

docker exec -it op8 /bin/sh -c "DATABASE_URL=put_here_your_database_url_point_4 bundle exec rake db:migrate"

docker exec -it op10 /bin/sh -c "DATABASE_URL=put_here_your_database_url_point_4 bundle exec rake db:migrate"

openproject configure

and you are done! :)

put ssl to apache - certboot

put RequestHeader set X-Forwarded-Proto "https" to apache.conf

RE: Upgrade from 5.0.20 to latest - docker issue - Added by Adam Szabo over 2 years ago

Congratulations and thank you for sharing the walk through, it will help others for sure in the future :) . Great job!

  • (1 - 4/4)
Loading...