mileidysg

Solution: In the report properties: When No Data: No Data Section And define in No Data Section what you want to display Mileidys Gonzalez Prieto MSc

The follow solution is working for me Mileidys Gonzalez Prieto Code:<bean id="userSearch" class="org.springframework.security.ldap.search.FilterBasedLdapUserSearch"> <constructor-arg index="0" value=""/> <constructor-arg index="1" value="(&(sAMAccountName={0}) (| (memberOf=CN=Group1,OU=Groups,OU=Site,DC=mydc,DC=org) (memberOf=CN=Group2,OU=Groups,OU=Site,DC=mydc,DC=org) (memberOf=CN=Group3,OU=Groups,OU=Site,DC=mydc,DC=org) ))" /> <constructor-arg index="2" ref="contextSource" /> </bean>

Glad to hear that its ok now.

I guess u replace xxxx for the values according to your settings, right? Maybe u should make it simple first, instead of use: <constructor-arg index="1" value="(&(sAMAccountName={0})(|(memberOf=CN=xxxxx,OU=xxx,DC=xxxx,DC=xxx)(memberOf=CN=xxxxx,OU=xxx,DC=xxxx,DC=xxx)))" /> replace it by: <constructor-arg index="1" value="(sAMAccountName={0})" /> Add an entry on ur log4j configuration to debug the ldap area: log4j.logger.org.springframework.security=DEBUG, stdout, fileout log4j.logger.org.springframework.security.ldap=DEBUG, stdout, fileout

Post ur code please...

Here u have an example... Code: <!-- ldap provider 2 --> <bean id="contextSource-2" class="org.springframework.security.ldap.DefaultSpringSecurityContextSource"> <constructor-arg value="ldap://127.0.0.1:389/DC=xxxx,DC=xx"/> <property name="userDn" value="CN=xxxxx,OU=xxxxx,OU=xxx,DC=xxxx,DC=xx" /> <property name="password" value="password"/> <property name="referral" value="follow" /> </bean> <bean id="userSearch_ALL-2" class="org.springframework.security.ldap.search.FilterBasedLdapUserSearch"> <constructor-arg index="0" value=""/> <constructor-arg index="1" value="(&(sAMAccountName={0})(|(memberOf=CN=xxxxx,OU=xxx,DC=xxxx,DC=xxx)(memberOf=CN=xxxxx,OU=xxx,DC=xxxx,DC=xxx)))" /> <constructor-arg index="2" ref="contextSource-2" /> </bean> <bean id="ldapAuthenticationProvider-2" class="org.springframework.security.providers.ldap.LdapAuthenticationProvider"> <constructor-arg> <bean class="org.springframework.security.providers.ldap.authenticator.BindAuthenticator"> <constructor-arg ref="contextSource-2"/> <property name="userDnPatterns" value="OU=xxxxx" /> <property name="userSearch" ref="userSearch_ALL-2"/> </bean> </constructor-arg> <constructor-arg> <bean class="org.springframework.security.ldap.populator.DefaultLdapAuthoritiesPopulator"> <constructor-arg ref="contextSource-2" /> <constructor-arg value=""/> <property name="rolePrefix" value=""/> <property name="convertToUpperCase" value="true"/> <property name="searchSubtree" value="true"></property> <property name="groupRoleAttribute" value="cn" /> <property name="groupSearchFilter" value="(&(objectClass=group)(member={0}))" /> </bean> </constructor-arg> </bean> <bean id="authenticationManager" class="org.springframework.security.providers.ProviderManager"> <property name="providers"> <list> <ref local="ldapAuthenticationProvider-2"/> <ref local="anonymousAuthenticationProvider"/> <ref bean="${bean.daoAuthenticationProvider}"/> </list> </property> </bean>

Thank you for the details... very useful.

Hi, I'm been trying to set up a double LDAP authentication on my Jasperserver without success. I tested both of them and separately they work fine, but the situation appear when I enabled both of them. Both configurations used they own context, user search and group filter. Any clue on this, please? Code:<bean id="authenticationManager" class="org.springframework.security.providers.ProviderManager"> <property name="providers"> <list> <ref local="ldapAuthenticationProvider-2"/> <ref local="ldapAuthenticationProvider-1"/> <ref local="anonymousAuthenticationProvider"/> <ref bean="${bean.daoAuthenticationProvider}"/> </list> </property> </bean>

Well, according to your requirements you can say the LDAP authentication was succesfull when: a) Recognized the user by using the usersearch b) Populate the roles using the groupsearchfilter As usual a debug log can be activated on the log4j.properties with the line log4j.logger.org.springframework.security.ldap=DEBUG, stdout, fileout The information is stored on the log file jasperserver.log and there you can check the connection with the LDAP Server, if the user was found and if the roles are fine. Post Edited by mileidysg at 08/10/2010 09:59

Hi, I have some doubts regarding Crosstabs generate per each group item and the performance. What is better: 1. Use a datasource only with the data for each group item / subreport 2. Reset the datasource on each group item (the crosstab is filling with the same data from the main report) I was running the two versions here but the numbers are not consistente, maybe cache? I do not know. Please, can somebody give me any clue? Thank you

Great idea!!!

I have the same situation over here. My solution was to use the time directly in the sql query according to the time of the server and is fine.

I have the same... I took a look on the libraries of jasperserver, specifically the jasperreports jar library. The one in ireport 3.7.2 is different from the one stored at jasperserver application, in ireport the component table have been included... I will try later on to update the librarie in jasperserver to see if the system is working good.

Good to hear... Let me share also the configuration to get the roles on jasper. According to the complexity of your AD u will like to import to Jasper only some of the roles for the user, and based on that set permittions on jasper. In this case is only importing the groups assign to the cn filter in groupSearchFilter Code:<bean class="org.springframework.security.ldap.populator.DefaultLdapAuthoritiesPopulator"> <constructor-arg ref="contextSource" /> <constructor-arg value=""/> <property name="rolePrefix" value=""/> <property name="convertToUpperCase" value="true"/> <property name="groupRoleAttribute" value="cn"></property> <property name="searchSubtree" value="true"></property> <property name="groupSearchFilter" value="(&(objectClass=group)(|(cn=<cn here>)(cn=<cn here>))(member={0})))"/></bean>

I did like the code below, the information is with the format: CN=...,OU=..,OU=..,DC=..,DC=... I hope it helps Code:<bean id="userSearch_ALL" class="org.springframework.security.ldap.search.FilterBasedLdapUserSearch"> <constructor-arg index="0" value=""/> <constructor-arg index="1" value="(&(sAMAccountName={0})(|(memberOf=[info here])(memberOf=[info here])))" /> <constructor-arg index="2" ref="contextSource" /> </bean>

Where I can find a similar solution for JasperServer Community Edition? WARN PermissionsListProtectionDomainProvider,main:61 - A security manager has not been configured for the JVM. The protection domain se t for the reports will NOT be effective." Thanks, Post Edited by mileidysg at 04/16/2010 17:18

Hi, Mine is working... Just replace the line <code> <bean class="org.springframework.security.providers.ldap.populator.DefaultLdapAuthoritiesPopulator"></code> by <code> <bean class="org.springframework.security.ldap.populator.DefaultLdapAuthoritiesPopulator"></code> The previous class does not exist anymore. Hope it helps

You can use the export/import script located in the jasperserver directory. The documentation has some small examples of how to use it. The export will create a folder with xml files that contains all the information about the reports and their resources, those are the one that you must use to import to the other server.

Any exception at all... Just permission not granted... was like Jasperserver couldn't connect to the LDAP server

