External database authentication in JasperServer 5.1

[dcristea]

Hello

For the past week I've been struggling to log in using credentials stored in an external database. I have modified and deployed the sample applicationContext-externalAuth-db.xml, as mentioned in the jasperreportsserver-auth-cookbook, but when i try to log in, i get a bad credentials exception. Do you have any suggestion on how to get the external database authentication working ? 

I have to mention that the password is stored as plain text in my external database.

Thank you,

Daniel.

[elizam]

If you are using plaintext, remove the reference to the passwordValidator bean in externalDaoAuthenticationProvider:

<bean id="externalDaoAuthenticationProvider" class="com.jaspersoft.jasperserver.multipleTenancy.security.externalAuth.db.MTExternalDaoAuthenticationProvider">
        <property name="userDetailsService"><ref local="externalUserTenantDetailsService"/></property>
        <property name="passwordValidator"><ref local="passwordValidator"/></property>
    </bean>

This example is from a pro file - the class might be slightly different in community. So make sure to edit your file & not copy this.

 

[dcristea]

Thank you for your reply. It seems like the root of my problem was an issue with the authoritiesByUsernameQuery. I would like to ask you if there is any way for me to see the "usersByUsernameQuery" and the "authoritiesByUsernameQuery" queries in the jasperserver log.

[elizam]

Just saw this - you can enable additional logging as described here:

http://community.jaspersoft.com/documentation/jasperreports-server-authentication-cookbook/v550/configuring-logging-debugging