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

Can't [Read a Verb-Resource Permission] #6

Closed
hsakamoto123 opened this issue Dec 19, 2022 · 3 comments
Closed

Can't [Read a Verb-Resource Permission] #6

hsakamoto123 opened this issue Dec 19, 2022 · 3 comments

Comments

@hsakamoto123
Copy link

hsakamoto123 commented Dec 19, 2022

You may need to make the same modifications as Update database seeding for Keyrock 8.2 or later. in "402. Roles and Permissions".
Also apply to "406. Administrating XACML via a PAP".

container log:
{"log":"2022-12-19T10:19:13.333Z idm:api-permissions Error: SequelizeDatabaseError: Unknown column 'regex_entity_ids' in 'field list'\n","stream":"stderr","time":"2022-12-19T10:19:13.333596701Z"}

@jason-fox
Copy link
Member

Fixed 8e06843

@hsakamoto123
Copy link
Author

hsakamoto123 commented Dec 20, 2022

Fixed 8e06843:mysql-data/backup.sql

Three columns of regex_entity_ids, regex_attributes, regex_types have been added, but four columns of "INSERT INTO permission VALUES" have been added.
It seems that there is one extra ",", so please check.

After that, is it necessary to change "INSERT INTO SequelizeMeta VALUES"?

I want an answer to this question.

fisuda added a commit to fisuda/tutorials.Administrating-XACML that referenced this issue Dec 20, 2022
jason-fox added a commit that referenced this issue Dec 20, 2022
@jason-fox
Copy link
Member

After that, is it necessary to change "INSERT INTO SequelizeMeta VALUES"?

The tutorial is just pre-inserting some data into a MySQL. SequelizeMeta just reshapes an existing DB. It looks like the shape of some tables changed between 8.2 and 8.3. You'll have to ask over a Keyrock how their Sequelize code has been set up.

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

No branches or pull requests

2 participants