simplesamlphp-module-oidc icon indicating copy to clipboard operation
simplesamlphp-module-oidc copied to clipboard

Published 20 hours ago • verified publisher icon simplesamlphp

Make the database scheme friendly for ndb (instead of innoDB only)

Open tommy2d opened this issue 3 years ago • 2 comments

Because of the combination of ON DELETE CASCADE and TEXT and BLOB fields in the default schema, simplesaml-module-oidc cannot be used on ndbcluster. This is easily fixed be converting some of the TEXT fields to varchar like i did in the attached schema.

oidc_patched_ndb-sql.txt

tommy2d avatar May 19 '22 15:05 tommy2d

Thanks @tommy2d For the user table did you also need to change type of claims ? I see you have mediumtext in your schema. Was text not supported?

pradtke avatar May 20 '22 22:05 pradtke

I did not need to update claims, probably because it was not directly hit by the ON DELETE CASCADE. TEXT was too small so I used MEDIUMTEXT. This has to do with the profile picture that was there.

tommy2d avatar May 31 '22 15:05 tommy2d