12 Replies Latest reply: Sep 18, 2012 12:08 AM by Jayesh Bhavsar

DB Password Change

Sujatha S Jan 23, 2012 1:26 PM

Hi,

DBA Team is Planning for a password change in Customized Application.

What changes has to be done from Remedy to reconnect it to the database?

Please advice

Thanks

Sujatha

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
Communities

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
Like Show 0 Likes (0)
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
Like Show 0 Likes (0)
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
Communities

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
Like Show 0 Likes (0)
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
Like Show 0 Likes (0)
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.
Like Show 0 Likes (0)
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
Communities

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
Like Show 0 Likes (0)
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
Like Show 0 Likes (0)
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
Like Show 0 Likes (0)
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
http://theremedyforit.com/
Like Show 0 Likes (0)
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
Like Show 0 Likes (0)
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
Like Show 1 Like (1)
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
Like Show 0 Likes (0)