-
1. Re: DB Password Change
Joel Rosete Jan 23, 2012 1:30 PM (in response to Sujatha S)Hello Sujatha,
You just need to change the password on ar.conf file on th “ Db-password:
“ in this case this password exists but is encrypted so you need to remove
the value and put the new value for the new password…
Regards
Joel Rosete
De: Sujatha forums@developer.bmc.com
Enviado el: lunes, 23 de enero de 2012 13:26
Para: Joel
Asunto: DB Password Change New message on BMC
BMC Communities <https://communities.bmc.com/communities/index.jspa>Thread:
"DB Password Change"
created by Sujatha <https://communities.bmc.com/communities/people/Sujatha>in
BMC Remedy AR System - View the full
discussion<https://communities.bmc.com/communities/message/222660#222660
-
2. DB Password Change
Sujatha S Jan 23, 2012 1:38 PM (in response to Joel Rosete)Thanks for your response Joel.
I dont see a db-password in my ar.conf file.
Iam using 7.5 arsystem.am i looking at the wrong file?
Thanks
Sujatha
-
3. Re: DB Password Change
Joel Rosete Jan 23, 2012 2:13 PM (in response to Sujatha S)Hello Sujatha,
If this line does not exists you can set on it, just be careful to write
like this ,for example:
Db-password: AR#Admin#
You write this below the line that is like this:
Db-user:
Regards
Joel Rosete
De: Sujatha forums@developer.bmc.com
Enviado el: lunes, 23 de enero de 2012 13:39
Para: Joel
Asunto: Re: DB Password Change New message on BMC
BMC Communities <https://communities.bmc.com/communities/index.jspa>Thread:
"Re: DB Password Change"
created by Sujatha <https://communities.bmc.com/communities/people/Sujatha>in
BMC Remedy AR System - View the full
discussion<https://communities.bmc.com/communities/message/222663#222663
-
4. DB Password Change
Jayesh Bhavsar Jan 24, 2012 8:27 AM (in response to Sujatha S)Hi Sujatha,
As Joel Suggested, You just need to add "Db-password:New-Password" in ar.cfg/ar.conf.
You can also take help of BMC Remedy Action Request System: Database Reference.
Regards,
Jay
-
5. DB Password Change
Luis Varela Jan 25, 2012 9:04 AM (in response to Jayesh Bhavsar)You dont have to directly modify the configuration file.
You can set the DB password in the Database tab of the Server Information form.
-
6. Re: DB Password Change
Joel Rosete Jan 25, 2012 9:08 AM (in response to Luis Varela)Yes like Ivarela says is right too, the thing in here is that like Jay
says, they would need to reconnect it, so in this case I would think that
the server is down and the password has changed… but if the server is up
you can you can use the way like Ivarela says.
Regards
Joel Rosete
De: lvarela forums@developer.bmc.com
Enviado el: miércoles, 25 de enero de 2012 9:05
Para: Joel
Asunto: Re: DB Password Change New message on BMC
BMC Communities <https://communities.bmc.com/communities/index.jspa>Thread:
"Re: DB Password Change"
created by lvarela <https://communities.bmc.com/communities/people/lvarela>in
BMC Remedy AR System - View the full
discussion<https://communities.bmc.com/communities/message/223143#223143
-
7. Re: DB Password Change
Sujatha S Jan 25, 2012 9:27 AM (in response to Joel Rosete)Thanks everyone for the response.
When i checked the database reference guide ,it says
Warning: Do not change this password directly in the database.
Does that mean,DBA Team shouldnt change the password and we have to do it in server information tab?
I assume as soon as we change it,we have to restart the server to make it work.
Please advice
Thanks
Sujatha
-
8. Re: DB Password Change
Joel Rosete Feb 1, 2012 9:33 AM (in response to Sujatha S)Hello Sujatha,
Exactly is not recommend it to change this password from Database side, but the tips that you have received is in case your dba had been perform the change from database side.. if he still does not apply this change you can suggest to change this password from de Configuration Server from ARS Server side.
Regards
Joel Rosete
-
9. Re: DB Password Change
Jose Huerta Feb 2, 2012 1:09 AM (in response to Joel Rosete)Also think that other products connect directly to the database, and that the password is not propagated from ARS.
For instance, Analytics (BOXI) or Dashboards.
Regards,
Jose Huerta
-
10. DB Password Change
Sujatha S Mar 1, 2012 3:56 PM (in response to Jose Huerta)Hi All,
Thanks for your response
It seems my DB Password is expired.when am trying to change my password from BMC AR system Server Information -Database tab,its throwing an error message
"ARERR [552] Failure during SQL operation to the database : ORA-28221: REPLACE not specified"
Please help
Thanks
Sujatha
-
11. Re: DB Password Change
Arun NameToUpdate Sep 17, 2012 8:58 PM (in response to Sujatha S)Hi Sujatha,
I hope your issue is resolved by now. Still, let me share this potential solution for the community's benefit.
'ARERR [552] Failure during SQL operation to the database : ORA-28221: REPLACE not specified' error may be because the aradmin (DB account) does not have the ALTER USER privilages on the database
Modify the permissions of this account from the DB (ask your DBA) and re-attempt to set the new password from the Server Information.(It worked in our environment). If your organisation has a security requirement not to have the ALTER privileges to the application accounts, revert to the original permissions after successfully resetting the password.
Cheers.
Arun
-
12. Re: DB Password Change
Jayesh Bhavsar Sep 18, 2012 12:08 AM (in response to Arun NameToUpdate)Thanks Arun,
It will be helpful for the Remedy Admin who are willing to change their DB Password from AR System.
Regards,
Jay
-
13. Re: DB Password Change
Stony Shi Oct 26, 2016 2:38 AM (in response to Jayesh Bhavsar)if DBA already change the password, how to encrypt it and then update it into ar.conf? Is there any Utility or tool to encrypt password?
-
14. Re: DB Password Change
LJ LongWingOct 26, 2016 8:18 AM (in response to Stony Shi)
3 of 3 people found this helpfulAccording to ar.cfg or ar.conf options C-D - BMC Remedy Action Request System 8.1 - BMC Documentation
Specify the password in the ar.cfg file in clear text, which will allow the Remedy server to startup, then go into the Server information console and set it to the same value again through the interface and that'll replace it with the encrypted value.