Hello! I tried installing OpenProject on Debian 11. During postinstall, I encountered the error attached in the log. Any ideas?

Hi Mine

1. not connected to your question: in config.txt i see server should be install and not skip, i dont know how you found a way to set SSL yes if you chose to skip the webserver install
2. please share the URL of the doc that you used to install OpenProject on Debian 11. please also share your teminal output during installation, with what you shared i just suppose there is a problem with the ruby - maybe the version? - on your debian for unknown reasons.

Hello, thanks for the reply.

1. I just ran openproject reconfigure and that option was available.
2. I used this doc for installing OpenProject. Apart from the error in the attached log, there was no other useful information printed on the terminal during installation (every other step seems to be completed successfully, postgres connection is ok, etc.). Output of ruby --version is ruby 2.7.4p191 (2021-07-07 revision a21a3b7d23) [x86_64-linux-gnu]. The system is also fully updated.

A bit of backstory, I had an old OpenProject installation on docker and wanted to install the update on bare metal. I already had postgres set up on bare metal, so I exported the db from the containerized postgres and imported it to the bare metal installation. Nginx is also installed, so this is why I skipped the apache installation.

what version of OP is the database, did you migrate the database to postgres 13.8?

https://www.openproject.org/docs/installation-and-operations/misc/

Postgres inside docker is in version psql (PostgreSQL) 13.1 (Debian 13.1-1.pgdg100+1). Is any migration necessary? What does the error message indicate anyway?

Hi

Sorry but I have only some recommendations here as I am not a Programmer and I do not know that error.

Please try to install all default from zero, do also a clean OS Install, then a clean OpenProject Install with the docs you shared, try not to make it too custom because we must minimize the source of errors. you can change those things later if it is once running, lets work in small steps.

In the configure wizard please install the database and also the apache

It comes with postgres 13.8 and not 13.1, you will need to maybe migrate some things from your docker but it shall be done by the configure automatically just you run in an error.

Other idea is to upgrade your docker OpenProject to 12.2.5 and then try your approach with what you did before.

I found some old notes, maybe they help you, i just copy paste them without commenting them

Legacy PSQL Dump Import to clean NEW OpenProject Packaged Installation

1.Save your instance's attachments. For package installations, these are under /var/db/openproject/files, but if you are still running a manual installation with Passenger, they may be in the installation location (it's best to check the OpenProject Apache configuration under /etc/apache2/sites-enabled/

2. Completely remove the OpenProject package via apt remove --purge openproject

3. Remove the Passenger configuration / installation that may still be present in Apache2 (at least that's my guess).

4. Install the latest version of OpenProject following our instructions https://www.openproject.org/docs/installation-and-operations/installation/packaged/

5. In the installation, select "Install a new PostgreSQL database" and fill out the rest of the configuration as your server is currently configured

6. This will result in a fresh, empty install. When that's over. Put your PSQL dump under /tmp/postgresql-dump.sql

7. Stop the OpenProject servers with service openproject stop

8. Switch to the postgres user with su - postgres and run the following commands

dropdb openproject createdb -O openproject psql -d openproject < /tmp/postgresql-dump.sql exit

9. You should now be root again. Run openproject configure again. The OpenProject server then restarts.

10. The OpenProject installation should now be up to date and contain your data.