Openproject installing to PostGre instead of MySQL

41

March 15, 2019, at 8:10 PM

Installing Openproject to a rented Ubuntu 18.04 server.
After following installation proceedure as described at https://www.openproject.org/download-and-installation/#installation, I'm at the initial configuration stage.

Takes me to the page postgres/autoinstall. Should be mysql/autoinstall.

How do I fix this?

Answer 1

With OpenProject 8.3.0, the packaged installation only provides automatic installers for PostgreSQL for several reasons, among others:

MySQL was / is not supported on all distributions we support, so we had to rely on MariaDB on some flavors that resulted in problems when trying to detect whether a DBMS was already present. This has caused troubles for users with existing custom MySQL packages on these distributions, since the autoinstall wizard will remove that package on-the-fly

Some features of OpenProject are not supported, or less performant on stable MySQL versions (which is often still 5.6. on distributions we support). One example is the full text search, which comes with MySQL 8.0 but is highly different from PostgreSQL. OpenProject is slowly going to shift to PostgreSQL.

For more information, here's the release blog with a section regarding this change: https://www.openproject.org/openproject-8-3-0-released/

Background: We rely heavily on views in our app and one of the ways in which we are looking to optimize them is by parameterizationWe've got that aspect all figured out, but in order to make it work, I must be able to set a user parameter for the customer...