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
    • Upgrade to Enterprise edition
    • 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

Support Installation & Updates
  1. OpenProject
  2. Forums
  3. Support Installation & Updates
  4. Service Unavailable on debian 9

Service Unavailable on debian 9

Added by Squellettore Killan almost 7 years ago

Hi,

I tried to install the last version (7.4.5) of OP.
When finish the install, following the doc (https://www.openproject.org/download-and-installation/#installation), i got an service unavailable.

No log, or explanation.

I have the domaine (openproject.mydomain.net), i got an apache2 openproject.conf file pointing on the /opt/openproject/public folder.

The database (mysql) has 7 tables created.

What can i do to solve the problem please ?
Thanks in advance.


Replies (3)

RE: Service Unavailable on debian 9 - Added by Squellettore Killan almost 7 years ago

Maybe it can help at the reconfigure time i got

== 0 AggregatedMigrations: migrating ==========================================
-- create_table("attachments", {:force=>true})
   -> 0.0347s
-- add_index("attachments", ["author_id"], {:name=>"index_attachments_on_author_id"})
   -> 0.0141s
-- add_index("attachments", ["container_id", "container_type"], {:name=>"index_attachments_on_container_id_and_container_type"})
   -> 0.0237s
-- add_index("attachments", ["created_on"], {:name=>"index_attachments_on_created_on"})
   -> 0.0248s
-- create_table("auth_sources", {:force=>true})
   -> 0.0509s
-- add_index("auth_sources", ["id", "type"], {:name=>"index_auth_sources_on_id_and_type"})
   -> 0.0160s
-- create_table("boards", {:force=>true})
   -> 0.0524s
-- add_index("boards", ["last_message_id"], {:name=>"index_boards_on_last_message_id"})
   -> 0.0163s
-- add_index("boards", ["project_id"], {:name=>"boards_project_id"})
   -> 0.0260s
-- create_table("changes", {:force=>true})
   -> 0.0483s
-- add_index("changes", ["changeset_id"], {:name=>"changesets_changeset_id"})
   -> 0.0151s
-- create_table("changesets", {:force=>true})
   -> 0.0483s
-- add_index("changesets", ["committed_on"], {:name=>"index_changesets_on_committed_on"})
   -> 0.0148s
-- add_index("changesets", ["repository_id", "revision"], {:name=>"changesets_repos_rev", :unique=>true})
rake aborted!
StandardError: An error has occurred, all later migrations canceled:

*Mysql2::Error: Specified key was too long; max key length is 767 bytes: CREATE UNIQUE INDEX `changesets_repos_rev`  ON `changesets` (`repository_id`, `revision`)
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/mysql2-0.4.9/lib/mysql2/client.rb:120:in `_query'*

Later same MySQL error

/opt/openproject/bin/bundle:3:in `load'
/opt/openproject/bin/bundle:3:in `<main>'
ActiveRecord::StatementInvalid: Mysql2::Error: Specified key was too long; max key length is 767 bytes: CREATE UNIQUE INDEX `changesets_repos_rev`  ON `changesets` (`repository_id`, `revision`)
/opt/openproject/vendor/bundle/ruby/2.4.0/gems/mysql2-0.4.9/lib/mysql2/client.rb:120:in `_query'

and later again

RE: Service Unavailable on debian 9 - Added by Oliver Günther almost 7 years ago

What mysql database version and collation for the database are you using? The error is quite clear, in your encoding, the prefix length exceeds the capability of MySQL. This might be because you’re using the now suggested utf8mb4 encoding to make MySQL accept all UTF-8 characeters and not just a subset.

For more information, see https://stackoverflow.com/a/1814594/420614. Fore example, upgrading to MySQL 5.7. should resolve that issue.

Best,
Oliver

RE: Service Unavailable on debian 9 - Added by Squellettore Killan almost 7 years ago

Hi,

Thanks for your answer.

Here is my version, apt update/upgrade done today. (debian 9)

mysql Ver 15.1 Distrib 10.1.26-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2

-If it’s an innodb problem, maybe we can try https://stackoverflow.com/a/38675910/6427809
points 1 to 5 ?-

EDIT : not working.

Thanks,

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