Author |
Message
|
JT |
Posted: Wed Apr 28, 2004 9:33 am Post subject: Broker and user database passwords |
|
|
Padawan
Joined: 27 Mar 2003 Posts: 1564 Location: Hartford, CT.
|
Am running WBIMB v5.0.2 in a Solaris 2.8 environment with Oracle 9i databases. Does anyone know (maybe an IBMer):- Where is the password for the broker database (as defined by the mqsicreatebroker command) and the passwords for user databases (as defined by the mqsisetdbparm command) stored?
- Are they encrypted?
|
|
Back to top |
|
 |
Missam |
Posted: Wed Apr 28, 2004 10:17 am Post subject: |
|
|
Chevalier
Joined: 16 Oct 2003 Posts: 424
|
Quote: |
Where is the password for the broker database (as defined by the mqsicreatebroker command) and the passwords for user databases (as defined by the mqsisetdbparm command) stored? |
I don't know whether WBIMB provides passwords for the Broker Databases.
BUT The best place you can get the password for the Broker database is to consult your DBA.
Quote: |
Are they encrypted?
|
I guess So |
|
Back to top |
|
 |
fschofer |
Posted: Wed Apr 28, 2004 12:14 pm Post subject: |
|
|
 Knight
Joined: 02 Jul 2001 Posts: 524 Location: Mainz, Germany
|
Hi,
take a look at the environment variable MQSI_REGISTRY of your broker.
It points to the directory where your DB config is stored.
I have no Unix System at hand, so i cannot name you the file name.
Under Windows the config is stored directly in the registry.
If you want to change the password, use the command mqsichangebroker.
Greetings
Frank |
|
Back to top |
|
 |
JT |
Posted: Wed Apr 28, 2004 1:10 pm Post subject: |
|
|
Padawan
Joined: 27 Mar 2003 Posts: 1564 Location: Hartford, CT.
|
IamSam,
Thank-you for your reply, but that wasn't exactly what I was looking for.
When a message broker is created via the mqsicreatebroker command, a password is specified for the broker database (-p parameter or -a parameter if the -u parameter is not specified). I not looking to determine what my password is, I need to ascertain whether WMQIMB v5.0 meets the security requirements for protecting passwords set forth by my company, thus I need to know where the password is stored and if it is encrypted.
The same holds true for those passwords specified on the mqsisetdbparms command which is issued for all user databases access via a compute or database node. Again, I don't need to determine what the password is, just where its located (i.e. on a particular broker table, stored in a system broker queue, etc...). |
|
Back to top |
|
 |
TonyD |
Posted: Wed Apr 28, 2004 3:55 pm Post subject: |
|
|
Knight
Joined: 15 May 2001 Posts: 540 Location: New Zealand
|
On AIX the passwords and userids are stored in:
/var/wmqi/registry/BrokerName
I imagine it will be similar for Solaris.
The passwords appear to be encrypted. |
|
Back to top |
|
 |
JT |
Posted: Thu Apr 29, 2004 5:12 am Post subject: |
|
|
Padawan
Joined: 27 Mar 2003 Posts: 1564 Location: Hartford, CT.
|
|
Back to top |
|
 |
mlafleur |
Posted: Mon Sep 27, 2004 1:41 pm Post subject: |
|
|
Acolyte
Joined: 19 Feb 2004 Posts: 73
|
Does anyone know where the usernames / passwds set with mqsisetdbparms are stored? |
|
Back to top |
|
 |
chanduy9 |
Posted: Mon Sep 27, 2004 1:54 pm Post subject: |
|
|
Disciple
Joined: 28 Nov 2001 Posts: 177 Location: USA
|
Hi,
On Widnows check in Registry and on HP Unix /var/wmqi/registry/<BrokerName>/DSN
Thanks,
Chandra. |
|
Back to top |
|
 |
kirani |
Posted: Mon Sep 27, 2004 10:27 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001 Posts: 3779 Location: Torrance, CA, USA
|
Passwords are encrypted in the registry. _________________ Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
Back to top |
|
 |
|