error compiling with the MD5 plugin

[Giuseppe Maxia]

Compiling Drizzle with MD5 plugins fails. (Rev 413 on Mac OSX 10.5)

This is my compilation script:

MYFLAGS="CFLAGS=-O3 CXXFLAGS=-O3"
./config/autorun.sh && \
    ./configure --disable-fail --prefix=$HOME/usr/local/drizzle --with-plugins=blackhole,md5 $MYFLAGS && \
    make && \
    make install

And this is the error I get:

g++ -W -Wall -Wextra -pedantic -Wundef -Wredundant-decls -Wno-long-long -Wno-strict-aliasing -fno-exceptions -ggdb3 -O3 -o .libs/drizzled sql_db.o sql_lex.o authentication.o sql_handler.o natural_join_column.o field_iterator.o item.o item_sum.o item_buff.o item_func.o item_cmpfunc.o item_strfunc.o item_timefunc.o thr_malloc.o item_create.o item_subselect.o item_row.o field.o strfunc.o key.o sql_class.o sql_list.o protocol.o sql_state.o lock.o sql_string.o drizzled.o sql_connect.o scheduler.o sql_parse.o set_var.o sql_yacc.o sql_base.o table.o sql_select.o sql_insert.o sql_error.o sql_locale.o sql_update.o sql_delete.o uniques.o log.o init.o derror.o unireg.o log_event.o rpl_record.o discover.o time.o opt_range.o opt_sum.o records.o filesort.o sql_table.o sql_rename.o sql_load.o mf_iocache.o field_conv.o sql_show.o sql_udf.o slave.o sql_repl.o rpl_filter.o rpl_tblmap.o rpl_utility.o rpl_rli.o rpl_mi.o rpl_reporting.o sql_union.o sql_derived.o sql_client.o stacktrace.o repl_failsafe.o sql_olap.o tztime.o my_decimal.o sql_plugin.o sql_binlog.o tmp_table.o sj_tmp_table.o sql_builtin.o -Wl,-framework -Wl,CoreFoundation -Wl,-bind_at_load -L/opt/local/lib/ ./.libs/libhandler.a ../drizzled/field/.libs/libfield.a ../drizzled/serialize/.libs/libserialize.a ../plugin/compress/libcompressudf.a ../plugin/crc32/libcrc32udf.a ../plugin/md5/libmd5udf.a ../plugin/uncompress/libuncompressudf.a ../plugin/uncompressed_length/libuncompressed_lengthudf.a ../storage/archive/libarchive.a ../storage/blackhole/libblackhole.a ../storage/csv/libcsv.a ../storage/heap/.libs/libheap.a ../storage/innobase/libinnobase.a ../storage/myisam/.libs/libmyisam.a /usr/local/lib/libprotobuf.dylib ../libdrizzle/.libs/libdrizzle.dylib ../mysys/.libs/libmysys.a ../mystrings/.libs/libmystrings.a -lz /opt/local/lib/libintl.dylib -L/opt/local/lib /opt/local/lib/libiconv.dylib -lc -ldl /opt/local/lib/libevent.dylib -lresolv -lm -lpthread
Undefined symbols:
  "_MD5_Init", referenced from:
      Item_func_md5::val_str(String*) in libmd5udf.a(md5udf.o)
  "_MD5_Update", referenced from:
      Item_func_md5::val_str(String*) in libmd5udf.a(md5udf.o)
  "_MD5_Final", referenced from:
      Item_func_md5::val_str(String*) in libmd5udf.a(md5udf.o)
ld: symbol(s) not found
collect2: ld returned 1 exit status
make[4]: *** [drizzled] Error 1
make[3]: *** [all-recursive] Error 1
make[2]: *** [all] Error 2
make[1]: *** [all-recursive] Error 1
make: *** [all] Error 2

[Stewart Smith (stewart)]

Do you have the openssl libraries and headers installed?

