documentation-developer icon indicating copy to clipboard operation
documentation-developer copied to clipboard

IBX-8377: Fix OAuth server installation

Open adriendupuis opened this issue 1 year ago • 0 comments

Question Answer
JIRA Ticket IBX-8377
Versions master, 4.6
Edition All

Install tables before enabling the bundles to avoid having php bin/console checking the bundles' configs.

SET FOREIGN_KEY_CHECKS=0; was useless: The session is broken between the commands and FOREIGN_KEY_CHECKS is set back to 1.

Preview: https://ez-systems-developer-documentation--2397.com.readthedocs.build/en/2397/users/oauth_server/#server-installation

Note: Some errors might occur during the play of the SQL dump. If a fix is found, another PR would be opened.

  • I encounter ERROR 1005 (HY000) at line 18: Can't create table db.ibexa_oauth2_consent (errno: 150 "Foreign key constraint is incorrectly formed") but the ibexa_oauth2_consent table is created anyway.
  • @bdunogier encounters ERROR 1822 (HY000): Failed to add the foreign key constraint. Missing index for constraint 'ibexa_oauth2_consent_user_fk' in the referenced table 'ezuser' which is also incomprehensible.

Checklist

  • [ ] Text renders correctly
  • [ ] Text has been checked with vale
  • [ ] Description metadata is up to date
  • [ ] Redirects cover removed/moved pages
  • [ ] Code samples are working
  • [ ] PHP code samples have been fixed with PHP CS fixer
  • [ ] Added link to this PR in relevant JIRA ticket or code PR

adriendupuis avatar Jun 10 '24 10:06 adriendupuis