Good luck with that. I try this since 2 weeks. No support here or in bitnami forums. They all have abandoned us.

In my case I have a 8.1.0 Bitnami stack and want to move to 11.2.2 native installation.

I managed to get the 11.2.2 running and export a mysql-dump from my old 8.1.0 bitnami stack (thanks to an old documentation I wrote for myself).

Now I fail since two days to import the old data into the new installation because the included script is not working and all documentation from openproject reagarding this is filded with errors, beginning with the location of the migration script.

Right now I imported the dump into a new mysql Database on the new VM, but when I run the script it tells me that the target database is currently in use.

Hi Thorsten, Hi Ian,

we certainly want you to suceed in your migration from Bitnami to a current supported OpenProject version.

Please note that we do not support Bitnami stack and have no idea how their setup looks like. We need help from the community in this to improve the migration step.

This does not mean that we abandon you.

We recommend that you use the all-in-one migration docker container that gets as input an older dump, and updates it automatically for you to then use in a packaged installation: https://docs.openproject.org/installation-and-operations/misc/upgrading-older-openproject-versions/#run-the-docker-migration-script

Can you please elaborate on what steps of the migration guides are outdated?

https://docs.openproject.org/installation-and-operations/misc/upgrading-older-openproject-versions/

https://docs.openproject.org/installation-and-operations/operation/faq/#how-to-migrate-from-bitnami-to-the-official-openproject-installation-packages

Best

Oliver from OpenProject

So I have to install docker, otherwise there is no way to migrate the database?

But I do want to use a native installation of Openproject.

I tried it this way:

https://docs.openproject.org/installation-and-operations/misc/packaged-postgresql-migration/

But found the following problems: The migrate-mysql-to-postgresql script is located in a different folder. Also, while there is a package located in https://dl.packager.io/srv/opf/pgloader-ccl/master/installer/ubuntu/20.04.repo, it does not allow to install pgloader-ccl.

I installed the 18.04 pgloader-ccl and mysql, imported the old dump into the mysql database, set the MYSQL_DATABASE_URL and ran the script which gave me UNSUPPORTED AUTHENTICATION METHOD error. I found something for this error too, activating native_passwords_authentication in MYSQL. When I ran the script again it started to migrate, but went south and destroyed the whole openproject installation. Although I was able to run a reconfigure and created a new postgresql databse in the process, it never ran again. If you try to access it via browser you get internal error and in your shell a boatload of ruby errors.

As to the FAQ-entry about migrating from Bitnami to official packages:

It is, for me, really hard to understand what to do eith points 5 & 6.

• By default, this will allow you to install a PostgreSQL database, which we recommend. You can migrate your data from MySQL using https://pgloader.io
• Import the dump into your new database. You can get your configuration by running sudo openproject config:get DATABASE_URL

"migrate by using pgloader"... how? And which dump do I import in which new database? Up to point 5 everything is as simple as it can get and easy to follow (once you remember how to dump a binami mysql database, which is not that hard but they put down the relevant articles.). But then you are left alone to figure out how pgloard is working and what to do with it. thats why I continued my search and came up with what I did describe earlier.

As to why I feel abandoned: https://community.openproject.org/topics/13284 - 9 days, zero replies.

Ok, so installed docker on my fesh installed Ubuntu 20.04 using:

sudo apt-get install docker

Then I got the script from the link, in a .sh-file and made it executable. 

then I ran

sudo bash migrate-from-pre-8.sh host.docker.internal /home/senger/backup_26032021.sql [sql|custom]

and got:

migrate-from-pre-8.sh: line 51: docker: command not found
migrate-from-pre-8.sh: line 52: docker: command not found
custom]: command not foun

Any ideas?

Okay, turns out I installed the wrong docker. so i tested to run the docker command and Ubuntu told me to please install docker.io first. Whatever it installed before that I don't know. So, I installed docker.io. Then ran the same command line again for the script, thus changing my error output to:

