How to Reset the idashAdm Password

Products

• iDash Workload Automation
• iDash Workload Automation for CA 7

Issue/Introduction

The customer has lost or forgotten the password for the idashAdm account.

Environment

IDASH 11.3.6

IDASH 11.4

IDASH 12.x

Cause

The customer forgot or lost the password.

Resolution

Reset the idashAdm password.

Login to the idash database as the idash user and run the following queries:

select * from idash_config where type = 'user' and id = 'idashAdm' and owner = 'idashAdm' and tag LIKE 'z.%';

delete from idash_config where type = 'user' and id = 'idashAdm' and owner = 'idashAdm' and tag LIKE 'z.%';

commit;

 

select * from idash_config where server = 'primary' and type = 'user' and id = 'idashAdm' and owner = 'idashAdm' and tag = 'idash.user.name' and value = 'idashAdm';

delete from idash_config where server = 'primary' and type = 'user' and id = 'idashAdm' and owner = 'idashAdm' and tag = 'idash.user.name' and value = 'idashAdm';

commit;

 

select * from idash_config where server = 'primary' and type = 'user' and id = 'idashAdm' and owner = 'idashAdm' and tag = 'idash.user.idash.admin.privilege' and value = 'true';

delete from idash_config where server = 'primary' and type = 'user' and id = 'idashAdm' and owner = 'idashAdm' and tag = 'idash.user.idash.admin.privilege' and value = 'true';

commit;

 

INSERT INTO idash_config (server,type,id,owner,tag,value,edited,deleted) VALUES ('primary', 'user', 'idashAdm', 'idashAdm','z.20010101000000', '49ZJWUUWZPA7XU',1160435872, 0);

INSERT INTO idash_config (server,type,id,owner,tag,value,edited,deleted) VALUES ('primary', 'user', 'idashAdm', 'idashAdm','idash.user.name', 'idashAdm',1160435872, 0);

INSERT INTO idash_config (server,type,id,owner,tag,value,edited,deleted) VALUES ('primary', 'user', 'idashAdm', 'idashAdm','idash.user.idash.admin.privilege', 'true',1160435872, 0);

commit;

Once you have committed the changes, the idashAdm password will be reset to the default password 'idashAdm'. Logging into the WebUI the first time will automatically prompt you to change the password to your preferred password.