rewrite DN from login@domain.com into uid=login,dc=domain,dc=com

[virtual-ldap] / sql / hreduperson.sql

diff --git a/sql/hreduperson.sql b/sql/hreduperson.sql
index b068bd7..568e5f5 100644 (file)
--- a/sql/hreduperson.sql
+++ b/sql/hreduperson.sql
@@ -1,6 +1,6 @@
 
 select
-       concat('uid=',trim(userid))                     as dn,
+       concat('uid=',trim(userid),',ou=',categorycode,',dc=ffzg,dc=hr')        as dn,
        'person
        organizationalPerson
        inetOrgPerson
@@ -18,6 +18,7 @@ select
        email                                           as mail,
        categorycode                                    as memberOf,
        categorycode                                    as ou,
+       categorycode                                    as department,
        concat('/home/',borrowernumber)                 as homeDirectory
 from borrowers