instructure/canvas-lms — Issue #116: Unable to initialize database on AWS RDS
Author: rvisintine
Created: 2011-10-13 09:25:05+00:00
State: open

I spun up a new instance today with the hopes of getting it work with with RDS as the database. Upon initializing the database I encountered an error when trying to create the triggers.

d== UngradedCountTriggers: migrating ==========================================
-- create_trigger("enrollments_after_insert_row_when_new_workflow_state_active__tr", {:generated=>true})
-> 0.0002s
rake aborted!
An error has occurred, all later migrations canceled:

Mysql::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 enrollments_after_insert_row_when_new_workflow_state_active__tr;

This is a pretty common error on RDS as you don't have true super user rights to the DB. See...
https://forums.aws.amazon.com/thread.jspa?messageID=181915

I did ensure that my database.yml contained the master DB user that was initially setup but am still encountering the error. Can anybody help point me in the right direction on where these triggers are getting initialized at? I've been poking around in the activerecord and hairtrigger gems but am not really finding what I think I need.

Thanks for any assistance.
--Roman