Daniel Zimmermann wrote:
Unfortunately no. I remember someone started one a while ago, but it never got past the stage of mapping the relationships between the tables. It's one of the things that we could never get round to doing.Hi dev_list, Hi jahia devs
I'm still working on a migration tool for migration of database users to ldap users. So far the tool creates for every database user (without root, siteadmin and guest) a user on a specific part of a LDAP tree. Currently this is achieved by writing a LDIF file which is then programaticaly imported into the directory server. The user creation process and conversion is finished and works nicely.
My problem is to change the ACL's or at least the group membership in the jahia database tables to the newly created ldap users. I looked into the actual table structure and data... but I get no clue from it. Especially the jahia_grp_access table seems to mix groups & users on the same table column. Is there any formal database model?
As for the jahia_grp_access table, it has a column membertype_grp_access which allows to differentiate between user members and group members. So far in Jahia only type 1 (users) are supported by the GUI so all members of groups are always users (no groups in groups inclusion possible through the GUI).
This means you will also have to modify the entries in the jahia_acl_entries table, and also the jahia_site_users (this last one specifies which users are available on which site, as it is possible to share users across sites).The plan is:
1. rename every occurence of dbuserX to ldapuserX on tablesinvolved
2. finished :P
You might have to check (maybe do a find) because out of the top of my head I might have missed a few user references.
Regards, Serge Huber.
