| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| MQSISETDBPARMS not sticking? Oracle/BIPBIP2322E |
« View previous topic :: View next topic » |
| Author |
Message
|
| catwood2 |
 Posted: Mon Jul 25, 2005 3:40 pm Post subject: MQSISETDBPARMS not sticking? Oracle/BIPBIP2322E |
 |
|
Centurion
Joined: 17 May 2002
Posts: 108
|
Thanks in advance for thoughts.
Windows2000/WBIMB5/CSD4
I had to rebuild the configuration and now am experiencing login issues when the broker attempts to access the database (exact trace error posted at the end of post). I have verified DSN is correct and that I can login to the db with the credentials I am trying to assign via mqsisetdbparms. I've deleted all components and recreated....a couple of times. Rebooted the system more than a few. I've turned on odbc tracing but it doesn't give me the credential it is trying to use for access. Looked in the registry - but the id there is specific to the broker database. So, not sure how I can determine exactly the credentials getting passed in to the db for login.
thanks,
catwood2
| Quote: |
2005-07-25 16:33:02.590867 4632 DatabaseException BIP2321E: Database erro
r: ODBC return code '-1'.
The message broker encountered an error w
hilst executing a database operation. The ODBC return code was '-1'. See the fol
lowing messages for information obtained from the database pertaining to this er
ror.
Use the following messages to determine t
he cause of the error. This is likely to be such things as incorrect datasource
or table names. Then correct either the database or message broker configuration
.
2005-07-25 16:33:02.590925 4632 DatabaseException BIP2322E: Database erro
r: SQL State '28000'; Native Error Code '1017'; Error Text '[Oracle][ODBC][Ora]O
RA-01017: invalid username/password; logon denied
'.
The error has the following diagnostic in
formation: SQL State '28000' SQL Native Error Code '1017'
SQL Error Text '[Oracle][ODBC][Ora]ORA-01017: invalid username/password
; logon denied
|
|
|
| Back to top |
|
 |
| catwood2 |
| Posted: Mon Jul 25, 2005 4:02 pm Post subject: |
|
|
Centurion
Joined: 17 May 2002
Posts: 108
|
| Missed the DSN folder in the registry. So, I can verify it is taking the userid I am specifying and the password is being encrypted. Doesn't explain why I'm getting the login failures.....but, does aid in verfiying what the configuration is. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Tue Jul 26, 2005 3:24 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
The database user is either the broker service user, the broker database user, or the user setup with mqsisetupdbparms.
You can change the broker database password using mqsichangebroker. I don't believe you can change the broker service user (but I could be remembering wrong), and mqsisetupdbparms will work as well without deleting the broker.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| ourtown |
| Posted: Sun Sep 25, 2005 3:21 am Post subject: |
|
|
Acolyte
Joined: 05 Feb 2002
Posts: 67
Location: Somerset, NJ
|
mqsichangeproperties
_________________
Brian S. Crabtree
WBI Consultant |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
