Bug #42872 In MySQL 5.1.31, unrecognized --with-innodb, --with-partition, --with-federated
Submitted: 16 Feb 2009 8:12 Modified: 15 Oct 2012 14:49
Reporter: ws lee Email Updates:
Status: Unsupported Impact on me:
None 
Category:MySQL Server: Compiling Severity:S3 (Non-critical)
Version:5.1.31 OS:Solaris (5.10)
Assigned to: Kent Boortz CPU Architecture:Any
Triage: Triaged: D3 (Medium)

[16 Feb 2009 8:12] ws lee
Description:

...

In MySQL 5.1.31, unrecognized --with-innodb --with-partition --with-federated-storage-engine configure option.

How to repeat:
gtar zxvf mysql-5.1.31.tar.gz
cd mysql-5.1.31
./configure --prefix=/usr/local/mysql5.1.31 --with-innodb --with-partition --with-federated-storage-engine
configure: WARNING: unrecognized options: --with-innodb, --with-partition, --with-federated-storage-engine
...
...
[16 Feb 2009 8:57] Sergei Golubchik
This is kind of ok, as these options are undocumented (see ./configure --help) backward compatibility options, the recommended ones are --with-plugin-innodb --with-plugin-federated --with-plugin-partition. But they also result in such a warning :(
[16 Feb 2009 9:10] Sveta Smirnova
Thank you for the report.

As Sergei said options --with-innodb, --with-partition, --with-federated are not supported. Supported options  --with-plugin-innodb --with-plugin-federated --with-plugin-partition don't produce warnings with current development sources anymore, although they did in version 5.1.31. Please wait next release or just ignore these warnings, because options really had effect.
[16 Feb 2009 9:15] ws lee
In tar package, was used --with-partition' '--with-innodb' like before.

'--prefix=/usr/local/mysql' '--localstatedir=/usr/local/mysql/data' '--libexecdir=/usr/local/mysql/b
in' '--with-comment=MySQL Community Server (GPL)' '--with-server-suffix=' '--enable-thread-safe-client' '--enable-local-infile' '--b
uild=i386-pc-solaris2.10' '--with-mysqld-libs=-lmtmalloc' '--with-named-curses=-lcurses' '--with-pic' '--with-client-ldflags=-static
' '--with-mysqld-ldflags=-static' '--with-zlib-dir=bundled' '--with-big-tables' '--with-ssl' '--with-readline' '--with-embedded-serv
er' '--with-partition' '--with-innodb' '--without-ndbcluster' '--with-archive-storage-engine' '--with-blackhole-storage-engine' '--w
ith-csv-storage-engine' '--without-example-storage-engine' '--with-federated-storage-engine' '--with-extra-charsets=complex' 'build_
alias=i386-pc-solaris2.10' 'CC=/opt/studio12/SUNWspro/bin/cc' 'CFLAGS=-g -xO2 -mt -fsimple=1 -ftrap=%none -nofstore -xbuiltin=%all -
xlibmil -xlibmopt -xtarget=generic' 'CXX=/opt/studio12/SUNWspro/bin/CC' 'CXXFLAGS=-g -xO2 -mt -fsimple=1 -ftrap=%none -nofstore -xbu
iltin=%all -features=no%except -xlibmil -xlibmopt -xtarget=generic'
[16 Feb 2009 9:49] Sergei Golubchik
Sveta, whether you'll see a warning depends on the autotools you're using. Try autoconf 2.63, for example
[16 Feb 2009 10:15] Sveta Smirnova
Sergei, thank you.

With autoconf 2.63 problem is repeatable for me as well.
[23 Mar 2009 12:01] Max von Seibold
Encountered the same problems trying to build on a 64 Sparc. 

Attempting various combinations of --with-PLUGIN or --with-plugin-PLUGIN_NAME always gave warnings like:- 

configure: WARNING: unrecognized options: --with-named-z-libs, --with-archive, --with-innobase, --with-csv

However using the --with-plugins and supplying the plugins as a list worked...

--with-plugins=innobase,csv,archive
[13 May 2009 1:05] Iain Kay
This 'bug' is still reported when compiling MySQL 5.1.34.  I have compiled using the --with-innodb flag and it does in fact compile with InnoDB, after I uncomment the InnoDB related stuff in /etc/my.cnf the MySQL server still starts.
Is this configure option going to be dropped, or is it a bug? If it's going to be dropped then what will replace it? If not then please fix the configure script!
[23 Aug 2009 16:25] Sergei Golubchik
bug#45056, bug#46073, bug#46871 were marked as duplicates of this bug
[15 Sep 2009 6:21] Alexey Kishkin
I would also note mysql error messages refers to this deprecated option:

mysql> create table testtbl (i int primary key) partition by key (i) partitions 5;
ERROR 1289 (HY000): The 'partitioning' feature is disabled; you need MySQL built with '--with-partition' to have it working
mysql> select version();
+-----------+
| version() |
+-----------+
| 5.1.38    |
+-----------+
1 row in set (0,00 sec)
[18 Sep 2009 8:39] Sergei Golubchik
Bug#47388 was marked a duplicate of this bug
[2 Feb 2010 20:10] Todd Rinaldo
Still present in 5.1.43

--with-plugins= format will get rid of warnings 

however, there is no feature to do --without-plugins=

I agree with the above commentary. There seems to be 3 ways to do this. I would suggest picking one, removing (don't deprecate) the others and let's clean this up once and for all.
[2 Feb 2010 21:06] Sergei Golubchik
From the autoconf point of view the warning is correct. plugin.m4 indeed checks $with_plugin_foo variables without declaring a --with-plugin-foo option using AC_ARG_WITH() macro. That is, --with-plugin-foo is properly flagged as unrecognized.

Two possible fixes, neither is perfect:

1. add AC_DISABLE_OPTION_CHECKING to configure.in
   this will turn off all warnings about unrecognized --with- or --enable
   including warnings for user mistakes like --with-big-tbales

2. In plugin.m4 add a line to the _MYSQL_PLUGIN macro:

   m4_define([$2], [$1])
+  _AC_ENABLE_IF([with],[plugin-$1])
   _MYSQL_PLUGAPPEND([__mysql_plugin_list__],[$1])

   it will register --with-plugin-XXX options for all plugins, making them recognized. Drawback - it's undocumented internal autoconf macro. Perhaps not portable across autoconf version, best to wrap it in m4_ifdef:

   m4_ifdef([_AC_ENABLE_IF], [AC_ENABLE_IF([with],[plugin-$1])])
[18 Mar 2010 10:22] Sveta Smirnova
Bug #52147 was marked as duplicate of this one.
[29 Mar 2010 11:03] hans dampf
Hi, 

still present in 5.1.45?

./configure --prefix=/usr/local/mysql --with-charset=latin1 --with-mysqld-user=mysql  --without-debug --enable-thread-safe-client --with-client-ldflags=-all-static --with-mysqld-ldflags=-all-static --disable-shared --with-plugin-heap --with-plugin-innobase --with-plugin-innodb_plugin --with-plugin-myisam --with-plugin-archive

However:
configure: WARNING: unrecognized options: --with-plugin-heap, --with-plugin-innobase, --with-plugin-innodb_plugin, --with-plugin-myisam, --with-plugin-archive

Regards,
Werner
[7 Jun 2010 7:35] Sveta Smirnova
Bug #54237 was marked as duplicate of this one.
[15 Oct 2012 14:49] Erlend Dahl
This only show in GNU autotools based builds, and from 5.5 and on we use
CMake.