Question related to MySQL 5.1.21 and enabling pbxt engine, please
Hi All, I would like to be able to use MySQL 5.1.21 with the PBXT engine. I have compiled MySQL 5.1.21 64 bits on Debian 4.0 with linux 2.6 with the options specified in the README that comes with the PBXT source code. I have copied the binary of the pbxt library into the lib/mysql directory When I tried to execuute the sql command install plugin pbxt soname 'llibpbxt.so'; I would get an error saying that I should have compiled with HAVE_DLOPEN ERROR 1289 (HY000): The 'plugin' feature is disabled; you need MySQL built with 'HAVE_DLOPEN' to have it working So I have re-compiled mysql server including -DHAVE_DLOPEN (e.g. ./configure CC=gcc CFLAGS=-DBIG_JOINS=1 -DHAVE_DLOPEN -O2 CXX=g++ CXXFLAGS=-DBIG_JOINS=1 -DHAVE_DLOPEN -felide-constructors -fno-rtti -O2 --prefix=/usr/local/mysql-5.1.21 --localstatedir=/usr/local/mysql-5.1.21/data --libexecdir=/usr/local/mysql-5.1.21/bin --datadir=/usr/local/mysql-5.1.21/data -with-comment=Debian x86_64 --with-server-suffix=Debian x86_64 --enable-shared --enable-static --enable-thread-safe-client --enable-assembler --enable-local-infile --with-big-tables --with-raid --with-mysqld-user=mysql --with-libwrap --with-mysqld-ldflags=-all-static --with-vio --with-bench --with-readline --with-extra-charsets=all --with-innodb --with-isam --with-archive-storage-engine --with-csv-storage-engine --with-federated-storage-engine --with-embedded-privilege-control --with-zlib-dir=bundled --with-ssl=bundled --with-partition --with-extra-charsets=complex --with-plugins=max-no-ndb --with-embedded-server) but unfortunately I get an error during the compilation mysqld.o: In function `set_user(char const*, passwd*)': mysqld.cc:(.text+0x406f): warning: Using 'initgroups' in statically linked applications requires at runtime the shared libraries from the glibc version used for linking mysqld.o: In function `main': mysqld.cc:(.text+0x558d): warning: Using 'getpwnam' in statically linked applications requires at runtime the shared libraries from the glibc version used for linking mysqld.cc:(.text+0x5949): warning: Using 'getpwuid' in statically linked applications requires at runtime the shared libraries from the glibc version used for linking ../mysys/libmysys.a(mf_pack.o): In function `unpack_dirname': mf_pack.c:(.text+0x485): warning: Using 'endpwent' in statically linked applications requires at runtime the shared libraries from the glibc version used for linking hostname.o: In function `ip_to_hostname(in_addr*, unsigned int*)': hostname.cc:(.text+0x391): warning: Using 'gethostbyaddr' in statically linked applications requires at runtime the shared libraries from the glibc version used for linking mysqld.o: In function `mysqld_get_one_option': mysqld.cc:(.text+0x5b19): warning: Using 'gethostbyname' in statically linked applications requires at runtime the shared libraries from the glibc version used for linking ../mysys/libmysys.a(my_gethostbyname.o): In function `my_gethostbyname_r': my_gethostbyname.c:(.text+0x10): warning: Using 'gethostbyname_r' in statically linked applications requires at runtime the shared libraries from the glibc version used for linking mysqld.o: In function `set_ports()': mysqld.cc:(.text+0x292d): warning: Using 'getservbyname' in statically linked applications requires at runtime the shared libraries from the glibc version used for linking sql_udf.o: In function `free_udf(st_udf_func*)': sql_udf.cc:(.text+0x124): undefined reference to `dlclose' sql_udf.o: In function `init_syms(st_udf_func*, char*)': sql_udf.cc:(.text+0x151): undefined reference to `dlsym' sql_udf.cc:(.text+0x18e): undefined reference to `dlsym' sql_udf.cc:(.text+0x1ae): undefined reference to `dlsym' sql_udf.cc:(.text+0x1d1): undefined reference to `dlsym' sql_udf.cc:(.text+0x1ee): undefined reference to `dlsym' sql_udf.o: In function `udf_free()': sql_udf.cc:(.text+0x4a8): undefined reference to `dlclose' sql_udf.o: In function `udf_init()': sql_udf.cc:(.text+0x92a): undefined reference to `dlclose' sql_udf.cc:(.text+0x9e1): undefined reference to `dlopen' sql_udf.o: In function `mysql_drop_function(THD*, st_mysql_lex_string const*)': sql_udf.cc:(.text+0xc46): undefined reference to `dlclose' sql_udf.o: In function `mysql_create_function(THD*, st_udf_func*)': sql_udf.cc:(.text+0xe35): undefined reference to `dlclose' sql_udf.cc:(.text+0xe70): undefined reference to `dlopen' sql_plugin.o: In function `plugin_dl_del(st_mysql_lex_string const*)': sql_plugin.cc:(.text+0x2ae0): undefined reference to `dlclose' sql_plugin.o: In function `plugin_shutdown()': sql_plugin.cc:(.text+0x3032): undefined reference to `dlclose' sql_plugin.o: In function `plugin_dl_add(st_mysql_lex_string const*, int)': sql_plugin.cc:(.text+0x355c): undefined reference to `dlopen' sql_plugin.cc:(.text+0x357f): undefined reference to `dlsym' sql_plugin.cc:(.text+0x35b5): undefined reference to `dlclose' sql_plugin.cc:(.text+0x3660): undefined reference to `dlsym' sql_plugin.cc:(.text+0x3691): undefined reference
Re: Question related to MySQL 5.1.21 and enabling pbxt engine, please
Vladimir, I have tried to recompile MySQL 5.1.21 as you suggested, but unfortunately I got the same error. Is it possible that some other define needs to be set ? Thanks in advance for your help, Mariella ./configure CC=gcc CFLAGS=-DBIG_JOINS=1 -DHAVE_DLOPEN -O2 CXX=g++ CXXFLAGS=-DBIG_JOINS=1 -DHAVE_DLOPEN -felide-constructors -fno-rtti -O2 --prefix=/usr/local/mysql-5.1.21 --localstatedir=/usr/local/mysql-5.1.21/data --libexecdir=/usr/local/mysql-5.1.21/bin --datadir=/usr/local/mysql-5.1.21/data -with-comment=Debian x86_64 --with-server-suffix=Debian x86_64 --enable-shared --disable-static --enable-thread-safe-client --enable-assembler --enable-local-infile --with-big-tables --with-raid --with-mysqld-user=mysql --with-libwrap --with-mysqld-ldflags=-all-static --with-vio --with-bench --with-readline --with-extra-charsets=all --with-innodb --with-isam --with-archive-storage-engine --with-csv-storage-engine --with-federated-storage-engine --with-embedded-privilege-control --with-zlib-dir=bundled --with-ssl=bundled --with-partition --with-extra-charsets=complex --with-plugins=max-no-ndb --with-embedded-server mysqld.o: In function `set_user(char const*, passwd*)': mysqld.cc:(.text+0x406f): warning: Using 'initgroups' in statically linked applications requires at runtime the shared libraries from the glibc version used for linking mysqld.o: In function `main': mysqld.cc:(.text+0x558d): warning: Using 'getpwnam' in statically linked applications requires at runtime the shared libraries from the glibc version used for linking mysqld.cc:(.text+0x5949): warning: Using 'getpwuid' in statically linked applications requires at runtime the shared libraries from the glibc version used for linking ../mysys/libmysys.a(mf_pack.o): In function `unpack_dirname': mf_pack.c:(.text+0x485): warning: Using 'endpwent' in statically linked applications requires at runtime the shared libraries from the glibc version used for linking hostname.o: In function `ip_to_hostname(in_addr*, unsigned int*)': hostname.cc:(.text+0x391): warning: Using 'gethostbyaddr' in statically linked applications requires at runtime the shared libraries from the glibc version used for linking mysqld.o: In function `mysqld_get_one_option': mysqld.cc:(.text+0x5b19): warning: Using 'gethostbyname' in statically linked applications requires at runtime the shared libraries from the glibc version used for linking ../mysys/libmysys.a(my_gethostbyname.o): In function `my_gethostbyname_r': my_gethostbyname.c:(.text+0x10): warning: Using 'gethostbyname_r' in statically linked applications requires at runtime the shared libraries from the glibc version used for linking mysqld.o: In function `set_ports()': mysqld.cc:(.text+0x292d): warning: Using 'getservbyname' in statically linked applications requires at runtime the shared libraries from the glibc version used for linking sql_udf.o: In function `free_udf(st_udf_func*)': sql_udf.cc:(.text+0x124): undefined reference to `dlclose' sql_udf.o: In function `init_syms(st_udf_func*, char*)': sql_udf.cc:(.text+0x151): undefined reference to `dlsym' sql_udf.cc:(.text+0x18e): undefined reference to `dlsym' sql_udf.cc:(.text+0x1ae): undefined reference to `dlsym' sql_udf.cc:(.text+0x1d1): undefined reference to `dlsym' sql_udf.cc:(.text+0x1ee): undefined reference to `dlsym' sql_udf.o: In function `udf_free()': sql_udf.cc:(.text+0x4a8): undefined reference to `dlclose' sql_udf.o: In function `udf_init()': sql_udf.cc:(.text+0x92a): undefined reference to `dlclose' sql_udf.cc:(.text+0x9e1): undefined reference to `dlopen' sql_udf.o: In function `mysql_drop_function(THD*, st_mysql_lex_string const*)': sql_udf.cc:(.text+0xc46): undefined reference to `dlclose' sql_udf.o: In function `mysql_create_function(THD*, st_udf_func*)': sql_udf.cc:(.text+0xe35): undefined reference to `dlclose' sql_udf.cc:(.text+0xe70): undefined reference to `dlopen' sql_plugin.o: In function `plugin_dl_del(st_mysql_lex_string const*)': sql_plugin.cc:(.text+0x2ae0): undefined reference to `dlclose' sql_plugin.o: In function `plugin_shutdown()': sql_plugin.cc:(.text+0x3032): undefined reference to `dlclose' sql_plugin.o: In function `plugin_dl_add(st_mysql_lex_string const*, int)': sql_plugin.cc:(.text+0x355c): undefined reference to `dlopen' sql_plugin.cc:(.text+0x357f): undefined reference to `dlsym' sql_plugin.cc:(.text+0x35b5): undefined reference to `dlclose' sql_plugin.cc:(.text+0x3660): undefined reference to `dlsym' sql_plugin.cc:(.text+0x3691): undefined reference to `dlsym' sql_plugin.cc:(.text+0x3869): undefined reference to `dlclose' sql_plugin.cc:(.text+0x3916): undefined reference to `dlclose' sql_plugin.cc:(.text+0x3a3d): undefined reference to `dlclose' collect2: ld returned 1 exit status make[3]: *** [mysqld] Error 1 make[3]: Leaving directory `/var/local/repository/src/mysql-5.1.21-beta/sql' make[2]: *** [all-recursive] Error 1 make[2]: Leaving directory `/var/local/repository/src/mysql-5.1.21-beta/sql' make[1]: *** [all] Error