| Author |
Message
|
| Lex |
 Posted: Wed Jan 31, 2007 2:52 am Post subject: DataSourceUserId and DataSourcePassword |
 |
|
Acolyte
Joined: 14 Nov 2006
Posts: 73
|
Hello,
I'm working on MQSI 2.1 and MQSeries 5.3 (i know it's too old we are migrating on a newer version soon).
Yesterday, i used the mqsichangebroker command on our developpement environnment (on a AIX computer) in order to change the DataSourcePassword (using the -p option).
I also changed the DataSourceUserId by editing the file in /var/mqsi/registry/<Broker_name>/DataSourceUserId.
Since then my broker can't reconnect to its database. I gave back the initial value that were in these 2 fields (DataSourceUserId and DataSourcePassword) but when i start the broker it says it can't connect to the database because of a wrong login/password.
But i use the same login/password on the software TOAD in order to connect to this database and it's working well!
Any clue how to solve this problem? As i'm working on a developpement environnment, i thought about recreatring the broker (i have all my workflows saved), but i can't, because when i use mqsideletebroker <broker_name>, it's failing cause the broker doesn't have access to its database!
Thanks in advance folks  |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Wed Jan 31, 2007 4:19 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
You can't change the user id without recreating the broker, I think.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| EddieA |
| Posted: Wed Jan 31, 2007 12:42 pm Post subject: |
|
|
Jedi
Joined: 28 Jun 2001
Posts: 2453
Location: Los Angeles
|
| jefflowrey wrote: |
| You can't change the user id without recreating the broker, I think. |
You can't. Full stop.
Cheers,
_________________
Eddie Atherton
IBM Certified Solution Developer - WebSphere Message Broker V6.1
IBM Certified Solution Developer - WebSphere Message Broker V7.0 |
|
| Back to top |
|
|
| pathipati |
| Posted: Wed Jan 31, 2007 1:18 pm Post subject: |
|
|
Master
Joined: 03 Mar 2006
Posts: 296
|
| Lex wrote: |
| As i'm working on a developpement environnment, i thought about recreatring the broker (i have all my workflows saved), but i can't, because when i use mqsideletebroker <broker_name>, it's failing cause the broker doesn't have access to its database! |
Try using Config Manager Proxy API to delete existing broker or Just create new broker without deleting existing broker.. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Wed Jan 31, 2007 1:44 pm Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Change the database password back. Change the database user back.
Delete the broker.
Change the password and userid in the database.
Create the broker again.
Make a note to next time read the manuals for all procedures before attempting them.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| EddieA |
| Posted: Wed Jan 31, 2007 2:39 pm Post subject: |
|
|
Jedi
Joined: 28 Jun 2001
Posts: 2453
Location: Los Angeles
|
| pathipati wrote: |
| Try using Config Manager Proxy API to delete existing broker or Just create new broker without deleting existing broker.. |
That didn't exist on V2.1.
Cheers,
_________________
Eddie Atherton
IBM Certified Solution Developer - WebSphere Message Broker V6.1
IBM Certified Solution Developer - WebSphere Message Broker V7.0 |
|
| Back to top |
|
|
| pathipati |
| Posted: Wed Jan 31, 2007 4:50 pm Post subject: |
|
|
Master
Joined: 03 Mar 2006
Posts: 296
|
 my bad... |
|
| Back to top |
|
|
|
|
