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 » Can't create ODBC datasource on new Integration Bus 9 server

Post new topic  Reply to topic Goto page Previous  1, 2
 Can't create ODBC datasource on new Integration Bus 9 server « View previous topic :: View next topic » 
Author Message
lancelotlinc
PostPosted: Fri Oct 04, 2013 3:44 am    Post subject: Reply with quote

Jedi Knight

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

smdavies99 wrote:
lancelotlinc wrote:


Whomever installed your IIB should be kept far away from any of your other applications as their depth of knowledge is questionable.


Should it be

'Whoever CONFIGURED your broker should be....'

configuring the broker with the right username etc is what's wrong. AFAIK, they don't need to reinstall


That depends. Often the file folder ownership for files is also goofed up when this happens.
_________________
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
mqsiman
PostPosted: Fri Oct 04, 2013 9:13 am    Post subject: Reply with quote

Novice

Joined: 01 Oct 2013
Posts: 12

lancelotlinc wrote:
smdavies99 wrote:
lancelotlinc wrote:


Whomever installed your IIB should be kept far away from any of your other applications as their depth of knowledge is questionable.


Should it be

'Whoever CONFIGURED your broker should be....'

configuring the broker with the right username etc is what's wrong. AFAIK, they don't need to reinstall


That depends. Often the file folder ownership for files is also goofed up when this happens.


Like I said in my first post, we're all new to Broker/IIB development. Could running the broker as mqm be causing my error though?
Back to top
View user's profile Send private message
lancelotlinc
PostPosted: Fri Oct 04, 2013 9:55 am    Post subject: Reply with quote

Jedi Knight

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

mqsiman wrote:
lancelotlinc wrote:
smdavies99 wrote:
lancelotlinc wrote:


Whomever installed your IIB should be kept far away from any of your other applications as their depth of knowledge is questionable.


Should it be

'Whoever CONFIGURED your broker should be....'

configuring the broker with the right username etc is what's wrong. AFAIK, they don't need to reinstall


That depends. Often the file folder ownership for files is also goofed up when this happens.


Like I said in my first post, we're all new to Broker/IIB development. Could running the broker as mqm be causing my error though?


No telling what else is wrong, since the very basic concepts were not followed during the install.
_________________
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
smdavies99
PostPosted: Fri Oct 04, 2013 10:05 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.

lancelotlinc wrote:

No telling what else is wrong, since the very basic concepts were not followed during the install.


I beg to differ. I did an install of IB9 onto a CentOS 6.4 system earlier today.
Configuring the broker using the mqm user ID didn't work.

Changing the use to another one who is a member of the mqbrkrs and mqm groups worked.

It was nothing to do with the installation. On Linux this is done using RPM under the covers so unless you mess up the file/directory ownerships post install they are correct.
_________________
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
mqsiman
PostPosted: Fri Oct 04, 2013 12:03 pm    Post subject: Reply with quote

Novice

Joined: 01 Oct 2013
Posts: 12

We noticed one more thing.

Every time we run mqsicvp DEVBROKER -n MDMDB

the following is logged to the /var/log/messages file

Oct 4 14:58:44 myserverhostname IIB[27439]: IBM Integration Bus v9000 (DEVBROKER) [Thread 27439] (Msg 1/1) BIP2801E: Unable to load implementation file '/opt/ibm/IE02/2.0.1/lib/libodbcinterface.so', rc=/opt/ibm/IE02/2.0.1/lib/libodbcinterface.so: wrong ELF class: ELFCLASS32.
Back to top
View user's profile Send private message
fjb_saper
PostPosted: Fri Oct 04, 2013 12:15 pm    Post subject: Reply with quote

Grand High Poobah

Joined: 18 Nov 2003
Posts: 20729
Location: LI,NY

mqsiman wrote:
We noticed one more thing.

Every time we run mqsicvp DEVBROKER -n MDMDB

the following is logged to the /var/log/messages file

