[debian-mysql] Bug#914188: Bug#914188: mariadb-server: Upgrade faild due to 'unknown variable': 'server_audit_file_path=/path/to/audit.log'

[Marco M. F. De Santis]

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)?
>