projects
/
virtual-ldap
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
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
d0eb058
..
568e5f5
100644
(file)
--- a/
sql/hreduperson.sql
+++ b/
sql/hreduperson.sql
@@
-1,6
+1,6
@@
select
select
- concat('uid=',trim(userid)
)
as dn,
+ concat('uid=',trim(userid)
,',ou=',categorycode,',dc=ffzg,dc=hr')
as dn,
'person
organizationalPerson
inetOrgPerson
'person
organizationalPerson
inetOrgPerson
@@
-16,7
+16,8
@@
select
surname as displayName,
rfid_sid as pager,
email as mail,
surname as displayName,
rfid_sid as pager,
email as mail,
--- categorycode as memberOf,
+ categorycode as memberOf,
+ categorycode as ou,
categorycode as department,
concat('/home/',borrowernumber) as homeDirectory
from borrowers
categorycode as department,
concat('/home/',borrowernumber) as homeDirectory
from borrowers