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. Issues installing OpenProject on Ubuntu Server

Issues installing OpenProject on Ubuntu Server

Added by Joaquin Aguilera Urbina over 8 years ago

Hello, im trying to install OpenProject on a Ubuntu Server 16.04.2, this server already has Apache and MySQL but when I try to run sudo openproject configure this is the result that I get:
Launching installer for openproject…
Selected addons: legacy-installer mysql apache2 repositories smtp memcached openproject
[legacy-installer] ./bin/configure
[mysql] ./bin/configure
MySQL connection OK
DONE
[apache2] ./bin/configure
DONE
[repositories] ./bin/configure
No server installed. Skipping.
DONE
[smtp] ./bin/configure
DONE
[memcached] ./bin/configure
DONE
[openproject] ./bin/configure
[legacy-installer] ./bin/preinstall
[mysql] ./bin/preinstall
[apache2] ./bin/preinstall
[repositories] ./bin/preinstall
[smtp] ./bin/preinstall
[memcached] ./bin/preinstall
[openproject] ./bin/preinstall
[legacy-installer] ./bin/postinstall
[mysql] ./bin/postinstall
Generating /etc/openproject/conf.d/database…
[apache2] ./bin/postinstall
[repositories] ./bin/postinstall
[smtp] ./bin/postinstall
[memcached] ./bin/postinstall
[openproject] ./bin/postinstall
WARNING: Nokogiri was built against LibXML version 2.9.1, but has dynamically loaded 2.9.3
WARNING: Nokogiri was built against LibXML version 2.9.1, but has dynamically loaded 2.9.3
rake aborted!
LoadError: Could not load ‘active_record/connection_adapters/mysql2_adapter’. Make sure that the adapter in config/database.yml is valid. If you use an adapter other than ‘mysql’, ‘mysql2’, ‘postgresql’ or ‘sqlite3’ add the necessary adapter gem to the Gemfile.
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activesupport-4.2.7.1/lib/active_support/dependencies.rb:274:in `require’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activesupport-4.2.7.1/lib/active_support/dependencies.rb:274:in `block in require’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activesupport-4.2.7.1/lib/active_support/dependencies.rb:240:in `load_dependency’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activesupport-4.2.7.1/lib/active_support/dependencies.rb:274:in `require’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/mysql2-0.4.3/lib/mysql2.rb:31:in `<top (required)>’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activesupport-4.2.7.1/lib/active_support/dependencies.rb:274:in `require’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activesupport-4.2.7.1/lib/active_support/dependencies.rb:274:in `block in require’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activesupport-4.2.7.1/lib/active_support/dependencies.rb:240:in `load_dependency’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activesupport-4.2.7.1/lib/active_support/dependencies.rb:274:in `require’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.7.1/lib/active_record/connection_adapters/mysql2_adapter.rb:4:in `<top (required)>’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activesupport-4.2.7.1/lib/active_support/dependencies.rb:274:in `require’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activesupport-4.2.7.1/lib/active_support/dependencies.rb:274:in `block in require’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activesupport-4.2.7.1/lib/active_support/dependencies.rb:240:in `load_dependency’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activesupport-4.2.7.1/lib/active_support/dependencies.rb:274:in `require’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.7.1/lib/active_record/connection_adapters/connection_specification.rb:175:in `spec’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.7.1/lib/active_record/connection_handling.rb:50:in `establish_connection’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.7.1/lib/active_record/railtie.rb:120:in `block (2 levels) in class:Railtie’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activesupport-4.2.7.1/lib/active_support/lazy_load_hooks.rb:38:in `instance_eval’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activesupport-4.2.7.1/lib/active_support/lazy_load_hooks.rb:38:in `execute_hook’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activesupport-4.2.7.1/lib/active_support/lazy_load_hooks.rb:28:in `block in on_load’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activesupport-4.2.7.1/lib/active_support/lazy_load_hooks.rb:27:in `each’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activesupport-4.2.7.1/lib/active_support/lazy_load_hooks.rb:27:in `on_load’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.7.1/lib/active_record/railtie.rb:116:in `block in class:Railtie’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/railties-4.2.7.1/lib/rails/initializable.rb:30:in `instance_exec’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/railties-4.2.7.1/lib/rails/initializable.rb:30:in `run’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/railties-4.2.7.1/lib/rails/initializable.rb:55:in `block in run_initializers’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/railties-4.2.7.1/lib/rails/initializable.rb:54:in `run_initializers’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/railties-4.2.7.1/lib/rails/application.rb:352:in `initialize!’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/railties-4.2.7.1/lib/rails/railtie.rb:194:in `public_send’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/railties-4.2.7.1/lib/rails/railtie.rb:194:in `method_missing’
/opt/openproject/config/environment.rb:34:in `<top (required)>’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activesupport-4.2.7.1/lib/active_support/dependencies.rb:274:in `require’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activesupport-4.2.7.1/lib/active_support/dependencies.rb:274:in `block in require’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activesupport-4.2.7.1/lib/active_support/dependencies.rb:240:in `load_dependency’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activesupport-4.2.7.1/lib/active_support/dependencies.rb:274:in `require’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/railties-4.2.7.1/lib/rails/application.rb:328:in `require_environment!’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/railties-4.2.7.1/lib/rails/application.rb:457:in `block in run_tasks_blocks’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/rake-11.2.2/exe/rake:27:in `<top (required)>’
LoadError: libmysqlclient.so.18: cannot open shared object file: No such file or directory - /opt/openproject/vendor/bundle/ruby/2.1.0/extensions/x86_64-linux/2.1.0-static/mysql2-0.4.3/mysql2/mysql2.so
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activesupport-4.2.7.1/lib/active_support/dependencies.rb:274:in `require’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activesupport-4.2.7.1/lib/active_support/dependencies.rb:274:in `block in require’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activesupport-4.2.7.1/lib/active_support/dependencies.rb:240:in `load_dependency’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activesupport-4.2.7.1/lib/active_support/dependencies.rb:274:in `require’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/mysql2-0.4.3/lib/mysql2.rb:31:in `<top (required)>’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activesupport-4.2.7.1/lib/active_support/dependencies.rb:274:in `require’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activesupport-4.2.7.1/lib/active_support/dependencies.rb:274:in `block in require’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activesupport-4.2.7.1/lib/active_support/dependencies.rb:240:in `load_dependency’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activesupport-4.2.7.1/lib/active_support/dependencies.rb:274:in `require’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.7.1/lib/active_record/connection_adapters/mysql2_adapter.rb:4:in `<top (required)>’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activesupport-4.2.7.1/lib/active_support/dependencies.rb:274:in `require’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activesupport-4.2.7.1/lib/active_support/dependencies.rb:274:in `block in require’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activesupport-4.2.7.1/lib/active_support/dependencies.rb:240:in `load_dependency’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activesupport-4.2.7.1/lib/active_support/dependencies.rb:274:in `require’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.7.1/lib/active_record/connection_adapters/connection_specification.rb:175:in `spec’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.7.1/lib/active_record/connection_handling.rb:50:in `establish_connection’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.7.1/lib/active_record/railtie.rb:120:in `block (2 levels) in class:Railtie’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activesupport-4.2.7.1/lib/active_support/lazy_load_hooks.rb:38:in `instance_eval’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activesupport-4.2.7.1/lib/active_support/lazy_load_hooks.rb:38:in `execute_hook’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activesupport-4.2.7.1/lib/active_support/lazy_load_hooks.rb:28:in `block in on_load’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activesupport-4.2.7.1/lib/active_support/lazy_load_hooks.rb:27:in `each’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activesupport-4.2.7.1/lib/active_support/lazy_load_hooks.rb:27:in `on_load’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.7.1/lib/active_record/railtie.rb:116:in `block in class:Railtie’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/railties-4.2.7.1/lib/rails/initializable.rb:30:in `instance_exec’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/railties-4.2.7.1/lib/rails/initializable.rb:30:in `run’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/railties-4.2.7.1/lib/rails/initializable.rb:55:in `block in run_initializers’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/railties-4.2.7.1/lib/rails/initializable.rb:54:in `run_initializers’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/railties-4.2.7.1/lib/rails/application.rb:352:in `initialize!’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/railties-4.2.7.1/lib/rails/railtie.rb:194:in `public_send’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/railties-4.2.7.1/lib/rails/railtie.rb:194:in `method_missing’
/opt/openproject/config/environment.rb:34:in `<top (required)>’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activesupport-4.2.7.1/lib/active_support/dependencies.rb:274:in `require’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activesupport-4.2.7.1/lib/active_support/dependencies.rb:274:in `block in require’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activesupport-4.2.7.1/lib/active_support/dependencies.rb:240:in `load_dependency’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activesupport-4.2.7.1/lib/active_support/dependencies.rb:274:in `require’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/railties-4.2.7.1/lib/rails/application.rb:328:in `require_environment!’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/railties-4.2.7.1/lib/rails/application.rb:457:in `block in run_tasks_blocks’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/rake-11.2.2/exe/rake:27:in `<top (required)>’
Tasks: TOP => db:migrate => environment
(See full trace by running task with —trace)

