ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Message Flow ODBC Login Fails but SQL Loging works

Post new topic  Reply to topic
 Message Flow ODBC Login Fails but SQL Loging works « View previous topic :: View next topic » 
Author Message
smdavies99
PostPosted: Fri Oct 03, 2003 1:50 am    Post subject: Message Flow ODBC Login Fails but SQL Loging works Reply with quote

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
View user's profile Send private message
lillo
PostPosted: Fri Oct 03, 2003 2:26 am    Post subject: Reply with quote

Master

Joined: 11 Sep 2001
Posts: 224
Check the following discussion
http://www.mqseries.net/phpBB2/viewtopic.php?t=5606
_________________
Lillo
IBM Certified Specialist - WebSphere MQ
Back to top
View user's profile Send private message
smdavies99
PostPosted: Fri Oct 03, 2003 3:23 am    Post subject: Reply with quote

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
View user's profile Send private message
EddieA
PostPosted: Fri Oct 03, 2003 7:43 am    Post subject: Reply with quote

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
View user's profile Send private message
smdavies99
PostPosted: Fri Oct 03, 2003 11:30 am    Post subject: Reply with quote

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
View user's profile Send private message
jefflowrey
PostPosted: Sun Oct 05, 2003 5:38 am    Post subject: Reply with quote

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
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Message Flow ODBC Login Fails but SQL Loging works
Jump to:  



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
Protected by Anti-Spam ACP
  
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.