maria-developers team mailing list archive

[Honza Horak <hhorak@xxxxxxxxxx>]

On 08/13/2013 12:51 PM, Michael Widenius wrote:
> Hi!
>
> > > > > > "Honza" == Honza Horak <hhorak@xxxxxxxxxx> writes:
>
> Honza> Hi guys,
> Honza> maybe I just need some little kick or I should get a coffee, but I can't
> Honza> understand the following config file ordering difference.
>
> Honza> Reading [1] and code in mariadb-5.5.32/mysys/default.c:1226, it looks
> Honza> like expected order of config files in Linux should be:
>
> Honza> /etc/my.cnf /etc/mysql/my.cnf ~/.my.cnf
>
> Honza> However, when asking for that using --help --verbose, I get a bit
> Honza> different output:
>
> Honza> $ /usr/libexec/mysqld --help --verbose 2>/dev/null | grep --after=1
> Honza> '^Default options' | tail -n 2
> Honza> Default options are read from the following files in the given order:
> Honza> /etc/mysql/my.cnf /etc/my.cnf ~/.my.cnf
>
> I checked this on my version of MariaDB (fresh from bzr) on OpenSuse:
>
> mysqld  Ver 5.5.32-MariaDB-debug
>
> Default options are read from the following files in the given order:
> /etc/my.cnf /etc/mysql/my.cnf ~/.my.cnf
>
> Honza> I don't understand why /etc/my.cnf is not on the first place in that
> Honza> output. Can somebody give me a hint? Am I just blind?
>
> I did check the mysqld version that comes with OpenSuse 12.3 and this
> gives:
>
> Default options are read from the following files in the given order:
> /etc/mysql/my.cnf /etc/my.cnf ~/.my.cnf
>
> This packet is named: mariadb-5.5.29-1.1.1.x86_64 and built by
> http://bugs.opensuse.org
>
> What is the version name of the libexec/mysqld that you got and who
> has built it?
>
> Can you get the source of the package ?

Hi Monty,

thanks for your explanation so far..

It's happening on all fedora packages I've tested, currently
mariadb-5.5.31-4.fc19.src.rpm

But when trying to build from downloaded tarball with various options 
I've found something interesting. When using "-DINSTALL_LAYOUT=RPM" in 
the cmake call, then the order is
  /etc/mysql/my.cnf /etc/my.cnf ~/.my.cnf
but when *not* using "-DINSTALL_LAYOUT=RPM", then the order is
  /etc/my.cnf /etc/mysql/my.cnf ~/.my.cnf

I haven't found yet why is this happening, haven't spotted any 
significant #IF macro or anything what could cause this.. Maybe you have 
an idea?

Cheers,
Honza