Uploaded image for project: 'Nuxeo Documentation'
  1. Nuxeo Documentation
  2. NXDOC-1492

"you do not have the SUPER privilege and binary logging is enabled" using MySQL in RDS

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Blocker
    • Resolution: Done
    • Affects Version/s: 9.10
    • Fix Version/s: None
    • Component/s: Administration

      Description

      Install Nuxeo in Ubuntu using a MySQL RDS instance this error message is shown in server.log:

      you do not have the SUPER privilege and binary logging is enabled

      To avoid this problem using RDS you have to create a new RDS parameter group (this can be done from the RDS dashboard on the web), set log_bin_trust_function_creators to 1 (as opposed to <engine-default>, save the parameter group.

      SEE: https://stackoverflow.com/questions/11601692/mysql-amazon-rds-error-you-do-not-have-super-priviledges

      This information must be included in the installation manual

        Attachments

          Activity

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: