Hi, I've been using it for months, accumulating valuable work, Bitnami Openproject 7.2.3 in a GoogleCloud instance and I've saved a database backup. Now I installed the Bitnami Openproject 7.4.2 stack on my Ubuntu 16.04. and starting phpmyadmin I imported the database I had. Openproject shows me everything but does not show me the workpackage, giving me an error regarding the mysql query. Is there a particular way to save / import my db?

Another question: I noticed that the stack is very comfortable, from the layman I wonder if you can install it on a virtual server and use the software with the same simplicity (solving the db first)

If so, could you let us know the error that it shows? In addition, we have a Support Tool that will gather relevant information for us to debug the issue. Could you please download and execute it on the machine where the stack is running by following the steps described in the guide below?

Thank you so much for your availability in the meantime and I apologize for my English (google translate). I'm afraid of having communicated badly. I explain better and summarize the starting situation:

on google cloud I have a working bitnami-openproject 7.2.3 on which I work from which I made a backup of the db

on my desktop pc runs mariaddb server with mariadb-client and I have installed in /opt the ubuntu version of openproject from the repository that I can not make go

I installed bitnami openproject stack in /home/myuser/openproject-7.4.2-0 which works perfectly, but on which I can not load the db saved from version 7.2.3 of googlecloud

Since I messed up a lot, I uninstalled and reinstalled the stack in point 3) above, so I'll follow your suggestions to the letter. But I go guided step by step .... for example, the guide you suggested does not take into account the situation in which I find myself because the mysql server is in /home/myuser/openproject-7.4.2-0 and i think so for every expected command including ruby.

I stopped mariadb on Ubuntu for security with "service mysql stop" Then:

Great jsalmeron, I have only fixed some paths inserting openproject-7.4.2-0/ before apps/ In fact from the terminal I have seen proceeding all the steps. Unfortunately, however, at the launch of openproject in the browser http://localhost:8081/openproject/I get an error:

We're sorry, but something went wrong.
The issue has been logged for investigation. Please try again later.
Technical details for the administrator of this website
Error:
Web application could not be started
Error ID:
4f07eb6b
Details:
Web application could not be started by the Phusion Passenger application server.
Please read the Passenger log file (search for the Error ID) to find the details of the error.
You can also get a detailed report to appear directly on this page, but for security reasons it is only provided if Phusion Passenger is run with environment set to development and/or with the friendly error pages option set to on.

at the bottom of file error_log:

[ 2018-04-03 18:50:34.2294 10294/7f1dabfff700 age/Cor/Con/CheckoutSession.cpp:285 ]: [Client 4-1] Cannot checkout session because a spawning error occurred. The identifier of the error is 767b1675. Please see earlier logs for details about the error.

Thank you for sharing this information with us. We followed the steps in our documentation and we could migrate all the information from OpenProject 7.2.3 to 7.4.2 without problems. We created some example projects and users in the first installation and they existed in the second one.

Regarding the information of the Bitnami support tool, we found the following information:

Our documentation about how to upgrade the application explains that you need to create the database first and set the password in the configuration file of the app, did you set the proper password? You can get it from the installdir/apps/openproject/htdocs/config/database.yml file of the new installation

I redid the update without getting any errors except the failed start of delayed_job server. I open the console and try to open mysql, I enter and see the db with my tables. If I try to open the openproject application I get the error to access the page again