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. General discussion

Mysql2 Error - unable to get certificate from /etc/openproject/addons/mysql/

Added by Angus Beath about 5 years ago

Hi everyone, hoping to get some help here. Have a long term install of OpenProject (up to date) that recently started to throw this error in the logs:

OpenProject openproject-worker-1.service[22132]: [ERROR] SSL error: Unable to get certificate from '/etc/openproject/addons/mysql/client-cert.pem'

OpenProject openproject-worker-1.service[22132]: rake aborted!

OpenProject openproject-worker-1.service[22132]: Mysql2::Error::ConnectionError: SSL connection error: Unable to get certificate

OpenProject is dead in the water and I can't recover it from a backup. It was working on Monday (I updated a project) so it's magically broken in the time since then. There is no file in the /etc/openproject/addons/mysql/ folder. I use Let's Encrypt to provide SSL certs for the site and that's all up to date.

Help!

Angus


Replies (3)

RE: Mysql2 Error - unable to get certificate from /etc/openproject/addons/mysql/ - Added by Oliver Günther about 5 years ago

Dear Angus,

your application cannot be up to date. We deprecated MySQL support in OpenProject 9 in May this year for reasons detailed in this blog post and pulled support in Openproject 10 released in september.

If this happened during an upgrade, please follow our guides to migrate from MySQL to PostgreSQL.

Best

Oliver

RE: Mysql2 Error - unable to get certificate from /etc/openproject/addons/mysql/ - Added by Angus Beath almost 5 years ago

Hi Oliver,

that was indeed the problem. Thank you for your post I'm back up and running with PostgreSQL.

Regards,

Angus

RE: Mysql2 Error - unable to get certificate from /etc/openproject/addons/mysql/ - Added by Oliver Günther almost 5 years ago

Thanks for getting back, great to hear the issue is resolved

Best

Oliver

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