Boris Gisselere

Hi jmcarcar ! I only find your post talking about that. You said : "to register a new user or change my password in login" My question is : It works fine to refister a new user but nothing work when I wnat to change my password in login. Did you make another change ? Thank you. Boris.

Hi, I've been looking for a solution since 2 weeks, read a lot of forums and user guides but not finding any solution. Here's the thing : We were facing a problem in Jaspersoft 5.1 version and we upgrade to 6.1.2 hoping it will be solved, but no. When we activate the password change for user on login page : Modifying /WEB-INF/jasperserver-servlet.xmlallowUserPasswordChange = truePutting this pattern :/WEB-INF/applicationContext.xml allowedPasswordPattern <property name="allowedPasswordPattern" value="^(?=.{10,}$)(?=.*[a-z])(?=.*[A-Z])(?=.*d).*$"></property>And setting exception : /WEB-INF/bundles/jsexceptions_messages_fr.propertiesexception.remote.weak.password Le mot de passe doit avoir au moins 10 caractu00e8res et contenir au moins une minuscule, une majuscule et un chiffre. When I create a user connecter as superuser, all this work fine But on the login page when user try to connect and change password : if new password and confirmed new password are different, there's a message corresponding to jsp.Login.link.passwordNotMatch in jasperserver_messages_fr.propertiesif new password doesn't match the REGEXP : nothing happens on login page and the user is logged in with old passwordif new password is matching REGEXP : nothing happens on login page and the user is logged in with old password in all cases, user password is never changedMay someone have some clue to solve this please ? Note : I did change security-config.properties to set encryption.on=true but nothing changes EDIT after one more day looking all sources to find some clue : in this file : .../WEB-INF/jsp/modules/login/loginState.jsp I found this : showLocaleMessage: '<spring:message code="jsp.Login.link.showLocale" javaScriptEscape="true"/>', hideLocaleMessage: '<spring:message code="jsp.Login.link.hideLocale" javaScriptEscape="true"/>', allowUserPasswordChange: ${allowUserPasswordChange}, changePasswordMessage: '<spring:message code="jsp.Login.link.changePassword" javaScriptEscape="true"/>', cancelPasswordMessage: '<spring:message code="jsp.Login.link.cancelPassword" javaScriptEscape="true"/>', passwordExpirationInDays: ${passwordExpirationInDays}, nonEmptyPasswordMessage: '<spring:message code="jsp.Login.link.nonEmptyPassword" javaScriptEscape="true"/>', passwordNotMatchMessage: '<spring:message code="jsp.Login.link.passwordNotMatch" javaScriptEscape="true"/>', Sadly I can't see anything making me think that there's a pattern control here ! Some one knows if there's a control and where ? I did upload a document with the 2 pages, In administration page, the control did work, but in login page, nothing happens .. Someone can help me ?

I found and fix the problem ! I examined the file applicationContext-report-scheduling.xml And I found this when he was custimized to block html, rtf, odt and txt export : <util:map id="outputKeyMapping"> <entry key="1" value="pdf"/> <!--<entry key="2" value="html"/>--> <entry key="2" value="xls"/> <!--<entry key="4" value="rtf"/>--> <entry key="3" value="csv"/> <!--<entry key="6" value="odt"/>--> <!--<entry key="7" value="txt"/>--> <entry key="4" value="docx"/> <entry key="5" value="ods"/> <entry key="6" value="xlsx"/> <!-- <entry key="11" value="xlsNoPag"/> --> <entry key="7" value="xlsxNoPag"/> </util:map> Keys were renamed. I fixed it putting the right number back : <util:map id="outputKeyMapping"> <entry key="1" value="pdf"/> <!--<entry key="2" value="html"/>--> <entry key="3" value="xls"/> <!--<entry key="4" value="rtf"/>--> <entry key="5" value="csv"/> <!--<entry key="6" value="odt"/>--> <!--<entry key="7" value="txt"/>--> <entry key="8" value="docx"/> <entry key="9" value="ods"/> <entry key="10" value="xlsx"/> <!-- <entry key="11" value="xlsNoPag"/> --> <entry key="12" value="xlsxNoPag"/> </util:map> and it works fine now ! Boris.

Hi, I try to planify a report and send a mail to receive it attached in my mail with DOCX or XLSX but I have this error : Job: Exécution en arrière-plan (ID: 3) Report unit: /Rapports_de_la_PADS/1b___Pr_paration_de_rapport_Rapport Quartz Job: ReportJobs.job_3 Quartz Trigger: ReportJobs.trigger_3_0 Exceptions: L’exportation vers DOCX n’a pas été terminée. Une erreur a interrompu le processus. com.jaspersoft.jasperserver.api.JSException: jsexception.report.unknown.output.format at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.getOutput(ReportExecutionJob.java:917) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.createOutputs(ReportExecutionJob.java:845) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.executeAndSendReport(ReportExecutionJob.java:443) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.execute(ReportExecutionJob.java:219) at com.jaspersoft.ji.report.options.engine.ReportOptionsExecutionJob.execute(ReportOptionsExecutionJob.java:48) at org.quartz.core.JobRunShell.run(JobRunShell.java:213) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:557) fail to send out alert mail notification com.jaspersoft.jasperserver.api.JSExceptionWrapper: javax.mail.internet.AddressException: Illegal address in string ``'' at org.springframework.mail.javamail.MimeMessageHelper.parseAddress(MimeMessageHelper.java:708) at org.springframework.mail.javamail.MimeMessageHelper.setTo(MimeMessageHelper.java:592) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJobAlertImpl.sendAlertMail(ReportExecutionJobAlertImpl.java:78) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.sendAlertMail(ReportExecutionJob.java:583) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.executeAndSendReport(ReportExecutionJob.java:563) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.execute(ReportExecutionJob.java:219) at com.jaspersoft.ji.report.options.engine.ReportOptionsExecutionJob.execute(ReportOptionsExecutionJob.java:48) at org.quartz.core.JobRunShell.run(JobRunShell.java:213) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:557) When I try in PDF it works fine. any idea ?

Hi ! Did you find a way to go through this ?

I have the same problem but don't find the way even choosing overwrite or sequential option ... nothing works :-( Job: Exécution en arrière-plan (ID: 3) Report unit: /Rapports_de_la_PADS/1b___Pr_paration_de_rapport_Rapport Quartz Job: ReportJobs.job_3 Quartz Trigger: ReportJobs.trigger_3_0 Exceptions: L’exportation vers DOCX n’a pas été terminée. Une erreur a interrompu le processus. com.jaspersoft.jasperserver.api.JSException: jsexception.report.unknown.output.format at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.getOutput(ReportExecutionJob.java:917) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.createOutputs(ReportExecutionJob.java:845) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.executeAndSendReport(ReportExecutionJob.java:443) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.execute(ReportExecutionJob.java:219) at com.jaspersoft.ji.report.options.engine.ReportOptionsExecutionJob.execute(ReportOptionsExecutionJob.java:48) at org.quartz.core.JobRunShell.run(JobRunShell.java:213) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:557) fail to send out alert mail notification com.jaspersoft.jasperserver.api.JSExceptionWrapper: javax.mail.internet.AddressException: Illegal address in string ``'' at org.springframework.mail.javamail.MimeMessageHelper.parseAddress(MimeMessageHelper.java:708) at org.springframework.mail.javamail.MimeMessageHelper.setTo(MimeMessageHelper.java:592) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJobAlertImpl.sendAlertMail(ReportExecutionJobAlertImpl.java:78) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.sendAlertMail(ReportExecutionJob.java:583) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.executeAndSendReport(ReportExecutionJob.java:563) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.execute(ReportExecutionJob.java:219) at com.jaspersoft.ji.report.options.engine.ReportOptionsExecutionJob.execute(ReportOptionsExecutionJob.java:48) at org.quartz.core.JobRunShell.run(JobRunShell.java:213) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:557)

Ok I did it in Word ! Just telling him to display in Web style instead of Page ... I will sell this to my fron user for now ... Thank you

Hi, Thank for your quick answer ... the point is that I try to find a way to do it without Ireport, because the front user don't have it when he compose a report on his own. But I see you was able to resize it ... even in Word ? So I guess I need more help from Word support because I was unable to do it myself :-( By the way, maybe I can set one of this option directy in one of server file properties ... just have to find the right one now. If I find it I tell you. Thank you.

Hi, I tried to export an adhoc crosstab, but there's no way for me to have the whole tab in word document. How can I set something in JS to fix it ? You can see an example in the word doc I attached. Thanks for your help

