Question:
User has changed superuser password and now he is not able to log in as superuser. What can he do?
Answer:
TIBCO JasperReports® Server user account information is stored in jasperserver repository data base jiuser table. Should user forgot the password for superuser, user can ask their DBA to access the database and run following query to update superuser account to reset its password:
UPDATE jiuser SET password = '' WHERE username = 'superuser';
With this approach, user needs to restart their server instance after the DB update, login to the account using superuser without a password, then go to Manage - Users to add a new password.
Alternately, user can export a superuser account from a standard deployment into a zip file, and run a command line import from their deployed jasperreports-server-{version}buildomatic directory to get it into the repository where you have problems with superuser password:
js-import.bat --input-zip {your-zip-file} --update
This will reset superuser password to default value of 'superuser'. If user does not have a back up copy of your exported superuser from a standard deployment, please open a support case and we can provide one for you.
Important note:
This wiki posting is written for JRS version 6.3 and earlier. After JRS 7.5 introduced server specific encryption frame work and around version 7.9, the first approach of using SQL query to blank out the password is no longer working.
In any latest JRS release versions, users MUST use the alternate approach to import the default superuser into the repository to fix the password problem. Users should get this legacy key encrypted "export1.zip" file from the following wiki posting and run command line script to reset the superuser password to the correctly encrypted "superuser" value.
https://community.jaspersoft.com/wiki/resetting-superuser-password
js-import.bat --input-zip export1.zip --update
TTC-20170630-20230810
Recommended Comments
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