Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

PPM 7.5 issue with "$" in [DB_PASSWORD]

SOLVED
Go to solution
Highlighted
bzdafro
Collector

PPM 7.5 issue with "$" in [DB_PASSWORD]

I am having a problem running the command below when the DB_PASSWORD contains a $.    I'm not sure if its an issue with PPM or Cygwin client.   I can use the ksc_simple_respond as a work around.  Just wondering if anyone knows how to get it to work without using ksc_simple_respond?  

 

This command doesnt work if DB_PASSWORD contains a $.   Running via Cygwin

sqlplus [DEST_ENV.DB_USERNAME]/[DEST_ENV.DB_PASSWORD]@[DEST_ENV.DB_NAME] @test.sql

 

This is the workaround

ksc_simple_respond "sqlplus [DEST_ENV.DB_USERNAME]\@[DEST_ENV.DB_NAME \@test.sql" -hide "Enter password:" "[DEST_ENV.DB_PASSWORD]"

1 REPLY
Jason Nichols K
Honored Contributor
Solution

Re: PPM 7.5 issue with "$" in [DB_PASSWORD]

I would say it's more of a shell issue than PPM or even Cygwin specifically.  The '$' is a special character in *nix environments in that it is the precursor to a variable name.  So, in your case, you are putting the password into the command line (a security risk to be sure) and the shell is trying to translate part of the password as a variable, which would end up being an empty string, thereby removing part, if not all of the password beyond the '$'.  The ksc_simple_respond is the best solution in this situation.

//Add this to "OnDomLoad" event