Content
Apache and 503 Service Unavailable problem after install
Added by Ricardo Vigatti over 7 years ago
I have copied this question at Stack Overflow: https://stackoverflow.com/questions/44510955/installing-open-project-7-apache-error-service-unavailable
I’m trying to install Open Project 7 in a brand new Ubuntu instance at Digital Ocean.
I’ve follow the instructions at https://www.openproject.org/download-and-installation/, but it’s not working.
After the complete of installation and the run of the openproject configure
command, i have selected options to install both MySQL and Apache server. When it’s all done, i’m unable to connect to my server.
My enviroment:
Ubuntu 16.04
http://159.203.191.172
At logs, i can see two strange messages.
First:
bundler: failed to load command: unicorn (/opt/openproject/vendor/bundle/ruby/2.4.0/bin/unicorn)
Second is a warning:
WARN -- : You are setting a key that conflicts with a built-in method OmniAuth::AuthHash::InfoHash#name defined at /opt/openproject/vendor/bundle/ruby/2.4.0/bundler/gems/omniauth-8385bc0da47e/lib/omniauth/auth_hash.rb:34. This can cause unexpected behavior when accessing the key via as a property. You can still access the key via the #[] method. W, [2017-06-13T01:01:17.860764 #25822]
I don’t know if the warning is related to problem, but i think that the unicorn problem is.
Replies (8)
Hi Ricardo,
could you attach the entire output of the
openproject configure
command?Best,
Oliver
(Not original poster). There is no “openproject” command available. Is this command from a separate project?
Oliver, i’ll provide the entire output soon.
Uibk, What do you mean by “there is no openproject command”?
root
ubuntu-512mb-nyc1-01:~# openproject configureLaunching installer for openproject…
Selected addons: legacy-installer mysql apache2 repositories smtp memcached openproject
[legacy-installer] ./bin/configure
[mysql] ./bin/configure
DONE
[apache2] ./bin/configure
DONE
[repositories] ./bin/configure
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
Module perl already enabled
Module dav already enabled
Considering dependency dav for dav_svn:
Module dav already enabled
Module dav_svn already enabled
[Thu Jun 15 01:48:22.042359 2017] [so:warn] [pid 2708] AH01574: module dav_module is already loaded, skipping
AH00558: apache2: Could not reliably determine the server’s fully qualified domain name, using 127.0.1.1. Set the ‘ServerName’ directive globally to suppress this message
Your MPM seems to be threaded. Selecting cgid instead of cgi.
Module cgid already enabled
[smtp] ./bin/preinstall
[memcached] ./bin/preinstall
[openproject] ./bin/preinstall
[legacy-installer] ./bin/postinstall
[mysql] ./bin/postinstall
mysql: [Warning] Using a password on the command line interface can be insecure.
Generating /etc/openproject/conf.d/database…
[apache2] ./bin/postinstall
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
W, [2017-06-15T01:49:10.535347 #3620] WARN — : You are setting a key that conflicts with a built-in method OmniAuth::AuthHash::InfoHash#name defined at /opt/openproject/vendor/bundle/ruby/2.4.0/bundler/gems/omniauth-8385bc0da47e/lib/omniauth/auth_hash.rb:34. This can cause unexpected behavior when accessing the key via as a property. You can still access the key via the #[] method.
W, [2017-06-15T01:49:11.525564 #3620] WARN — : You are setting a key that conflicts with a built-in method OmniAuth::Strategy::Options#display defined in Kernel. This can cause unexpected behavior when accessing the key via as a property. You can still access the key via the #[] method.
W, [2017-06-15T01:49:46.153641 #3677] WARN — : You are setting a key that conflicts with a built-in method OmniAuth::AuthHash::InfoHash#name defined at /opt/openproject/vendor/bundle/ruby/2.4.0/bundler/gems/omniauth-8385bc0da47e/lib/omniauth/auth_hash.rb:34. This can cause unexpected behavior when accessing the key via as a property. You can still access the key via the #[] method.
W, [2017-06-15T01:49:47.092123 #3677] WARN — : You are setting a key that conflicts with a built-in method OmniAuth::Strategy::Options#display defined in Kernel. This can cause unexpected behavior when accessing the key via as a property. You can still access the key via the #[] method.
rake aborted!
Mysql2::Error: Can’t connect to MySQL server on ‘127.0.0.1’ (111)
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/mysql2-0.4.6/lib/mysql2/client.rb:89:in `connect’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/mysql2-0.4.6/lib/mysql2/client.rb:89:in `initialize’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/activerecord-5.0.3/lib/active_record/connection_adapters/mysql2_adapter.rb:25:in `new’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/activerecord-5.0.3/lib/active_record/connection_adapters/mysql2_adapter.rb:25:in `mysql2_connection’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/activerecord-5.0.3/lib/active_record/connection_adapters/abstract/connection_pool.rb:729:in `new_connection’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/activerecord-5.0.3/lib/active_record/connection_adapters/abstract/connection_pool.rb:773:in `checkout_new_connection’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/activerecord-5.0.3/lib/active_record/connection_adapters/abstract/connection_pool.rb:752:in `try_to_checkout_new_connection’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/activerecord-5.0.3/lib/active_record/connection_adapters/abstract/connection_pool.rb:713:in `acquire_connection’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/activerecord-5.0.3/lib/active_record/connection_adapters/abstract/connection_pool.rb:490:in `checkout’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/activerecord-5.0.3/lib/active_record/connection_adapters/abstract/connection_pool.rb:364:in `connection’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/activerecord-5.0.3/lib/active_record/connection_adapters/abstract/connection_pool.rb:883:in `retrieve_connection’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/activerecord-5.0.3/lib/active_record/connection_handling.rb:128:in `retrieve_connection’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/activerecord-5.0.3/lib/active_record/connection_handling.rb:91:in `connection’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/activerecord-5.0.3/lib/active_record/model_schema.rb:327:in `table_exists?’
/opt/openproject/config/initializers/30-redmine.rb:36:in `<top (required)>’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/activesupport-5.0.3/lib/active_support/dependencies.rb:287:in `load’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/activesupport-5.0.3/lib/active_support/dependencies.rb:287:in `block in load’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/activesupport-5.0.3/lib/active_support/dependencies.rb:259:in `load_dependency’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/activesupport-5.0.3/lib/active_support/dependencies.rb:287:in `load’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/railties-5.0.3/lib/rails/engine.rb:648:in `block in load_config_initializer’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/activesupport-5.0.3/lib/active_support/notifications.rb:166:in `instrument’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/railties-5.0.3/lib/rails/engine.rb:647:in `load_config_initializer’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/railties-5.0.3/lib/rails/engine.rb:612:in `block (2 levels) in class:Engine’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/railties-5.0.3/lib/rails/engine.rb:611:in `each’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/railties-5.0.3/lib/rails/engine.rb:611:in `block in class:Engine’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/railties-5.0.3/lib/rails/initializable.rb:30:in `instance_exec’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/railties-5.0.3/lib/rails/initializable.rb:30:in `run’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/railties-5.0.3/lib/rails/initializable.rb:55:in `block in run_initializers’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/railties-5.0.3/lib/rails/initializable.rb:44:in `each’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/railties-5.0.3/lib/rails/initializable.rb:44:in `tsort_each_child’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/railties-5.0.3/lib/rails/initializable.rb:54:in `run_initializers’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/railties-5.0.3/lib/rails/application.rb:352:in `initialize!’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/railties-5.0.3/lib/rails/railtie.rb:193:in `public_send’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/railties-5.0.3/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.3/lib/active_support/dependencies.rb:293:in `require’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/activesupport-5.0.3/lib/active_support/dependencies.rb:293:in `block in require’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/activesupport-5.0.3/lib/active_support/dependencies.rb:259:in `load_dependency’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/activesupport-5.0.3/lib/active_support/dependencies.rb:293:in `require’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/railties-5.0.3/lib/rails/application.rb:328:in `require_environment!’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/railties-5.0.3/lib/rails/application.rb:448:in `block in run_tasks_blocks’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/rake-12.0.0/exe/rake:27:in `<top (required)>’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/bundler-1.13.2/lib/bundler/cli/exec.rb:74:in `load’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/bundler-1.13.2/lib/bundler/cli/exec.rb:74:in `kernel_load’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/bundler-1.13.2/lib/bundler/cli/exec.rb:27:in `run’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/bundler-1.13.2/lib/bundler/cli.rb:332:in `exec’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/bundler-1.13.2/lib/bundler/vendor/thor/lib/thor/command.rb:27:in `run’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/bundler-1.13.2/lib/bundler/vendor/thor/lib/thor/invocation.rb:126:in `invoke_command’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/bundler-1.13.2/lib/bundler/vendor/thor/lib/thor.rb:359:in `dispatch’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/bundler-1.13.2/lib/bundler/cli.rb:20:in `dispatch’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/bundler-1.13.2/lib/bundler/vendor/thor/lib/thor/base.rb:440:in `start’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/bundler-1.13.2/lib/bundler/cli.rb:11:in `start’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/bundler-1.13.2/exe/bundle:34:in `block in <top (required)>’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/bundler-1.13.2/lib/bundler/friendly_errors.rb:100:in `with_friendly_errors’
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/bundler-1.13.2/exe/bundle:26: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)@
Hi Ricardo,
it appears that the MySQL database isn’t running:
Did you choose to install MySQL in the OpenProject wizard ?
Best,
Oliver
Whence cometh “openproject”? The GIT repo has no such file. Is it from a separate project?
otheus S wrote:
It’s part of the installation packages of OpenProject we provide. If you had actually read both my message on your other post and the installation guide, you would know what it provides.
Ok, i understood now. Oliver’s answer is correct, and thanks for the tip about mysql, My password configuration was wrong. Anyway, it did not solve the problem with apache. I decided to quit from the package installation and give a try to manually installing openproject.