f_chas01

I have Installed a JasperReports Server based on an ORACLE DB. Everything works fine, except for the dashboards. Each report area displays in the top left corner a frame about the report containing no data but the report itself is displayed at the right of it. The reports used in the dashboard are displyed without this empty report frame when run separately. I have add two screenshots to demonstrate the problem. Does anybody know, what causes this problem?

Are there any documentation on this topic? I found quite less regarding the custom flash elements in JasperReports. There ist no options for entering a hyperlink for the flash map using iReport interface. PS: Some flash maps listed do not work like the german state maps. Post Edited by f_chas01 at 07/15/2011 14:32

I understand the importance of the parameter order. But still it is about a value of a parameter (which is defined in the XML report definition at the right place) used as a default value for another parameter (coming few lines after the first one). The problem is at the Input Control stage in the JasperReports Server. In iReport the value of the first parameter is defined by user before the evaluation of the second parameter which does not require an input control. So in iReport as soon as the first parameter is defined all depended parameters can be defined as well. In JasperReports Server the evaluation of the parameters which do NOT require an input control happens BEVOR the user defines the value of the defining parameter. So if I use the value of a defining parameter in the dependant parameter in an expression the value used is null. The use case scenario is when we have one parameter defined by the user via input control and several dependant parameters which do not require the input control and can be calculated from the first parameter. Simple Example: user is entering the year and we want to define as another parameter the last day of the previous year. How can we do it in JasperReports Server?

Hello, I have intalled JasperReports Server from the WAR file. I am using an oracle DB and a tomcat server. Everything is working perfectly except for the js-import and js-export tools. Any attempt to run one of the tools results in a tonne of errors. The reason seems to be a oracle jdbs driver which can not be found. The point is, that the jdbc driver is deployed. ojdbc14.jar is in the classpath and OracleDriver class can be found. I checked it using the java oracle.jdbc.OracleDriver which results in Exception in thread "main" java.lang.NoSuchMethodError: main Does anybody know what it might be? Here are the error messages I get when I try to start js-export. Code: Post Edited by f_chas01 at 07/14/2011 14:03

I am still trying to understand it. Does somebody have any experience with it?

Can somebody tell me whether it is possible to execute a report on click event of the flash map?

teodord Wrote: Hi, What version of JR are you using? Thank you, Teodor I am using the JasperReport Server 4.1 bundle

Did someone encountered the same problem?

Is there nothing one can do? I am curious about this little response.

There is some obvious problem while parsing the sql query. Parsing this query works perfectly: select '01.02.$P!{P_YEAR}' txt from dual But if the parameter is within some certain bracket constallation it does not work, example: select to_char(last_day(to_date('01.02.$P!{P_YEAR}', 'dd.mm.yyyy')),'DD') txt from dual $P!{} will not be evaluated. You will get the same error message, as if you would write select to_char(last_day(to_date('01.02.blablabla', 'dd.mm.yyyy')),'DD') txt from dual The error is: Code: Post Edited by f_chas01 at 06/29/2011 14:35

I have a simple question. I want to use a value provided by the user via Input Control in JasperServer for the defaultValueExpression in the jrxml report definition. Is it possible? In report jrxml it looks like: <defaultValueExpression><![CDATA["16.10."+(new Integer(Integer.valueOf($P{P_JAHR}).intValue() - 1).toString())]]></defaultValueExpression> P_JAHR is provided via Input Control. In iReport this construction works perfectly. But using the same report definition in JasperServer with Input Controls causes the following error: Code:com.jaspersoft.jasperserver.api.JSExceptionWrapper: net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression : Source text : "16.10."+(new Integer(Integer.valueOf($P{P_JAHR}).intValue() - 1).toString())

I also would appriciate if someone would give an advice, how to alternatively implement this szenario.

I have tried to execute a custom report with 2 date input controls and encountered a strage error. I decided to execute a standard Freight Sample Report which worked for me perfectly in 4.0 and got the same error. The symptoms are: when you trying to run the report - the first thing you see is an error pop up window. When you close it, you can modify the input control values. The error window look like this: http://img687.imageshack.us/img687/6356/errorparameter.png Does anybody have an idea what it might be? With regards, Friedrich Code: Post Edited by f_chas01 at 06/28/2011 10:33

I can't find the ODBO connector within the Jaspersoft BI Enterprise edition. Is there a way to test the driver? With regards, Friedrich

I am wondering if there is a way to use maps in the report which could provide parameters (depending on where the user clicks on the map) for executing a certain report. I've seen a Map Pro example which is provided with in the JasperReports Server. There is a flash map where you can only see one single value when you put the cursor over the certain part of the flash map. The question is: is there a way to execute a report with a certain parameter value depending on the area the user has selected on the map? With regards, Friedrich

This must be the deciding part: 2011-06-16 10:37:25,172 DEBUG JIPortletAuthenticationProcessingFilter,http-8484-4:86 - Requested from Trusted Host IP:192.168.5.101 2011-06-16 10:37:25,219 DEBUG JIPortletAuthenticationProcessingFilter,http-8484-4:139 - Created New User:bruno@7cogs.com -^user object is created here^- 2011-06-16 10:37:25,219 INFO MTJIPortletAuthenticationProcessingFilter,http-8484-4:153 - Creating portlet tenant 10494 -^portlet organization is created, 10494 is the ID of the Liferay orga^- 2011-06-16 10:37:31,687 DEBUG JIPortletAuthenticationProcessingFilter,http-8484-4:151 - Created Authentication Object within JIPortletAuthenticationProcessingFilter 2011-06-16 10:37:31,687 DEBUG MTBasicProcessingFilter,http-8484-4:74 - Authorization header: Basic YnJ1bm9AN2NvZ3MuY29tOg== 2011-06-16 10:37:31,906 DEBUG MTUserAuthorityServiceImpl,http-8484-4:141 - No such user as: bruno@7cogs.com in tenant null -^This is where it looks like something going wrong. Why is the tanant null when few seconds ago the tenant 10494 was created?^ - 2011-06-16 10:37:31,906 DEBUG MTUserAuthorityServiceImpl,http-8484-4:191 - User not found with username "bruno@7cogs.com" in tenant alias null -^The same here^ - 2011-06-16 10:37:31,922 WARN LoggerListener,http-8484-4:60 - Authentication event AuthenticationFailureBadCredentialsEvent: bruno@7cogs.com; details: com.jaspersoft.jasperserver.multipleTenancy.MTWebServicesAuthenticationDetails@84b158; exception: Bad credentials -^This part is also weird. How could there be bad credentials when user successfully logs on into the JasperServer and can browse the repository of the portlet organization?^ - Post Edited by f_chas01 at 06/17/2011 07:43

I've discovered the following problem: While integrating JasperServer in Liferay via JasperServer portlet the portlet organization is being imported in JasperServer. It works and one can work with JasperServer via portlet _as long as JasperServer is running_. If you try to restart JasperServer, it will not start. I tested it several times - each time the same effect. Can anybody please take a look on the logs? Here are the logs. The first part is for for the importing the portlet organization and user in JasperServer: 2011-06-16 10:37:25,172 DEBUG JIPortletAuthenticationProcessingFilter,http-8484-4:75 - Trusted Host Authentication. 2011-06-16 10:37:25,172 DEBUG JIPortletAuthenticationProcessingFilter,http-8484-4:86 - Requested from Trusted Host IP:192.168.5.101 2011-06-16 10:37:25,219 DEBUG JIPortletAuthenticationProcessingFilter,http-8484-4:139 - Created New User:bruno@7cogs.com 2011-06-16 10:37:25,219 INFO MTJIPortletAuthenticationProcessingFilter,http-8484-4:153 - Creating portlet tenant 10494 2011-06-16 10:37:31,687 DEBUG JIPortletAuthenticationProcessingFilter,http-8484-4:151 - Created Authentication Object within JIPortletAuthenticationProcessingFilter 2011-06-16 10:37:31,687 DEBUG MTBasicProcessingFilter,http-8484-4:74 - Authorization header: Basic YnJ1bm9AN2NvZ3MuY29tOg== 2011-06-16 10:37:31,906 DEBUG MTUserAuthorityServiceImpl,http-8484-4:141 - No such user as: bruno@7cogs.com in tenant null 2011-06-16 10:37:31,906 DEBUG MTUserAuthorityServiceImpl,http-8484-4:191 - User not found with username "bruno@7cogs.com" in tenant alias null 2011-06-16 10:37:31,922 WARN LoggerListener,http-8484-4:60 - Authentication event AuthenticationFailureBadCredentialsEvent: bruno@7cogs.com; details: com.jaspersoft.jasperserver.multipleTenancy.MTWebServicesAuthenticationDetails@84b158; exception: Bad credentials 2011-06-16 10:37:31,984 WARN LoggerListener,http-8484-4:60 - Authentication event AuthenticationSuccessEvent: bruno@7cogs.com; details: com.jaspersoft.jasperserver.multipleTenancy.MTWebServicesAuthenticationDetails@3c12f 2011-06-16 10:37:31,984 DEBUG MTBasicProcessingFilter,http-8484-4:169 - Authentication success: org.springframework.security.providers.UsernamePasswordAuthenticationToken@fed80c01: Principal: MetadataUserDetails: bruno@7cogs.com; Password: [PROTECTED]; Authenticated: true; Details: com.jaspersoft.jasperserver.multipleTenancy.MTWebServicesAuthenticationDetails@3c12f; Granted Authorities: com.jaspersoft.jasperserver.api.metadata.user.domain.impl.client.TenantAwareGrantedAuthority@802d16, com.jaspersoft.jasperserver.api.metadata.user.domain.impl.client.TenantAwareGrantedAuthority@1101c54 While trying to restart JasperServer the following happening: 2011-06-16 10:41:03,703 ERROR ContextLoader,Thread-1:215 - Context initialization failed org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'proOnStartPropagator' defined in ServletContext resource [/WEB-INF/applicationContext-multiTenancy-web.xml]: Invocation of init method failed; nested exception is com.jaspersoft.jasperserver.api.metadata.common.service.JSResourceNotFoundException: jsexception.folder.not.found.at at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1338) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:473) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409) at java.security.AccessController.doPrivileged(Native Method) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:429) at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:728) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:380) at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:255) at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:199) at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:45) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3972) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4467) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546) at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637) at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053) at org.apache.catalina.core.StandardHost.start(StandardHost.java:785) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443) at org.apache.catalina.core.StandardService.start(StandardService.java:519) at org.apache.catalina.core.StandardServer.start(StandardServer.java:710) at org.apache.catalina.startup.Catalina.start(Catalina.java:581) 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:597) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414) Caused by: com.jaspersoft.jasperserver.api.metadata.common.service.JSResourceNotFoundException: jsexception.folder.not.found.at at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.getFolder(HibernateRepositoryServiceImpl.java:382) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl$11.execute(HibernateRepositoryServiceImpl.java:336) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.HibernateDaoImpl.executeWriteCallback(HibernateDaoImpl.java:73) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.HibernateDaoImpl.executeWriteCallback(HibernateDaoImpl.java:64) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.saveFolder(HibernateRepositoryServiceImpl.java:304) 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:597) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy0.saveFolder(Unknown Source) at com.jaspersoft.ji.war.themes.MTThemeOnStartPropagator.createFolderByTemplate(MTThemeOnStartPropagator.java:133) at com.jaspersoft.ji.war.themes.MTThemeOnStartPropagator.ensureDefaultFolder(MTThemeOnStartPropagator.java:111) at com.jaspersoft.ji.war.themes.MTThemeOnStartPropagator.afterPropertiesSet(MTThemeOnStartPropagator.java:53) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1369) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1335) ... 39 more

Problem is solved. Do not try to use JapserReportServer-4.0.0-Portlet with Liferay 6.x Version. It supports per default only the 5.2.3 Version. --------- I was trying to get the Liferay-5.2.3-JasperReportsServer-4.0.0-Portlet.zip working with my JasperReport Server. I managed to put Liferay 6.0.5 online and add the JasperReport Server portlet. I also configured the Jasperserver and the portlet as mantioned in the documentation. My Problem is that the portlet does not display any content. It looks like this: http://img26.imageshack.us/img26/6701/liferaysilent.png Here is what I've done. - Liferay is on the different machine. Both machines: the one with Jasperserver and the other one with Liferay are in the same local network and can ping each other. - applicationContext-security-web.xml is configured with: <property name="trustedIpAddress"> <list> <value>192.168.5.112</value> <!--ip of the Liferay machine --> </list> </property> -applicationContext-multiTenancy-web.xml is configured with: <bean id="mtPortletAuthenticationProcessingFilter" parent="portletAuthenticationProcessingFilter" [...] <property name="portletOrganizationId" value="10494"/> <!-- id of the Liferay organization I wold like to use--> </bean> - portlet.xml (of the JasperReport Server portlet) is configured with: <init-param> <name>jasperserver_repository_ws_url</name> <value>http://192.168.6.136:8484/jasperserver-pro/services/repository</value> <!-- url to the Jasperserver Repository Web Service--> </init-param> ------- I dont see Liferay trying to connect to Jasperserver and I cannot fint the way to trace it. Can anybody please give me hint where to look or what to modify? With regards, Friedrich Post Edited by f_chas01 at 06/10/2011 12:21 Post Edited by f_chas01 at 06/10/2011 13:00

I am glad it worked for you.

It seems to fail while searching for the groups the user is assigned to (in the AD) Try to check following things. 1) Change the default ldapContextSource for searching for groups. <bean class="org.springframework.security.ldap.populator.DefaultLdapAuthoritiesPopulator">- ...- <constructor-arg index="1"> <value /> </constructor-arg>Here is an example: <constructor-arg index="1"><value>cn=Users</value></constructor-arg> In the Spring Security API it is said that you have to provide this parameter. In other case the search function will not work. 2) Check and recheck whether you can access your entire AD with the account you use to bind with AD. It might be that it is restricted in some way. (try LDAP Browser as a Tool) When the roles are found you will see the following message: 2011-05-09 11:46:26,718 DEBUG DefaultLdapAuthoritiesPopulator,http-8484-3:202 - Searching for roles for user .... 2011-05-09 11:46:26,718 DEBUG SpringSecurityLdapTemplate,http-8484-3:148 - Using filter: ... 2011-05-09 11:46:26,734 DEBUG DefaultLdapAuthoritiesPopulator,http-8484-3:210 - Roles from search: [LAWUSER, LOCALUSER] Post Edited by f_chas01 at 05/09/2011 12:53

you have to check the proprties of the data source. On the screen it is the 10.0.1.19 data source. Check whether it has the same properties as the data source you have used in iReport 3.0.x

Check following things. 1) Check if you really can use - <property name="userDn"> <value>Administrator</value> FAs far as I know you have to use a Full DN Name as a value. Here is the example:<property name="userDn"><value>CN=Servicer Serv,CN=Users,DC=corp,DC=ama-eve,DC=dyndns,DC=org</value></property> 32) Check the userSearch bean. I am quite sure that the reason for bad credentials error is caused by not being able to find the user. Try to change <bean id="userSearch" class="org.springframework.security.ldap.search.FilterBasedLdapUserSearch">- <constructor-arg index="0"> <value>OU=xxxxxxxx,OU=xxxxx,OU=xxxxxxxxxx</value> t to <bean id="userSearch" class="org.springframework.security.ldap.search.FilterBasedLdapUserSearch">- <constructor-arg index="0"> <value></value> It will alow to search in the entire tree. 3) if it does not help try to turn on the logs for following packages. It will give you a bit more information.log4j.logger.com.jaspersoft.jasperserver.multipleTenancy.MTUserAuthorityServiceImpl=DEBUG, stdout, fileout log4j.logger.org.springframework.security.ldap=DEBUG, stdout, fileout log4j.logger.org.springframework.security.providers.dao=DEBUG, stdout, fileout log4j.logger.org.springframework.security.userdetails.ldap=DEBUG, stdout, fileout log4j.logger.org.springframework.security.ui.webapp=DEBUG, stdout, fileout log4j.logger.org.springframework.security.event.authentication=DEBUG, stdout, fileout Let me know, if it does not work for you. Post Edited by f_chas01 at 05/09/2011 11:08

