[Clfs-support] mysql install issue

[Koornstra, Reinoud]

Hi,

I tried something else in my /etc/my.cnf in the log file I see this:

InnoDB: Error: log file ./ib_logfile0 is of different size 0 5242880 bytes
InnoDB: than specified in the .cnf file 0 16777216 bytes!
090429 19:01:51 [ERROR] Plugin 'InnoDB' init function returned error.
090429 19:01:51 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
090429 19:01:51 [ERROR] Unknown/unsupported table type: INNODB
090429 19:01:51 [ERROR] Aborting

In the configure option I did set --with-plugins twice, did this screw things up possibly?

CFLAGS="${CFLAGS} -fPIC" CXXFLAGS="${CXXFLAGS} -fno-exceptions -fno-rtti -fno-strict-aliasing -fno-implicit-templates -felide-constructors -DBIG_JOINS=1 -fPIC" 
./configure --prefix=/usr --with-mysqld-ldflags=-all-static --with-ssl --with-fast-mutexes --with-plugins=federated --sysconfdir=/etc --libexecdir=/usr/sbin --localstatedir=/srv/mysql --enable-assembler --enable-local-infile --without-debug --with-libwrap --with-readline --with-geometry --with-low-memory --without-pstack --without-docs --with-pic --with-lib-ccflags=-fPIC --enable-thread-safe-client --with-client-ldflags=-lstdc++ --with-extra-charsets=all --with-mysqld-user=mysql --with-server --with-unix-socket-path=/var/run/mysql/mysql.sock --with-plugins=csv,myisam,myisammrg,heap,innobase --with-embedded-server --with-embedded-privilege-control

Thanks,

Reinoud.

-----Original Message-----
From: clfs-support-bounces at lists.cross-lfs.org [mailto:clfs-support-bounces at lists.cross-lfs.org] On Behalf Of Mark McCorkell
Sent: Tuesday, April 28, 2009 4:22 PM
To: CLFS Support
Subject: Re: [Clfs-support] mysql install issue

On Tue, 2009-04-28 at 23:52 +0100, Mark McCorkell wrote:
> On Tue, 2009-04-28 at 20:38 +0000, Koornstra, Reinoud wrote:
> > Hi,
> > 
> >  
> > 
> > I tried to install mysql as described in the book.
> > 
> > Upon installing the tables I encountered an issue:
> > 
> >  
> > 
> > root:/usr/lib# /usr/bin/mysql_install_db --user=mysql
> > 
> > Installing MySQL system tables...
> > 
> > 090428 13:30:32 [ERROR] /usr/sbin/mysqld: unknown option
> > '--skip-federated'
> > 
> > 090428 13:30:32 [ERROR] Aborting
> > 
> >  
> > 
> > 090428 13:30:32 [Warning] Forcing shutdown of 1 plugins
> > 
> > 090428 13:30:32 [Note] /usr/sbin/mysqld: Shutdown complete
> > 
> >  
> > 
> > Installation of system tables failed!
> > 
> >  
> > 
> > I noticed that in /etc/my.cnf :
> > 
> > # Disable Federated by default
> > 
> > skip-federated
> > 
> >  
> > 
> > It seems to have a problem with that option eventhough the file came
> > straight from:
> > 
> > /usr/share/mysql/my-medium.cnf
> > 
> >  
> > 
> > In the configure phase I added these options as possibilities
> > suggested:
> > 
> >  
> > 
> > --with-mysqld-ldflags=-all-static \
> > 
> > --with-ssl \
> > 
> > --with-fast-mutexes \
> > 
> >  
> > 
> > Any hints why skip-federated is unknown?
> > 
> > Thanks,
> > 
> >  
> > 
> > Reinoud.
> 
> I think it's an error in either the shipped config file or the default
> configure script options. You can either recompile and tell it to build
> the Federation plugin (look in configure --help for the syntax) or
> comment out the line in the .cnf file.
> 
> I've never examined what the Federation plugin is and generally go by
> the rule that if I don't know what it is I probably don't need it, so I
> just commented out the line. It doesn't seem to have hurt mysql in any
> way, YMMV.
> 
> --
> Mark.

By Federation I of course mean federated. That's what happens when you
read Star Trek movie reviews while replying to lists.

_______________________________________________
Clfs-support mailing list
Clfs-support at lists.cross-lfs.org
http://lists.cross-lfs.org/listinfo.cgi/clfs-support-cross-lfs.org