Skip to content
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

Add V1 baseline migration in order to avoid SUPER privilege need from 0.x schema version #956

Open
3 tasks done
juherr opened this issue Nov 5, 2022 · 0 comments
Open
3 tasks done

Comments

@juherr
Copy link
Contributor

juherr commented Nov 5, 2022

Checklist

  • I checked other issues already and found no answer
  • I checked the documentation and found no answer
  • I am running the latest version and the feature i am requesting is not implemented there

Describe the problem you are trying to solve

When you build Steve, you need to have a database with SUPER privilege otherwise you are not able to run migrations (see #495 ad other related issues).
This need was removed in a later migration and V1.x doesn't need it anymore.

Describe the solution you'd like

Flyway has baseline migration which skips migrations files when not needed.
https://flywaydb.org/documentation/tutorials/baselineMigrations
Having a V1.0 baseline migration will skip the migrations which need more privileges.

Describe alternative solutions or features you've considered

Do it by hand:

  1. Run migrations on a database with enough privilege
  2. Export schema
  3. Import schema into the target database without super privilege

Additional context

When working, it will be possible to remove the FAQ entry.
https://github.com/steve-community/steve/wiki/FAQ#database-migration-fails-on-mariadb-due-to-missing-super-privilege

juherr added a commit to juherr/steve that referenced this issue May 8, 2023
It drops the need to grant super privileges to the db user
Fix steve-community#956
juherr added a commit to juherr/steve that referenced this issue May 8, 2023
It drops the need to grant super privileges to the db user
Fix steve-community#956
juherr added a commit to juherr/steve that referenced this issue May 8, 2023
It drops the need to grant super privileges to the db user
Fix steve-community#956
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant