One Star

tLDAPConnection, space within base DN and tLDAPAttributesInput

Hello,
My first test with talend open studio for DI with access to our AD Directory fails.
I've a simple test job with only tLDAPConnection, tLDAPAttributesInput, tSortRow and tLogRow and it dies with this exception :
Exception in component tLDAPAttributesInput_1
javax.naming.NamingException: [LDAP: error code 1 - 000020D6: SvcErr: DSID-031007DB, problem 5012 (DIR_ERROR), data 0
My Base DN contains a space : ou=Personnel CHL, ou=myusers,dc=mydomain,dc=com
I've spied queries with wireshark, the base DN sent to the server is only : ou=Personnel
I've made a test with only ou=myusers,dc=mydomain,dc=com and it worked (but I retrieved too much entries).
Is there a way to make it working ?
Rgds.
5 REPLIES
Community Manager

Re: tLDAPConnection, space within base DN and tLDAPAttributesInput

Hi
Try to add a single quote around the value that contains space
"ou='Personnel CHL', ou=myusers,dc=mydomain,dc=com"

If it does not work, please report a issue in our bugtracker, our developer will investigate it further.
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: tLDAPConnection, space within base DN and tLDAPAttributesInput

Hello,
Thanks for your answer, I've tested but unfortunately, now it looks for ou='Personnel only...
Jira issue filled : https://jira.talendforge.org/browse/TDI-27138
Philippe.
Community Manager

Re: tLDAPConnection, space within base DN and tLDAPAttributesInput

Hi Philippe
Thanks for reporting the issue in our bugtracker, let's monitor the issue and see the feedback from our developers.
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: tLDAPConnection, space within base DN and tLDAPAttributesInput

Hi Team,
Kindly let me know if there is any component by which we could query a LDAP source. I would be needing a functionality synonymous to 'Use PreparedStatement' in 'tMysqlRow' component.
I have a set of user names in a file and i want to lookup to an LDAP source to get few other attributes pertaining to a particular user. I was able to establish a connection to LDAP and i tried joining the file and LDAP by username by using tMap component. But, due to some LDAP configuration i am able to get only a subset of data from LDAP and not details of all usernames in LDAP.
Hence i wish to query the LDAP source directly pertaining to a username , similar to querying a database using the 'Use PreparedStatement' in 'tMysqlRow' component.

Please let me know on any update needed.
Thank You
Regards
Sudharshan
One Star

Re: tLDAPConnection, space within base DN and tLDAPAttributesInput

Hi Team,
Sorry about the last post irrelevant to the current thread. I tried creating a new thread for my query, but i posted as a response to the current query. Anyways, i tried deleting my post in this thread, but i am not able to do that.
Kindly pardon me .
Thank YOu