Project and Portfolio Management Practitioners Forum
cancel

Automating password encryption or can I allow user to update just a few environment passwords?

Highlighted
bzdafro
Honored Contributor.

Automating password encryption or can I allow user to update just a few environment passwords?

I have used the kEncrypt.sh to generate encrypted password.  Then drop the first and last 3 characters (#!#) and update the password in an environment.     I would like to create a workflow that will automate this.   Is it possible to pass the entire encryption to the update statement or must you drop the first 3 and last 3?   Because I am not sure of an easy way to drop the last 3 without some crazy awk or sed.   (Plus I would prefer not to mess around with cutting characters).   Any suggestions or better ways to perform this?  I need to allow some users to update a few passwords in PPM.

6 REPLIES
Jim Esler
Acclaimed Contributor.

Re: Automating password encryption or can I allow user to update just a few environment passwords?

We have a request type for this function. The commands that encrypt the new value and place it in a temporary token are:

 

./kEncrypt.sh -t "[REQD.VP.RUNTIME_PASSWORD]" | grep "\#\!\#" | sed 's/#\!#//g'
ksc_set ENCRYPTED="[EXEC.OUTPUT]"

Celil
Acclaimed Contributor.

Re: Automating password encryption or can I allow user to update just a few environment passwords?

what is your system? grep & sed are linux commands
Celil

IT Governance Professional
& PPM Solution Architect
Jim Esler
Acclaimed Contributor.

Re: Automating password encryption or can I allow user to update just a few environment passwords?

We run on AIX servers. grep and sed are also available in a Cygwin environment which, I assume, would be available on a Windows server that is running PPM.

bzdafro
Honored Contributor.

Re: Automating password encryption or can I allow user to update just a few environment passwords?

That should work.  Do you run an update script to update a PPM environment password or do you pass the token to a script to run?

Jim Esler
Acclaimed Contributor.

Re: Automating password encryption or can I allow user to update just a few environment passwords?

We create a script with the appropriate values with ksc_begin_script / ksc_end_script, then execute it with a sqlplus command.

Vibhor
Contributor.

Re: Automating password encryption or can I allow user to update just a few environment passwords?

We have a similar requirement in to automate the password update for environment. Does this workaounrd working for you. If you can share some feedback then it will be great help for us. Also we are on Solaris server. Will this command work over there.