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
  • Feature tour
    Feature tour

Content

You are here:
  1. Forums
  2. Support Installation & Updates

HTTP: failed to make connection to backend: 127.0.0.1

Added by Bernd Müller almost 9 years ago

EDIT: Solved it. Seems like you should use utf8 as encoding, not utf8mb4 :( Maybe this should be added to FAQ or installation instructions.

Hi,

I try to install openproject with packaged installation, but I get an error when I try to access openproject.mydomain.tld:

This is the output in apache error.log:

(111)Connection refused: AH00957: HTTP: attempt to connect to 127.0.0.1:6000 (127.0.0.1) failed
AH00959: ap_proxy_connect_backend disabling worker for (127.0.0.1) for 0s
AH01114: HTTP: failed to make connection to backend: 127.0.0.1

This is the config created by openproject installer:

Include /etc/openproject/addons/apache2/includes/server/*.conf

<VirtualHost *:80>
ServerName openproject.domain.tld
DocumentRoot /opt/openproject/public

ProxyRequests off

Include /etc/openproject/addons/apache2/includes/vhost/*.conf

ProxyPass / http://127.0.0.1:6000/ retry=0
ProxyPassReverse / http://127.0.0.1:6000/

Thanks in advance!

Edit: I reinstalled it and during ‘openproject configure’ there is an error:

Mysql2::Error: Specified key was too long; max key length is 767 bytes: CREATE UNIQUE INDEX `changes ets_repos_rev` ON `changesets` (`repository_id`, `revision`) /opt/openproject/vendor/bundle/ruby/2. 1.0/gems/activerecord-4.2.4/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:305:in ` query’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/connection_adapt ers/abstract_mysql_adapter.rb:305:in `block in execute’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/connection_adapt ers/abstract_adapter.rb:473:in `block in log’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activesupport-4.2.4/lib/active_support/notifications/ instrumenter.rb:20:in `instrument’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/connection_adapt ers/abstract_adapter.rb:467:in `log’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/connection_adapt ers/abstract_mysql_adapter.rb:305:in `execute’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/connection_adapt ers/mysql2_adapter.rb:231:in `execute’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/connection_adapt ers/abstract_mysql_adapter.rb:535:in `add_index’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/migration.rb:662 :in `block in method_missing’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/migration.rb:631 :in `block in say_with_time’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/migration.rb:631 :in `say_with_time’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/migration.rb:651 :in `method_missing’
/opt/openproject/db/migrate/000_aggregated_migrations.rb:354:in `run_aggregated_migrations’
/opt/openproject/db/migrate/000_aggregated_migrations.rb:241:in `up’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/migration.rb:608 :in `exec_migration’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/migration.rb:589 :in `block (2 levels) in migrate’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/migration.rb:588 :in `block in migrate’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/connection_adapt ers/abstract/connection_pool.rb:292:in `with_connection’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/migration.rb:587 :in `migrate’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/migration.rb:765 :in `migrate’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/migration.rb:995 :in `block in execute_migration_in_transaction’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/migration.rb:104 3:in `ddl_transaction’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/migration.rb:994 :in `execute_migration_in_transaction’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/migration.rb:956 :in `block in migrate’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/migration.rb:952 :in `each’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/migration.rb:952 :in `migrate’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/migration.rb:820 :in `up’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/migration.rb:798 :in `migrate’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/tasks/database_t asks.rb:137:in `migrate’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/railties/databas es.rake:44:in `block (2 levels) in <top (required)>’
ActiveRecord::StatementInvalid: Mysql2::Error: Specified key was too long; max key length is 767 byt es: CREATE UNIQUE INDEX `changesets_repos_rev` ON `changesets` (`repository_id`, `revision`)
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/connection_adapt ers/abstract_mysql_adapter.rb:305:in `query’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/connection_adapt ers/abstract_mysql_adapter.rb:305:in `block in execute’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/connection_adapt ers/abstract_adapter.rb:473:in `block in log’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activesupport-4.2.4/lib/active_support/notifications/ instrumenter.rb:20:in `instrument’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/connection_adapt ers/abstract_adapter.rb:467:in `log’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/connection_adapt ers/abstract_mysql_adapter.rb:305:in `execute’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/connection_adapt ers/mysql2_adapter.rb:231:in `execute’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/connection_adapt ers/abstract_mysql_adapter.rb:535:in `add_index’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/migration.rb:662 :in `block in method_missing’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/migration.rb:631 :in `block in say_with_time’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/migration.rb:631 :in `say_with_time’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/migration.rb:651 :in `method_missing’
/opt/openproject/db/migrate/000_aggregated_migrations.rb:354:in `run_aggregated_migrations’
/opt/openproject/db/migrate/000_aggregated_migrations.rb:241:in `up’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/migration.rb:608 :in `exec_migration’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/migration.rb:589 :in `block (2 levels) in migrate’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/migration.rb:588 :in `block in migrate’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/connection_adapt ers/abstract/connection_pool.rb:292:in `with_connection’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/migration.rb:587 :in `migrate’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/migration.rb:765 :in `migrate’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/migration.rb:995 :in `block in execute_migration_in_transaction’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/migration.rb:104 3:in `ddl_transaction’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/migration.rb:994 :in `execute_migration_in_transaction’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/migration.rb:956 :in `block in migrate’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/migration.rb:952 :in `each’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/migration.rb:952 :in `migrate’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/migration.rb:820 :in `up’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/migration.rb:798 :in `migrate’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/tasks/database_t asks.rb:137:in `migrate’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/railties/databas es.rake:44:in `block (2 levels) in <top (required)>’
Mysql2::Error: Specified key was too long; max key length is 767 bytes
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/connection_adapt ers/abstract_mysql_adapter.rb:305:in `query’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/connection_adapt ers/abstract_mysql_adapter.rb:305:in `block in execute’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/connection_adapt ers/abstract_adapter.rb:473:in `block in log’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activesupport-4.2.4/lib/active_support/notifications/ instrumenter.rb:20:in `instrument’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/connection_adapt ers/abstract_adapter.rb:467:in `log’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/connection_adapt ers/abstract_mysql_adapter.rb:305:in `execute’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/connection_adapt ers/mysql2_adapter.rb:231:in `execute’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/connection_adapt ers/abstract_mysql_adapter.rb:535:in `add_index’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/migration.rb:662 :in `block in method_missing’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/migration.rb:631 :in `block in say_with_time’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/migration.rb:631 :in `say_with_time’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/migration.rb:651 :in `method_missing’
/opt/openproject/db/migrate/000_aggregated_migrations.rb:354:in `run_aggregated_migrations’
/opt/openproject/db/migrate/000_aggregated_migrations.rb:241:in `up’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/migration.rb:608 :in `exec_migration’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/migration.rb:589 :in `block (2 levels) in migrate’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/migration.rb:588 :in `block in migrate’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/connection_adapt ers/abstract/connection_pool.rb:292:in `with_connection’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/migration.rb:587 :in `migrate’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/migration.rb:765 :in `migrate’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/migration.rb:995 :in `block in execute_migration_in_transaction’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/migration.rb:104 3:in `ddl_transaction’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/migration.rb:994 :in `execute_migration_in_transaction’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/migration.rb:956 :in `block in migrate’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/migration.rb:952 :in `each’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/migration.rb:952 :in `migrate’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/migration.rb:820 :in `up’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/migration.rb:798 :in `migrate’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/tasks/database_t asks.rb:137:in `migrate’
/opt/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.4/lib/active_record/railties/databas es.rake:44:in `block (2 levels) in <top (required)>’


Loading...