Failing migration with mysql

[ariep]

We've been using kratos and hydra in our project for a long time. Up until now, with mariadb as the database. That's not supported though, and since a while hydra cannot upgrade because of that, so we're now attempting to switch to mysql instead.

Ironically however, a fresh kratos install fails to apply its (auto)migrations against mysql:

error executing migrations/sql/20210817181232000006_unique_credentials.mysql.up.sql, sql: ALTER TABLE `identity_credential_identifiers` MODIFY `identity_credential_type_id` char(36) NOT NULL;: Error 1832 (HY000): Cannot change column 'identity_credential_type_id': used in a foreign key constraint 'identity_credential_identifiers_type_id_fk_idx'

This is with mysql running in docker: docker.io/bitnami/mysql:8.4.2-debian-12-r4 and a fresh empty database. I found an issue about this, and the recommended solution is to set mysql's sql_mode to TRADITIONAL. I tried that by setting the env var MYSQL_EXTRA_FLAGS to --sql-mode=TRADITIONAL, but the kratos error remains.

Any suggestions?

[ariep]

Solved: there was a sql_mode='' in our dsn for kratos, removing that fixed it. Apparently mariadb and mysql treat that differently.