Jump to content
Help

User menu

Sign in
Forgot your password?
Open link in a new tab

Content

Expand project menu
Support Installation & Updates

Install fail because of perl

Started June 7, 2019 12:16 · 5 replies · 2 participants

Updateing Openproject from 8.3.1 to 8.3.2 i receive after running openproject configure.

ERROR: Module perl not properly enabled: /etc/apache2/mods-enabled/perl.load is a real file, not touching it 

Ubuntu 16.04

Various Interactive
Message actions
Oliver Günther
Message actions

Hi Harald,

which distribution are you running on?

Best,

Oliver

Various Interactive
Message actions

Hi Oliver,

thanks but this link solved my issue: https://ubuntuforums.org/showthread.php?t=1843307.

Now i have that issue:

root@projects /etc/apt/sources.list.d # sudo openproject configure
Launching installer for openproject...
Selected addons: legacy-installer postgres apache2 repositories smtp memcached openproject
[legacy-installer] ./bin/configure
[postgres] ./bin/configure
Installation is already using MySQL, skipping postgres addon.
DONE
[apache2] ./bin/configure
DONE
[repositories] ./bin/configure
DONE
[smtp] ./bin/configure
DONE
[memcached] ./bin/configure
DONE
[openproject] ./bin/configure
DONE
[legacy-installer] ./bin/preinstall
[postgres] ./bin/preinstall
INFO: autoinstall=skip. Skipping to next step.
[apache2] ./bin/preinstall
[repositories] ./bin/preinstall
Module perl already enabled
Module dav already enabled
Considering dependency dav for dav_svn:
Module dav already enabled
Module dav_svn already enabled
[Fri Jun 07 15:40:04.769231 2019] [so:warn] [pid 3064] AH01574: module dav_module is already loaded, skipping
Module cgi already enabled
[smtp] ./bin/preinstall
[memcached] ./bin/preinstall
[openproject] ./bin/preinstall
[legacy-installer] ./bin/postinstall
[postgres] ./bin/postinstall
[apache2] ./bin/postinstall
Last prefix was /
Module rewrite already enabled
Module proxy already enabled
Considering dependency proxy for proxy_http:
Module proxy already enabled
Module proxy_http already enabled
Module headers already enabled
Module expires already enabled
Considering dependency filter for deflate:
Module filter already enabled
Module deflate already enabled
Module filter already enabled
Site openproject already enabled
[repositories] ./bin/postinstall
No repositories have been configured. Skipping configuration.
[smtp] ./bin/postinstall
[memcached] ./bin/postinstall
[openproject] ./bin/postinstall
rake aborted!
PG::ConnectionBad: FATAL:  password authentication failed for user "openproject"
FATAL:  password authentication failed for user "openproject"
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/pg-1.1.4/lib/pg.rb:56:in `initialize'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/pg-1.1.4/lib/pg.rb:56:in `new'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/pg-1.1.4/lib/pg.rb:56:in `connect'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/connection_adapters/postgresql_adapter.rb:692:in `connect'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/connection_adapters/postgresql_adapter.rb:223:in `initialize'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/connection_adapters/postgresql_adapter.rb:48:in `new'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/connection_adapters/postgresql_adapter.rb:48:in `postgresql_connection'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:811:in `new_connection'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:855:in `checkout_new_connection'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:834:in `try_to_checkout_new_connection'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:795:in `acquire_connection'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:523:in `checkout'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:382:in `connection'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:1010:in `retrieve_connection'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/connection_handling.rb:118:in `retrieve_connection'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/connection_handling.rb:90:in `connection'
/opt/openproject/lib/open_project/null_db_fallback.rb:35:in `fallback'
/opt/openproject/config/initializers/05-null_db_fallback.rb:36:in `<top (required)>'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.2.1/lib/active_support/dependencies.rb:285:in `load'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.2.1/lib/active_support/dependencies.rb:285:in `block in load'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.2.1/lib/active_support/dependencies.rb:257:in `load_dependency'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.2.1/lib/active_support/dependencies.rb:285:in `load'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/railties-5.2.2.1/lib/rails/engine.rb:657:in `block in load_config_initializer'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.2.1/lib/active_support/notifications.rb:170:in `instrument'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/railties-5.2.2.1/lib/rails/engine.rb:656:in `load_config_initializer'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/railties-5.2.2.1/lib/rails/engine.rb:614:in `block (2 levels) in <class:Engine>'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/railties-5.2.2.1/lib/rails/engine.rb:613:in `each'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/railties-5.2.2.1/lib/rails/engine.rb:613:in `block in <class:Engine>'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/railties-5.2.2.1/lib/rails/initializable.rb:32:in `instance_exec'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/railties-5.2.2.1/lib/rails/initializable.rb:32:in `run'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/railties-5.2.2.1/lib/rails/initializable.rb:61:in `block in run_initializers'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/railties-5.2.2.1/lib/rails/initializable.rb:50:in `each'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/railties-5.2.2.1/lib/rails/initializable.rb:50:in `tsort_each_child'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/railties-5.2.2.1/lib/rails/initializable.rb:60:in `run_initializers'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/railties-5.2.2.1/lib/rails/application.rb:361:in `initialize!'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/railties-5.2.2.1/lib/rails/railtie.rb:190:in `public_send'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/railties-5.2.2.1/lib/rails/railtie.rb:190:in `method_missing'
/opt/openproject/config/environment.rb:34:in `<top (required)>'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.2.1/lib/active_support/dependencies.rb:291:in `require'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.2.1/lib/active_support/dependencies.rb:291:in `block in require'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.2.1/lib/active_support/dependencies.rb:257:in `load_dependency'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.2.1/lib/active_support/dependencies.rb:291:in `require'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/railties-5.2.2.1/lib/rails/application.rb:337:in `require_environment!'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/railties-5.2.2.1/lib/rails/application.rb:520:in `block in run_tasks_blocks'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/rake-12.3.2/exe/rake:27:in `<top (required)>'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/cli/exec.rb:74:in `load'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/cli/exec.rb:74:in `kernel_load'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/cli/exec.rb:28:in `run'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/cli.rb:463:in `exec'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/vendor/thor/lib/thor/command.rb:27:in `run'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/vendor/thor/lib/thor/invocation.rb:126:in `invoke_command'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/vendor/thor/lib/thor.rb:387:in `dispatch'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/cli.rb:27:in `dispatch'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/vendor/thor/lib/thor/base.rb:466:in `start'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/cli.rb:18:in `start'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/exe/bundle:30:in `block in <top (required)>'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/friendly_errors.rb:124:in `with_friendly_errors'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/exe/bundle:22:in `<top (required)>'
/opt/openproject/bin/bundle:3:in `load'
/opt/openproject/bin/bundle:3:in `<main>'
Tasks: TOP => db:migrate => db:load_config => environment
(See full trace by running task with --trace)

and

openproject config:get MYSQL_DATABASE_URL

return the correct value. With username/password i can onnect with mysql -u openproject -p I tried to migrate to posgre but that fails. 

Any ideas?

Thanks and kind regards,

Harald

Various Interactive
Message actions

Now, that also works, but and configure script compleates without error.

But still have empty page (500): https://projects.varioous.at/index.php

Oliver Günther
Message actions

The error reports that with the value in DATABASE_URL postgres cannot connect to the database due to an invalid password.

You can check what this entry is with openproject config:get DATABASE_URL

Can you manually connect with the following command?

psql $(openproject config:get DATABASE_URL) 

If you followed our migration guides , you were instructed to create a postgres user with a password. This password needs to be entered in the URL and potentially URL escaped. If you have special characters in your URL, please escape your password with

openproject run ruby -r cgi -e "puts CGI.escape('your-password-here');"

Best,

Oliver

Various Interactive
Message actions

Hi Oliver,

thanks now everything is working. I migrated to PostgreSQL and updated to 9.0.1.

Thanks and kind regards,

Harald