无法在RHEL6.5上安装lib_mysqludf_sys

Question

我在RHEL6.5上安装lib_mysqludf_sys时遇到问题

MySQL版本- 5.6.23

获取以下错误：

编译MySQL用户定义项

gcc -Wall -I/usr/include/mysql -I. -shared lib_mysqludf_sys.c -o /usr/lib/lib_mysqludf_sys.so
/usr/bin/ld: /tmp/cclkfAbr.o: relocation R_X86_64_32 against `.rodata' can not be used when making a shared object; recompile with -fPIC
/tmp/cclkfAbr.o: could not read symbols: Bad value
collect2: ld returned 1 exit status
make: *** [install] Error 1
ERROR: You need libmysqlclient development software installed
to be able to compile this UDF, on Debian/Ubuntu just run:
apt-get install libmysqlclient15-dev

如果有其他方式在RedHat 6.5上安装lib_mysqludf_sys，请告诉我

Answer 1

这是一个古老的问题，但张贴给那些仍在努力解决这个问题的人们。对于RedHat/CentOS6.10，要创建lib_mysqludp_sys.so (https://github.com/mysqludf/lib_mysqludf_sys/)，请使用以下Makefile (OP缺少Makefile中的-fPIC )：

   LIBDIR=/usr/lib64/mysql/plugin

   install:
           gcc -Wall -I/usr/include/mysql -I. -shared lib_mysqludf_sys.c -fPIC -o 
   $(LIBDIR)/lib_mysqludf_sys.so

   # above line is on one line

在安装了以下命令的RedHat 6.10上运行5.5版的MySQL : mysql55w、libmysqlclient16、mysql55w-devel、mysql55w-libs和mysql55w-server