Author |
Message
|
richhel |
Posted: Mon Dec 31, 2007 5:10 am Post subject: TO CHANGE PASSWORD |
|
|
Newbie
Joined: 26 Dec 2007 Posts: 9
|
HI
My broker is running in AIX
I want to change the broker password.
pls can anyone tell me the steps. |
|
Back to top |
|
 |
richhel |
Posted: Mon Dec 31, 2007 5:19 am Post subject: |
|
|
Newbie
Joined: 26 Dec 2007 Posts: 9
|
pls reply  |
|
Back to top |
|
 |
Nigelg |
Posted: Mon Dec 31, 2007 5:45 am Post subject: |
|
|
Grand Master
Joined: 02 Aug 2004 Posts: 1046
|
Try the Search button... _________________ MQSeries.net helps those who help themselves.. |
|
Back to top |
|
 |
jefflowrey |
Posted: Mon Dec 31, 2007 7:59 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002 Posts: 19981
|
Which password?
Please don't doublepost.
First you need to change the password at the OS.
Then you need to run the right mqsi command to change the broker, or to set the database parameters. _________________ I am *not* the model of the modern major general. |
|
Back to top |
|
 |
richhel |
Posted: Tue Jan 01, 2008 4:21 am Post subject: |
|
|
Newbie
Joined: 26 Dec 2007 Posts: 9
|
I ve changed the database parameter and also put the mqsichangebroker command.
mqsichangebroker -a <password> -i <username>
after that i stop and start the broker.but the dataflow engine is not running. |
|
Back to top |
|
 |
jefflowrey |
Posted: Tue Jan 01, 2008 7:59 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002 Posts: 19981
|
richhel wrote: |
after that i stop and start the broker.but the dataflow engine is not running. |
What errors do you get when it starts up?
Are you sure you wanted to use the -a/-i flags to change the database password? There are two usernames/passwords on the mqsichangebroker command - One for broker service user and one for broker database user.
You can't change the user name for broker service user, and i don't think you can change the database user name either - you have to delete broker and recreate it to change those. _________________ I am *not* the model of the modern major general. |
|
Back to top |
|
 |
fjb_saper |
Posted: Tue Jan 01, 2008 12:04 pm Post subject: |
|
|
 Grand High Poobah
Joined: 18 Nov 2003 Posts: 20756 Location: LI,NY
|
jefflowrey wrote: |
richhel wrote: |
after that i stop and start the broker.but the dataflow engine is not running. |
What errors do you get when it starts up?
Are you sure you wanted to use the -a/-i flags to change the database password? There are two usernames/passwords on the mqsichangebroker command - One for broker service user and one for broker database user.
You can't change the user name for broker service user, and i don't think you can change the database user name either - you have to delete broker and recreate it to change those. |
Jeff are you sure about the DB user? I believe if the new user has the correct access including to the right schemas (synonyms etc...) you might be able to change the DB user... never tried it though... would mean a lot of work on the DBAdmin side...  _________________ MQ & Broker admin |
|
Back to top |
|
 |
jefflowrey |
Posted: Tue Jan 01, 2008 7:45 pm Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002 Posts: 19981
|
I'm not positive about the database, without double-checking it. _________________ I am *not* the model of the modern major general. |
|
Back to top |
|
 |
samar14 |
Posted: Tue Jan 01, 2008 9:46 pm Post subject: |
|
|
Novice
Joined: 30 Nov 2007 Posts: 17
|
Hi, mqsichangebroker command doesn't offer you an option to change
the database user id. For database access, you can change only the password. (-p flag). If you need to change the DB user, then you need to recreate the broker.
On the other note, if the broker is created without -u , -p options, then database access userid/passwd will default to broker userid & password (specified at -i , -a). So if you change -i,-a using mqsichangebroker then it will change the database access credentials also. In such case you need to make sure that new userid has the right permissions to access the database.(otherwise the broker would not start). |
|
Back to top |
|
 |
samar14 |
Posted: Tue Jan 01, 2008 9:48 pm Post subject: |
|
|
Novice
Joined: 30 Nov 2007 Posts: 17
|
The above post is in connection to the broker database and not the user database. If the user wants to change the "user" database access credentials , then mqsisetdbparams command can be used. |
|
Back to top |
|
 |
|