Here are the steps I made. As I sad the configuration of my System is: -Active Directory on Windows Server 2008 with the domain corp.ama-eve.dyndns.org -I am able to bind to Active Directory on the machine where my WebApp is. For binding I use LDAP Administrator. The LDAP URL used in LDAP Administrator is ldap://192.168.5.101:389/DC=corp,DC=ama-eve,DC=dyndns,DC=org??one?(objectClass=*) -Anonym browsing of AD is forbidden. For browsing ldap folders I can use different principals like: CN=Administrator,CN=Users,DC=corp,DC=ama-eve,DC=dyndns,DC=org (Administrator@corp.ama-eve.dyndns.org) or CN=service_acc,CN=Users,DC=corp,DC=ama-eve,DC=dyndns,DC=org (service_acc@corp.ama-eve.dyndns.org) I have added the ldap provider in applicationContext-security.xml: <bean id="authenticationManager" class="org.springframework.security.providers.ProviderManager"> <property name="providers"> <list><ref local="ldapAuthenticationProvider"/> <ref bean="${bean.daoAuthenticationProvider}"/> <ref bean="anonymousAuthenticationProvider"/></list> </property> </bean> I have entered the correct ldap url (Spring Security can connect to the ldap since it reacts on entering wrong ldap url): <bean id="ldapContextSource" class="org.springframework.security.ldap.DefaultSpringSecurityContextSource"> <constructor-arg value="ldap://192.168.5.101:389/DC=corp,DC=ama-eve,DC=dyndns,DC=org"/> <property name="userDn"><value>CN=service_acc,CN=Users,DC=corp,DC=ama-eve,DC=dyndns,DC=org</value></property> <property name="password"><value>MyPassword</value></property> </bean> I use userSearch for finding users: <bean id="ldapAuthenticationProvider" class="org.springframework.security.providers.ldap.LdapAuthenticationProvider"> <constructor-arg> <bean class="org.springframework.security.providers.ldap.authenticator.BindAuthenticator"> <constructor-arg><ref local="ldapContextSource"/></constructor-arg> <property name="userSearch" ref="userSearch"/> </bean> </constructor-arg> <bean id="userSearch" class="org.springframework.security.ldap.search.FilterBasedLdapUserSearch"> <constructor-arg index="0"><value>CN=Users</value></constructor-arg> <constructor-arg index="1"><value>(sAMAccountName={0})</value></constructor-arg> <constructor-arg index="2"><ref local="ldapContextSource"/></constructor-arg> <property name="searchSubtree"><value>true</value></property> </bean> Symptoms: - When I try to connect using credentials from ldap I get this: 2011-05-04 16:07:30,160 WARN LoggerListener,http-8484-5:60 - Authentication event AuthenticationFailureBadCredentialsEvent: Administrator; details: com.jaspersoft.jasperserver.multipleTenancy.MTWebAuthenticationDetails@fffd148a: RemoteIpAddress: 127.0.0.1; SessionId: D5043C32241F76C089F3D182546C5239; exception: Bad credentials - I've tried to change userDn for ldap bind to Administrator@corp.ama-eve.dyndns.org - nothing happens. - Any changes to UserDN and Password in ldapContextSource have no effect. (logging in log4j.properties is set to log4j.logger.org.springframework.security.providers.ldap=ALL, stdout, fileout) - Adding userDnPatterns to BindAuthenticator: <bean id="ldapAuthenticationProvider" class="org.springframework.security.providers.ldap.LdapAuthenticationProvider"> <constructor-arg> <bean class="org.springframework.security.providers.ldap.authenticator.BindAuthenticator"> <constructor-arg><ref local="ldapContextSource"/></constructor-arg> <property name="userDnPatterns"> <list> <value>sAMAccountName={0}, CN=Users,DC=corp,DC=ama-eve,DC=dyndns,DC=org</value> <value>sAMAccountName={0}, OU=Sales,DC=corp,DC=ama-eve,DC=dyndns,DC=org</value> <value>sAMAccountName={0}, OU=accounts,DC=corp,DC=ama-eve,DC=dyndns,DC=org</value> </list> </property> <property name="userSearch" ref="userSearch"/> </bean> </constructor-arg> ... generate following log output: 2011-05-04 16:07:29,988 DEBUG BindAuthenticator,http-8484-5:117 - Failed to bind as sAMAccountName=Administrator, CN=Users,DC=corp,DC=ama-eve,DC=dyndns,DC=org: org.springframework.ldap.AuthenticationException: [LDAP: error code 49 - 80090308: LdapErr: DSID-0C0903AA, comment: AcceptSecurityContext error, data 525, v1771 ]; nested exception is javax.naming.AuthenticationException: [LDAP: error code 49 - 80090308: LdapErr: DSID-0C0903AA, comment: AcceptSecurityContext error, data 525, v1771 ] 2011-05-04 16:07:30,020 DEBUG BindAuthenticator,http-8484-5:117 - Failed to bind as sAMAccountName=Administrator, OU=Sales,DC=corp,DC=ama-eve,DC=dyndns,DC=org: org.springframework.ldap.AuthenticationException: [LDAP: error code 49 - 80090308: LdapErr: DSID-0C0903AA, comment: AcceptSecurityContext error, data 525, v1771 ]; nested exception is javax.naming.AuthenticationException: [LDAP: error code 49 - 80090308: LdapErr: DSID-0C0903AA, comment: AcceptSecurityContext error, data 525, v1771 ] 2011-05-04 16:07:30,051 DEBUG BindAuthenticator,http-8484-5:117 - Failed to bind as sAMAccountName=Administrator, OU=accounts,DC=corp,DC=ama-eve,DC=dyndns,DC=org: org.springframework.ldap.AuthenticationException: [LDAP: error code 49 - 80090308: LdapErr: DSID-0C0903AA, comment: AcceptSecurityContext error, data 525, v1771 ]; nested exception is javax.naming.AuthenticationException: [LDAP: error code 49 - 80090308: LdapErr: DSID-0C0903AA, comment: AcceptSecurityContext error, data 525, v1771 ] - I have tried to change <value>sAMAccountName={0}, CN=Users,DC=corp,DC=ama-eve,DC=dyndns,DC=org</value> to <value>sAMAccountName={0}, CN=Users</value> no effect. -I have tried to change first constr argument in FilterBasedLdapUserSearch from <constructor-arg index="0"><value>CN=Users</value></constructor-arg> to <constructor-arg index="0"><value></value></constructor-arg> no effect. - Changes in FilterBasedLdapUserSearch does not provide additional log output so I can't trace it. Post Edited by f_chas01 at 05/04/2011 14:29 Post Edited by f_chas01 at 05/04/2011 14:39

