Problem
User has the JasperReports Server (JRS) installed in two servers, one Master and other StandBy. The JRS is using the database in PostgreSQL 10.5 instance running on the server. There is an instance of PostgreSQL on each server. PostgreSQL is configured to replicate the data from the Master server to the StandBy server. When there is a switch between servers the StandBy becomes the master and Master becomes StandBy. The PostgreSQL instances also switch properly.However the internal users that are stored in the PostgreSQL database (superuser, jasperadmin), start failing the authentication.They are not able to login in the JasperReports server. To workaround this issue, users have to connect directly to the PostgreSQL database and set the password to null in order to be able to login and change the passwords. However, this workaround is not acceptable as a permanent solution.
Cause
This user must have used different keystores in those two server deployments. The repository content cannot use different keystores to encrypt and decrypt if the are identical in two DB deployments
Resolution
User needs to make sure to use the same keystore files by copying those files from master to secondary:
.jrsks - Java keystore file
.jrsksp - keystore properties
References:
https://community.jaspersoft.com/wiki/encryption-jasperreports-server-75
=============================================
TTC-20220222-2085273
Recommended Comments
There are no comments to display.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now