domagoj.hrzic

Hello everyone, I'm testing integration of JasperServer with AD. I've managed to configure JasperServer to authenticate users with AD, but having problems with AD group sync with JasperServer roles for one organization only. The testing version of JasperServer is 6.3. where I've followed this instructions from: JasperReports Server 6.0.1 Authentication with NTLM | Jaspersoft Community Problem is that every user gets only the default role ROLE_USER when logging into JasperServer. Looks like it ignores the groupSearchFilter property "&(sAMAccountName={0})(objectclass=group)(cn=JASPER_*))" in ldapAuthenticationProvider bean. The scenario which I'm reproducing: - Two groups in AD: JASPER_GROUP1, JASPER_GROUP2 - Two roles in JasperServer: ROLE_GROUP1, ROLE_GROUP2 So if user is located in JASPER_GROUP1 by logging into JasperServer need to be assigned with ROLE_GROUP1 role. Reading the documentations this is possible and other were able to set up this kind of integration. I'm pasting the beans (applicationContext-externalAuth-LDAP-mt.xml) if somebody has idea what could be wrong. <bean id="ldapAuthenticationManager" class="com.jaspersoft.jasperserver.api.security.externalAuth.wrappers.spring.JSProviderManager"> <property name="providers"> <list> <ref local="ldapAuthenticationProvider"/> <ref bean="${bean.daoAuthenticationProvider}"/> </list> </property> </bean> <bean id="ldapAuthenticationProvider" class="com.jaspersoft.jasperserver.api.security.externalAuth.wrappers.spring.ldap.JSLdapAuthenticationProvider"> <constructor-arg> <bean class="com.jaspersoft.jasperserver.api.security.externalAuth.wrappers.spring.ldap.JSBindAuthenticator"> <constructor-arg><ref local="ldapContextSource"/></constructor-arg> <property name="userSearch" ref="userSearch"/> </bean> </constructor-arg> <constructor-arg> <bean class="com.jaspersoft.jasperserver.api.security.externalAuth.wrappers.spring.ldap.JSDefaultLdapAuthoritiesPopulator"> <constructor-arg index="0"><ref local="ldapContextSource"/></constructor-arg> <constructor-arg index="1"><value>OU=REPORTING</value></constructor-arg> <property name="groupRoleAttribute" value="CN"/> <property name="rolePrefix" value="ROLE_"/> <property name="convertToUpperCase" value="true"/> <property name="groupSearchFilter" value="(&(sAMAccountName={0})(objectclass=group)(cn=JASPER_*))"/> <property name="searchSubtree" value="true"/> </bean> </constructor-arg> </bean> <bean id="userSearch" class="com.jaspersoft.jasperserver.api.security.externalAuth.wrappers.spring.ldap.JSFilterBasedLdapUserSearch"> <constructor-arg index="0"> <value></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> <bean id="ldapContextSource" class="com.jaspersoft.jasperserver.api.security.externalAuth.ldap.JSLdapContextSource"> <constructor-arg value="ldap://hostname:389/dc=demo,dc=local"/> <!-- manager user name and password (may not be needed) --> <property name="userDn" value="CN=jasperadmin,OU=REPORTING,DC=demo,DC=local"/> <property name="password" value="<password>"/> <property name="referral" value="follow"/> </bean> Also here is the role mapping i've set: <bean id="mtExternalUserSetupProcessor" class="com.jaspersoft.jasperserver.multipleTenancy.security.externalAuth.processors.MTExternalUserSetupProcessor" parent="abstractExternalProcessor"> <!--Default permitted role characters; others are removed. Change regular expression to allow other chars. --> <property name="permittedExternalRoleNameRegex" value="[A-Za-z0-9_]+"/> <property name="userAuthorityService"> <ref bean="${bean.internalUserAuthorityService}"/> </property> <property name="defaultInternalRoles"> <list> <value>ROLE_USER</value> </list> </property> <property name="organizationRoleMap"> <map> <!-- Example of mapping customer roles to JRS roles --> <entry> <key> <value>ROLE_JASPER_GROUP1</value> </key> <!-- JRS role that the <key> external role is mapped to--> <value>ROLE_GROUP1</value> </entry> </map> </property> </bean> Best Regards, Domagoj

found the solution here: https://community.jaspersoft.com/wiki/how-display-parameter-value-ad-hoc-report

Hello, i've a question about pulling the selected value from input controls and displaying it into the report. So i have following in stateXML.xml <subFilter id="filter_1" letter="A" sourceString="DYNAMIC"> <expressionString>isAnyValue(public_ticket_state.comments2)</expressionString> <parameterizedExpressionString>public_ticket_state.comments2 in comments2_1</parameterizedExpressionString> </subFilter> This is the filter created within JasperServer (not JasperStudio), and i want to get the selected value from that resource and display it directly on the report. Does anyone know how to acomplish that? Or maybe a tip how to do it. Thanks in advance, Domagoj

Hello all, I have created croatian locales for JasperServer 6.3 and having problem with displaying croatian characters. DB that i'm using is MySQL and has the jasperserver schema set to UTF-8. Also, the jdbc:mysql is set: <Resource name="jdbc/jasperserver" auth="Container" type="javax.sql.DataSource" maxActive="100" maxIdle="30" maxWait="10000" driverClassName="org.mariadb.jdbc.Driver" accessToUnderlyingConnectionAllowed = "true" validationQuery="SELECT 1" testOnBorrow="true" url="jdbc:mysql://localhost:3306/jasperserver?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&autoReconnectForPools=true&tinyInt1isBit=false" factory="com.jaspersoft.jasperserver.tomcat.jndi.JSCommonsBasicDataSourceFactory" /> Anyone got an idea what could be the problem?

I managed to connect Jasper to LDAP but i'm not being able to implement SSO, i have one application that when i click link on it would log in to jasper, is this possible? Thanks

Hi all, is there a way to set a filter to show only top N results, for example I made a report that shows a chart with 40 bars, so I want to do is to set the filter to show only top let's say 5 result. Thank you

Hi all, having trouble generating a chart, I'm using JasperStudio 6.3.1. I created query that joins multiple tables, for categorized reporting. I have let's say 80000 rows with a priority defined for each row with 5 different priority values repeating. Now I want to create a pie chart to display priority count for each value. As chart dataset series i put column where are all of the priorities repeating, and in value count of all rows. I'm getting the error: net.sf.jasperreports.engine.JRException: net.sf.jasperreports.engine.JRRuntimeException: Key 3 normal is duplicated in pie dataset. Is there a way, parameter or function to avoid this problem. I'm aware that it would be better to write only query to get the set of 5 value with a total count. Please help, Thanks