[Clfs-support] mysql install issue

[Koornstra, Reinoud]

Hi, I see this option when doing configure --help:

  --with-plugins=PLUGIN[[[,PLUGIN..]]]
                          Plugins to include in mysqld. (default is: none)
                          Must be a configuration name or a comma separated
                          list of plugins.
                          Available configurations are: none max max-no-ndb
                          all.
                          Available plugins are: partition daemon_example
                          ftexample archive blackhole csv example federated
                          heap ibmdb2i innobase myisam myisammrg ndbcluster.


Underneath I see:

=== Federated Storage Engine ===
  Plugin Name:      federated
  Description:      Connects to tables on remote MySQL servers
  Supports build:   static and dynamic
  Configurations:   max, max-no-ndb

So: --with-plugins= federated

Should do it then? Or should I do: --with-plugins=max ?
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 3:52 PM
To: CLFS Support
Subject: Re: [Clfs-support] mysql install issue

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.

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