I checked that file in /opt/openproject/vendor/bundle/ruby/2.1.0/extensions/x86_64-linux/2.1.0-static/mysql2-0.4.3/mysql2/mysql2.so exists and it has 777 perms and the database.yml has the next:
production:
adapter: mysql
database: openproject
host: localhost
username: openproject
password: node248-l
encoding: utf8

development:
adapter: mysql
database: openproject_development
host: localhost
username: openproject
password: node248-l
encoding: utf8

databases are tested and working so I don’t know what could be the issue


Replies (10)

RE: Issues installing OpenProject on Ubuntu Server - Added by Oliver Günther over 8 years ago

Hey Joaquin,

users were seeing this exact issue when using the Ubuntu 14.04. package source instead of the 16.04. package source.
For OpenProject 6.x, this source is:

https://deb.packager.io/gh/opf/openproject-ce xenial stable/6

Best,
Oliver

RE: Issues installing OpenProject on Ubuntu Server - Added by Simon Knappe over 8 years ago

I’ve got exact the same problem. Fresh Ubuntu Server 16.04.1 installation, then:

wget -qO - https://deb.packager.io/key | sudo apt-key add - echo "deb https://deb.packager.io/gh/opf/openproject-ce xenial stable/6" | sudo tee /etc/apt/sources.list.d/openproject.list sudo apt-get update sudo apt-get install openproject openproject configure

