Page 1 of 1

LDAP - propery ldap.filter not found (TrackStudio 5.0.2)

PostPosted: Fri Nov 14, 2014 7:52 am
by BigDave
Hi,
We have recently coverted our TrackStudio 3.5.12 (Unix) to TrackStudio 5.0.2 (Unix). The TrackStudio 3.5.12 was configured to use LDAP via the `trackstidio.ldap.properties` file. For TrackStudio 5.0.2, the exact LDAP properties were moved to the `trackstudio.security.properties` file. Unfortunately with TrackStudio 5.0.2 on UNIX, when attempting to login with a user id and password, the login fails and a `property ldap filter not found` message is displayed on the Login page (a similar error is seen in the catalina.out log file). The contents of the `trackstudio.security.properties` file and `catalina.out log file are shown below. Please advise on what ldap properties files are missing. The LDAP continues to function correctly with TrackStudio 3.5.12 (UNX). Also the TrackStudio 5.0.2 on Windows was successfully configured with SMAN to use LDAP and logins are successful. What extra properties are required for TrackStudio 5.0.2 on a UNIX environment? Thanks for any information.

##################################
# LDAP configuration options (Unix)#
#################################

## Authorize by name or login of TrackStudio user properties?
ldap.loginAttrTS login

## Authorize by dispayName (User name), sAMAccountName (Windows user logon
## name) or other of LDAP user properties

ldap.loginAttrLDAP sAMAccountName

## LDAP server port
ldap.port 389

trackstudio.useLDAP yes

ldap.baseDN DC=root,DC=sutterhealth,DC=org

ldap.host ldap.sutterhealth.org

ldap.userDN CN=dummybind,OU=Users,OU=wasprod,DC=root,DC=sutterhealth,DC=org

ldap.userDNpass dummypw
ldap.useSSL no

===================
Catalina.log (on UNIX)

Nov 13, 2014 3:36:56 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 71092 ms
Nov 13, 2014 3:37:33 PM org.apache.catalina.core.ApplicationContext log
INFO: HTMLManager: init: Associated with Deployer 'Catalina:type=Deployer,host=localhost'
Nov 13, 2014 3:37:33 PM org.apache.catalina.core.ApplicationContext log
INFO: HTMLManager: init: Global resources are available
Nov 13, 2014 3:37:33 PM org.apache.catalina.core.ApplicationContext log
INFO: HTMLManager: list: Listing contexts for virtual host 'localhost'
2014-11-13 15:37:53,133 INFO org.apache.struts.chain.ComposableRequestProcessor:init:147 - Initializing composable request processor for module prefix ''
2014-11-13 15:37:53,214 INFO org.apache.struts.chain.commands.servlet.CreateAction:createAction:97 - Initialize action of type: com.trackstudio.action.LoginAction
2014-11-13 15:38:07,087 INFO com.trackstudio.app.adapter.auth.LDAPAuthAdapter:authorizeImpl:74 - Authenticating as user DN = "CN=dummybind,OU=Users,OU=wasprod,DC=root,DC=sutterhealth,DC=org"
com.trackstudio.exception.GranException: property ldap.filter not found
at com.trackstudio.app.adapter.auth.LDAPAuthAdapter.authorizeImpl(LDAPAuthAdapter.java:92)
at com.trackstudio.app.adapter.auth.AuthAdapterManager.authorize(AuthAdapterManager.java:47)
at com.trackstudio.kernel.manager.UserManager.authenticate(UserManager.java:398)
at com.trackstudio.securedkernel.SecuredUserAdapterManager.authenticate(SecuredUserAdapterManager.java:618)
at com.trackstudio.action.LoginAction.login(LoginAction.java:188)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:601)
at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:269)
at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:170)
at com.trackstudio.action.LoginAction.execute(LoginAction.java:52)
at org.apache.struts.chain.commands.servlet.ExecuteAction.execute(ExecuteAction.java:58)
at org.apache.struts.chain.commands.AbstractExecuteAction.execute(AbstractExecuteAction.java:67)
at org.apache.struts.chain.commands.ActionCommandBase.execute(ActionCommandBase.java:51)
at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:191)
at org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:305)
at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:191)
at org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:283)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462)
at com.trackstudio.action.TSStrutsServlet.doGet(TSStrutsServlet.java:36)
at com.trackstudio.action.TSStrutsServlet.doPost(TSStrutsServlet.java:44)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:641)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at jcifs.http.NtlmHttpFilter.doFilter(NtlmHttpFilter.java:130)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at com.trackstudio.filters.CompressResponseFilter.doFilter(CompressResponseFilter.java:64)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:225)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1001)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:585)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
at java.lang.Thread.run(Thread.java:722)
2014-11-13 15:38:07,093 ERROR com.trackstudio.app.adapter.auth.AuthAdapterManager:authorize:52 - authorize
com.trackstudio.exception.GranException: property ldap.filter not found
at com.trackstudio.app.adapter.auth.LDAPAuthAdapter.authorizeImpl(LDAPAuthAdapter.java:92)
at com.trackstudio.app.adapter.auth.AuthAdapterManager.authorize(AuthAdapterManager.java:47)
at com.trackstudio.kernel.manager.UserManager.authenticate(UserManager.java:398)
at com.trackstudio.securedkernel.SecuredUserAdapterManager.authenticate(SecuredUserAdapterManager.java:618)
at com.trackstudio.action.LoginAction.login(LoginAction.java:188)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:601)
at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:269)
at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:170)
at com.trackstudio.action.LoginAction.execute(LoginAction.java:52)
at org.apache.struts.chain.commands.servlet.ExecuteAction.execute(ExecuteAction.java:58)
:

Re: LDAP - propery ldap.filter not found (TrackStudio 5.0.2)

PostPosted: Mon Nov 17, 2014 1:09 pm
by Petr
Hello.
you should put this line to trackstudio.security.default.properties

ldap.filter=(&(objectClass=*)(sAMAccountName={0}))

Re: LDAP - propery ldap.filter not found (TrackStudio 5.0.2)

PostPosted: Mon Nov 17, 2014 7:41 pm
by BigDave
Thank you, kindly. Your suggestion work perfectly. LDAP is now working just fine.