This is the log information: 2010-03-28 12:28:04,268 DEBUG ParseUtil,http-81-5:43 - Using iframe POST mode 2010-03-28 12:28:04,270 DEBUG BaseCallMarshaller,http-81-5:43 - Environment: c0-e13=number:2, c0-e28=boolean:false, c0-e42=boolean:false, c0-e6=Array:[], c0-e14=Array:[], c0-e33=string:0018, c0-e16=boolean:false, c0-e46=string:%2FFormsItems%2FInputControls%2FAbsentType, c0-e38=boolean:true, c0-e11=string:, c0-e43=Object_Object:{controlName:reference:c0-e44, controlValue:reference:c0-e45, resourceUriPrefix:reference:c0-e46, controlType:reference:c0-e47, optionsList:reference:c0-e48, visible:reference:c0-e49, disabled:reference:c0-e50}, c0-e8=boolean:false, c0-e1=Object_Object:{controlName:reference:c0-e2, controlValue:reference:c0-e3, resourceUriPrefix:reference:c0-e4, controlType:reference:c0-e5, optionsList:reference:c0-e6, visible:reference:c0-e7, disabled:reference:c0-e8}, c0-e31=string:Department, c0-e40=string:0018, c0-e3=string:, c0-e21=number:4, c0-e10=string:dateEnd, c0-e32=Array:[reference:c0-e33], c0-e5=number:2, c0-e27=boolean:true, c0-e41=boolean:true, c0-e26=string:BUSS, c0-e15=boolean:true, c0-e34=string:%2FFormsItems%2FInputControls%2FDepartment, c0-e35=number:7, c0-e44=string:AbsentType, c0-e45=Array:[], c0-e20=string:%2FFormsItems%2FInputControls%2FDivision, c0-e36=Array:[reference:c0-e37], c0-e25=string:Bussiness%20Development, c0-e22=Array:[reference:c0-e23], c0-e9=Object_Object:{controlName:reference:c0-e10, controlValue:reference:c0-e11, resourceUriPrefix:reference:c0-e12, controlType:reference:c0-e13, optionsList:reference:c0-e14, visible:reference:c0-e15, disabled:reference:c0-e16}, c0-e23=Object_Object:{selected:reference:c0-e24, label:reference:c0-e25, value:reference:c0-e26}, c0-e19=string:BUSS, c0-e30=Object_Object:{controlName:reference:c0-e31, controlValue:reference:c0-e32, resourceUriPrefix:reference:c0-e34, controlType:reference:c0-e35, optionsList:reference:c0-e36, visible:reference:c0-e41, disabled:reference:c0-e42}, c0-e29=boolean:true, c0-e24=boolean:true, c0-e18=string:Division, c0-e7=boolean:true, c0-e49=boolean:true, c0-e39=string:Information%20Services, c0-e17=Object_Object:{controlName:reference:c0-e18, controlValue:reference:c0-e19, resourceUriPrefix:reference:c0-e20, controlType:reference:c0-e21, optionsList:reference:c0-e22, visible:reference:c0-e27, disabled:reference:c0-e28, permanent:reference:c0-e29}, c0-e2=string:dateStart, c0-e48=Array:[], c0-e4=string:%2FFormsItems%2FInputControls%2FdateStart, c0-e50=boolean:false, c0-e47=number:7, c0-e37=Object_Object:{selected:reference:c0-e38, label:reference:c0-e39, value:reference:c0-e40}, c0-e12=string:%2FFormsItems%2FInputControls%2FdateEnd, 2010-03-28 12:28:04,271 DEBUG TypeHintContext,http-81-5:43 - Using type info from JDK5 reflection of com.jaspersoft.jasperserver.war.cascade.EventEnvelope for handleEvents(1<0>) 2010-03-28 12:28:04,272 DEBUG TypeHintContext,http-81-5:43 - Using type info from JDK5 reflection of com.jaspersoft.jasperserver.war.cascade.EventOption for setOptionsList(0<0>) 2010-03-28 12:28:04,273 DEBUG TypeHintContext,http-81-5:43 - Using type info from JDK5 reflection of com.jaspersoft.jasperserver.war.cascade.EventOption for setOptionsList(0<0>) 2010-03-28 12:28:04,275 DEBUG TypeHintContext,http-81-5:43 - Using type info from JDK5 reflection of com.jaspersoft.jasperserver.war.cascade.EventOption for setOptionsList(0<0>) 2010-03-28 12:28:04,276 INFO DefaultRemoter,http-81-5:51 - Exec: RemoteCascadeDirector.handleEvents() 2010-03-28 12:28:04,276 DEBUG DefaultRemoter,http-81-5:43 - --Object created, not stored. id=0 2010-03-28 12:28:04,364 WARN DefaultRemoter,http-81-5:67 - Method execution failed: java.lang.IndexOutOfBoundsException: Index: 0, Size: 0 at java.util.ArrayList.RangeCheck(ArrayList.java:546) at java.util.ArrayList.get(ArrayList.java:321) at com.jaspersoft.jasperserver.war.cascade.token.TokenControlLogic.executeQuery(TokenControlLogic.java:381) at com.jaspersoft.jasperserver.war.cascade.token.TokenControlLogic.processEnvelope(TokenControlLogic.java:151) at com.jaspersoft.jasperserver.war.cascade.token.TokenControlLogic.handleEvents(TokenControlLogic.java:131) at com.jaspersoft.jasperserver.war.cascade.ControlLogicDelegator.handleEvents(ControlLogicDelegator.java:106) at com.jaspersoft.jasperserver.war.cascade.CascadeDirector.handleEvents(CascadeDirector.java:45) at com.jaspersoft.jasperserver.war.cascade.CascadeDirector$$FastClassByCGLIB$$cb78188c.invoke(<generated>) at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:191) at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:700) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131) at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:635) at com.jaspersoft.jasperserver.war.cascade.CascadeDirector$$EnhancerByCGLIB$$1891e94d.handleEvents(<generated>) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:592) at org.directwebremoting.impl.ExecuteAjaxFilter.doFilter(ExecuteAjaxFilter.java:34) at org.directwebremoting.impl.DefaultRemoter$1.doFilter(DefaultRemoter.java:428) at org.directwebremoting.impl.DefaultRemoter.execute(DefaultRemoter.java:431) at org.directwebremoting.impl.DefaultRemoter.execute(DefaultRemoter.java:283) at org.directwebremoting.servlet.PlainCallHandler.handle(PlainCallHandler.java:52) at org.directwebremoting.servlet.UrlProcessor.handle(UrlProcessor.java:101) at org.directwebremoting.spring.DwrSpringServlet.doPost(DwrSpringServlet.java:158) at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.jaspersoft.jasperserver.war.common.UploadMultipartFilter.doFilter(UploadMultipartFilter.java:83) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378) at com.jaspersoft.jasperserver.war.security.JSSwitchUserProcessingFilter.doFilterHttp(JSSwitchUserProcessingFilter.java:146) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109) at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:139) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at com.jaspersoft.jasperserver.war.util.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:97) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:175) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:277) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:175) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at com.jaspersoft.jasperserver.api.logging.filter.BasicLoggingFilter.doFilter(BasicLoggingFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175) at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:67) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:525) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:859) at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:574) at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1527) at java.lang.Thread.run(Thread.java:595) 2010-03-28 12:28:04,365 DEBUG DebuggingPrintWriter,http-81-5:43 - out(30): //#DWR-INSERT 2010-03-28 12:28:04,366 DEBUG DebuggingPrintWriter,http-81-5:43 - out(30): //#DWR-REPLY 2010-03-28 12:28:04,367 DEBUG DebuggingPrintWriter,http-81-5:43 - out(30): dwr.engine._remoteHandleException('3','0',{javaClassName:"java.lang.Throwable",message:"Error"}); 2010-03-28 12:28:04,368 WARN BaseCallMarshaller,http-81-5:59 - --Erroring: batchId[3] message[java.lang.IndexOutOfBoundsException: Index: 0, Size: 0]

Seems related with an empty result of the query that bring the data to the second input control... Any idea? I'm using Jasperserver 3.7.0

Hi I'm getting an error by using a cascading input control (single value select list fills multiple value list): Code: Post Edited by mileidysg at 03/28/2010 13:22 Post Edited by mileidysg at 03/28/2010 13:23

How did you solve the second problem?

I found the same in the file login_welcome.jsp How should I resolve the rest of the missing files? Commenting as well as the common.js?

The same is happening with me.. What version of Jasperserver are you using?