Hello, have you tried running openproject reconfigure and selecting Use existing database instead of installing it? It should then just go ahead and ask you for existing database details and not install the MySQL packages.

Thank you for your answer! Well right, this was the clue … reconfigured and saw that I could chose this.

My problem now ist, that it won’t take the database. I can include all the data (created database and user, flushed privileges and so on) but the result is as follows:

E: Unable to correct problems, you have held broken packages.

Any ideas what I have been missing?

Who did a good install with mariadb preinstalled and might have some advice for the ongoing installation?

Thanks in advance.

Hi Jens,

The error stems from APT and reads like you are holding packages that openproject might want to install.

Check the list of held packages with:
dpkg --get-selections | grep hold

Best,
Oliver

Hey,

still no luck :-(

• I refreshed testing-system and did the following:

apt-get install mariadb-server
apt-get install openproject

• The I created a new database in mariadb with clean install (user openproject, db-name the same)
• the I started configuring, but it wouldn’t take the database, did then the configuring with skipping DB
• Then I tried to configure DB manually: openproject config:set DATABASE_URL="mysql://openproject:*PW*localhost/openproject"@ —> that didn’t do the job, since configure/database.yml was still empty
• then I copied the example-database.yml to database.yml and put in all the credentials that I had and commented out development/testing

—> always I do get now the following error:

[openproject] ./bin/postinstall
rake aborted!
LoadError: Could not load 'active_record/connection_adapters/mysql_adapter'. Make sure that the adapter in config/database.yml is valid. If you use an adapter other than 'mysql2', 'postgresql' or 'sqlite3' add the necessary adapter gem to the Gemfile.

Anybody any ideas what I’m missing?

Thanks in advance, and thanks for your support, Oliver, before! Jens.

I’ve exactly the same problem here on a Jessie (Debian 8) with mariadb previously installed. I guess you’ve reinstalled OpenProject since 9 month but I’ve found a workaround, maybe it can help others.

Solution:

1) Install mariadb-client if not already done :
$sudo apt-get install mariadb-client

2) edit /usr/share/openproject/installer/addons/mysql/bin/configure
replace Line 133 “mysql-client” with “mariadb-client” in the input_check function, save the file, exit editor

3) retry :
$ openproject reconfigure

Hope it helps.

This problem is even worse on Ubuntu 16.04 with mariadb installed.
I asked to install with mysql, since mariadb is a drop in replacement.
The installer uninstalled mariadb and tried to reinstall mysql!
I have mariadb in use for other purposes, so it broke the system.
There is a bug in Ubuntu 16.04 which prevents reinstalling mysql once mariadb has been installed.
Please add a warning and choice before uninstalling mariadb! An installer should not high handedly uninstall other packages, at least without warning and an op-out.
I will see if I can fix up the machine, and report back.

Ted