Top Menu

Jump to content
Home
    Modules
      • Projects
      • Activity
      • Work packages
      • Gantt charts
      • Calendars
      • Team planners
      • Boards
      • News
    • Getting started
    • Introduction video
      Welcome to OpenProject Community
      Get a quick overview of project management and team collaboration with OpenProject. You can restart this video from the help menu.
    • Help and support
    • User guides
    • Videos
    • Shortcuts
    • Community forum
    • Enterprise support
    • Additional resources
    • Data privacy and security policy
    • Digital accessibility (DE)
    • OpenProject website
    • Security alerts / Newsletter
    • OpenProject blog
    • Release notes
    • Report a bug
    • Development roadmap
    • Add and edit translations
    • API documentation
  • Sign in
      Forgot your password?

      or sign in with your existing account

      Google

Side Menu

  • Overview
  • Activity
    Activity
  • Roadmap
  • Work packages
    Work packages
  • Gantt charts
    Gantt charts
  • Calendars
    Calendars
  • Team planners
    Team planners
  • Boards
    Boards
  • News
  • Forums

Content

You are here:
  1. Messages
Support Installation & Updates
  1. OpenProject
  2. Forums
  3. Support Installation & Updates
  4. Installing OpenProject with existing mariadb

Installing OpenProject with existing mariadb

Added by Andreas Hartmann about 6 years ago

I'm having an issue installing OpenProject on my Ubuntu 18.04 server with an existing mariadb:

  1. Installed OpenProject package according to the instructions from the repository.
  2. openproject configure/reconfigure -> reuse existing DB
  3. configure everything correctly, then when it should connect to the DB:

(Reading database ... 293681 files and directories currently installed.) 
Removing mariadb-server (1:10.1.38-0ubuntu0.18.04.1) ... 
Removing mariadb-server-10.1 (1:10.1.38-0ubuntu0.18.04.1) ... 
dpkg: mariadb-client-10.1: dependency problems, but removing anyway as you requested: 
dbconfig-mysql depends on default-mysql-client | virtual-mysql-client; however: 
 Package default-mysql-client is not installed. 
 Package virtual-mysql-client is not installed. 
 Package mariadb-client-10.1 which provides virtual-mysql-client is to be removed. 

Removing mariadb-client-10.1 (1:10.1.38-0ubuntu0.18.04.1) ... 
Removing mariadb-client-core-10.1 (1:10.1.38-0ubuntu0.18.04.1) ... 
Selecting previously unselected package mysql-client-5.7. 
(Reading database ... 293500 files and directories currently installed.) 
Preparing to unpack .../mysql-client-5.7_5.7.25-0ubuntu0.18.04.2_amd64.deb ... 
Unpacking mysql-client-5.7 (5.7.25-0ubuntu0.18.04.2) ... 
Selecting previously unselected package mysql-client-core-5.7. 
Preparing to unpack .../mysql-client-core-5.7_5.7.25-0ubuntu0.18.04.2_amd64.deb ... 
Unpacking mysql-client-core-5.7 (5.7.25-0ubuntu0.18.04.2) ... 
Selecting previously unselected package mysql-client. 
Preparing to unpack .../mysql-client_5.7.25-0ubuntu0.18.04.2_all.deb ... 
Unpacking mysql-client (5.7.25-0ubuntu0.18.04.2) ... 
Processing triggers for man-db (2.8.3-2ubuntu0.1) ... 
Setting up mysql-client-core-5.7 (5.7.25-0ubuntu0.18.04.2) ... 
Setting up mysql-client-5.7 (5.7.25-0ubuntu0.18.04.2) ... 
Setting up mysql-client (5.7.25-0ubuntu0.18.04.2) ... 
W: --force-yes is deprecated, use one of the options starting with --allow instead. 
ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (111)

So basically, attempting to connect OpenProject to a local mariadb is impossible, because it requires "mysql-client" to be installed. So it forces "mysql-client" to be installed which causes mariadb-server to be uninstalled without the user being asked! (!!!)

It sucks that it doesn't seem to work with mariadb, but just uninstalling packages without the user's consent is pretty atrocious. Luckily the DB data itself isn't deleted.

Is there any way to get this to run with mariadb?


Loading...