Oct 4 14:58:44 myserverhostname IIB[27439]: IBM Integration Bus v9000 (DEVBROKER) [Thread 27439] (Msg 1/1) BIP2801E: Unable to load implementation file '/opt/ibm/IE02/2.0.1/lib/libodbcinterface.so', rc=/opt/ibm/IE02/2.0.1/lib/libodbcinterface.so: wrong ELF class: ELFCLASS32.
Wrong ELF class means that you are trying to load a 32 bit library into a 64 bit process, or vice versa.
Something might be wrong with your library path (LD_LIBRARY_PATH?).
_________________
MQ & Broker admin
Back to top
View user's profile Send private message Send e-mail
mqsiman
PostPosted: Fri Oct 04, 2013 2:50 pm    Post subject: Reply with quote

Novice

Joined: 01 Oct 2013
Posts: 12

fjb_saper wrote:
mqsiman wrote:
We noticed one more thing.

Every time we run mqsicvp DEVBROKER -n MDMDB

the following is logged to the /var/log/messages file

Oct 4 14:58:44 myserverhostname IIB[27439]: IBM Integration Bus v9000 (DEVBROKER) [Thread 27439] (Msg 1/1) BIP2801E: Unable to load implementation file '/opt/ibm/IE02/2.0.1/lib/libodbcinterface.so', rc=/opt/ibm/IE02/2.0.1/lib/libodbcinterface.so: wrong ELF class: ELFCLASS32.
Wrong ELF class means that you are trying to load a 32 bit library into a 64 bit process, or vice versa.
Something might be wrong with your library path (LD_LIBRARY_PATH?).


This may be happening because we installed the Linux x_86_64 version of IIB9 but the x_86 version of IIB9 ODBC Database Extender. However there is no download for Linux x_86_64 IIB9 Database Extender on the IBM site.
Back to top
View user's profile Send private message
smdavies99
PostPosted: Sat Oct 05, 2013 1:53 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.

Did you install a downloaded version of IE02 OR the one that comes packaged inside the Broker Runtime 64bit kit?

inside the
Code:

integrationbus.amd64_linux_2.rt.tar/integrationbus_runtime1/

directory I see a directory labelled IE02

This contains
Code:

ie02.pdf            67,510 bytes
install-ie02.bin   70,833,416 bytes

_________________
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
mqsiman
PostPosted: Mon Oct 07, 2013 7:17 am    Post subject: Reply with quote

Novice

Joined: 01 Oct 2013
Posts: 12

smdavies99 wrote:
Did you install a downloaded version of IE02 OR the one that comes packaged inside the Broker Runtime 64bit kit?

inside the
Code:

integrationbus.amd64_linux_2.rt.tar/integrationbus_runtime1/

directory I see a directory labelled IE02

This contains
Code:

ie02.pdf            67,510 bytes
install-ie02.bin   70,833,416 bytes


I downloaded IE02 separately from IBM. After your post, we looked around and found the 64 bit installler on the box, then uninstalled the 32 bit and isntalled the 64 bit. The issue is now resolved. Thank you everyone for your help. Hopefully someone else will benefit from this thread as well.
Back to top
View user's profile Send private message
deecee
PostPosted: Thu Dec 17, 2015 9:02 am    Post subject: Reply with quote

Acolyte

Joined: 11 Sep 2014
Posts: 51

Hello,

I am facing the same issue currently.
Was this problem rectified? If so, could you please tell me how it was.
Back to top
View user's profile Send private message
Vitor
PostPosted: Thu Dec 17, 2015 9:37 am    Post subject: Reply with quote

Grand High Poobah

Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA

deecee wrote:
Was this problem rectified? If so, could you please tell me how it was.


mqsiman wrote:
I downloaded IE02 separately from IBM. After your post, we looked around and found the 64 bit installler on the box, then uninstalled the 32 bit and isntalled the 64 bit



_________________
Honesty is the best policy.
Insanity is the best defence.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Goto page Previous  1, 2 Page 2 of 2

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Can't create ODBC datasource on new Integration Bus 9 server
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.