Delphix Products

Back to discussions
Expand all | Collapse all

change DB password through cli interface

  • 1.  change DB password through cli interface

    Posted 03-23-2016 07:23:00 AM

    I try to change db credentials through cli interface, but I always get an error:
    sourceconfig
    select $SOURCE
    update
    credentials.password="$pwd"
    commit
    Got an error:
    2016-03-23_08:41:24 06005 Change pwd of DB
    Unknown command 'credentials.password=pwd'.
    Delphix version is 4.2.5.0


    #Tip


  • 2.  RE: change DB password through cli interface

    Posted 03-23-2016 11:00:00 AM
    Hello,

    I think you are missing "set":

    nstackdelphix.dcenter sourceconfig 'pubs2'> update

    nstackdelphix.dcenter sourceconfig 'pubs2' update *> set credentials.password=abc

    nstackdelphix.dcenter sourceconfig 'pubs2' update *> 



  • 3.  RE: change DB password through cli interface

    Posted 03-24-2016 06:38:00 AM

    vmdelphix> sourceconfig
    vmdelphix sourceconfig> select TESTDB
    vmdelphix sourceconfig 'TESTDB'> update
    vmdelphix sourceconfig 'TESTDB' update *> set credentials.password=test
    No such property 'password'.

    I also tried with setting version 1.4.0, but it doesn't work neither.

    If I make an edit credentials,
    I see the following:
     ls
    Properties
        type: KeyPairCredential (*)
        privateKey: (required)
        publicKey: (required)



  • 4.  RE: change DB password through cli interface
    Best Answer

    Posted 03-24-2016 10:49:00 AM
    sourceconfig
    select TESTDB
    update
    set credentials.type=PasswordCredential
    set credential.password=abc


  • 5.  RE: change DB password through cli interface

    Posted 03-24-2016 11:37:00 AM

    start better, but doesn't really work neither:

    vmdelphix sourceconfig 'TESTDB' update *> set credentials.type=PasswordCredential
    vmdelphix sourceconfig 'TESTDB' update *> set credentials.password=test
    vmdelphix sourceconfig 'TESTDB' update *> commit
       Error: A server error occurred while processing your request.
      Action: Please contact Delphix support.



  • 6.  RE: change DB password through cli interface

    Posted 03-24-2016 11:42:00 AM
    Did you disable the database first?


  • 7.  RE: change DB password through cli interface

    Posted 03-24-2016 11:47:00 AM
    No. I did what was marked in the tipp of the day on this subject.
    Should I disable?


  • 8.  RE: change DB password through cli interface

    Posted 03-24-2016 11:49:00 AM
    After you type "commit" do you see a job in the Delphix console's action pane?




  • 9.  RE: change DB password through cli interface

    Posted 03-24-2016 11:54:00 AM
    No. I am just trying to work through replicating your scenario.


  • 10.  RE: change DB password through cli interface

    Posted 03-24-2016 11:54:00 AM
    Can you give me the link to the Tip of the Day article you are following?


  • 11.  RE: change DB password through cli interface

    Posted 03-24-2016 12:02:00 PM
    Yep, but the job is failed. I can change the pwd through gui though


  • 12.  RE: change DB password through cli interface

    Posted 03-24-2016 12:03:00 PM
    If you click on that job in the action pane, does it provide any details?


  • 13.  RE: change DB password through cli interface

    Posted 03-24-2016 12:12:00 PM

    Hi again,

    Found the problem. My source was pointing to the standby DB. When I do same using the name pointing to primary DB, it works fine.

    Many thanks for you help!



  • 14.  RE: change DB password through cli interface

    Posted 03-24-2016 12:41:00 PM
    Supreme.