kkpan47

Were you able to fix this issue ?

Hi, I have 2 instances of Jasper Server installed. One on my machine and one on a server. I have configured Microsoft AD Authentication for both. The authentication works fine on my machine. On the Server: When i try to login with invalid credentials, i get an error message. This indicates that jasper is able to talk to LDAP ServerWhen i enter valid credentials, i am redirected to localhost:8080/jasperserver/j_spring_security_check. This is a blank page with HTTP 500 StatusBelow are the logs for the same: 2016-08-24 13:42:31,816 DEBUG ProviderManager,http-apr-8080-exec-2:152 - Authentication attempt using com.jaspersoft.jasperserver.api.security.externalAuth.wrappers.spring.ldap.JSLdapAuthenticationProvider2016-08-24 13:42:31,816 DEBUG ProviderManager,http-apr-8080-exec-2:152 - Authentication attempt using com.jaspersoft.jasperserver.api.security.externalAuth.wrappers.spring.ldap.JSLdapAuthenticationProvider2016-08-24 13:42:31,817 DEBUG FilterBasedLdapUserSearch,http-apr-8080-exec-2:107 - Searching for user 'karan.pandit', with user search [ searchFilter: '(sAMAccountName={0})', searchBase: 'OU=abc', scope: subtree, searchTimeLimit: 0, derefLinkFlag: false ]2016-08-24 13:42:31,817 DEBUG FilterBasedLdapUserSearch,http-apr-8080-exec-2:107 - Searching for user 'karan.pandit', with user search [ searchFilter: '(sAMAccountName={0})', searchBase: 'OU=abc', scope: subtree, searchTimeLimit: 0, derefLinkFlag: false ]2016-08-24 13:42:32,100 DEBUG SpringSecurityLdapTemplate,http-apr-8080-exec-2:211 - Searching for entry under DN 'dc=corp,dc=abc,dc=net', base = 'ou=abc', filter = '(sAMAccountName={0})'2016-08-24 13:42:32,100 DEBUG SpringSecurityLdapTemplate,http-apr-8080-exec-2:211 - Searching for entry under DN 'dc=corp,dc=abc,dc=net', base = 'ou=abc', filter = '(sAMAccountName={0})'2016-08-24 13:42:32,106 DEBUG SpringSecurityLdapTemplate,http-apr-8080-exec-2:223 - Found DN: cn=Karan Pandit,ou=Engineering OU,ou=Mumbai,ou=abc2016-08-24 13:42:32,106 DEBUG SpringSecurityLdapTemplate,http-apr-8080-exec-2:223 - Found DN: cn=Karan Pandit,ou=Engineering OU,ou=Mumbai,ou=abc2016-08-24 13:42:32,108 DEBUG BindAuthenticator,http-apr-8080-exec-2:108 - Attempting to bind as cn=Karan Pandit,ou=Engineering OU,ou=Mumbai,ou=abc,dc=corp,dc=abc,dc=net2016-08-24 13:42:32,108 DEBUG BindAuthenticator,http-apr-8080-exec-2:108 - Attempting to bind as cn=Karan Pandit,ou=Engineering OU,ou=Mumbai,ou=abc,dc=corp,dc=abc,dc=net2016-08-24 13:42:32,649 DEBUG BindAuthenticator,http-apr-8080-exec-2:116 - Retrieving attributes...2016-08-24 13:42:32,649 DEBUG BindAuthenticator,http-apr-8080-exec-2:116 - Retrieving attributes...2016-08-24 13:42:32,924 DEBUG DefaultLdapAuthoritiesPopulator,http-apr-8080-exec-2:182 - Getting authorities for user cn=Karan Pandit,ou=Engineering OU,ou=Mumbai,ou=abc,dc=corp,dc=abc,dc=net2016-08-24 13:42:32,924 DEBUG DefaultLdapAuthoritiesPopulator,http-apr-8080-exec-2:182 - Getting authorities for user cn=Karan Pandit,ou=Engineering OU,ou=Mumbai,ou=abc,dc=corp,dc=abc,dc=net2016-08-24 13:42:32,924 DEBUG DefaultLdapAuthoritiesPopulator,http-apr-8080-exec-2:211 - Searching for roles for user 'karan.pandit', DN = 'cn=Karan Pandit,ou=Engineering OU,ou=Mumbai,ou=abc,dc=corp,dc=abc,dc=net', with filter (uid={1}) in search base ''2016-08-24 13:42:32,924 DEBUG DefaultLdapAuthoritiesPopulator,http-apr-8080-exec-2:211 - Searching for roles for user 'karan.pandit', DN = 'cn=Karan Pandit,ou=Engineering OU,ou=Mumbai,ou=abc,dc=corp,dc=abc,dc=net', with filter (uid={1}) in search base ''2016-08-24 13:42:32,926 DEBUG SpringSecurityLdapTemplate,http-apr-8080-exec-2:150 - Using filter: (uid=karan.pandit)2016-08-24 13:42:32,926 DEBUG SpringSecurityLdapTemplate,http-apr-8080-exec-2:150 - Using filter: (uid=karan.pandit)2016-08-24 13:42:33,312 DEBUG HttpSessionSecurityContextRepository,http-apr-8080-exec-2:304 - SecurityContext is empty or contents are anonymous - context will not be stored in HttpSession.2016-08-24 13:42:33,312 DEBUG HttpSessionSecurityContextRepository,http-apr-8080-exec-2:304 - SecurityContext is empty or contents are anonymous - context will not be stored in HttpSession.2016-08-24 13:42:33,312 DEBUG SecurityContextPersistenceFilter,http-apr-8080-exec-2:97 - SecurityContextHolder now cleared, as request processing completed2016-08-24 13:42:33,312 DEBUG SecurityContextPersistenceFilter,http-apr-8080-exec-2:97 - SecurityContextHolder now cleared, as request processing completed

I have been facing the same issue for a while. Finally found the solution: add below property below the password tag for the LDAP authentication <property name="userDn" value="CN=Administrator,CN=Users,DC=DOMAIN,DC=COM"/><property name="password" value="password"/><property name="referral" value="follow" />

Guys any help on this ??

I have a master report which consists of the following crosstab format:- List of SourceDateSource 1Source 201/02/1510502/02/1567I need to be able to drill down on each of the counts( say 10) to display the corresponding records. I can pass the 'Date' and 'Source' as parameters to the drill down report query. However the master report has additional 7 input controls like 'Department' , 'Status' etc. which are parameters to the dataset In the Hyperlink section of the measure field i cannot find these 7 parameters so that i can pass them to the drill down report Is there a way to achieve this or am i missing something ?? Thanks, Karan