Percona Server moved to https://jira.percona.com/projects/PS

  1. Bug #1435606
  2. Comment #5

Comment 5 for bug 1435606

Revision history for this message
monty solomon (monty+launchpad) wrote : Re: Installation of audit_log plugin crashes mysql server

Installation procedure for the running servers via puppet

Add entries to my.cnf

audit-log = FORCE_PLUS_PERMANENT
audit_log_file = /opt/mysql/dblogs1/test-p0/audit/audit.log
audit_log_format = JSON
audit_log_strategy = SEMISYNCHRONOUS
plugin-load = audit_log.so

execute
INSTALL PLUGIN audit_log SONAME 'audit_log.so'

Mar 23 22:43:56 puppet-agent[16927]: (/Stage[main]/Mysql::Audit_log/Exec[load_audit_log.so]/returns) ERROR 2013 (HY000) at line 1: Lost connection to MySQL server during query
Mar 23 22:43:56 puppet-agent[16927]: mysql -uroot -e "INSTALL PLUGIN audit_log SONAME 'audit_log.so'" returned 1 instead of one of [0]
Mar 23 22:43:56 puppet-agent[16927]: (/Stage[main]/Mysql::Audit_log/Exec[load_audit_log.so]/returns) change from notrun to 0 failed: mysql -uroot -e "INSTALL PLUGIN audit_log SONAME 'audit_log.so'" returned 1 instead of one of [0]
Mar 23 22:43:56 puppet-agent[16927]: (/Stage[main]/Mysql::Audit_log/Exec[load_audit_log.so]/returns) ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/mysql/dbprod/test-p0.sock' (2)
Mar 23 22:43:56 puppet-agent[16927]: (/Stage[main]/Mysql::Audit_log/Exec[load_audit_log.so]) Failed to call refresh: mysql -uroot -e "INSTALL PLUGIN audit_log SONAME 'audit_log.so'" returned 1 instead of one of [0]
Mar 23 22:43:56 puppet-agent[16927]: (/Stage[main]/Mysql::Audit_log/Exec[load_audit_log.so]) mysql -uroot -e "INSTALL PLUGIN audit_log SONAME 'audit_log.so'" returned 1 instead of one of [0]