Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.0.0, 5.5.28a
-
None
-
# cat /etc/issue; uname -m
CentOS release 5.8 (Final)
Kernel \r on an \m
x86_64
System: Linux a10-52-75-225.qa.plesk.ru 2.6.18-028stab099.3 #1 SMP Wed Mar 7 15:20:22 MSK 2012 x86_64 x86_64 x86_64 GNU/Linux
Compilation info (call): CC='/usr/bin/gcc' CFLAGS='-Wall -Wall -O3 -g -static-libgcc -fno-omit-frame-pointer -fno-strict-aliasing -DDBUG_OFF -DMY_PTHREAD_FASTMUTEX=1' CXX='/usr/bin/c++' CXXFLAGS='-Wall -Wall -Wno-unused-parameter -fno-exceptions -fno-rtti -O3 -g -static-libgcc -fno-omit-frame-pointer -fno-strict-aliasing -DDBUG_OFF -DMY_PTHREAD_FASTMUTEX=1' LDFLAGS='' ASFLAGS=''
Compilation info (used): CC='/usr/bin/gcc' CFLAGS='-Wall -Wall -O3 -g -static-libgcc -fno-omit-frame-pointer -fno-strict-aliasing -DDBUG_OFF -DMY_PTHREAD_FASTMUTEX=1' CXX='/usr/bin/c++' CXXFLAGS='-Wall -Wall -Wno-unused-parameter -fno-exceptions -fno-rtti -O3 -g -static-libgcc -fno-omit-frame-pointer -fno-strict-aliasing -DDBUG_OFF -DMY_PTHREAD_FASTMUTEX=1' LDFLAGS='' ASFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 11 May 23 2012 /lib/libc.so.6 -> libc-2.5.so
-rwxr-xr-x 1 root root 1686312 Apr 20 2012 /lib/libc-2.5.so
# cat /etc/issue; uname -m CentOS release 5.8 (Final) Kernel \r on an \m x86_64 System: Linux a10-52-75-225.qa.plesk.ru 2.6.18-028stab099.3 #1 SMP Wed Mar 7 15:20:22 MSK 2012 x86_64 x86_64 x86_64 GNU/Linux Compilation info (call): CC='/usr/bin/gcc' CFLAGS='-Wall -Wall -O3 -g -static-libgcc -fno-omit-frame-pointer -fno-strict-aliasing -DDBUG_OFF -DMY_PTHREAD_FASTMUTEX=1' CXX='/usr/bin/c++' CXXFLAGS='-Wall -Wall -Wno-unused-parameter -fno-exceptions -fno-rtti -O3 -g -static-libgcc -fno-omit-frame-pointer -fno-strict-aliasing -DDBUG_OFF -DMY_PTHREAD_FASTMUTEX=1' LDFLAGS='' ASFLAGS='' Compilation info (used): CC='/usr/bin/gcc' CFLAGS='-Wall -Wall -O3 -g -static-libgcc -fno-omit-frame-pointer -fno-strict-aliasing -DDBUG_OFF -DMY_PTHREAD_FASTMUTEX=1' CXX='/usr/bin/c++' CXXFLAGS='-Wall -Wall -Wno-unused-parameter -fno-exceptions -fno-rtti -O3 -g -static-libgcc -fno-omit-frame-pointer -fno-strict-aliasing -DDBUG_OFF -DMY_PTHREAD_FASTMUTEX=1' LDFLAGS='' ASFLAGS='' LIBC: lrwxrwxrwx 1 root root 11 May 23 2012 /lib/libc.so.6 -> libc-2.5.so -rwxr-xr-x 1 root root 1686312 Apr 20 2012 /lib/libc-2.5.so
Description
libmyodbc on this system is not usable with MariaDB MySQL compatibility layer (MariaDB-compat) due to relocation error. This can be demonstrated with isql or iusql utilities from unixODBC package (unixODBC64 will do as well):
[root@a10-52-75-225 ~]# echo "" | isql -b apsc
|
isql: relocation error: /usr/lib64/libmyodbc3.so: symbol strmov, version libmysqlclient_15 not defined in file libmysqlclient.so.15 with link time reference
|
[root@a10-52-75-225 ~]# strings /usr/lib64/libmyodbc3.so | grep strmov
|
strmov
|
[root@a10-52-75-225 ~]# strings /usr/lib64/libmysqlclient.so.15 | grep strmov
|
[root@a10-52-75-225 ~]# rpm -qf /usr/lib64/libmysqlclient.so.15
|
MariaDB-compat-10.0.0-1
|
[root@a10-52-75-225 ~]# rpm -qf /usr/lib64/libmyodbc3.so
|
mysql-connector-odbc-3.51.26r1127-2.el5
|
This assumes following sample odbc configuration:
[root@a10-52-75-225 ~]# cat /etc/odbc.ini
|
[apsc]
|
Description = Sample MySQL database (DSN)
|
Driver = MySQL
|
SERVER = localhost
|
USER = apsc
|
PASSWORD = HDA0edvGpCvs
|
PORT = 3306
|
DATABASE = apsc
|
 |
[root@a10-52-75-225 ~]# tail -n 9 /etc/odbcinst.ini
|
[MySQL]
|
Description = Sample MySQL driver
|
Driver = /usr/lib64/libmyodbc3.so
|
Setup =
|
FileUsage = 1
|
Driver64 = /usr/lib64/libmyodbc3.so
|
Setup64 =
|
UsageCount = 1
|
This was done on CentOS 5 x64 machine with MariaDB 10.0, but same issues were observed with MariaDB 5.5. Also this most probably happens on other architectures and RedHat el5, maybe on RedHat/CentOS 6 as well.