custom]: command not found
Unable to find image 'mysql:5.6' locally
docker: Error response from daemon: Get https://registry-1.docker.io/v2/: dial tcp 18.214.230.110:443: connect: connection refused.
See 'docker run --help'.

I tried... I really tried... for hours...

I went to your linked docker website, being confronted with a whole new way to install docker, not using the Ubuntu-included repos. I wanted to use the full docker-container because maybe, just maybe 15th time is the charm... git clone worked fine, docker-compose pull resulted in unknown command.

So nothing changed... still jumping from error to error to error to error to error...

And here for another set of Errors. I promise those to be the last ones for today since I want to go home. I'm simply tired...

What did I do? I used yet another fresh install of Ubuntu20.04, installed the docker.io, set a proxy for docker, copied my dump and the bash script. left out the stuff in brackets at the end:

sudo bash migrate-from-pre-8.sh host.docker.internal /home/senger/tmp/backup_26032021.sql

Thus resulting in docker downloading and starting up mysql:5.6, openproject/community:7, openproject/community:8-mysql (still don't know why ist even started Openproject 7, since the dump is from a 8.1.0 bitnami stack...) and getting this error:

1.4) Creating MySQL database for migration from OP 7 to 8
migrate-from-pre-8.sh: line 82: mysql: command not found
 Could not create database

Another 7 days withou response... Is there really noone who can help?

Really? Nobody?

Hi Thorsten and Ian,

I just stumbled upon this thread.  I know this is an old one, but I'm on a similar quest.  I'm not on Bitnami, but attempting to upgrade and migrate from OP v8.3.2 to 9.x.x so I can then jump to the latest version.  First off, I want to let the OP team know how much I appreciate their software.  Our church uses it to manage our facilities, media, IT, etc., and it's been invaluable.  I wish we could afford to go enterprise and support the project further.

However, even with the enterprise support, I really want to know how to do the upgrade as a mere mortal too.  I've been at this off and on for 2-3 years now, or whenever v9 was released.  I just wanted to echo your frustrations as well with the migration process.  All the guides don't seem to match the experience, and are riddled with cryptic errors, mostly from Ruby in my case.

I am giving it another go, so I wanted to reach out and see if you ever discovered a solution to your issues, and if not, hopefully we might be able to crack this together.  Please let me know how you fared, and I hope you haven't given up entirely at this point.

Cheers,

Brian

Hi all, just for your information what is going on behind the scenes.

The script located at the description is maintained and usually migrates right away to latest (now 12) by doing this automatically in steps...

7 to 8, 8 to 9 conversion to PostgreSQL and then 9 to 12, maybe I am wrong with the details here, I am not the author of the script.

https://www.openproject.org/docs/installation-and-operations/misc/upgrading-older-openproject-versions/#migrating-from-an-old-mysql-database

If the wish is to migrate only to Version 9 then parts of the script most likely must be commented out.

It might help if you break the script yourself in these steps, for that some programming experience might be needed.

Also I recommend to add "set -x" and read every action, that is done by the script.

Brian: If your church is a non-profit or NGO, the Enterprise subscription would be discounted, unluckily OpenProject just offers support for the migration from MySQL databases within our one-year Premium Enterprise subscription.

On the other hand if you have an OpenProject Version 7,8 with already PostgreSQL installed, we would offer support in the one-year Basic Enterprise subscription, too.

Wish you good luck and fingers crossed.

Kind regards, Adam

Hi Adam,

Thank you for the info.  I am moving to v12 once I make it past this migration hurdle.  On a test system I seem to make it further with this script than the manual methods I was accustomed to 2-3 years ago.  However, before I can truly give it a test run, I have to work around the complications of running Docker inside my OpenProject LXC container, or setup a remote system to offload it too.  I will report back with my progress assuming I have anything useful to share.

Thanks again,

Brian