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 » Broker Connecting to Database on Linux

Post new topic  Reply to topic
 Broker Connecting to Database on Linux « View previous topic :: View next topic » 
Author Message
mickey1691
PostPosted: Wed Jun 12, 2013 6:27 am    Post subject: Broker Connecting to Database on Linux Reply with quote

Novice

Joined: 04 Jun 2013
Posts: 19

Hi. We're working on two brokers, one that listens in on a port below 1024 (Broker A)and one on the default (on 7080, calling it Broker B). The brokers are running on Linux, so root had to start the Broker A, while we had another user start the other one.

We also set up an OBDC connection for the brokers and the users. The bashprofiles of both users are pointing to the same odbc.ini and odbcinst.ini.

We deployed an application that makes use of Database nodes and Stored Procedure calls on both brokers, but there seems to be a problem. While the application in Broker B can access the database and execute the database functions without any problem, the application in Broker A is unable to.

When we run the mqsicvp command for Broker A with the data source in odbc.ini, it seems to connect. Any ideas on how to solve this?
Back to top
View user's profile Send private message
McueMart
PostPosted: Wed Jun 12, 2013 6:31 am    Post subject: Reply with quote

Chevalier

Joined: 29 Nov 2011
Posts: 490
Location: UK...somewhere

What error do you get?
Back to top
View user's profile Send private message
mqjeff
PostPosted: Wed Jun 12, 2013 6:34 am    Post subject: Reply with quote

Grand Master

Joined: 25 Jun 2008
Posts: 17447

presumably the root user does not have access to the odbc.ini file.
Back to top
View user's profile Send private message
mickey1691
PostPosted: Wed Jun 12, 2013 6:41 am    Post subject: Reply with quote

Novice

Joined: 04 Jun 2013
Posts: 19

McueMart wrote:
What error do you get?


Something along the lines of "Data source name or driver not found."
Back to top
View user's profile Send private message
mickey1691
PostPosted: Wed Jun 12, 2013 6:46 am    Post subject: Reply with quote

Novice

Joined: 04 Jun 2013
Posts: 19

mqjeff wrote:
presumably the root user does not have access to the odbc.ini file.


Even if it has superuser priveleges?
Back to top
View user's profile Send private message
lancelotlinc
PostPosted: Wed Jun 12, 2013 6:54 am    Post subject: Re: Broker Connecting to Database on Linux Reply with quote

Jedi Knight

Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA

mickey1691 wrote:
When we run the mqsicvp command for Broker A with the data source in odbc.ini, it seems to connect. Any ideas on how to solve this?


You may be running mqsicvp in a different user context than the Broker service Id, which by the way should not be mqm.

That may be why mqsicvp works interactively but Broker runtime is unable to connect.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER
Back to top
View user's profile Send private message Send e-mail
mickey1691
PostPosted: Wed Jun 12, 2013 4:16 pm    Post subject: Re: Broker Connecting to Database on Linux Reply with quote

Novice

Joined: 04 Jun 2013
Posts: 19

lancelotlinc wrote:


You may be running mqsicvp in a different user context than the Broker service Id, which by the way should not be mqm.

That may be why mqsicvp works interactively but Broker runtime is unable to connect.


The service id is root, and we also used the mqsicvp command under root. Same result, but broker runtime is still unable to connect.
Back to top
View user's profile Send private message
Tibor
PostPosted: Thu Jun 13, 2013 5:36 am    Post subject: Reply with quote

Grand Master

Joined: 20 May 2001
Posts: 1033
Location: Hungary

I know this is only a workaround, but using a proxy / redirector seems to me a more future-proof and simpler solution. Everything would be simpler...
Back to top
View user's profile Send private message
mqjeff
PostPosted: Thu Jun 13, 2013 5:40 am    Post subject: Reply with quote

Grand Master

Joined: 25 Jun 2008
Posts: 17447

particularly since in v8 it's very easy to export the HTTP config of one or more Brokers into a file usable by several different HTTP server plugins...
http://publib.boulder.ibm.com/infocenter/wmbhelp/v8r0m0/topic/com.ibm.etools.mft.doc/be55180_.htm
Back to top
View user's profile Send private message
mickey1691
PostPosted: Thu Jun 13, 2013 7:55 pm    Post subject: Reply with quote

Novice

Joined: 04 Jun 2013
Posts: 19

I searched the logs, apparently, it's a BIP2347.

Database error: SQL State <insert_1>; Native Error Code <insert_2>; Error Text 'System information file not found. Please check the ODBCINI and the ODBCSYSINI environment variables are correctly set.'

Though the question now is how can root not find the file when both user bash_profiles are pointing at the same files?
Back to top
View user's profile Send private message
Tibor
PostPosted: Thu Jun 13, 2013 9:47 pm    Post subject: Reply with quote

Grand Master

Joined: 20 May 2001
Posts: 1033
Location: Hungary

For double-checking you can display the environment of the running DataFlowEngine process:
Code:
cat /proc/<PID>/environ | strings | grep ODBC


Last edited by Tibor on Thu Jun 13, 2013 11:52 pm; edited 1 time in total
Back to top
View user's profile Send private message
mickey1691
PostPosted: Thu Jun 13, 2013 10:58 pm    Post subject: Reply with quote

Novice

Joined: 04 Jun 2013
Posts: 19

Tibor wrote:
For double-checking you can display the environment of the running DataFlowEngine process:
Code:
cat /proc/<PID>>/environ | strings | grep ODBC


Thanks. I used that command, and I found out that there's no define ODBCINI for the dataflowengine and the ODBCSYSINI is pointing to a wrong file.

Though, when I echo ODBCINI and ODBCSYSINI, they refer to the correct files.
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 » Broker Connecting to Database on Linux
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.