system-app logs the error "You do not have the SUPER privilege and binary logging is enabled"

Solution Unverified - Updated -

Issue

  • When using an external MySQL database system-app logs the following error:
ActiveRecord::StatementInvalid: Mysql2::Error: You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable): DROP TRIGGER IF EXISTS accounts_tenant_id

Environment

  • Red Hat 3scale API Management 2.9
  • Red Hat OpenShift Container Platform 4.X

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In