I am trying to get my JasperServer authentication work with the ActiveDirectory. I encountered a problem which I can not solve for a long time. It would be great if someone could take a look on it. There is an error message in the jasperserver.log: "2011-05-03 15:17:41,104 WARN LoggerListener,http-8484-6:60 - Authentication event AuthenticationFailureBadCredentialsEvent: Administrator; details: com.jaspersoft.jasperserver.multipleTenancy.MTWebAuthenticationDetails@2eb76: RemoteIpAddress: 127.0.0.1; SessionId: A5CD18C104C8CCD410A414B718CFEBC8; exception: Bad credentials" Here is detailed Information on my System configuration: I am using 2 machines in the same local network. 1) WindowsServer 2008 with an ActiveDirectory on it. 2) JasperServer configured to authenticate via ldap. The configuration of ActiveDirectory can be seen here: http://img218.imageshack.us/img218/7347/adconfiguration.png I am able to acces ActiveDirectory on the JasperServer machine using LDAPAdministrator. Providing the following credentials I can browse the AD tree: http://img585.imageshack.us/img585/7297/ldapadmin.png The connection configuration is here: applicationContext-security.xml ... <bean id="authenticationManager" class="org.springframework.security.providers.ProviderManager"> <property name="providers"> <list> <ref local="ldapAuthenticationProvider"/> <ref bean="${bean.daoAuthenticationProvider}"/> <ref bean="anonymousAuthenticationProvider"/> </list> </property> </bean> ... <bean id="ldapContextSource" class="org.springframework.security.ldap.DefaultSpringSecurityContextSource"> <constructor-arg value="ldap://192.168.5.101:389/dc=corp,dc=ama-eve,dc=dyndns,dc=org"/> <property name="userDn"><value>CN=Administrator,CN=Users,DC=corp,DC=ama-eve,DC=dyndns,DC=org</value></property> <property name="password"><value>mypassword</value></property> </bean> ... I tried following: - Changing the userDN value - same error - Trying to use user accounts which are not existing in AD - same error - Trying to disable ldap authentication by commenting <ref local="ldapAuthenticationProvider"/> - same error - I do restart the JasperServer each time after making changes The fact that there is always the same error which is the same for the case when no ldap authentication is configured wonders me. Post Edited by f_chas01 at 05/03/2011 14:53 Post Edited by f_chas01 at 05/03/2011 14:55

The reason is of the technical nature. It was implemented like this. Here is a quotation from the documentation: "ROLE_USER: Every user that logs into JasperReports Server must have this role. The server automatically assigns this role to every user that is created, and it cannot be removed. It is a special system-level role that is visible in every organization." Take a look on JasperReports-Server-Admin-Guide.pdf for detailed information which is in the doc folder of the JasperServer Pro installation.