KB Article #182679

How to reset password for Portal IAM user: system

Problem

If you're ever locked out of Portal with no access to any user credentials, you may gain access through the System user by forcing a reset of the System user password.**


Requirements:

  • Admin access to database
  • Admin access to server where AIS is installed

  • **This procedure involves the deletion of a line in your database. There is very low risk for complication, but be aware that there may be references to an old System user elsewhere in the database. One way to avoid this is to import a known configuration with the replace mode in the Portal GUI, as it should remove any missing references in your database.

    Resolution

    • Delete the line with USER_NAME 'system' in database located in the IAM schema in the I_USER table:
    • Commit the change
    • Restart your Tomcat server. The system user will automatically be re-created upon server startup with a temporary password
    • Check the catalina.out log and take note of the temporary password
      • The log is located in .../InstallationDirectory/AIS/Tools/apache-tomcat/logs
      • Look for: For user synchrony/system generated random password: ************
    • Enter into Portal GUI and login using the system credentials with the password found in the catalina.out logs
    • Change the system password
    • Log in with system user and new password