Content
OpenProject configuration error
Added by Marcelo Magalhães about 7 years ago
I’m trying to setup OpenProject on one server with Centos 7 and MySQL Server on another server. The MySQL server is configured correctly, because I test the connection with the user that I set for OpenPrroject (does not have root privileges in MySQL). In the middle of the setup the error below appears and nothing is installed. What is happening?
DONE
[openproject] ./bin/configure
[legacy-installer] ./bin/preinstall
[mysql] ./bin/preinstall
[apache2] ./bin/preinstall
Nota: Encaminhando requisição para ‘systemctl enable httpd.service’.
[repositories] ./bin/preinstall
[smtp] ./bin/preinstall
[memcached] ./bin/preinstall
No memcached server to install. Skipping.
[openproject] ./bin/preinstall
[legacy-installer] ./bin/postinstall
[mysql] ./bin/postinstall
Generating /etc/openproject/conf.d/database…
[apache2] ./bin/postinstall
Redirecting to /bin/systemctl restart httpd.service
[repositories] ./bin/postinstall
Setting up SVN integration for Apache
Redirecting to /bin/systemctl restart httpd.service
[smtp] ./bin/postinstall
[memcached] ./bin/postinstall
[openproject] ./bin/postinstall
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 ‘mysql2’, ‘postgresql’ or ‘sqlite3’ add the necessary adapter gem to the Gemfile.
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/activesupport-5.0.6/lib/active_support/dependencies.rb:293:in `require’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/activesupport-5.0.6/lib/active_support/dependencies.rb:293:in `block in require’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/activesupport-5.0.6/lib/active_support/dependencies.rb:259:in `load_dependency’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/activesupport-5.0.6/lib/active_support/dependencies.rb:293:in `require’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/mysql2-0.4.9/lib/mysql2.rb:31:in `<top (required)>’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/activesupport-5.0.6/lib/active_support/dependencies.rb:293:in `require’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/activesupport-5.0.6/lib/active_support/dependencies.rb:293:in `block in require’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/activesupport-5.0.6/lib/active_support/dependencies.rb:259:in `load_dependency’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/activesupport-5.0.6/lib/active_support/dependencies.rb:293:in `require’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/mysql2_adapter.rb:5:in `<top (required)>’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/activesupport-5.0.6/lib/active_support/dependencies.rb:293:in `require’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/activesupport-5.0.6/lib/active_support/dependencies.rb:293:in `block in require’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/activesupport-5.0.6/lib/active_support/dependencies.rb:259:in `load_dependency’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/activesupport-5.0.6/lib/active_support/dependencies.rb:293:in `require’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/connection_specification.rb:174:in `spec’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/activerecord-5.0.6/lib/active_record/connection_handling.rb:53:in `establish_connection’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/activerecord-5.0.6/lib/active_record/railtie.rb:125:in `block (2 levels) in class:Railtie’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/activesupport-5.0.6/lib/active_support/lazy_load_hooks.rb:69:in `instance_eval’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/activesupport-5.0.6/lib/active_support/lazy_load_hooks.rb:69:in `block in execute_hook’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/activesupport-5.0.6/lib/active_support/lazy_load_hooks.rb:60:in `with_execution_control’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/activesupport-5.0.6/lib/active_support/lazy_load_hooks.rb:65:in `execute_hook’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/activesupport-5.0.6/lib/active_support/lazy_load_hooks.rb:41:in `block in on_load’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/activesupport-5.0.6/lib/active_support/lazy_load_hooks.rb:40:in `each’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/activesupport-5.0.6/lib/active_support/lazy_load_hooks.rb:40:in `on_load’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/activerecord-5.0.6/lib/active_record/railtie.rb:121:in `block in class:Railtie’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/railties-5.0.6/lib/rails/initializable.rb:30:in `instance_exec’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/railties-5.0.6/lib/rails/initializable.rb:30:in `run’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/railties-5.0.6/lib/rails/initializable.rb:55:in `block in run_initializers’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/railties-5.0.6/lib/rails/initializable.rb:54:in `run_initializers’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/railties-5.0.6/lib/rails/application.rb:352:in `initialize!’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/railties-5.0.6/lib/rails/railtie.rb:193:in `public_send’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/railties-5.0.6/lib/rails/railtie.rb:193:in `method_missing’
/opt/openproject/config/environment.rb:34:in `<top (required)>’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/activesupport-5.0.6/lib/active_support/dependencies.rb:293:in `require’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/activesupport-5.0.6/lib/active_support/dependencies.rb:293:in `block in require’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/activesupport-5.0.6/lib/active_support/dependencies.rb:259:in `load_dependency’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/activesupport-5.0.6/lib/active_support/dependencies.rb:293:in `require’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/railties-5.0.6/lib/rails/application.rb:328:in `require_environment!’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/railties-5.0.6/lib/rails/application.rb:448:in `block in run_tasks_blocks’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/rake-12.1.0/exe/rake:27:in `<top (required)>’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.1/lib/bundler/cli/exec.rb:74:in `load’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.1/lib/bundler/cli/exec.rb:74:in `kernel_load’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.1/lib/bundler/cli/exec.rb:27:in `run’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.1/lib/bundler/cli.rb:360:in `exec’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.1/lib/bundler/vendor/thor/lib/thor/command.rb:27:in `run’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.1/lib/bundler/vendor/thor/lib/thor/invocation.rb:126:in `invoke_command’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.1/lib/bundler/vendor/thor/lib/thor.rb:369:in `dispatch’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.1/lib/bundler/cli.rb:20:in `dispatch’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.1/lib/bundler/vendor/thor/lib/thor/base.rb:444:in `start’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.1/lib/bundler/cli.rb:10:in `start’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.1/exe/bundle:35:in `block in <top (required)>’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.1/lib/bundler/friendly_errors.rb:121:in `with_friendly_errors’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.1/exe/bundle:27:in `<top (required)>’
/opt/openproject/bin/bundle:3:in `load’
/opt/openproject/bin/bundle:3:in `
’
LoadError: libmysqlclient.so.18: cannot open shared object file: No such file or directory - /opt/openproject/vendor/bundle/ruby/2.4.0/gems/mysql2-0.4.9/lib/mysql2/mysql2.so
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/activesupport-5.0.6/lib/active_support/dependencies.rb:293:in `require’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/activesupport-5.0.6/lib/active_support/dependencies.rb:293:in `block in require’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/activesupport-5.0.6/lib/active_support/dependencies.rb:259:in `load_dependency’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/activesupport-5.0.6/lib/active_support/dependencies.rb:293:in `require’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/mysql2-0.4.9/lib/mysql2.rb:31:in `<top (required)>’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/activesupport-5.0.6/lib/active_support/dependencies.rb:293:in `require’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/activesupport-5.0.6/lib/active_support/dependencies.rb:293:in `block in require’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/activesupport-5.0.6/lib/active_support/dependencies.rb:259:in `load_dependency’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/activesupport-5.0.6/lib/active_support/dependencies.rb:293:in `require’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/mysql2_adapter.rb:5:in `<top (required)>’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/activesupport-5.0.6/lib/active_support/dependencies.rb:293:in `require’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/activesupport-5.0.6/lib/active_support/dependencies.rb:293:in `block in require’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/activesupport-5.0.6/lib/active_support/dependencies.rb:259:in `load_dependency’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/activesupport-5.0.6/lib/active_support/dependencies.rb:293:in `require’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/connection_specification.rb:174:in `spec’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/activerecord-5.0.6/lib/active_record/connection_handling.rb:53:in `establish_connection’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/activerecord-5.0.6/lib/active_record/railtie.rb:125:in `block (2 levels) in class:Railtie’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/activesupport-5.0.6/lib/active_support/lazy_load_hooks.rb:69:in `instance_eval’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/activesupport-5.0.6/lib/active_support/lazy_load_hooks.rb:69:in `block in execute_hook’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/activesupport-5.0.6/lib/active_support/lazy_load_hooks.rb:60:in `with_execution_control’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/activesupport-5.0.6/lib/active_support/lazy_load_hooks.rb:65:in `execute_hook’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/activesupport-5.0.6/lib/active_support/lazy_load_hooks.rb:41:in `block in on_load’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/activesupport-5.0.6/lib/active_support/lazy_load_hooks.rb:40:in `each’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/activesupport-5.0.6/lib/active_support/lazy_load_hooks.rb:40:in `on_load’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/activerecord-5.0.6/lib/active_record/railtie.rb:121:in `block in class:Railtie’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/railties-5.0.6/lib/rails/initializable.rb:30:in `instance_exec’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/railties-5.0.6/lib/rails/initializable.rb:30:in `run’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/railties-5.0.6/lib/rails/initializable.rb:55:in `block in run_initializers’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/railties-5.0.6/lib/rails/initializable.rb:54:in `run_initializers’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/railties-5.0.6/lib/rails/application.rb:352:in `initialize!’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/railties-5.0.6/lib/rails/railtie.rb:193:in `public_send’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/railties-5.0.6/lib/rails/railtie.rb:193:in `method_missing’
/opt/openproject/config/environment.rb:34:in `<top (required)>’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/activesupport-5.0.6/lib/active_support/dependencies.rb:293:in `require’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/activesupport-5.0.6/lib/active_support/dependencies.rb:293:in `block in require’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/activesupport-5.0.6/lib/active_support/dependencies.rb:259:in `load_dependency’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/activesupport-5.0.6/lib/active_support/dependencies.rb:293:in `require’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/railties-5.0.6/lib/rails/application.rb:328:in `require_environment!’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/railties-5.0.6/lib/rails/application.rb:448:in `block in run_tasks_blocks’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/rake-12.1.0/exe/rake:27:in `<top (required)>’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.1/lib/bundler/cli/exec.rb:74:in `load’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.1/lib/bundler/cli/exec.rb:74:in `kernel_load’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.1/lib/bundler/cli/exec.rb:27:in `run’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.1/lib/bundler/cli.rb:360:in `exec’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.1/lib/bundler/vendor/thor/lib/thor/command.rb:27:in `run’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.1/lib/bundler/vendor/thor/lib/thor/invocation.rb:126:in `invoke_command’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.1/lib/bundler/vendor/thor/lib/thor.rb:369:in `dispatch’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.1/lib/bundler/cli.rb:20:in `dispatch’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.1/lib/bundler/vendor/thor/lib/thor/base.rb:444:in `start’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.1/lib/bundler/cli.rb:10:in `start’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.1/exe/bundle:35:in `block in <top (required)>’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.1/lib/bundler/friendly_errors.rb:121:in `with_friendly_errors’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.1/exe/bundle:27:in `<top (required)>’
/opt/openproject/bin/bundle:3:in `load’
/opt/openproject/bin/bundle:3:in `
’
Tasks: TOP => db:migrate => environment
(See full trace by running task with —trace)
[marcelo.magalhaes@calisto ~]$
Replies (4)
Hi Marcelo,
the actual error is this line here:
It doesn’t find the system mysql library that should have been installed by the package. This usually is caused by installing a package from the wrong package source, but it may be an issue in the Centos 7 package process. It could be because you use an existing MySQL database and the
mariadb-develpackage is missing.Can you double check that:
1.
mariadb-develis present. If you chose “auto-install MySQL” and it is not present, this is an error in our packaging process. If not, please install it manually.2. The package source is correct (since we no logner provide stable versions for Centos 6, this is likely irrelevant)
Best,
Oliver
Hi Oliver,
The database I will use is MySQL and it is already installed on another server. But you mentioned that you need mysql-devel to run OpenProject, right?
Can you tell me if I need another package to be installed on the server that I am installing the Open Project?
Live long and prosper,
Marcelo Magalhães
Hi Marcelo,
yes you will need mariadb-devel / mysql-devel, whatever your system provides. It is something the package should provide, but it is obviously missing. We will look into that.
Best,
Oliver
Hi Oliver,
Its working!!!
In addition to the package you mentioned, mysql-devel, I also installed mysql-community-libs-compat. All of these dependencies would be installed if I installed MySQL on the same OpenProject server.
But as each one is on a server I had to do the installation of these doiis packages on hand. Thanks a lot for the help.
Live long and prosper,
Marcelo Magalhães