{"action":"created","issue":{"url":"https://api.github.com/repos/mcafee/mysql-audit/issues/99","labels_url":"https://api.github.com/repos/mcafee/mysql-audit/issues/99/labels{/name}","comments_url":"https://api.github.com/repos/mcafee/mysql-audit/issues/99/comments","events_url":"https://api.github.com/repos/mcafee/mysql-audit/issues/99/events","html_url":"https://github.com/mcafee/mysql-audit/issues/99","id":55889120,"number":99,"title":"How to install audit plugin for multiple running mysql instances on a single server","user":{"login":"vishal08jan","id":10756764,"avatar_url":"https://avatars.githubusercontent.com/u/10756764?v=3","gravatar_id":"","url":"https://api.github.com/users/vishal08jan","html_url":"https://github.com/vishal08jan","followers_url":"https://api.github.com/users/vishal08jan/followers","following_url":"https://api.github.com/users/vishal08jan/following{/other_user}","gists_url":"https://api.github.com/users/vishal08jan/gists{/gist_id}","starred_url":"https://api.github.com/users/vishal08jan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/vishal08jan/subscriptions","organizations_url":"https://api.github.com/users/vishal08jan/orgs","repos_url":"https://api.github.com/users/vishal08jan/repos","events_url":"https://api.github.com/users/vishal08jan/events{/privacy}","received_events_url":"https://api.github.com/users/vishal08jan/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-01-29T11:45:05Z","updated_at":"2015-01-29T12:21:27Z","closed_at":null,"body":"Hi\r\n\r\nI have a server where 1 mysql 5.5.server is running and there are 2 instances of mysql 5.6 running.\r\n5.5 - RPM installation\r\n5.6 - Binary Installation\r\nI already have audit plugin installed for mysql 5.5 but have issues installing audit plugin on mysql 5.6.\r\n\r\nI am getting the following error\r\n\r\nmysql> INSTALL PLUGIN AUDIT SONAME 'libaudit_plugin.so';\r\nERROR 1123 (HY000): Can't initialize function 'AUDIT'; Plugin initialization function failed.\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/mcafee/mysql-audit/issues/comments/72015529","html_url":"https://github.com/mcafee/mysql-audit/issues/99#issuecomment-72015529","issue_url":"https://api.github.com/repos/mcafee/mysql-audit/issues/99","id":72015529,"user":{"login":"vishal08jan","id":10756764,"avatar_url":"https://avatars.githubusercontent.com/u/10756764?v=3","gravatar_id":"","url":"https://api.github.com/users/vishal08jan","html_url":"https://github.com/vishal08jan","followers_url":"https://api.github.com/users/vishal08jan/followers","following_url":"https://api.github.com/users/vishal08jan/following{/other_user}","gists_url":"https://api.github.com/users/vishal08jan/gists{/gist_id}","starred_url":"https://api.github.com/users/vishal08jan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/vishal08jan/subscriptions","organizations_url":"https://api.github.com/users/vishal08jan/orgs","repos_url":"https://api.github.com/users/vishal08jan/repos","events_url":"https://api.github.com/users/vishal08jan/events{/privacy}","received_events_url":"https://api.github.com/users/vishal08jan/received_events","type":"User","site_admin":false},"created_at":"2015-01-29T12:21:27Z","updated_at":"2015-01-29T12:21:27Z","body":"Hi \r\n\r\nyes the plugin is 5.6 compatible.Errors from Error log:\r\n\r\n2015-01-29 16:49:48 64349 [Note] Audit Plugin: starting up. Version: 1.0.6 , Revision: 491 (64bit). AUDIT plugin interface version: 769 (0x301). MySQL Server version: 5.6.22-log.\r\n2015-01-29 16:49:48 64349 [Note] Audit Plugin: setup_offsets audit_offsets: (null) validate_checksum: 1 offsets_by_version: 1\r\n2015-01-29 16:49:49 64349 [Note] Audit Plugin: mysqld: /usr/local/mysql-5.6.22-linux-glibc2.5-x86_64/bin/mysqld (e1106bb336a206d1be38c365013523bc)\r\n2015-01-29 16:49:49 64349 [Note] Audit Plugin: Couldn't find proper THD offsets for: 5.6.22-log\r\n2015-01-29 16:49:49 64349 [ERROR] Plugin 'AUDIT' init function returned error.\r\n2015-01-29 16:49:49 64349 [ERROR] Plugin 'AUDIT' registration as a AUDIT failed.\r\n2015-01-29 16:49:49 64349 [Note] Shutting down plugin 'AUDIT'\r\n2015-01-29 16:49:49 64349 [Note] Audit Plugin: deinit\r\n \r\nI have a running mysql 5.5 and have audit running on it with plugin file for 5.5  placed in /usr/lib64/mysql/plugin/ and i have placed the audit plugin for 5.6 file in /usr/local/mysql/lib/plugin/.\r\nall the binary files for mysql 5.6 are placed in /usr/local/mysql.\r\n\r\nI am not sure where to place the plugin file for mysql 5.6."}}