OnDemand Users Group

Support Forums => CMOD for Multiplatforms => Topic started by: abdeshpa on September 09, 2015, 04:37:35 AM

Title: NEW USER ID Creation through database
Post by: abdeshpa on September 09, 2015, 04:37:35 AM
Hi,

I am using v8.5.0.6. I have a dev environment which is not being used since a long time.
And now when I want to use it and trying to log in with the known id and password, it says incorrect credentials.
Is there a way, I can retrieve the password of the ID I was using to login or is there a way I can create a new user running any ars* command?

I tired querying the arsuser table but found that the passwords are encrypted. What is the encryption type that is used by OnDemand for mp - AIX,DB2?
I also tried updating the arstash command, but not sure whether that feature is supported on v8.5.

Thanks
AD
Title: Re: NEW USER ID Creation through database
Post by: Alessandro Perucchi on September 10, 2015, 09:35:34 AM
Hello abdeshpa,

As any secure system to store password, you cannot decrypt the passwords, since they are using hashing technique.
The only way to find your password is to search all possible by brute force.

And Stash is something else. Is to help automate batches. But the password that you put in the stash file must match the one in the database!

-
Alessandro
Title: Re: NEW USER ID Creation through database
Post by: Justin Derrick on September 10, 2015, 10:29:46 AM
You'll need to reset the password for the account you want to use in the Admin client.  If you don't have access to the admin account (because you don't have that password either) then you'll need to reset it by blanking out the password for the admin account in the arsuser database table.

Title: Re: NEW USER ID Creation through database
Post by: Alessandro Perucchi on September 10, 2015, 12:08:08 PM
Hello Justin,

:-) true, I just didn't want to give that solution in public  ;D
Title: Re: NEW USER ID Creation through database
Post by: Justin Derrick on September 10, 2015, 01:52:11 PM
Quote from: Alessandro Perucchi on September 10, 2015, 12:08:08 PM
:-) true, I just didn't want to give that solution in public  ;D

Yeah, that's why I didn't include the SQL to do it.  Although, I wonder if posting the SQL that's done right is less dangerous than having people discover it on their own.  :D

-JD.