Hello Faustin,
I had the same issue. Then commented out the audit plugin lines in the
configuration file, finished the upgrade and un-commented them again.
These are my configuration files (with some info removed):
# cat /etc/mysql/mariadb.cnf | grep -v ^#
[client-server]
!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mariadb.conf.d/
and
# cat /etc/mysql/mariadb.conf.d/50-server.cnf | grep -v ^#
[server]
[mysqld]
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking
open_files_limit = 24000
server_audit_events=CONNECT,TABLE,QUERY_DCL
server_audit_logging=on
server_audit_output_type=syslog
server_audit_syslog_facility=LOG_LOCAL2
bind-address = REMOVED
key_buffer_size = 16M
max_allowed_packet = 16M
thread_stack = 192K
thread_cache_size = 8
myisam_recover_options = BACKUP
query_cache_limit = 1M
query_cache_size = 16M
log_error = /var/log/mysql/error.log
expire_logs_days = 10
max_binlog_size = 100M
ssl-ca=REMOVED.pem
ssl-cert=REMOVED.pem
ssl-key=REMOVED.pem
ssl=on
character-set-server = utf8mb4
collation-server = utf8mb4_general_ci
[embedded]
[mariadb]
[mariadb-10.1]
These are server audit variables:
SHOW GLOBAL VARIABLES LIKE '%server_audit%';
+-------------------------------+-------------------------+
| Variable_name | Value |
+-------------------------------+-------------------------+
| server_audit_events | CONNECT,TABLE,QUERY_DCL |
| server_audit_excl_users | |
| server_audit_file_path | server_audit.log |
| server_audit_file_rotate_now | OFF |
| server_audit_file_rotate_size | 1000000 |
| server_audit_file_rotations | 9 |
| server_audit_incl_users | |
| server_audit_logging | ON |
| server_audit_mode | 0 |
| server_audit_output_type | syslog |
| server_audit_query_log_limit | 1024 |
| server_audit_syslog_facility | LOG_LOCAL2 |
| server_audit_syslog_ident | mysql-server_auditing |
| server_audit_syslog_info | |
| server_audit_syslog_priority | LOG_INFO |
+-------------------------------+-------------------------+
Maybe the issue happens with "server_audit_events" enabled?
I installed this Debian stable system in March 2018, no previous mysql
or mariadb versions before that.
Best regards,
Marco
Il 22/11/18 20:06, Faustin Lammler ha scritto:
Marc,
I am not able to reproduce this.
Here are my steps:
- installation of mariadb-server-10.1_10.1.26-0+deb9u1;
- load and activation of the audit plugin:
$ cat /etc/mysql/my.cnf | grep -v ^#
[mysqld]
plugin_load=server_audit=server_audit.so
server_audit_file_path=/var/log/mysql/mariadb_server_audit.log
server_audit_logging=ON
[client-server]
!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mariadb.conf.d/
- restart mariadb and check that plugin is loaded and activated;
- upgrade to mariadb-server-10.1_10.1.37-0+deb9u1;
$ sudo apt-get dist-upgrade
- check that audit plugin is still activated;
Can you give me the content of you /etc/mysql/my.cnf file?
Is it possible that on your system a previous version of mariadb/mysql
was installed (before 10.1.26)?