Building as loadable plugin should detect this (pretty sure mtaylor fixed it so that if no OpenSSL headers detected, it doesn't build .so). But this may be broken for building static plugin. Try building without --with-plugin=md5 and see if the dynamic plugin is built.

[Giuseppe Maxia (giuseppe-maxia)]

openssl library and headers are present, detected, and used.
Building with --with-plugin=md5 worked just fine until last time I compiled
Drizzle, a few days ago.

Building without plugin works.

Thanks

Giuseppe

On Mon, Sep 29, 2008 at 8:29 AM, Stewart Smith <email address hidden>wrote:

> Do you have the openssl libraries and headers installed?
>
> Building as loadable plugin should detect this (pretty sure mtaylor
> fixed it so that if no OpenSSL headers detected, it doesn't build .so).
> But this may be broken for building static plugin. Try building without
> --with-plugin=md5 and see if the dynamic plugin is built.
>
> --
> error compiling with the MD5 plugin
> https://bugs.launchpad.net/bugs/275705
> You received this bug notification because you are a direct subscriber
> of the bug.
>
> Status in A Lightweight SQL Database for Cloud and Web: New
>
> Bug description:
> Compiling Drizzle with MD5 plugins fails. (Rev 413 on Mac OSX 10.5)
>
> This is my compilation script:
>
> MYFLAGS="CFLAGS=-O3 CXXFLAGS=-O3"
> ./config/autorun.sh && \
> ./configure --disable-fail --prefix=$HOME/usr/local/drizzle
> --with-plugins=blackhole,md5 $MYFLAGS && \
> make && \
> make install
>
> And this is the error I get:
>
> g++ -W -Wall -Wextra -pedantic -Wundef -Wredundant-decls -Wno-long-long
> -Wno-strict-aliasing -fno-exceptions -ggdb3 -O3 -o .libs/drizzled sql_db.o
> sql_lex.o authentication.o sql_handler.o natural_join_column.o
> field_iterator.o item.o item_sum.o item_buff.o item_func.o item_cmpfunc.o
> item_strfunc.o item_timefunc.o thr_malloc.o item_create.o item_subselect.o
> item_row.o field.o strfunc.o key.o sql_class.o sql_list.o protocol.o
> sql_state.o lock.o sql_string.o drizzled.o sql_connect.o scheduler.o
> sql_parse.o set_var.o sql_yacc.o sql_base.o table.o sql_select.o
> sql_insert.o sql_error.o sql_locale.o sql_update.o sql_delete.o uniques.o
> log.o init.o derror.o unireg.o log_event.o rpl_record.o discover.o time.o
> opt_range.o opt_sum.o records.o filesort.o sql_table.o sql_rename.o
> sql_load.o mf_iocache.o field_conv.o sql_show.o sql_udf.o slave.o sql_repl.o
> rpl_filter.o rpl_tblmap.o rpl_utility.o rpl_rli.o rpl_mi.o rpl_reporting.o
> sql_union.o sql_derived.o sql_client.o stacktrace.o repl_failsafe.o
> sql_olap.o tztime.o my_decimal.o sql_plugin.o sql_binlog.o tmp_table.o
> sj_tmp_table.o sql_builtin.o -Wl,-framework -Wl,CoreFoundation
> -Wl,-bind_at_load -L/opt/local/lib/ ./.libs/libhandler.a
> ../drizzled/field/.libs/libfield.a
> ../drizzled/serialize/.libs/libserialize.a
> ../plugin/compress/libcompressudf.a ../plugin/crc32/libcrc32udf.a
> ../plugin/md5/libmd5udf.a ../plugin/uncompress/libuncompressudf.a
> ../plugin/uncompressed_length/libuncompressed_lengthudf.a
> ../storage/archive/libarchive.a ../storage/blackhole/libblackhole.a
> ../storage/csv/libcsv.a ../storage/heap/.libs/libheap.a
> ../storage/innobase/libinnobase.a ../storage/myisam/.libs/libmyisam.a
> /usr/local/lib/libprotobuf.dylib ../libdrizzle/.libs/libdrizzle.dylib
> ../mysys/.libs/libmysys.a ../mystrings/.libs/libmystrings.a -lz
> /opt/local/lib/libintl.dylib -L/opt/local/lib /opt/local/lib/libiconv.dylib
> -lc -ldl /opt/local/lib/libevent.dylib ...

[Stewart Smith (stewart)]

On Mon, Sep 29, 2008 at 07:18:42AM -0000, Giuseppe Maxia wrote:
> openssl library and headers are present, detected, and used.
> Building with --with-plugin=md5 worked just fine until last time I compiled
> Drizzle, a few days ago.
>
> Building without plugin works.

but should still generate the loadable one.... will have to fix the
auto-foo for linking in -lssl at some point.

--
Stewart Smith

[Stewart Smith (stewart)]

pretty sure you've fixed this... may want to double check...

[Lee Bieber (kalebral-deactivatedaccount)]

Can't reproduce this, as noted by Stewart this looks to be fixed