Answers.Body: <p>Turns out, Amazon RDS by default turns on binary logging that prevents "CREATE TRIGGER" to succeed, and CiviCRM interprets this as insufficient permissions. More <a href="https://forums.aws.amazon.com/thread.jspa?threadID=45258" rel="nofollow">here</a>. For now I turned off automatic backups and completed installation successfully.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-10-31T08:25:55.883Z
Answers.Text: Was it possible to turn on automatic backup after the installation? It is a valuable feature of Amazon RDS.
Answers.UserDisplayName: Kainuk - CiviCooP
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-04-15T16:08:47.760Z
Answers.LastActivityDate: 2016-04-15T16:08:47.760Z
Answers.UserDisplayName: Felix
Answers.Body: <p>On <a href="https://stackoverflow.com/questions/8919907/can-i-create-trigger-in-an-rds-db">https://stackoverflow.com/questions/8919907/can-i-create-trigger-in-an-rds-db</a> is described how database triggers can be created on Amazon RDS. </p>
  
  <p>Short summary:</p>
  
  <ul>
  <li>Create a new Parameter Group.</li>
  <li>Set <code>log_bin_trust_function_creators</code> to 1.</li>
  </ul>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-10-31T08:23:06.947Z
Answers.LastActivityDate: 2016-10-31T08:23:06.947Z
Answers.LastEditDate: 2017-05-23T12:38:59.763Z
Answers.UserDisplayName: Kainuk - CiviCooP
Body: <p>I am installing CiviCRM in Amazon AWS environment. User civicrm has full rights on civicrm database. I certainly see TRIGGER among all others in my phpMyAdmin console. Out of abundance of caution I even gave global TRIGGER permission. Still, I am getting the error.
  I had a test installation with DB running on the same server as web server and didn't have any problems. Don't know if CiviCRM doesn't see TRIGGER permission because of different host, or because of RDS limitations, or yet something else.</p>
  
  <p>Web Server is Amazon Linux (similar to Fedora/CentOS); Apache 2.4; MySQL is 5.6.27</p>
  
  <p><strong>UPDATE</strong>: I tried "root" account and I get the same error. I don't think (or at least I don't know how) I can spool the SQLs that get generated - so if somebody can point me to a query that tries to create a trigger and fails, that would be awesome!</p>
  
Tags: <database><installation><amazon>
Title: Could not create a database trigger on AWS RDS
ThreadText: # Could not create a database trigger on AWS RDS
  
  (Asked by: username_0 on 2016-04-15)
  
  I am installing CiviCRM in Amazon AWS environment. User civicrm has full rights on civicrm database. I certainly see TRIGGER among all others in my phpMyAdmin console. Out of abundance of caution I even gave global TRIGGER permission. Still, I am getting the error.
  I had a test installation with DB running on the same server as web server and didn't have any problems. Don't know if CiviCRM doesn't see TRIGGER permission because of different host, or because of RDS limitations, or yet something else.
  
  Web Server is Amazon Linux (similar to Fedora/CentOS); Apache 2.4; MySQL is 5.6.27
  
  **UPDATE**: I tried "root" account and I get the same error. I don't think (or at least I don't know how) I can spool the SQLs that get generated - so if somebody can point me to a query that tries to create a trigger and fails, that would be awesome!
  
  **Tags:** database, installation, amazon
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2016-10-31. Score: 4 | Accepted answer
  
  On <https://stackoverflow.com/questions/8919907/can-i-create-trigger-in-an-rds-db> is described how database triggers can be created on Amazon RDS.
  
  Short summary:
  
  * Create a new Parameter Group.
  * Set `log_bin_trust_function_creators` to 1.
  
  
  ---
  
  ### Answer by username_0 on 2016-04-15. Score: 4
  
  Turns out, Amazon RDS by default turns on binary logging that prevents "CREATE TRIGGER" to succeed, and CiviCRM interprets this as insufficient permissions. More [here](https://forums.aws.amazon.com/thread.jspa?threadID=45258). For now I turned off automatic backups and completed installation successfully.
  
  > **Comments:**
  > **username_1**: Was it possible to turn on automatic backup after the installation? It is a valuable feature of Amazon RDS.  
  
  ---
  
  