[Clfs-support] mysql install issue

[Mark McCorkell]

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.