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.

openproject configure

Output begins:

Launching installer for openproject...
Selected addons: legacy-installer postgres apache2 repositories smtp memcached openproject

It should read:

Selected addons: legacy-installer mysql apache2 repositories smtp memcached openproject

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/

READ ALSO
How to set mysql user variable at every new connection in Laravel 5.5?

How to set mysql user variable at every new connection in Laravel 5.5?

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...

48
Mysql adding index for column type text does not improve performance while using select query

Mysql adding index for column type text does not improve performance while using select query

I am using InnoDBFrom this question, I found out that I have to specify the length if I want to add index to columns which type is TEXT

52
How to find cpanel credential? [on hold]

How to find cpanel credential? [on hold]

I am facing a mail server Debian 7Few years ago, roundcube 0

25