DX NetOps

  • Private Community

  • 1.  CAPM Repo dradmin password change

    Posted Jun 08, 2018 11:05 AM

    I need to change the password for the dradmin user for a secondary set of repo's in CAPM 3.5 . Is there a config file that can be edited to do this, or is the DB password also the O/S password?



  • 2.  Re: CAPM Repo dradmin password change

    Broadcom Employee
    Posted Jun 08, 2018 11:09 AM

    Hi David,

     

    Please refer to 

     

    DB user password change in Data Aggregator configu - CA Knowledge 

     

    Regards,

    Arvind Sugurr



  • 3.  Re: CAPM Repo dradmin password change

    Posted Jun 08, 2018 11:56 AM

    Thanks Aravind. I'll have a look.



  • 4.  Re: CAPM Repo dradmin password change

    Broadcom Employee
    Posted Jun 08, 2018 11:49 AM

    David,

     

    Which user are you referring to?  The dradmin OS user or the dradmin Database user.  They are two distinctly different users.

     

    Troy



  • 5.  Re: CAPM Repo dradmin password change

    Posted Jun 08, 2018 11:55 AM

    Troy - I'm . thinking I need to change the password for the dradmin DB user. I need to change the password used in adminTools to stop the DB. But you also cleared up a tangential question for me as well about whether the user and password was the same as the OS.



  • 6.  Re: CAPM Repo dradmin password change
    Best Answer

    Broadcom Employee
    Posted Jun 08, 2018 12:00 PM

    Then you would need to follow the KB that Aravind mentioned to accomplish that.  The KB does mention setting another user as well so for you, use these steps:

     

    Note: the user name of dradmin is assumed as it is the default.

     

    1) Login to the Data Aggregator server

    2) Change directory to /opt/IMDataAggregator/scripts/common.tools.encryption
    3) ./doEncryption.sh dradmin NEWPASSWORD
    4) Replace password in dbconnection.cfg with new password provided by script.
    5) Login into the Data Repository server as OS user dradmin
    6) /opt/verica/bin/vsql -U dradmin -w <old password>
    7) ALTER USER dradmin IDENTIFIED BY 'newpassword'



  • 7.  Re: CAPM Repo dradmin password change

    Posted Jun 08, 2018 02:24 PM

    Thanks guys.



  • 8.  Re: CAPM Repo dradmin password change

    Broadcom Employee
    Posted Jun 13, 2018 08:41 AM

    David,

     

    Just wanted to check in and see if you are all set and were able to get the procedure Aravind and I mentioned working.  If you do not have any follow up questions, could we mark one of our replies as correct so if someone else comes along with the same question they can find the answer quickly?

     

    Troy



  • 9.  Re: CAPM Repo dradmin password change

    Posted Jun 13, 2018 08:51 AM

    Troy,

     

    I haven’t had time to work through it yet. It may be a week or two. Meanwhile, yes I think you can mark your answers correct. If I have any further questions I’ll let you know. Thanks for your help.

     

     

    Regards,

    David Marion