[Clfs-support] mysql install issue

[Mark McCorkell]

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.