Hi Judith,
Op 18-07-19 om 21:37 schreef Judith Bush:
Most components have their own database schema.
For the main database we support MySQL and any of its variants (MariaDB,
galera, percona).
Its most important schema is of Engineblock. You can find it represented
in Doctrine Migrations here:
https://github.com/OpenConext/OpenConext-engineblock/tree/master/database/DoctrineMigrations
Every other component will also contain its own database schema. The Java
based applications use a similar way as Doctrine, called Flyway.
But OpenConext deploy will install the necessary schemas for you.
Notable exception is the Manage application, which stores its data in a
MongoDB database, not MySQL. But this is also managed by OpenConext deploy
for you.
Your assumption is not correct. Engineblock will store the values of the
schacHomeOrganization and uid attributes of each authenticated user that
passes through the proxy. This is necessary to store which SPs the user
has given consent for and to store the pseudonymous identifiers we hand
out for that user. The lifecycle app you mention will deprovision this
data after a configurable period of inactivity of the user.
More details should be fairly evident from the database schemas themselves
but we can also help you out further with more specific questions.
Kind regards,
Thijs