mysql-connector-odbc-5.1.5 32-bit for CentOS6

Issues related to applications and software problems
infdata
Posts: 21
Joined: 2011/02/10 10:35:16
Contact:

mysql-connector-odbc-5.1.5 32-bit for CentOS6

Post by infdata » 2011/09/25 20:26:15

Hi everybody,

I cannot find 32-bit mySQL ODBC connector.
Can somebody help? The only connector I can list with yum list is:
[code]yum list mysql*odbc*[/code]

result:
[code]mysql-connector-odbc.x86_64 5.1.5r1144-7.el6 @anaconda-CentOS-201106060106.x86_64/6.0[/code]

Any help appreciated.

Jani

infdata
Posts: 21
Joined: 2011/02/10 10:35:16
Contact:

Re: mysql-connector-odbc-5.1.5 32-bit for CentOS6

Post by infdata » 2011/09/25 20:29:00

I use 64-bit Centos 6.0 but I still need 32-bit ODBC driver. System info is:

Basic system information.
[code]
== BEGIN uname -rmi ==
2.6.32-71.el6.x86_64 x86_64 x86_64
== END uname -rmi ==

== BEGIN rpm -qa \*-release\* ==
centos-release-6-0.el6.centos.5.x86_64
== END rpm -qa \*-release\* ==

== BEGIN cat /etc/redhat-release ==
CentOS Linux release 6.0 (Final)
== END cat /etc/redhat-release ==

== BEGIN getenforce ==
Permissive
== END getenforce ==

== BEGIN free -m ==
total used free shared buffers cached
Mem: 3016 2801 214 0 45 1613
-/+ buffers/cache: 1142 1873
Swap: 31999 0 31999
== END free -m ==

[/code]

freethinker
Posts: 29
Joined: 2010/03/24 16:24:15
Location: St. Louis, MO
Contact:

Re: mysql-connector-odbc-5.1.5 32-bit for CentOS6

Post by freethinker » 2011/09/26 16:19:04

I run into this sort of thing all the time.
My recommendation is:

1) boot a CentOS6/SL6 32-bit live-cd (or use a running EL6, 32-bit box)
2) install yum-utils,
3) use "yumdownloader --resolve mysql-connector-odbc" to pull the files.
4) port the files to your 64-bit box
5) "yum localinstall mysql-connector-odbc" (etc) from #3
6) profit

freethinker
Posts: 29
Joined: 2010/03/24 16:24:15
Location: St. Louis, MO
Contact:

Re: mysql-connector-odbc-5.1.5 32-bit for CentOS6

Post by freethinker » 2011/09/26 16:27:37

Good luck and do not forget to point to the 32-bit libraries (/usr/lib/libmyodbc3.so)

infdata
Posts: 21
Joined: 2011/02/10 10:35:16
Contact:

Re: mysql-connector-odbc-5.1.5 32-bit for CentOS6

Post by infdata » 2011/09/26 19:50:55

Thanx for the idea. (with mySQL ODBC 5.1 it is actualy /usr/lib/libmyodbc5.so)

But isn't yum on 64-bit system suppose to show 32-bit packages too?

There has to be an easier way :) (lazy me :)

freethinker
Posts: 29
Joined: 2010/03/24 16:24:15
Location: St. Louis, MO
Contact:

Re: mysql-connector-odbc-5.1.5 32-bit for CentOS6

Post by freethinker » 2011/09/26 19:59:58

Not all of the packages in EL6 have a 32-bit repo available by default so I have to do it this way frequently.
I just did it on a DEV box this morning in fact.

Maybe there is another repo you can enable but I have not run across it and this works for me.
In the amount of time we both typed these replies you could have probably pulled the packages you needed. ;-)

infdata
Posts: 21
Joined: 2011/02/10 10:35:16
Contact:

Re: mysql-connector-odbc-5.1.5 32-bit for CentOS6

Post by infdata » 2011/09/26 20:05:27

:) haha you are probably right.
I go hunt for CentOS live CD.

pschaff
Retired Moderator
Posts: 18276
Joined: 2006/12/13 20:15:34
Location: Tidewater, Virginia, North America
Contact:

mysql-connector-odbc-5.1.5 32-bit for CentOS6

Post by pschaff » 2011/09/26 20:06:27

[quote]
infdata wrote:
Thanx for the idea. (with mySQL ODBC 5.1 it is actualy /usr/lib/libmyodbc5.so)

But istn't yum on 64-bit system suppose to show 32-bit packages too?[/quote]

Only if they exist. On 64-bit SL6 (similar for CentOS-6):[code]
[root@poq1 ~]# uname -i
x86_64
[root@poq1 ~]# yum whatprovides /usr/lib/libmyodbc5.so
Loaded plugins: priorities, refresh-packagekit
6587 packages excluded due to repository priority protections
No Matches found
[root@poq1 ~]# yum whatprovides /usr/lib64/libmyodbc5.so
Loaded plugins: priorities, refresh-packagekit
6587 packages excluded due to repository priority protections
mysql-connector-odbc-5.1.5r1144-7.el6.x86_64 : ODBC driver for MySQL
Repo : sl6x
Matched from:
Filename : /usr/lib64/libmyodbc5.so[/code]

On 32-bit:[code]
[root@sl6vm ~]# uname -i
i386
[root@sl6vm ~]# yum whatprovides /usr/lib/libmyodbc5.so
Loaded plugins: priorities, refresh-packagekit
5033 packages excluded due to repository priority protections
mysql-connector-odbc-5.1.5r1144-7.el6.i686 : ODBC driver for MySQL
Repo : sl6x
Matched from:
Filename : /usr/lib/libmyodbc5.so[/code]

[quote]
There has to be an easier way :) (lazy me :)[/quote]
Don't use 32-bit packages on your 64-bit system, or be prepared to do more work. EL6 now defaults to "pure" x86_64 rather than multi-arch.

P.S. Not sure what good the LiveCD will do you. Perhaps the i386 install media.

infdata
Posts: 21
Joined: 2011/02/10 10:35:16
Contact:

Re: mysql-connector-odbc-5.1.5 32-bit for CentOS6

Post by infdata » 2011/09/26 20:35:53

Thank you Phil.

[quote]Don't use 32-bit packages on your 64-bit system, or be prepared to do more work. EL6 now defaults to "pure" x86_64 rather than multi-arch.[/quote]

But what if the SW I use is 64-bit AND requires 32-bit ODBC driver?

This means I am in a dead corner - so I understand, you propose in order to put everything together I should use 32-bit CentOS?

Anyway I found the rpm at [url=http://mirror.centos.org/centos/6/os/i386/Packages/mysql-connector-odbc-5.1.5r1144-7.el6.i686.rpm]centos mirror[/url].

Not sure now what to do.

I really understood that 32-bit and 64-bit SW should not collide on 64-bit system (RHEL based) since it is a multilib system. Thus using double libraries: /usr/lib/ & /usr/lib64/ etc.

freethinker
Posts: 29
Joined: 2010/03/24 16:24:15
Location: St. Louis, MO
Contact:

Re: mysql-connector-odbc-5.1.5 32-bit for CentOS6

Post by freethinker » 2011/09/26 20:44:51

Just download the rpm to your system and then do "yum localinstall ${rpm}"

Post Reply