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 2
make[1]: Leaving directory
`/var/local/repository/src/mysql-5.1.21-beta/sql'
make: *** [all-recursive] Error 1
--- Vladimir Shebordaev
<[EMAIL PROTECTED]> wrote:
> 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
>
=== message truncated ===
____________________________________________________________________________________
Pinpoint customers who are looking for what you sell.
http://searchmarketing.yahoo.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
