mysqlclient15 not compatible with mysql-odbc from RHEL5

[Yuriy]

When running isql -v easyroute
I get the following
error: "isql: relocation error: /usr/lib64/libmyodbc3_r.so: symbol strmov, version libmysqlclient_15 not defined in file libmysqlclient_r.so.15 with link time reference"

rpm -qa \*mysql\* php\* \*odbc\*
mysql55-libs-5.5.27-2.ius.el5
mysqlclient15-5.0.92-2.ius.el5
mysql55-5.5.27-2.ius.el5
mysql55-server-5.5.27-2.ius.el5
mysql55-devel-5.5.27-2.ius.el5
mysql-connector-odbc-3.51.26r1127-2.el

CentOS 5.8

[Jeffrey Ness (jeffrey-ness)]

Hello Yuriy,

I'm having a look in to your issue, so far I've not been able to reproduce:

# cat /etc/redhat-release
CentOS release 5.6 (Final)

# rpm -qa | grep mysql
mysql55-libs-5.5.27-2.ius.el5
mysqlclient15-5.0.92-2.ius.el5
mysql-connector-odbc-3.51.26r1127-2.el5
mysql55-5.5.27-2.ius.el5
mysql55-server-5.5.27-2.ius.el5

# isql -v easyroute
[IM002][unixODBC][Driver Manager]Data source name not found, and no default driver specified
[ISQL]ERROR: Could not SQLConnect

[Jeffrey Ness (jeffrey-ness)]

I've updated to latest 5.8 release, and have still been unable to reproduce:

# cat /etc/redhat-release
CentOS release 5.8 (Final)

# rpm -qa | grep mysql
mysql55-libs-5.5.27-2.ius.el5
mysqlclient15-5.0.92-2.ius.el5
mysql-connector-odbc-3.51.26r1127-2.el5
mysql55-5.5.27-2.ius.el5
mysql55-server-5.5.27-2.ius.el5

[# isql -v easyroute
[IM002][unixODBC][Driver Manager]Data source name not found, and no default driver specified
[ISQL]ERROR: Could not SQLConnect

[Yuriy (nasida)]

Please configure some odbc-DSN in /etc/odbc.ini

For exmple,

[easyroute]
Driver = MySQL
Description = MyODBC Driver DSN
SERVER = localhost
PORT = 3306
USER = root
Password = XXXX
Database = databasename
OPTION = 4194307

[Jeffrey Ness (jeffrey-ness)]

If I recall correctly last time I reproduced the issue I had to setup a ODBC connection,
I'll test that now.

[Yuriy (nasida)]

You have fixed this issue earlier but for mysqlclient16-5.1.61-1.ius under EL6 x86_64 only

https://bugs.launchpad.net/ius/+bug/942524

[Jeffrey Ness (jeffrey-ness)]

Yuriy,

I've been able to successfully configure my unixODBC to connect:

# cat /etc/odbc.ini
[easyroute]
Driver = MySQL
Description = MyODBC Driver DSN
SERVER = localhost
PORT = 3306
USER = root
Database = temp
OPTION = 4194307

# cat /etc/odbcinst.ini
# Example driver definitinions
#
#

# Driver from the MyODBC package
# Setup from the unixODBC package
[MySQL]
Description = ODBC for MySQL
Driver = /usr/lib64/libmyodbc3.so
Setup = /usr/lib64/libodbcmyS.so
FileUsage = 1

=====

# isql -v easyroute
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+
SQL>

=====

# rpm -qf /usr/lib64/libmyodbc3.so
mysql-connector-odbc-3.51.26r1127-1.el5.x86_64

# rpm -qf /usr/lib64/libodbcmyS.so
unixODBC-2.2.11-7.1.x86_64

[Jeffrey Ness (jeffrey-ness)]

It looks like your ODBC connect is set using the *_r shared library,
however above I was using the non *_r and it worked.

Can you try making these changes?

[Yuriy (nasida)]

cat /etc/odbcinst.ini

[MySQL]
Description = ODBC for MySQL
Driver = /usr/lib64/libmyodbc3.so
Setup = /usr/lib64/libodbcmyS.so
FileUsage = 1

=====

rpm -qf /usr/lib64/libmyodbc3.so
mysql-connector-odbc-3.51.26r1127-2.el5

====

rpm -qf /usr/lib64/libodbcmyS.so
unixODBC-libs-2.2.11-10.el5

===

isql -v easyroute
isql: relocation error: /usr/lib64/libmyodbc3.so: symbol strmov, version libmysqlclient_15 not defined in file libmysqlclient.so.15 with link time reference

Um... Not sure what it can be.

[Yuriy (nasida)]

You have:
 unixODBC-2.2.11-7.1.x86_64
I have:
unixODBC-libs-2.2.11-10.el5

[Yuriy (nasida)]

Also the versions of mysql-connector-odbc is a bit different.

You have:
mysql-connector-odbc-3.51.26r1127-1.el5.x86_64

I have:
mysql-connector-odbc-3.51.26r1127-2.el5

[Jeffrey Ness (jeffrey-ness)]

I've updated to match your rpms:

# rpm -qa | grep mysql
mysql55-libs-5.5.27-2.ius.el5
mysqlclient15-5.0.92-2.ius.el5
mysql-connector-odbc-3.51.26r1127-2.el5
mysql55-5.5.27-2.ius.el5
mysql55-server-5.5.27-2.ius.el5

Using these exact versions I can reproduce it seems:

# isql -v easyroute
isql: relocation error: /usr/lib64/libmyodbc3_r.so: symbol strmov, version libmysqlclient_15 not defined in file libmysqlclient_r.so.15 with link time reference

# isql -v easyroute
isql: relocation error: /usr/lib64/libmyodbc3.so: symbol strmov, version libmysqlclient_15 not defined in file libmysqlclient.so.15 with link time reference

[Yuriy (nasida)]

Great! Can you please add the patch for mysqlclient15 as well ?

[Jeffrey Ness (jeffrey-ness)]

Hello Yuriy,

I've built a mysqlclient15 package adding in the strmov patch,
this package appears to resolve the issue you were seeing:

# rpm -qa mysqlclient15
mysqlclient15-5.0.92-3.ius.el5

# isql -v easyroute
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+
SQL>

---

I've added this package to our testing-candidate tag, you should see this package from the IUS Testing channel here tomorrow.

When you get a chance it would be great if you could test out this package.

Jeffrey-

[Yuriy (nasida)]

It works! Many thanks Jeffrey!

[Jeffrey Ness (jeffrey-ness)]

Yuriy,

Thank you very much for validating!

I'll be getting this added to IUS stable soon.

Jeffrey-