We did it. So it was what we suspected the other day .. we just took the part of code to encrypt password which was used in Creating users application in LDAP, ans do we made a single jar of it, and implemented it with this code in application context file : <bean id="ldapAuthenticationProvider" class="org.springframework.security.providers.ldap.LdapAuthenticationProvider"> <constructor-arg> <bean class="org.springframework.security.providers.ldap.authenticator.PasswordComparisonAuthenticator"> <constructor-arg><ref local="ldapContextSource"/></constructor-arg> <property name="userSearch" ref="userSearch"/> <property name="passwordEncoder" ref="OurPasswordEncoder"/> </bean> </constructor-arg> <constructor-arg> <bean class="org.springframework.security.ldap.populator.DefaultLdapAuthoritiesPopulator"> <constructor-arg index="0"><ref local="ldapContextSource"/></constructor-arg> <constructor-arg index="1"><value></value></constructor-arg> <property name="groupRoleAttribute" value="title"/> <property name="groupSearchFilter" value="(cn={1})"/> <property name="searchSubtree" value="true"/> <!-- Can setup additional external default roles here <property name="defaultRole" value="LDAP"/> --> </bean> </constructor-arg> </bean> <bean class="our.jasper.auth.encoding.JasperPasswordEncoder" id="OurPasswordEncoder"/>

I didn't had set referral to follow before ... so i tried it .. but still blocked :-( On the other hand I put more logs in log4j.properties and did have this : 2013-11-21 11:18:23,327 DEBUG SpringSecurityLdapTemplate,TP-Processor10:214 - Found DN: cn=adminStats2 2013-11-21 11:18:23,330 DEBUG BindAuthenticator,TP-Processor10:106 - Attemptimg to bind as cn=adminStats2,ou=personnes,o=ADALIS,dc=inpes,dc=com 2013-11-21 11:18:23,330 DEBUG BindAuthenticator,TP-Processor10:106 - Attemptimg to bind as cn=adminStats2,ou=personnes,o=ADALIS,dc=inpes,dc=com 2013-11-21 11:18:23,333 DEBUG BindAuthenticator,TP-Processor10:142 - Failed to bind as cn=adminStats2: org.springframework.ldap.AuthenticationException: [LDAP: error code 49 - Invalid Credentials]; nested exception is javax.naming.AuthenticationException: [LDAP: error code 49 - Invalid Credentials] 2013-11-21 11:18:23,333 DEBUG BindAuthenticator,TP-Processor10:142 - Failed to bind as cn=adminStats2: org.springframework.ldap.AuthenticationException: [LDAP: error code 49 - Invalid Credentials]; nested exception is javax.naming.AuthenticationException: [LDAP: error code 49 - Invalid Credentials] 2013-11-21 11:18:23,334 DEBUG ProviderManager,TP-Processor10:183 - Authentication attempt using com.jaspersoft.jasperserver.multipleTenancy.MTDaoAuthenticationProvider 2013-11-21 11:18:23,334 DEBUG ProviderManager,TP-Processor10:183 - Authentication attempt using com.jaspersoft.jasperserver.multipleTenancy.MTDaoAuthenticationProvider 2013-11-21 11:18:23,373 WARN LoggerListener,TP-Processor10:60 - Authentication event AuthenticationFailureBadCredentialsEvent: adminStats2; details: com.jaspersoft.jasperserver.multipleTenancy.MTWebAuthenticationDetails@b364: RemoteIpAddress: 160.92.7.69; SessionId: 32BC22B906AD965BB53C4B56FB90FF75.37DEE6C137D5D7C53E8C8EC6; exception: Bad credentials 2013-11-21 11:18:23,373 WARN LoggerListener,TP-Processor10:60 - Authentication event AuthenticationFailureBadCredentialsEvent: adminStats2; details: com.jaspersoft.jasperserver.multipleTenancy.MTWebAuthenticationDetails@b364: RemoteIpAddress: 160.92.7.69; SessionId: 32BC22B906AD965BB53C4B56FB90FF75.37DEE6C137D5D7C53E8C8EC6; exception: Bad credentials We're thinking that LDAP user are created by an application which encrypt password before saving it in LDAP. So, in the case of CAS connection, our CAS had a extra class passwordEncoder to match with the one of LDAP. So maybe it comes from here and we have to try to do the same with Jaspersoft before attempting connection to LDAP ? By the way, I tried to create an user direct in LDAP with clear password and it didn't work either .. so I'm still wondering what is the solution for this case ?

