PostgreSQL Question posted in
The official documentation can be found here.

Postgresql – ERROR: could not compute MD5 hash: disabled for FIPS (PG::InternalError)

I am trying to deploy OpenProject 14 on Azure but using Azure Postgres Felxible Database server. But I get the below error, looks like our Azure tenant is FIPS complaint and below is the error message it is throwing. Any thoughts?

 Caused by:
       PG::InternalError: ERROR:  could not compute MD5 hash: disabled for FIPS (PG::InternalError)
       /app/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.4/lib/active_record/connection_adapters/postgresql_adapter.rb:894:in `exec_params'
       /app/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.4/lib/active_record/connection_adapters/postgresql_adapter.rb:894:in `block (2 levels) in exec_no_cache'

We would like to deploy Openproject using Azure Postgres flexible server.

Tags:

2

Answers


  1. 0

    PostgreSQL uses OpenSSL’s MD5 implementation, and your OpenSSL was compiled in what’s known as "FIPS mode" and refuses to calculate MD5 hashes.

    Either use a different OpenSSL (not an option on a hosted database) or don’t use MD5 or implement your own version of MD5.

    Login or Signup to reply.
  2. 0

    I was recently in contact with Microsoft Azure support. They told us that SCRAM is the new default for logins on Azure PostgreSQL Flexible servers and MD5 is disabled on all newly created servers from versions greater than 13.

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search