This a frequentlly probelm to me.

To solve this problem I change my Manual install to Package Install:

First, Backup you OP Database. This is Important!!

Install a fresh OP;

1. Install manually a MYSQL:

apt-get install mysql-server libmysqlclient-dev -y

2. AND CREATE OPENPROJECT DB. HERE pass YOU CHANGE TO YOUR PASSWORD USED IN INSTALLATION PROCESS:

• mysql -uroot -p
• UPDATE user SET Password=PASSWORD WHERE User=‘root’; FLUSH PRIVILEGES;
• CREATE DATABASE openproject CHARACTER SET utf8;
• CREATE USER ‘openproject’`'localhost' IDENTIFIED BY 'pass';
  • GRANT ALL PRIVILEGES ON openproject.* TO 'openproject'`‘localhost’;
• \q

3. Use this code:

wget -qO - https://deb.packager.io/key | sudo apt-key add - echo "deb https://deb.packager.io/gh/opf/openproject-ce trusty stable/5" | sudo tee /etc/apt/sources.list.d/openproject.list sudo apt-get update -y sudo apt-get install openproject -y sudo openproject configure

4. Restore you DB in this new Install

To upgrade use this code, but you need to change the file: /etc/yum.repos.d/openproject.repo

default is: stable/5, change to stable/6

5. Run updates:

apt-get update -y apt-get upgrade -y

6. Finally run:

apt-get update -y apt-get install --only-upgrade openproject -y openproject configure

Best upgade!

Thank you for your extensive answer!

I did not use the packaged install, as you suggested. But you did bring me to idea that the Openproject app and the MySQL database are two separate things. So I just did a new OP install using GitHub and skipped the db:create command.

This resulted in a working OP v6.04

Thanks!

A variation of this is to bring ‘stable/6’ into the same folder as you had ‘stable/5’. To do this:

1. Edit your .git/config file and replace ‘fetch = +refs/heads/stable/5:refs/remotes/origin/stable/5’ with ‘fetch = +refs/heads/:refs/remotes/origin/’
2. Run ‘git fetch’
3. Checkout latest stable/6 with ‘git checkout -b stable/6 origin/stable/6’