How to reset Admin user password in Rational Focal Point

Technote (FAQ)


Question

How do you reset Admin user password without logging into IBM Rational Focal Point?

Cause

If there is only one administrator user in Rational Focal Point and password for the user is lost and also Lost Your Password link is not enabled.

Answer

To reset the admin user password in Rational Focal Point, login to the database and execute the following queries:

Note: You are advised to take a database backup before executing the below queries.

1. To obtain XXX value of projectid for the list of users, execute the below sql.


select projectid from toc where type='allusers'


projectid
type
1
allusers

2. To obtain YYY value of eida, execute the below sql.


select * from attXXX where textvalue like'%admin%'


For example:
select * from att1 where textvalue like'%admin%'


eida
textvalue
13
admin

3. To obtain ZZZ value of refa, execute the below sql.


select * from att XXX where eida= YYY


For example:
select * from att1 where eida=13


eida
textvalue
refa
13
!PBKDF2....
148

You will see a record containing an encrypted value like '!PBKDF2....', ZZZ value of refa is password attribute for the admin user and usually 148.

4. To reset the admin user password, execute the below command


update att XXX set textvalue='<new password>' where eida= YYY and refa= ZZZ


For example:
update att1 set textvalue='newpassword' where eida=13 and refa=148


Note: '<new password>' is your new password for the admin user.

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Rational Focal Point
General Information

Software version:

6.4.1.2, 6.4.1.3, 6.5, 6.5.0.1, 6.5.0.2, 6.5.1, 6.5.1.1, 6.5.2, 6.5.2.1, 6.5.2.2, 6.5.2.3, 6.6, 6.6.0.1, 6.6.1

Operating system(s):

Linux, Solaris, Windows

Reference #:

1501739

Modified date:

2014-02-13

Translate my page

Machine Translation

Content navigation