-
-
Notifications
You must be signed in to change notification settings - Fork 41
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
ORM error with MySQL backend #115
Comments
Hail, @MattiaFailla 👋 Welcome to Fief's kingdom! Our team will get back to you very soon to help. In the meantime, take a minute to star our repository ⭐️ Farewell! |
Hello @MattiaFailla 👋 Hmm, that's indeed an error during the creation of the database schema. It's strange because Fief is tested against MySQL during CI. Could you tell me which version of MySQL you are using? |
Hey @frankie567 I'm using Here is the docker-compose file:
And this is the .env
|
Hail, @MattiaFailla 👋 I've noticed you shared secret values: For your security, I've taken the liberty to replace them with dummy values. |
Thank you for those details! So it turns out it works with MariaDB, but not MySQL (🙄). I've added it to our CI so we can catch those errors earlier. The culprit is actually an index on the message column of the AuditLog model. It's a TEXT column, so it's indeed a bit weird to have an index on this, don't really know why I did this. I'll push a fix soon! |
Fixes ----- * Fix MySQL compatibility (#115). Thanks @MattiaFailla for the report 🎉 * Run count users task only once per day.
Describe the bug
Hi Team, following the self-hosted docker-compose guide with MYSQL database the following error is issued:
To Reproduce
Steps to reproduce the behavior:
Expected behavior
Fief server should start and migration should be performed with a MySQL backend.
Configuration
Additional context
Here is the full log:
errorlog.txt
The text was updated successfully, but these errors were encountered: