Hello,

until now I don't understand how to add users to a group in Openldap with back-sql

I use a VIEW for ldap_entries like described in the manual pages of slapd-sql.

CREATE VIEW ldap_entries (id, dn, oc_map_id, parent, keyval) AS SELECT 0, UPPER(’o=MyCompany,c=NL’), 3, 0, ’baseObject’ FROM unixusers WHERE userid=’root’ UNION SELECT (1000000000+userid), UPPER(CONCAT(CONCAT(’cn=’,gecos),’,o=MyCompany,c=NL’)), 1, 0, userid FROM unixusers UNION SELECT (2000000000+groupnummer), UPPER(CONCAT(CONCAT(’cn=’,groupnaam),’,o=MyCompany,c=NL’)), 2, 0, groupnummer FROM groups;

How can I add users to a group?

1.) build additional entries like uid=testuser,cn=group1,o=MyCompany,c=NL

OR 2.) use the memberOf Attribute (but how?)

Thank you for your answers

Cheers, David