back-sql : defining groups

[DavidHornung <hornuda@googlemail.com>]

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