Uploaded image for project: 'Red Hat 3scale API Management'
  1. Red Hat 3scale API Management
  2. THREESCALE-10105

prerequisites for MySQL external DB integration are incomplete

    XMLWordPrintable

Details

    • 3
    • API CCS Sprint 44 (3Scale) 2

    Description

      Current behaviour

      An external MySQL 8.0 DB has been configured with a user as follows:

      CREATE USER '3scale'@example.com' IDENTIFIED WITH 'mysql_native_password' BY 'XXXXXXXX';

      GRANT ALL PRIVILEGES ON 3scale.* TO '3scale'@'example.com';

      When trying to complete the installation some pods were failing and the reason was due to this 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)

      That was resolved with the following steps:

      enabled log_bin_trust_function_creators on DB

      turned off forced encrypted connections

      The problem is that it seems 3scale has a requirement here which is not listed in the documentation

      Expected behaviour

      When following the documentation to integrate an external MySQL DB all prerequisites should be listed to avoid errors like above.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              rhn-support-keprice Kevin Price
              Darren Fennessy Darren Fennessy
              Matej Dujava Matej Dujava
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated: