You can translate the question and the replies:

LDAP Datasource & Base View Creation

**System** Distributor ID: Ubuntu Description: Ubuntu 18.04.5 LTS Release: 18.04 Codename: bionic **Denodo** Version: 8 (denodo-install-8.0-ga-linux64) Updates: None **Issue** Ldap datasource gets created fine & 'Test Connection' succeeds. But the creation of a base view fails - both via 'Create Selected' & via 'Create from LDAP expression' The same LDAP expression works fine querying the LDAP server directly from a terminal... **slapd logs when querying directly** (success case) slapd[4411]: conn=1010 fd=16 ACCEPT from IP=127.0.0.1:48882 (IP=0.0.0.0:389) slapd[4411]: conn=1010 op=0 BIND dn="cn=admin,dc=xplordat,dc=com" method=128 slapd[4411]: conn=1010 op=0 BIND dn="cn=admin,dc=xplordat,dc=com" mech=SIMPLE ssf=0 slapd[4411]: conn=1010 op=0 RESULT tag=97 err=0 text= slapd[4411]: conn=1010 op=1 **SRCH base="dc=xplordat,dc=com"** scope=2 deref=0 filter="(objectClass=organizationalUnit)" slapd[4411]: conn=1010 op=1 SEARCH RESULT tag=101 **err=0** nentries=2 text= slapd[4411]: conn=1010 op=2 UNBIND slapd[4411]: conn=1010 fd=16 closed **slapd logs when the query comes from Denodo 8** (failure case) slapd[4411]: conn=1009 op=5 **SRCH base=""** scope=2 deref=3 filter="(&(objectClass=organizationalUnit))" slapd[4411]: conn=1009 op=5 SRCH attr=objectclass slapd[4411]: conn=1009 op=5 SEARCH RESULT tag=101 **err=32** nentries=0 text= The 'SRCH base' is missing in the failure case and hence the **[LDAP: error code 32 - No Such Object]** error? **Execution trace** QUERY: SELECT * FROM organizationalunit LIMIT 150 CONTEXT ('i18n'='us_pst', 'cache_wait_for_load'='true') TRACE EXECUTION PLAN ( name = Execution startTime = Mon Nov 30 11:46:52 465 PST 2020 endTime = Mon Nov 30 11:46:52 512 PST 2020 responseTime = - numRows = 0 state = ERROR completed = false waitingTime = 0 STATIC OPTIMIZATION ( staticOptimized = false staticOptimizationTime = 3 staticOptimizationStart = Mon Nov 30 11:46:52 481 PST 2020 staticOptimizationEnd = Mon Nov 30 11:46:52 484 PST 2020 ) BASE PLAN ( name = organizationalunit database = ldap_test startTime = Mon Nov 30 11:46:52 487 PST 2020 endTime = Mon Nov 30 11:46:52 512 PST 2020 responseTime = - numRows = 0 state = ERROR completed = false fields = [ou] search conditions = [] filter conditions = [] ordered = false numOfFilteredTuples = 0 numOfDuplicatedTuples = 0 numOfSwappedTuples = 0 swapping = false memoryLimitReached = false mainTime = 0 ns indexes = [] LDAP WRAPPER ( name = organizationalunit database = ldap_test startTime = Mon Nov 30 11:46:52 488 PST 2020 endTime = Mon Nov 30 11:46:52 512 PST 2020 responseTime = - numRows = 0 state = ERROR completed = false searchConditions = [] orderByFields = [] projectedFields = [ou] additionalSubPlans = 0 additionalErroneousSubPlans = 0 LDAP ROUTE ( name = organizationalunit#0 datasource = ldap_data_source datasource database = ldap_test startTime = Mon Nov 30 11:46:52 488 PST 2020 endTime = Mon Nov 30 11:46:52 512 PST 2020 responseTime = - numRows = 0 state = ERROR completed = false **exception = java.security.PrivilegedActionException ** LDAP URI = ldap://localhost:389 use paging = false userName = cn=admin,dc=xplordat,dc=com filter = (objectClass=organizationalUnit) recursive search = false projected attributes = [ou] connectionTime = 23 cachedStatus = false ) ) ) )
user
30-11-2020 14:49:52 -0500

1 Answer

Think I have resolved this isse. The 'SRCH base' to start at can be specified as part of the LDAP server uri (as per an another answer) Changing the 'Server URI' to: ldap://localhost:389/**dc=xplordat,dc=com** did the trick. The stuff in bold above was added to the original URI, and taken as the search base by the app.
user
30-11-2020 16:35:15 -0500
You must sign in to add an answer. If you do not have an account, you can register here