MYSQL ODBC install on RedHat Linux

Reply
Helper
Posts: 76
Registered: ‎05-16-2011

MYSQL ODBC install on RedHat Linux

We are getting a little frustrated here...we have not had much success in installing  Mysql ODBC drivers (5.18) for the community version of MYSQL 5.1 on RedHat.

Seems to be a dependency problem of some kind, but if anyobe has experience please reply:

rpm -iv mysql-connector-odbc-3.51.28-1.rhel5.i386.rpm

error: Failed dependencies:

        libodbcinst.so.1 is needed by mysql-connector-odbc-3.51.28-1.rhel5.i386

Trusted Expert
Posts: 810
Registered: ‎02-10-2006

Re: MYSQL ODBC install on RedHat Linux

Are you planning on using this for MD or as a warehouse?
Helper
Posts: 76
Registered: ‎05-16-2011

Re: MYSQL ODBC install on RedHat Linux

the RH server will host the MSTR IS and the MYSQL MD.

So DSNs:
1. poitining to local MD
2. pointing to remote (MYSQL) WH
Trusted Expert
Posts: 810
Registered: ‎02-10-2006

Re: MYSQL ODBC install on RedHat Linux

Make sure you are using MicroStrategy 9.2.1 otherwise you will run into this known issue: TN35634: The Delivery and Subscription managers do not appear in MicroStrategy Desktop 9.0.x when the MicroStrategy Intelligence Server 9.0.x is on Linux 5.5 and the metadata is hosted on MySQL

As for the issue, you need to install the libodbcinst libraries. This is included with the unixODBC driver manager package.
Helper
Posts: 76
Registered: ‎05-16-2011

Re: MYSQL ODBC install on RedHat Linux


yes our linux person did yum install unixodbc.   but ldd on this one does not work:
# ls /usr/lib/libodbcinst.1
/usr/lib/libodbcinst.1
# ldd /usr/lib/libodbcinst.1
ldd: /usr/lib/libodbcinst.1: No such file or directory

what gives here? should not ldd work?




A little more info:
- > .cn -d mstr_rep -u xxxx -p xxxxxx
Connect failed.
Error type: Odbc error. Odbc operation attempted: SQLDriverConnect. Specified driver could not be loaded


Snippet from odbc.init
- > .cn -d mstr_rep -u root -p j3diKnight
Connect failed.
Error type: Odbc error. Odbc operation attempted: SQLDriverConnect. Specified driver could not be loaded
Driver=/usr/lib/libmyodbc5.so
Description=MySQL ODBC 5.1 Driver
SERVER=localhost
PORT=3306
USER=xxx
Password=yyyyy
DATABASE=mstr_repository
OPTION=3
SOCKET=
DriverUnicodeType=1

some ldd love:
# ldd /usr/lib/libmyodbc5.so
        linux-gate.so.1 =>  (0x004bd000)
        libdl.so.2 => /lib/libdl.so.2 (0x00a02000)
        libcrypt.so.1 => /lib/libcrypt.so.1 (0x00ce0000)
        libnsl.so.1 => /lib/libnsl.so.1 (0x00900000)
        libm.so.6 => /lib/libm.so.6 (0x00e32000)
        libpthread.so.0 => /lib/libpthread.so.0 (0x002b5000)
        libodbcinst.so.1 => not found
        libc.so.6 => /lib/libc.so.6 (0x00110000)
        /lib/ld-linux.so.2 (0x00ad1000)
libfreebl3.so => /usr/lib/libfreebl3.so (0x00a42000) 
Trusted Expert
Posts: 810
Registered: ‎02-10-2006

Re: MYSQL ODBC install on RedHat Linux

What is the output of "rpm -qi unixODBC"? Have you talked to your sysadmin? They should be able to help you with verifying the libraries.
Helper
Posts: 76
Registered: ‎05-16-2011

Re: MYSQL ODBC install on RedHat Linux

# rpm -qi unixODBC
Name        : unixODBC                     Relocations: (not relocatable)
Version     : 2.2.14                            Vendor: Red Hat, Inc.
Release     : 11.el6                        Build Date: Tue 04 May 2010 01:05:25 PM EDT
Install Date: Tue 19 Jul 2011 12:40:19 PM EDT      Build Host: x86-005.build.bos.redhat.com
Group       : System Environment/Libraries   Source RPM: unixODBC-2.2.14-11.el6.src.rpm
Size        : 1197632                          License: GPLv2+ and LGPLv2+
Signature   : RSA/8, Mon 16 Aug 2010 04:15:12 PM EDT, Key ID 199e2f91fd431d51
Packager    : Red Hat, Inc. <http://bugzilla.redhat.com/bugzilla>
URL         : http://www.unixODBC.org/
Summary     : A complete ODBC driver manager for Linux
Description :
Install unixODBC if you want to access databases through ODBC.
You will also need the mysql-connector-odbc package if you want to access
a MySQL database, and/or the postgresql-odbc package for PostgreSQL.
My unix admin is also at a loss, having installed/unistalled unixodbc, creating soft links etc. etc.

# rpm -qi unixODBC
Name        : unixODBC                     Relocations: (not relocatable)
Version     : 2.2.14                            Vendor: Red Hat, Inc.
Release     : 11.el6                        Build Date: Tue 04 May 2010 01:05:25 PM EDT
Install Date: Tue 19 Jul 2011 12:40:19 PM EDT      Build Host: x86-005.build.bos.redhat.com
Group       : System Environment/Libraries   Source RPM: unixODBC-2.2.14-11.el6.src.rpm
Size        : 1197632                          License: GPLv2+ and LGPLv2+
Signature   : RSA/8, Mon 16 Aug 2010 04:15:12 PM EDT, Key ID 199e2f91fd431d51
Packager    : Red Hat, Inc. <http://bugzilla.redhat.com/bugzilla>
URL         : http://www.unixODBC.org/
Summary     : A complete ODBC driver manager for Linux
Description :
Install unixODBC if you want to access databases through ODBC.
You will also need the mysql-connector-odbc package if you want to access
a MySQL database, and/or the postgresql-odbc package for PostgreSQL.
Trusted Expert
Posts: 810
Registered: ‎02-10-2006

Re: MYSQL ODBC install on RedHat Linux

What is the output of: ls -al /usr/lib/libodbcinst*

Did you log on / off after the install? This could just be a path issue.

Helper
Posts: 76
Registered: ‎05-16-2011

Re: MYSQL ODBC install on RedHat Linux

@Aaaron- hang on a bit.  Our admin is now going to re-install everything, and see if it works. Yes it could be a path issue since I can see the  libodbcinst.so.1 after the admin got it installed somehow. but we have tried symbolic links and other stuff but no luck.

we even tried this (https://bugzilla.redhat.com/show_bug.cgi?id=498311

ln -s libodbcinst.so.2 libodbcinst.so.1

but no joy so far.

let me see how it goes after the install

GR