http://bugzilla.opensuse.org/show_bug.cgi?id=1091465 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] -- You are receiving this mail because: You are on the CC list for the bug.