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?
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.
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'.)