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.
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.