MySQL on AWS RDS does not accept SET GLOBAL commands

#1

Running the kaltura db on AWS RDS requires changes to sql scripts because RDS does not allow the SUPER USER to execute ‘SET GLOBAL’ commands. Not making this change prevents the database tables being created.

grep -rl ‘SET GLOBAL’ /opt/kaltura/app/deployment/base/sql/ | xargs sed -i ‘s/^SET GLOBAL.*//g’

#2

Hello @rsutton,

The SET GLOBAL statements in the SQL files under /opt/kaltura/app/deployment/base/sql were put there in order to disable strict mode and thus support MySQL 5.5 and 5.6 with “vanilla” configurations [strict mode is enabled in these versions in all common MySQL distributions, including the official deb and RPM packages in the distros’ repos]. If you’re using lower versions of MySQL via the AWS RDS service, it’s safe to drop these.
You may also globally disable strict mode by taking different steps.

#3

Thanks for the info. I spent several hours tracking this down and hope it helps others who want to use RDS for their system.