Bug ID | 1091465 |
---|---|
Summary | Mariadb is unable to follow configurations as defined in /etc/my.cnf for initial single instance |
Classification | openSUSE |
Product | openSUSE Distribution |
Version | Leap 42.3 |
Hardware | x86-64 |
OS | openSUSE 42.3 |
Status | NEW |
Severity | Minor |
Priority | P5 - None |
Component | Other |
Assignee | bnc-team-screening@forge.provo.novell.com |
Reporter | jcdole@free.fr |
QA Contact | qa-bugs@suse.de |
Found By | --- |
Blocker | --- |
Configuring error log in /etc/my.cnf in [mysqld] is not took into account. [Code] # The following options will be passed to all MariaDB clients [client] # password = your_password # port = 3306 # socket = /var/run/mysql/mysql.sock [mysqld] # Remove leading # if you don't want to listen on network (only socket - safer) # skip-networking ..... ..... log-error = /var/log/mysql/mysql/mysql_error.log ..... ..... [/Code] You have to modify /usr/lib/mysql/mysql-systemd-helper this way : [Code] mysql_start() { exec /usr/sbin/mysqld \ --defaults-file="$config" \ $ignore_db_dir \ --user="$mysql_daemon_user" \ --log-error="/var/log/mysql/mysql/mysql_error.log" } [/Code] Changing the syntax in /etc/my.cnf from log-error= to log_error= make no difference. Note: ----- In /etc/my.cnf setting general log run ok : [Code] # The following options will be passed to all MariaDB clients [client] # password = your_password # port = 3306 # socket = /var/run/mysql/mysql.sock [mysqld] # Remove leading # if you don't want to listen on network (only socket - safer) # skip-networking ..... ..... general_log = 1 general_log_file = /var/log/mysql/mysql/mysql.log ..... ..... [/Code] To verify the mysql configuration I use this command : [Code] mysql --socket=/var/run/mysql/mysql.sock -BNe "show global variables" | grep err[/Code] and [Code] mysql --socket=/var/run/mysql/mysql.sock -BNe "show global variables" | grep general_log[/Code]