MYSQL ODBC install on RedHat Linux
Posted:
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

 
Posted:
2 years 9 months ago
Are you planning on using this for MD or as a warehouse?

            
 
Posted:
2 years 9 months ago
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

            
 
Posted:
2 years 9 months ago
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.

            
 
Posted:
2 years 9 months ago

yes our linux person did yum install unixodbc.   but ldd on this one does not work:
[root@st-microstrat MicroStrategy]# ls /usr/lib/libodbcinst.1
/usr/lib/libodbcinst.1
[root@st-microstrat MicroStrategy]# 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. [IM003:0: on SQLHANDLE] [DataDirect][ODBC lib] 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. [IM003:0: on SQLHANDLE] [DataDirect][ODBC lib] Specified driver could not be loaded
[mstr_rep]
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:
[root@st-microstrat MicroStrategy]# 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) 

            
 
Posted:
2 years 9 months ago
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.

            
 
Posted:
2 years 9 months ago
[root@st-microstrat MicroStrategy]# 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.

[root@st-microstrat MicroStrategy]# 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.

            
 
Posted:
2 years 9 months ago

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.


            
 
Posted:
2 years 9 months ago

@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