Technote (FAQ)
Question
TSOM's default userid when installing TSOM is 'admin'. This userid has an initial password of 'password'. If the password is changed and subsequently lost/forgotten, is there a way to reset it?
Answer
All TSOM login credentials are kept in the TSOM database in a table named "TSOM_USER". This table has several fields, most important of which are the "NS_USER_NAME" and "PASSWORD" fields.
- NS_USER_NAME: Contains the short-name or "User Name". This is the name entered when logging into both the TSOM and jReport interfaces.
- PASSWORD: Contains an MD5 hash of that user's password.
You may set any userid's password by updating the password field with the MD5 hash of the desired password.
Example:
Have your database administrator run the following SQL command to reset admin's password to 'password'.
update tsom_user set password='5f4dcc3b5aa765d61d8327deb882cf99' where ns_user_name='admin'
('5f4dcc3b5aa765d61d8327deb882cf99' is the MD5 hash of 'password'.)
Rate this page:
Average rating
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.