| Author |
Message
|
| smdavies99 |
 Posted: Fri Oct 03, 2003 1:50 am Post subject: Message Flow ODBC Login Fails but SQL Loging works |
 |
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
Here is a question that I am sure has a simple resolution.
The Message Flow is reporting the following
Oct 3 10:20:38 solsrvr10 WMQIv210[13203]: [ID 702911 user.error] (SOLWMQI10.APP_EXEGroup01)[16]BIP2628E: Exception condition detected on input node 'smdtestflow.MQInput1'. : SOLWMQI10.2ffc2df8-f700-0000-0080-bafc5ff94bf0: /build/S210_P/src/DataFlowEngine/ImbMqInputNode.cpp: 1334: ImbMqInputNode::readQueue: ComIbmMQInputNode: 54202901-f800-0000-0080-bafc5ff94bf0
Oct 3 10:20:38 solsrvr10 WMQIv210[13203]: [ID 702911 user.error] (SOLWMQI10.APP_EXEGroup01)[16]BIP2230E: Error detected whilst processing a message in node 'smdtestflow.Compute1'. : SOLWMQI10.2ffc2df8-f700-0000-0080-bafc5ff94bf0: /build/S210_P/src/DataFlowEngine/ImbComputeNode.cpp: 453: ImbComputeNode::evaluate: ComIbmComputeNode: 154f2901-f800-0000-0080-bafc5ff94bf0
Oct 3 10:20:38 solsrvr10 WMQIv210[13203]: [ID 702911 user.error] (SOLWMQI10.APP_EXEGroup01)[16]BIP2321E: Database error: ODBC return code '-1'. : SOLWMQI10.2ffc2df8-f700-0000-0080-bafc5ff94bf0: /build/S210_P/src/DataFlowEngine/ImbOdbc.cpp: 152: ImbOdbcHandle::checkRcInner: :
Oct 3 10:20:38 solsrvr10 WMQIv210[13203]: [ID 702911 user.error] (SOLWMQI10.APP_EXEGroup01)[16]BIP2322E: Database error: SQL State '28000'; Native Error Code '1017'; Error Text '[MERANT][ODBC Oracle 8 driver][Oracle 8]ORA-01017: invalid username/password; logon denied: SOLWMQI10.2ffc2df8-f700-0000-0080-bafc5ff94bf0: /build/S210_P/src/DataFlowEngine/ImbOdbc.cpp: 252: ImbOdbcHandle::checkRcInner: :
The Key point is the ORA-01017 Login Denied.
Here is the .ODBC.INI stanza for this database.
[APPICDB]
Driver=/opt/mqsi/merant/lib/UKor816.so
Description=Oracle8
ServerName=ORASRVR99
LogonID=mqsiuser
Password=gonzo100
EnableDescribeParam=1
OptimizePrepare=1
If I login to this user with SQL*PLUS it works.
$ sqlplus mqsiuser/gonzo100@ORASRVR99
SQL*Plus: Release 8.1.7.0.0 - Production on Fri Oct 3 10:44:08 2003
(c) Copyright 2000 Oracle Corporation. All rights reserved.
Connected to:
Oracle8i Enterprise Edition Release 8.1.7.2.0 - Production
With the Partitioning option
JServer Release 8.1.7.2.0 - Production
SQL>
Can anyone point as to why this is failing.
Stephen Davies
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
 |
| lillo |
| Posted: Fri Oct 03, 2003 2:26 am Post subject: |
|
|
Master
Joined: 11 Sep 2001
Posts: 224
|
|
| Back to top |
|
|
| smdavies99 |
| Posted: Fri Oct 03, 2003 3:23 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
I understand that you can turn on ODBC Tracing. I am told that this can help sort out the probles like those I am encountering. This Database is a totally separate oracle instance from the Broker DB.
does any reader of this forum know how to turn on/setup ODBC trace?
Stephen Davies
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
| EddieA |
| Posted: Fri Oct 03, 2003 7:43 am Post subject: |
|
|
Jedi
Joined: 28 Jun 2001
Posts: 2453
Location: Los Angeles
|
Is mqsiuser/gonzo100 the service ID/password of the broker, as this is the ID/password it will use to connect.
Cheers,
_________________
Eddie Atherton
IBM Certified Solution Developer - WebSphere Message Broker V6.1
IBM Certified Solution Developer - WebSphere Message Broker V7.0 |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Fri Oct 03, 2003 11:30 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
Ok, much egg on face. It appears that I am experiencing WMQI's expected behaviour.
Note to any Hursley Readers...
It would be nice though for future versions to actually use the info you have so carefully put into the odbc.ini or have some other method of specifying database Access Control.
Stephen D
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Sun Oct 05, 2003 5:38 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
| smdavies99 wrote: |
| It would be nice though for future versions to actually use the info you have so carefully put into the odbc.ini or have some other method of specifying database Access Control. |
You can specify mutliple logins for databases in WBIMB v5.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
|
|
