While setting up SteVe on a cloud VM the database migration fails during build

[mctsnt]

I am trying to create a SteVe instance using a standard Ubuntu VM on DigitalOcean. I have seen the wiki about "How to create a SteVe Server using AWS Lightsail" and followed all the steps. However when I try to build SteVe I get the following error:

[ERROR] Failed to execute goal org.flywaydb:flyway-maven-plugin:7.3.2:migrate (default) on project steve: org.flywaydb.core.internal.command.DbMigrate$FlywayMigrateException: [ERROR] Migration V0_6_6__inital.sql failed [ERROR] ----------------------------------- [ERROR] SQL State : HY000 [ERROR] Error Code : 1419 [ERROR] Message : 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)

Since I cannot grant SUPER privileges to the user I was wondering if there is any solution for this?

[csamsel]

Depends on the actual mysql or mariadb version. But likely no in your case.

[mctsnt]

I am using mariadb 10.5.8 . How did you work around this issue in AWS? Would moving the Ubuntu VM I am using to set up SteVe on AWS instead solve this for me?

[csamsel]

Some MySQL/MariaDB versions do require super rights for stored procedure handling, some dont. Also depending on the service you use, it's actually possibe to reconfigured the mentioned parameter, see: https://aws.amazon.com/premiumsupport/knowledge-center/rds-mysql-functions/