Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.0.13
-
None
-
None
-
src build of MariaDB v10.0.13 (r4346)
mysqld -V
mysqld Ver 10.0.13-MariaDB for Linux on x86_64 (Source distribution)
Description
I've built/installed MariaDB v10.0.13 (r4346) from src.
mysqld -V
|
mysqld Ver 10.0.13-MariaDB for Linux on x86_64 (Source distribution)
|
|
My build config includes
cmake .. --debug-output \
|
-DCMAKE_BUILD_TYPE="Release" \
|
-DCMAKE_INSTALL_PREFIX=/usr/local/mariadb \
|
-DINSTALL_LAYOUT=STANDALONE \
|
-DINSTALL_SYSCONFDIR=/usr/local/etc/mariadb.DEFAULT \
|
-DINSTALL_SYSCONF2DIR=/usr/local/etc/mariadb.DEFAULT/conf.d \
|
-DDEFAULT_SYSCONFDIR=/usr/local/etc/mariadb \
|
...
|
|
With this config, and the 'docs' below, a config in
/usr/local/etc/mariadb/my.cnf
|
|
should be searched for, found, and used.
It's not.
Here's the ENV.
MariaDB (via systemd) is launched with
/usr/local/mariadb/bin/mysqld --defaults-file=/usr/local/etc/mariadb/my.cnf --basedir=/usr/local/mariadb --datadir=/var/db/mariadb --plugin-dir=/usr/local/mariadb/lib/plugin --log-error=/var/log/mariadb/mariadb-err.log --pid-file=/var/cache/mariadb/mariadb.pid --socket=/var/cache/mariadb/mariadb.sock --port=3306
|
|
Note
cat CMakeLists.txt
|
...
|
IF(INSTALL_SYSCONFDIR)
|
SET(DEFAULT_SYSCONFDIR "${INSTALL_SYSCONFDIR}")
|
ENDIF()
|
...
|
|
|
&
|
|
|
cat ./cmake/install_layout.cmake
|
...
|
# - INSTALL_SYSCONFDIR (my.cnf config file. Usually /etc or nothing)
|
# - INSTALL_SYSCONF2DIR (additional config files, e.g. /etc/mysql/conf.d)
|
...
|
|
|
&
|
|
|
cat ./scripts/CMakeLists.txt
|
...
|
IF(INSTALL_SYSCONFDIR)
|
SET(sysconfdir ${DEFAULT_SYSCONFDIR})
|
ELSE()
|
SET(sysconfdir "/etc")
|
ENDIF()
|
...
|
|
|
&
|
cat ./mysys/my_default.c
|
...
|
/* Which directories are searched for options (and in which order) */
|
...
|
/*
|
This structure defines the context that we pass to callback
|
function 'handle_default_option' used in search_default_file
|
to process each option. This context is used if search_default_file
|
was called from load_defaults.
|
*/
|
|
struct handle_option_ctx
|
...
|
/**
|
Create the list of default directories.
|
|
|
@param alloc MEM_ROOT where the list of directories is stored
|
|
|
@details
|
The directories searched, in order, are:
|
- Windows: GetSystemWindowsDirectory()
|
- Windows: GetWindowsDirectory()
|
- Windows: C:/
|
- Windows: Directory above where the executable is located
|
- Unix: /etc/ or the value of DEFAULT_SYSCONFDIR, if defined
|
- Unix: /etc/mysql/ unless DEFAULT_SYSCONFDIR is defined
|
- ALL: getenv("MYSQL_HOME")
|
- ALL: --defaults-extra-file=<path> (run-time option)
|
- Unix: ~/
|
|
|
On all systems, if a directory is already in the list, it will be moved
|
to the end of the list. This avoids reading defaults files multiple times,
|
while ensuring the correct precedence.
|
|
|
@retval NULL Failure (out of memory, probably)
|
@retval other Pointer to NULL-terminated array of default directories
|
*/
|
...
|
|
|
&
|
|
|
@ https://mariadb.com/kb/en/mariadb/documentation/getting-started/configuring-mariadb-with-mycnf/
|
|
|
On a Linux, Unix or Mac server, MariaDB looks for the my.cnf file in the following locations:
|
|
|
Location Scope
|
/etc/my.cnf Global
|
/etc/mysql/my.cnf Global
|
SYSCONFDIR/my.cnf Global
|
$MYSQL_HOME/my.cnf Server
|
defaults-extra-file File specified with --defaults-extra-file=path, if any
|
/.my.cnf User
|
|
|
SYSCONFDIR is the directory specified with the CMake SYSCONFDIR option when MariaDB was built, by default etc under the compiled-in installation directory.
|
|
With x.13, changes to my config in
/usr/local/etc/mariadb/my.cnf
|
|
are NOT correctly picked up by any mysql client tools.
For example, if in my.cnf I add
...
|
[client]
|
user = root
|
password = 'XXXXXX'
|
...
|
|
and it's correctly picked up, then at shell, instead of
mysqlshow -u root -p
|
password: XXXXXX
|
|
I should be able to just
mysqlshow
|
|
with the in-config, specified user= & password= optiont picked up.
But, with MariaDB 10.0.13, config file changes are simply ignored.
Checking, If I
strace mysqlshow
|
|
I see
...
|
stat("/usr/local/etc/mariadb.DEFAULT/my.cnf", {st_mode=S_IFREG|0644, st_size=202, ...}) = 0
|
open("/usr/local/etc/mariadb.DEFAULT/my.cnf", O_RDONLY) = 3
|
fstat(3, {st_mode=S_IFREG|0644, st_size=202, ...}) = 0
|
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f1db94ec000
|
read(3, "#\n# This group is read both both"..., 4096) = 202
|
openat(AT_FDCWD, "/etc/my.cnf.d/", O_RDONLY|O_NONBLOCK|O_DIRECTORY|O_CLOEXEC) = 4
|
getdents(4, /* 3 entries */, 32768) = 88
|
getdents(4, /* 0 entries */, 32768) = 0
|
close(4) = 0
|
stat("/etc/my.cnf.d/default_plugins.cnf", {st_mode=S_IFREG|0640, st_size=122, ...}) = 0
|
open("/etc/my.cnf.d/default_plugins.cnf", O_RDONLY) = 4
|
fstat(4, {st_mode=S_IFREG|0640, st_size=122, ...}) = 0
|
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f1db94eb000
|
read(4, "[server]\n#plugin-load=blackhole="..., 4096) = 122
|
read(4, "", 4096) = 0
|
close(4) = 0
|
munmap(0x7f1db94eb000, 4096) = 0
|
read(3, "", 4096) = 0
|
close(3) = 0
|
munmap(0x7f1db94ec000, 4096) = 0
|
stat("/root/.my.cnf", {st_mode=S_IFREG|0644, st_size=8792, ...}) = 0
|
open("/root/.my.cnf", O_RDONLY) = 3
|
...
|
|
Notice,
stat("/usr/local/etc/mariadb.DEFAULT/my.cnf", {st_mode=S_IFREG|0644, st_size=202, ...}) = 0
|
open("/usr/local/etc/mariadb.DEFAULT/my.cnf", O_RDONLY) = 3
|
|
then
stat("/root/.my.cnf", {st_mode=S_IFREG|0644, st_size=8792, ...}) = 0
|
open("/root/.my.cnf", O_RDONLY) = 3
|
|
is searched. There's no indication at all that the specified dir
-DDEFAULT_SYSCONFDIR=/usr/local/etc/mariadb \
|
|
is searched.
This is consistent with
$ mysqldump --help
|
...
|
Default options are read from the following files in the given order:
|
/usr/local/etc/mariadb.DEFAULT/my.cnf ~/.my.cnf
|
...
|
|
where, as in the strace ^^^, that those are the ONLY two locations checked – DESPITE having specified all of
-DINSTALL_SYSCONFDIR=/usr/local/etc/mariadb.DEFAULT \
|
-DINSTALL_SYSCONF2DIR=/usr/local/etc/mariadb.DEFAULT/conf.d \
|
-DDEFAULT_SYSCONFDIR=/usr/local/etc/mariadb \
|
|
Verifying what DOES work, starting with
ls -al /usr/local/etc/mariadb/my.cnf /etc/my.cnf /root/.my.cnf
|
ls: cannot access /etc/my.cnf: No such file or directory
|
ls: cannot access /root/.my.cnf: No such file or directory
|
-rw-r--r--+ 1 root mysql 8.7K Aug 11 17:48 /usr/local/etc/mariadb/my.cnf
|
|
given a config that includes
grep "\[client\]" /usr/local/etc/mariadb/my.cnf -A2
|
[client]
|
user = root
|
password = 'xxxxxx'
|
|
the file's only picked up if it exists in /root/.my.cnf
mysqlshow
|
mysqlshow: Access denied for user 'root'@'localhost' (using password: NO)
|
|
|
ln -sf /usr/local/etc/mariadb/my.cnf /etc/my.cnf
|
mysqlshow
|
mysqlshow: Access denied for user 'root'@'localhost' (using password: NO)
|
|
|
rm -f /etc/my.cnf
|
ln -sf /usr/local/etc/mariadb/my.cnf /root/.my.cnf
|
mysqlshow
|
+------------------------------+
|
| Databases |
|
+------------------------------+
|
| information_schema |
|
| mysql |
|
| performance_schema |
|
| test |
|
+------------------------------+
|
|
Bottom line:
The docs and behavior of default config-file location/use are inconsistent (and likely have been for years).
There should be a clear, consistent, documented search order, and an option to override – at build- (maybe run-, too) time with an abolute/exclusive location.
The current 'right' config option should be
-DDEFAULT_SYSCONFDIR= /path/to/dir/that/contains/my.cnf/
|
|
which, if defined, should limit search path to ONLY that dir, overriding all other search paths.