EmergeMysql with extraengine but engines not available

[partysoft]

hello, i've emerged mysql 5.1 with extraengine , (modifyed some params in portage)

gentoo # cat /etc/portage/package.use
dev-db/mysql ~x86 extraengine


gentoo # cat /etc/portage/package.keywords
=dev-db/mysql-5.1.46
=virtual/mysql-5.1

ACCEPT_KEYWORDS="~x86" emerge -p mysql

gentoo # emerge -av mysql
[ebuild R ] dev-db/mysql-5.1.46 USE="community extraengine perl ssl -big-tables -cluster -debug -embedded -latin1 -max-idx-128 -minimal -pbxt -profiling (-selinux) -static -test -xtradb" 0 kB

My target is to make use of the federated engine... which after this didn't activated still (I didn't delete the old instalation of mysql-5.1.46 that was compiled before without extraengine)

And no federated or other engines available , I ran out ideas...please help

mysql> show engines;
+------------+---------+----------------------------------------------------------------+--------------+------+------------+
| Engine | Support | Comment | Transactions | XA | Savepoints |
+------------+---------+----------------------------------------------------------------+--------------+------+------------+
| MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great performance | NO | NO | NO |
| MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO |
| BLACKHOLE | YES | /dev/null storage engine (anything you write to it disappears) | NO | NO | NO |
| CSV | YES | CSV storage engine | NO | NO | NO |
| MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO |
| InnoDB | YES | Supports transactions, row-level locking, and foreign keys | YES | YES | YES |
| ARCHIVE | YES | Archive storage engine | NO | NO | NO |
+------------+---------+----------------------------------------------------------------+--------------+------+------------+

[VoidMage]

Any chance on this being a need to load a plugin ?
Does the build log show that engine as being built ?

[partysoft]

[VoidMage]

Portage creates a log automatically (at least AFAIK) in /var/log/portage.
What about first question ?

[partysoft]

sorry , i've logged all output to a file with emerge mysql /tmp/dump.txt

and i've found that federates is compiled as a plugin but on the compile itself it sais WARNING: unrecognized options: --with-plugindir


What i did now, was, remove old files from mysql old install
and run

emerge --config =dev-db/mysql-5.1.46

Is there anyway to clean (deleting even data files and configs and reinstall again from scratch?)

>>> Source prepared.
>>> Configuring source in /var/tmp/portage/dev-db/mysql-5.1.46/work/mysql ...
* Before using the Federated storage engine, please be sure to read
* http://dev.mysql.com/doc/refman/5.1/en/federated-limitations.html
* Available plugins: partition example myisam federated archive heap innodb_plugin csv innobase ndbcluster myisammrg blackhole ibmdb2i
* Dynamic plugins: csv myisam myisammrg heap archive blackhole partition federated innodb_plugin
* Static plugins: csv myisam myisammrg heap archive blackhole partition innobase
* Disabled plugins: example ibmdb2i ndbcluster pbxt


./configure --prefix=/usr --build=i686-pc-linux-gnu --host=i686-pc-linux-gnu --mandir=/usr/share/man --infodir=/usr/share/info --datadir=/usr/share --syscon$
configure: WARNING: unrecognized options: --with-plugindir, --without-plugin-example, --without-plugin-ibmdb2i, --without-plugin-ndbcluster, --without-plugi$

-------------------------------
checking whether to use CSV Storage Engine... yes
checking whether to use Example Storage Engine... no
checking whether to use Federated Storage Engine... plugin
checking whether to use Memory Storage Engine... yes
checking whether to use IBM DB2 for i Storage Engine... no


--------------------------------

config.status: creating storage/csv/Makefile
config.status: creating storage/example/Makefile
config.status: creating storage/federated/Makefile
config.status: creating storage/heap/Makefile


------------------------------------------
Making all in federated
make[2]: Entering directory `/var/tmp/portage/dev-db/mysql-5.1.46/work/mysql/storage/federated'
/bin/sh ../../libtool --preserve-dup-deps --tag=CXX --mode=compile i686-pc-linux-gnu-g++ -DHAVE_CONFIG_H -I. -I../../include -I../../include -I../../incl$
libtool: compile: i686-pc-linux-gnu-g++ -DHAVE_CONFIG_H -I. -I../../include -I../../include -I../../include -I../../regex -I../../sql -I. -DMYSQL_DYNAMIC_P$
libtool: compile: i686-pc-linux-gnu-g++ -DHAVE_CONFIG_H -I. -I../../include -I../../include -I../../include -I../../regex -I../../sql -I. -DMYSQL_DYNAMIC_P$
mv -f .deps/ha_federated_la-ha_federated.Tpo .deps/ha_federated_la-ha_federated.Plo
/bin/sh ../../libtool --preserve-dup-deps --tag=CXX --mode=link i686-pc-linux-gnu-g++ -DMYSQL_DYNAMIC_PLUGIN -O2 -march=i686 -pipe -DHAVE_ERRNO_AS_DEFIN$
libtool: link: i686-pc-linux-gnu-g++ -shared -nostdlib /usr/lib/gcc/i686-pc-linux-gnu/4.3.4/../../../crti.o /usr/lib/gcc/i686-pc-linux-gnu/4.3.4/crtbeginS.o$
libtool: link: (cd ".libs" && rm -f "ha_federated.so.0" && ln -s "ha_federated.so.0.0.0" "ha_federated.so.0")
libtool: link: (cd ".libs" && rm -f "ha_federated.so" && ln -s "ha_federated.so.0.0.0" "ha_federated.so")
libtool: link: i686-pc-linux-gnu-ar cru .libs/ha_federated.a ha_federated_la-ha_federated.o
libtool: link: i686-pc-linux-gnu-ranlib .libs/ha_federated.a
libtool: link: ( cd ".libs" && rm -f "ha_federated.la" && ln -s "../ha_federated.la" "ha_federated.la" )
make[2]: Leaving directory `/var/tmp/portage/dev-db/mysql-5.1.46/work/mysql/storage/federated'

------------------------------------

make[2]: Entering directory `/var/tmp/portage/dev-db/mysql-5.1.46/work/mysql/storage/federated'
make[3]: Entering directory `/var/tmp/portage/dev-db/mysql-5.1.46/work/mysql/storage/federated'
make[3]: Nothing to be done for `install-exec-am'.

------------------------------

* configure: WARNING: unrecognized options: --with-plugindir, --without-plugin-example, --without-plugin-ibmdb2i, --without-plugin-ndbcluster, --witho$
* configure: WARNING:$ unrecognized options: --with-plugindir, --without-plugin-example, --without-plugin-ibmdb2i, --without-plugin-ndbcluster, --with$
strip: i686-pc-linux-gnu-strip --strip-unneeded -R .comment
usr/lib/mysql/libmysqlclient_r.so.16.0.0
usr/lib/mysql/plugin/ha_federated.so.0.0.0
usr/lib/mysql/plugin/ha_innodb_plugin.so.0.0.0
usr/lib/mysql/libmysqlclient.so.16.0.0
usr/bin/mysqlshow
usr/bin/mysqlslap

[kadrim]

a little bit late, but i posted the solution for your problem in this thread:

https://forums.gentoo.org/viewtopic-p-6674375.html#6674375