| Author |
Message
|
| adivyayadav |
 Posted: Tue Nov 08, 2011 3:32 am Post subject: Password Change Config Manager has stopped working |
 |
|
Novice
Joined: 09 Mar 2011
Posts: 10
|
Hi All,
I have installed websphere MQ and MBv6.0. I am using db2 as the broker database. I am using the local system user id and password for broker data base.
Unfortunately, I need to change my network password every 45 days. So when I change the password the broker and config manager stop communicating with the db2.
when I try to deploy or undeploy I get the following error.
| Code: |
[color=darkred][b]( WBRK6_BROKER ) The broker made an unsuccessful attempt to access its database 'DEFBKDB6' with userid 'adivya_yadav'.
The broker's database could not be accessed using the userid and password supplied.
Ensure that the database is running and that the userid and password are correct. [/b]
[/color]
[color=brown]( WBRK6_BROKER ) Database error: SQL State ''08001''; Native Error Code '-30082'; Error Text ''[IBM][CLI Driver] SQL30082N Attempt to establish connection failed with security reason "24" ("USERNAME AND/OR PASSWORD INVALID"). SQLSTATE=08001 ''.
The error has the following diagnostic information: SQL State ''08001'' SQL Native Error Code '-30082' SQL Error Text ''[IBM][CLI Driver] SQL30082N Attempt to establish connection failed with security reason "24" ("USERNAME AND/OR PASSWORD INVALID"). SQLSTATE=08001 '' |
This message may be accompanied by other messages describing the effect on the message broker itself. Use the reason identified in this message with the accompanying messages to determine the cause of the error. [/color]
Please can anyone suggest a permanent solution to the problem. |
|
| Back to top |
|
 |
| Vitor |
| Posted: Tue Nov 08, 2011 5:26 am Post subject: Re: Password Change Config Manager has stopped working |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| adivyayadav wrote: |
| Please can anyone suggest a permanent solution to the problem. |
Upgrade to WMBv7. No database = no database id problems. 
(And of course no config manager = no config manager problems)
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| adivyayadav |
| Posted: Tue Nov 08, 2011 5:35 am Post subject: |
|
|
Novice
Joined: 09 Mar 2011
Posts: 10
|
I cant untill my organisation does not..  |
|
| Back to top |
|
|
| Vitor |
| Posted: Tue Nov 08, 2011 6:24 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
Then run the broker components with a local id that has a non-expiring password.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| adivyayadav |
| Posted: Tue Nov 08, 2011 6:28 am Post subject: |
|
|
Novice
Joined: 09 Mar 2011
Posts: 10
|
| My local id and password needs to be changed every 45 days.. |
|
| Back to top |
|
|
| Vitor |
| Posted: Tue Nov 08, 2011 7:19 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| adivyayadav wrote: |
| My local id and password needs to be changed every 45 days.. |
I said a local id, i.e. not yours. 
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| amitk22784 |
| Posted: Wed Nov 16, 2011 8:33 pm Post subject: |
|
|
Newbie
Joined: 23 Nov 2009
Posts: 9
|
you need to change your broker & config manager service id password and data source password if you have mentioned your network id during the installation every time when your password expired.
or you have to create a local user on same machine add that user into mqm , mqbrkrs and db2admns group.
replace the service id & password of broker & config manager with local user id & password.
restart the service; it will work.
 |
|
| Back to top |
|
|
| adivyayadav |
| Posted: Thu Nov 17, 2011 6:40 am Post subject: |
|
|
Novice
Joined: 09 Mar 2011
Posts: 10
|
| Thanks amit for the suggestion. Can you explain how to add the user into mqm , mqbrkrs and db2admns group. |
|
| Back to top |
|
|
| Vitor |
| Posted: Thu Nov 17, 2011 9:47 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| adivyayadav wrote: |
| Thanks amit for the suggestion. |
Given that's also what I suggested, you're welcome. 
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| adivyayadav |
| Posted: Wed Nov 23, 2011 4:11 am Post subject: |
|
|
Novice
Joined: 09 Mar 2011
Posts: 10
|
Vitor,Sorry and thanks 
But can you help me in this a little further .
how to add the user into mqm , mqbrkrs and db2admns group |
|
| Back to top |
|
|
| Vitor |
| Posted: Wed Nov 23, 2011 7:09 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| adivyayadav wrote: |
| how to add the user into mqm , mqbrkrs and db2admns group |
Using whatever method is relevant for the OS you're using.
Speak to whoever administers the box. You might need them to do it anyway depending on your site security standards.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
|
|