I configure 2 types of LDAP one with CAS is doing well, but the other one without CAS doesn't work .. it stops like this : 2013-11-20 15:03:06,987 DEBUG FilterBasedLdapUserSearch,TP-Processor11:109 - Searching for user 'test', with user search [ searchFilter: '(& (cn={0}) (employeeType=*STATS_CONSULT*))', searchBase: '', scope: subtree, searchTimeLimit: 0, derefLinkFlag: false ] 2013-11-20 15:03:06,987 DEBUG FilterBasedLdapUserSearch,TP-Processor11:109 - Searching for user 'test', with user search [ searchFilter: '(& (cn={0}) (employeeType=*STATS_CONSULT*))', searchBase: '', scope: subtree, searchTimeLimit: 0, derefLinkFlag: false ] 2013-11-20 15:03:07,025 DEBUG SpringSecurityLdapTemplate,TP-Processor11:197 - Searching for entry in under DN 'ou=personnes,o=ADALIS,dc=inpes,dc=com', base = '', filter = '(& (cn={0}) (employeeType=*STATS_CONSULT*))' 2013-11-20 15:03:07,025 DEBUG SpringSecurityLdapTemplate,TP-Processor11:197 - Searching for entry in under DN 'ou=personnes,o=ADALIS,dc=inpes,dc=com', base = '', filter = '(& (cn={0}) (employeeType=*STATS_CONSULT*))' 2013-11-20 15:03:07,032 DEBUG SpringSecurityLdapTemplate,TP-Processor11:214 - Found DN: cn=test 2013-11-20 15:03:07,032 DEBUG SpringSecurityLdapTemplate,TP-Processor11:214 - Found DN: cn=test And we don't have any further information on what is wrong. Any idea ? For example with CAS authentication we've got : 2013-11-20 11:38:34,959 DEBUG SpringSecurityLdapTemplate,TP-Processor9:214 - Found DN: cn=adminStats 2013-11-20 11:38:34,959 DEBUG SpringSecurityLdapTemplate,TP-Processor9:214 - Found DN: cn=adminStats and after that : 2013-11-20 11:38:34,983 DEBUG DefaultLdapAuthoritiesPopulator,TP-Processor9:176 - Getting authorities for user cn=adminStats,ou=personnes,o=A_A,dc=inpes,dc=com 2013-11-20 11:38:34,983 DEBUG DefaultLdapAuthoritiesPopulator,TP-Processor9:176 - Getting authorities for user cn=adminStats,ou=personnes,o=A_A,dc=inpes,dc=com etc ... Here is a part of my configuration : <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> <constructor-arg> <bean class="org.springframework.security.ldap.populator.DefaultLdapAuthoritiesPopulator"> <constructor-arg index="0"><ref local="ldapContextSource"/></constructor-arg> <constructor-arg index="1"><value></value></constructor-arg> <property name="groupRoleAttribute" value="title"/> <property name="groupSearchFilter" value="(cn={1})"/> <property name="searchSubtree" value="true"/> <!-- Can setup additional external default roles here <property name="defaultRole" value="LDAP"/> --> </bean> </constructor-arg> </bean> <bean id="userSearch" class="org.springframework.security.ldap.search.FilterBasedLdapUserSearch"> <constructor-arg index="0"> <value></value> </constructor-arg> <constructor-arg index="1"> <value>(& (cn={0}) (employeeType=*STATS_CONSULT*))</value> </constructor-arg> <constructor-arg index="2"> <ref local="ldapContextSource" /> </constructor-arg> <property name="searchSubtree"> <value>true</value> </property> </bean>

Changed Assigned User from - to @User_306070 We've got the same problem in row title in CrossTab, Whene you're in ad'hoc view it's ok but when you published it the title is cutted.

Hi, I work with 2 similars domains using the same datasource and join_tree but with distinct filtering options I have built some reports on the first domain, and i would like to build same reports on the second one, but i don't know if it's possible to copy my reports and just switch domain on the new copies ? Is it possible ?

I'm still looking for a solution .. someone know something ? Thank you