Re: Question related to MySQL 5.1.21 and enabling pbxt engine, please

Mariella,

try to disable building static binaries, please don't use "--enable-static" configure option, you'd better use "--disable-static" instead.

In the hope it helps.

Regards,
Vladimir

Mariella Petrini пишет:
> 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 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 2
> make[1]: Leaving directory
> `/var/local/repository/src/mysql-5.1.21-beta/sql'
> make: *** [all-recursive] Error 1
>
>
>
> Could you please help ?
>
> Thanks in advance for your help,
>
> Mariella
>
>
>
> ____________________________________________________________________________________
> Looking for a deal? Find great prices on flights and hotels with Yahoo! FareChase.
> http://farechase.yahoo.com/
>

-- 
MySQL Internals Mailing List
For list archives: 
http://lists.mysql.com/internals
To unsubscribe:    
http://lists.mysql.com/internals?unsub=lists@pantek.com