Invalid Username or Password

Technote (FAQ)


Question

When trying to log into Reporter as the Administrator I receive and error about the username/password being invalid, why?

Answer

When an invalid username/password error is received when logging into Reporter, it mean the username or password is invalid. This is usually the password. The usernames and passwords are stored in the repository. To change the password, sqlplus into the repository and then do the following:
1.) select * from tab; (verify the RPUSER table exists)
2.) select * from RPUSER; (verify the users exist)
3.) select rppasswd from RPUSER where name='administrator'; (verify the user has a password set)
4.) If there is no password returned, log in with administrator and a blank password. If there is a password, you can have the dba reset it to blank as follows:

update RPUSER set rppasswd='' where name='administrator'; commit;

This should blank the password (in the above the rppasswd is being set to two single ticks ')

5.) select rppasswd from RPUSER where name='administrator'; (verify the password is now blank)
6.) Try to log into Reporter as the administrator user with no password.

If this works, the administrator can reset the other users passwords via the GUI.

Rate this page:

(0 users)Average rating

Document information


More support for:

Tivoli Netcool/Reporter

Software version:

2.1, 2.2

Operating system(s):

AIX, HP-UX, Linux, Solaris, Windows

Software edition:

All Editions

Reference #:

1616384

Modified date:

2014-10-13

Translate my page

Machine Translation

Content navigation