Setps to configure external db authentication for external user to login to the jasperserver.

External users not within the 'jasperserver' database can be authenticated to access Jasperserver. Below are the configuration steps to enable external database authentication:

1) Create an external database with any name to store external user details. Attached are sample tables created for user details, user roles, and organizations in "DB_Queries.txt".
2) Copy the "sample-applicationContext-externalAuth-db-mt.xml" file from ...\jasperreports-server-8.2.0\samples\externalAuth-sample-config\ and rename it as "applicationContext-externalAuth-db-mt.xml".
3) After renaming the file, edit the necessary bean to configure LDAP authentication. We have provided the working configured "applicationContext-externalAuth-db-mt.xml" file for Jasperserver version 8.2.0. To understand the changes, compare this file with the default "sample-applicationContext-externalAuth-db-mt.xml".
4) Place the edited "applicationContext-externalAuth-db-mt.xml" file in the location: ...\webapps\jasperserver-pro\WEB-INF.
5) Restart Jasperserver.
6) After the restart, log in using the external user ID and password, and specify the organization name during login.
 

applicationContext-externalAuth-db-mt.xml sample-applicationContext-externalAuth-db-mt.xml DB_Queries.txt