Sorry to be late... I was busy making other mistakes
I went back on this ldap test, and tried to quote/escape the ldap DN as suggested... if I got it.
It still doesn't work.
now from jboss-cli I get:
ls /subsystem=resource-adapters/resource-adapter=ldapQS/connection-definitions=ldapDS/config-properties=LdapAdminUserDN
value=\"CN=<username>,OU=<sub OU1>,OU=<sub OU2>,OU=<sub OU3>,OU=<sub OU4>,DC=<domainL3>,DC=<domainL2>,DC=<domainL1>\"
and in the standalone-teiid.xml file I have
<resource-adapter id="ldapQS">
<module slot="main" id="org.jboss.teiid.resource-adapter.ldap"/>
<connection-definitions>
<connection-definition class-name="org.teiid.resource.adapter.ldap.LDAPManagedConnectionFactory" jndi-name="java:/ldapDS" enabled="true" use-java-context="true" pool-name="ldapDS">
<config-property name="LdapAdminUserPassword">
<thepassword>
</config-property>
<config-property name="LdapUrl">
ldap://<the ip address>:389
</config-property>
<config-property name="LdapAdminUserDN">
\"CN=<username>,OU=<sub OU1>,OU=<sub OU2>,OU=<sub OU3>,OU=<sub OU4>,DC=<domainL3>,DC=<domainL2>,DC=<domainL1>\"
</config-property>
</connection-definition>
</connection-definitions>
</resource-adapter>
where obviously I replaced here the right, valid, tested, values with sample values like <sample value>
from squirrel, any query gets:
Error: TEIID30504 Remote org.teiid.core.TeiidProcessingException: TEIID30504 local: TEIID60000 javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:/ldapDS
SQLState: 50000
ErrorCode: 30504
(below is the whole stack trace after the sql query)
the key error seems to be:
Unable to get managed connection for java:/ldapDS'. Originally TeiidProcessingException '[LDAP: error code 49 - 80090308: LdapErr: DSID-0C090334, comment: AcceptSecurityContext error, data 525, vece]' LdapCtx.java:3088.
but I am double sure all auth values are sure, as said above...
17:02:08,868 WARN [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue23) bDBgzW1ds+5s Connector worker process failed for atomic-request=bDBgzW1ds+5s.9.0.1095: org.teiid.translator.TranslatorException: TEIID60000 javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:/ldapDS
at org.teiid.translator.ExecutionFactory.getConnection(ExecutionFactory.java:175) [teiid-api-8.12.3.jar:8.12.3]
at org.teiid.translator.ExecutionFactory.getConnection(ExecutionFactory.java:194) [teiid-api-8.12.3.jar:8.12.3]
at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:313)
at sun.reflect.GeneratedMethodAccessor103.invoke(Unknown Source) [:1.7.0_91]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_91]
at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_91]
at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211)
at com.sun.proxy.$Proxy46.execute(Unknown Source)
at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:306)
at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:112)
at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108)
at java.util.concurrent.FutureTask.run(FutureTask.java:262) [rt.jar:1.7.0_91]
at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:65)
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276)
at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119)
at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_91]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_91]
at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_91]
Caused by: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:/ldapDS
at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:421)
at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:327)
at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:510)
at org.teiid.resource.spi.WrappedConnectionFactory.getConnection(WrappedConnectionFactory.java:58) [teiid-api-8.12.3.jar:8.12.3]
at org.teiid.translator.ExecutionFactory.getConnection(ExecutionFactory.java:173) [teiid-api-8.12.3.jar:8.12.3]
... 18 more
Caused by: javax.resource.ResourceException: IJ000658: Unexpected throwable while trying to create a connection: null
at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.getConnection(SemaphoreArrayListManagedConnectionPool.java:421)
at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getSimpleConnection(AbstractPool.java:453)
at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getConnection(AbstractPool.java:425)
at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:354)
... 22 more
Caused by: javax.resource.ResourceException: Initializing LDAP directory context failed. Please check LDAP connection properties, including username and password: [LDAP: error code 49 - 80090308: LdapErr: DSID-0C090334, comment: AcceptSecurityContext error, data 525, vece]
at org.teiid.resource.adapter.ldap.LDAPConnectionImpl.initializeLDAPContext(LDAPConnectionImpl.java:151)
at org.teiid.resource.adapter.ldap.LDAPConnectionImpl.<init>(LDAPConnectionImpl.java:75)
at org.teiid.resource.adapter.ldap.LDAPManagedConnectionFactory$1.getConnection(LDAPManagedConnectionFactory.java:49)
at org.teiid.resource.adapter.ldap.LDAPManagedConnectionFactory$1.getConnection(LDAPManagedConnectionFactory.java:43)
at org.teiid.resource.spi.BasicManagedConnectionFactory.createManagedConnection(BasicManagedConnectionFactory.java:71) [teiid-api-8.12.3.jar:8.12.3]
at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.createConnectionEventListener(SemaphoreArrayListManagedConnectionPool.java:834)
at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.getConnection(SemaphoreArrayListManagedConnectionPool.java:379)
... 25 more
Caused by: javax.naming.AuthenticationException: [LDAP: error code 49 - 80090308: LdapErr: DSID-0C090334, comment: AcceptSecurityContext error, data 525, vece]
at com.sun.jndi.ldap.LdapCtx.mapErrorCode(LdapCtx.java:3088) [rt.jar:1.7.0_91]
at com.sun.jndi.ldap.LdapCtx.processReturnCode(LdapCtx.java:3034) [rt.jar:1.7.0_91]
at com.sun.jndi.ldap.LdapCtx.processReturnCode(LdapCtx.java:2836) [rt.jar:1.7.0_91]
at com.sun.jndi.ldap.LdapCtx.connect(LdapCtx.java:2750) [rt.jar:1.7.0_91]
at com.sun.jndi.ldap.LdapCtx.<init>(LdapCtx.java:317) [rt.jar:1.7.0_91]
at com.sun.jndi.ldap.LdapCtxFactory.getUsingURL(LdapCtxFactory.java:193) [rt.jar:1.7.0_91]
at com.sun.jndi.ldap.LdapCtxFactory.getUsingURLs(LdapCtxFactory.java:211) [rt.jar:1.7.0_91]
at com.sun.jndi.ldap.LdapCtxFactory.getLdapCtxInstance(LdapCtxFactory.java:154) [rt.jar:1.7.0_91]
at com.sun.jndi.ldap.LdapCtxFactory.getInitialContext(LdapCtxFactory.java:84) [rt.jar:1.7.0_91]
at org.jboss.as.naming.InitialContext.getDefaultInitCtx(InitialContext.java:122)
at org.jboss.as.naming.InitialContext.init(InitialContext.java:107)
at javax.naming.ldap.InitialLdapContext.<init>(InitialLdapContext.java:153) [rt.jar:1.7.0_91]
at org.jboss.as.naming.InitialContext.<init>(InitialContext.java:98)
at org.jboss.as.naming.InitialContextFactory.getInitialContext(InitialContextFactory.java:44)
at javax.naming.spi.NamingManager.getInitialContext(NamingManager.java:684) [rt.jar:1.7.0_91]
at javax.naming.InitialContext.getDefaultInitCtx(InitialContext.java:307) [rt.jar:1.7.0_91]
at javax.naming.InitialContext.init(InitialContext.java:242) [rt.jar:1.7.0_91]
at javax.naming.ldap.InitialLdapContext.<init>(InitialLdapContext.java:153) [rt.jar:1.7.0_91]
at org.teiid.resource.adapter.ldap.LDAPConnectionImpl.initializeLDAPContext(LDAPConnectionImpl.java:148)
... 31 more
17:02:09,005 WARN [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue24) bDBgzW1ds+5s TEIID30020 Processing exception for request bDBgzW1ds+5s.9 'TEIID30504 local: TEIID60000 javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:/ldapDS'. Originally TeiidProcessingException '[LDAP: error code 49 - 80090308: LdapErr: DSID-0C090334, comment: AcceptSecurityContext error, data 525, vece]' LdapCtx.java:3088. Enable more detailed logging to see the entire stacktrace.
Any hint welcome...