results in error

LoadError: Could not load 'active_record/connection_adapters/mysql2_adapter'. Make sure that the adapter in config/database.yml is valid. If you use an adapter other than 'mysql', 'mysql2', 'postgresql' or 'sqlite3' add the necessary adapter gem to the Gemfile.

Is there any solution?

RE: Issues installing OpenProject on Ubuntu Server - Added by Oliver Günther over 8 years ago

Hi Simon,

thanks for weighing in. This issue is rooted in the LoadError a few lines below in the backtrace (cf. OPs log output):

LoadError: libmysqlclient.so.18: cannot open shared object file: No such file or directory - /opt/openproject/vendor/bundle/ruby/2.1.0/extensions/x86_64-linux/2.1.0-static/mysql2-0.4.3/mysql2/mysql2.so

The packages bundled mysql gem fails to locate the shared library, which means that the buildpack is wrongly referencing it.
I’ve created a bug report for it here:

Best,
Oliver

RE: Issues installing OpenProject on Ubuntu Server - Added by Joaquin Aguilera Urbina over 8 years ago

Good morning, Oliver,

Do you know if is there any quick fix to this, that I could made? because I do really need to set OpenPoject as soon as possible on my server. If necesary I could install any old version that can be ran on Ubuntu Server 16.04

Greetings, Joaquin

RE: Issues installing OpenProject on Ubuntu Server - Added by Jason Bowman over 8 years ago

Greetings all,

I am trying to demo this option for my boss today.

Is there a quick workaround? Maybe an older version that we can upgrade from later?
Would you recommend a manual install?

Same issues and errors as above. Installing via packager.io repository on a fresh Ubuntu 16.04.

Thank you,
Jason B.

RE: Issues installing OpenProject on Ubuntu Server - Added by Jason Bowman over 8 years ago

Quick side note. I get the same LoadError as above and noticed that the referenced file does exist on my system:

# ls -la /opt/openproject/vendor/bundle/ruby/2.1.0/extensions/x86_64-linux/2.1.0-static/mysql2-0.4.3/mysql2/mysql2.so
-rwxr-xr-x 1 openproject openproject 241712 Jul 28 06:25 /opt/openproject/vendor/bundle/ruby/2.1.0/extensions/x86_64-linux/2.1.0-static/mysql2-0.4.3/mysql2/mysql2.so

RE: Issues installing OpenProject on Ubuntu Server - Added by Andreas Metag over 8 years ago

i get the same Error, what can we do ?

RE: Issues installing OpenProject on Ubuntu Server - Added by Oliver Günther over 8 years ago

Hi everyone,

we have released a new stable/6 package with a fix for Ubuntu 16.04.
https://packager.io/gh/opf/openproject-ce/install?bid=175#ubuntu-16-04-openproject

Could you please try that version?

Best,
Oliver

RE: Issues installing OpenProject on Ubuntu Server - Added by Jason Bowman over 8 years ago

Thank you for the quick turn-around!!!

Can confirm that the configure process worked. Been up all night, so can’t test it fully right now. Will look at it tomorrow sometime.
- Jason B.

RE: Issues installing OpenProject on Ubuntu Server - Added by Andreas Metag over 8 years ago

Thank you,

installation working

  • (1 - 10/10)
Loading...