Re: jahia ldap migration / acl database model

Daniel Zimmermann wrote:

>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? 
>  
>
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.

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).

>The plan is:
>
>1. rename every occurence of dbuserX to ldapuserX on tablesinvolved
>2. finished :P
>  
>
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).

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.