Gentoo Forums
Gentoo Forums
Gentoo Forums
Quick Search: in
EmergeMysql with extraengine but engines not available
View unanswered posts
View posts from last 24 hours

 
Reply to topic    Gentoo Forums Forum Index Portage & Programming
View previous topic :: View next topic  
Author Message
partysoft
n00b
n00b


Joined: 15 Jul 2010
Posts: 4

PostPosted: Thu Jul 15, 2010 5:07 pm    Post subject: EmergeMysql with extraengine but engines not available Reply with quote

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 |
+------------+---------+----------------------------------------------------------------+--------------+------+------------+
Back to top
View user's profile Send private message
VoidMage
Watchman
Watchman


Joined: 14 Oct 2006
Posts: 5433

PostPosted: Thu Jul 15, 2010 8:40 pm    Post subject: Reply with quote

Any chance on this being a need to load a plugin ?
Does the build log show that engine as being built ?
Back to top
View user's profile Send private message
partysoft
n00b
n00b


Joined: 15 Jul 2010
Posts: 4

PostPosted: Thu Jul 15, 2010 9:22 pm    Post subject: Reply with quote

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


The thruth is that i don't know how to log the output,as i can't see while it compiles because it goes too fast :)
Back to top
View user's profile Send private message
VoidMage
Watchman
Watchman


Joined: 14 Oct 2006
Posts: 5433

PostPosted: Thu Jul 15, 2010 11:13 pm    Post subject: Reply with quote

:roll: Portage creates a log automatically (at least AFAIK) in /var/log/portage.
What about first question ?
Back to top
View user's profile Send private message
partysoft
n00b
n00b


Joined: 15 Jul 2010
Posts: 4

PostPosted: Fri Jul 16, 2010 12:10 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
kadrim
n00b
n00b


Joined: 23 Nov 2004
Posts: 10
Location: Germany

PostPosted: Wed May 04, 2011 1:07 pm    Post subject: Reply with quote

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

http://forums.gentoo.org/viewtopic-p-6674375.html#6674375
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic    Gentoo Forums Forum Index Portage & Programming All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum