Stages Documentation

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
Next revisionBoth sides next revision
75:system_requirements_mysql [2020/06/23 08:25] – [Azure MySQL DB] etea75:system_requirements_mysql [2020/09/02 06:26] – ndn
Line 19: Line 19:
 For installing Stages with the Azure MySQL DB, all of the above applies as well. For installing Stages with the Azure MySQL DB, all of the above applies as well.
  
-In addition, the l''og_bin_trust_function_creators'' parameter must be set to 1. See [[https://stackoverflow.com/questions/11601692/mysql-amazon-rds-error-you-do-not-have-super-privileges|here for more info]].+In addition, the l''og_bin_trust_function_creators'' parameter of Azure MySQL DB must be set to 1. See [[https://stackoverflow.com/questions/11601692/mysql-amazon-rds-error-you-do-not-have-super-privileges|here for more info]]. 
 + 
 +The connection timeout for Azure MySQL DB might be set very low. If you see connection errors after a while, you should set the connection timeout for Stages to 100 seconds via<code> 
 + 
 +torque.database.default.expiryTime=100000 
 + 
 +</code> 
 + 
 +in ''database.properties''. 
 +===== Required MySQL Permissions ===== 
 + 
 +The Stages user needs the following permissions for the database that is configured in database.properties 
 + 
 +  * <font inherit/Courier New,Courier,monospace;;inherit;;inherit>ALTER, CREATE, DELETE, DROP, INDEX, INSERT, REFERENCES, SELECT, TRIGGER, UPDATE</font> 
 + 
 +Additionally, one of the following is required 
 + 
 +  * The SUPER privilege, globally:  \\ <font inherit/Courier New,Courier,monospace;;inherit;;inherit>GRANT SUPER ON *.* TO 'stages'@'localhost';</font> 
 +  * <font inherit/Arial,Helvetica,sans-serif;;inherit;;inherit>If this is not desirable, binary logging has to be disabled. Add the following line to the MySQL configuration file:</font> \\ <font inherit/Courier New,Courier,monospace;;inherit;;inherit>disable_log_bin</font>