cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
935
Views
5
Helpful
5
Replies

CTM SysAdmin Password

randall.holt
Level 1
Level 1

Is there a way to recover a lost CTM SysAdmin password? The customer is using CTM v8 on a Sun station.

Thanks in advance!

5 Replies 5

jreekers
Level 4
Level 4

Hi Randall,

Use this SQL command sequence

this will reset the pwd to Ctm123!

update User_Table set UserLoginDisabled = 0 where UserName ='SysAdmin';

update User_Table set LastLoginTime = Null where UserName = 'SysAdmin';

update User_Table set LOCKEDSTATE = 0 where UserName = 'SysAdmin';

update User_Table set AUTODISABLEINTERVAL = 0 where UserName = 'SysAdmin';

update USER_TABLE set USERPASSWORD = 'F6E839178611157BA182FBED1CAEF056' where

USERNAME = 'SysAdmin';

update User_Table set PASSWORDSETTIME='05/03/2008' where UserName='SysAdmin';

commit;

Hope this helps.

-Joe

Thanks Joe,

I went through the steps you listed and it appearsd to take properly, but I still can't log into SysAdmin using Ctm123! as the password.

Can you verify the UserPassword string? I went though it 3 time, just to make sure I wasn't mis-typing anything.

Thanks!

-Randy

Just wanted to post a follow up. In addition to the login password, there were other things that weren't opperating properly on the box. We restarted the Sun station... and now the CTM password works! Go figure :)

I followed the SQL command sequence.  Everything appeared to work correctly.

I was able to login using the SysAdmin username and new password.  I tried to change the SysAdmin password and received a notice that I don't have permission to change my password.

What else needs to be done?

BTW, my system is hosted on RHEL, not SUN.  My version is CPO 9.6.

I managed to change the SysAdmin password.  After successfully changing the SysAdmin password and logging in, I created a SuperUser account for myself.  Logged out and logged back in as my new account.  I opened the Domain Explorer, then Administration, and Users.  I edited the SysAdmin account password from there.

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community:

Innovations in Cisco Full Stack Observability - A new webinar from Cisco