| Author |
Message
|
| hopsala |
 Posted: Tue Aug 05, 2008 1:25 am Post subject: Retrieving broker ODBC user and password [Solved] |
 |
|
Guardian
Joined: 24 Sep 2004
Posts: 960
|
WMB 6.0.0.3. Windows.
I am having security problems with a broker that I did not set up myself. This is a production environment, so I can't just go about changing things before I first know what's going on. I am familiar with setting the user to access database resources using mqsisetdbparams (for ESQL), and that if this command is not issued then the broker user is used.
My question is simple - for an existing broker, how do I find out with which user it accesses a given ODBC name? or conversely, how do I find out if whether the broker user is used?
I have been unable to find any command that does this, or anything here or in the literature; is it possible that there is no way to do this? 
Help will be most appreciated.
Last edited by hopsala on Tue Aug 05, 2008 2:51 am; edited 1 time in total |
|
| Back to top |
|
 |
| sachinramesh |
| Posted: Tue Aug 05, 2008 1:31 am Post subject: Re: Retrieving broker ODBC user and password |
|
|
Disciple
Joined: 20 Feb 2007
Posts: 170
|
Hi
AFAIK In the registry under the MB istallation folder You can find the user that the broker is accessing.
This is in the Windows Env..
| hopsala wrote: |
WMB 6.0.0.3. Windows.
I am having security problems with a broker that I did not set up myself. This is a production environment, so I can't just go about changing things before I first know what's going on. I am familiar with setting the user to access database resources using mqsisetdbparams (for ESQL), and that if this command is not issued then the broker user is used.
My question is simple - for an existing broker, how do I find out with which user it accesses a given ODBC name? or conversely, how do I find out if whether the broker user is used?
I have been unable to find any command that does this, or anything here or in the literature; is it possible that there is no way to do this?
Help will be most appreciated. |
|
|
| Back to top |
|
|
| AkankshA |
| Posted: Tue Aug 05, 2008 1:58 am Post subject: |
|
|
Grand Master
Joined: 12 Jan 2006
Posts: 1494
Location: Singapore
|
mqsireportproperties might be of your help.... chk out
_________________
Cheers |
|
| Back to top |
|
|
| hopsala |
| Posted: Tue Aug 05, 2008 2:51 am Post subject: |
|
|
Guardian
Joined: 24 Sep 2004
Posts: 960
|
| AkankshA wrote: |
| mqsireportproperties might be of your help.... chk out |
This command does not allow reporting of general broker properties, except those of httplistener and execution groups.
| sachinramesh wrote: |
AFAIK In the registry under the MB istallation folder You can find the user that the broker is accessing.
|
Yep, found it!
For future reference, if for example I added a user/pass for a db called TESTDB to a broker called TESTBK, you will find the user/pass in the registery here:
"HKEY_LOCAL_MACHINE/SOFTWARE/IBM/WebSphereMQIntegrator/2/MYBROKER/CurrentVersion/DSN/TESTDB"
If there are no entries under "DSN", that means that the broker user is used.
Thanks for the help!  |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Tue Aug 05, 2008 7:47 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
mqsiservice BROKERNAME should give this information.
No need to go traipsing all over the place... 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| hopsala |
| Posted: Tue Aug 05, 2008 8:07 am Post subject: |
|
|
Guardian
Joined: 24 Sep 2004
Posts: 960
|
| fjb_saper wrote: |
mqsiservice BROKERNAME should give this information.
No need to go traipsing all over the place... |
This command returns the following:
| Code: |
d:\Program Files\IBM\MQSI\6.0>mqsiservice WBRK6_DEFAULT_BROKER
Install Path = d:\Program Files\IBM\MQSI\6.0
Working Path = C:\Documents and Settings\All Users\Application Data\IBM\MQSI
Component UUID = 8232886f-1b01-0000-0080-e314db22ac09
process id = 3132
broker db name = DEFBKDB6
broker db userId = myuser
broker db password =
queue manager = WBRK6_DEFAULT_QUEUE_MANAGER
pubsub migration = no
fastpath Queue Manager = no
configuration timeout = 300
configuration delay timeout = 60
statistics major interval = 60
ComponentType = Broker
BIP8071I: Successful command completion. |
Only the user associated with the broker db is shown, but not users associated with other databases.
What i'm looking for is a command which shows all ODBC resources and the users which were associated to them using mqsisetdbparms for a given broker; is there some parameter that does this? The lit doesn't specify anything of the sort.. |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Tue Aug 05, 2008 8:09 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
I think you'll need to use mqsireport for that.
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| hopsala |
| Posted: Tue Aug 05, 2008 8:36 am Post subject: |
|
|
Guardian
Joined: 24 Sep 2004
Posts: 960
|
I'm getting a strange sensation of deja-vu here...
| hopsala wrote: |
| AkankshA wrote: |
| mqsireportproperties might be of your help.... chk out |
This command does not allow reporting of general broker properties, except those of httplistener and execution groups. |
|
|
| Back to top |
|
|
|
|
