Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

and run it against your JIRA database as the 'postgres' user (or equivalent superuser able to enable extensions):

Code Block
psql -tAq jira < /tmp/crowd_to_ldapsearch.sql

...

Code Block
$ psql -tAq < ~/crowd_to_ldapsearch.sql 
␀
# For directory 10000
ldapsearch \
-LL -x -z5 \
-H ldaps://tx-dc2.corp.example.com:636 \
-D 'CN=svcLDAPquery,CN=Managed Service Accounts,DC=corp,DC=example,DC=com' \
-w 'REDACTED' \
-b 'OU=Internal,DC=corp,DC=example,DC=com' \
-s sub \
'(&(objectCategory=Person)(sAMAccountName=*))' sAMAccountName displayName givenName sn mail
Time: 2.063 ms