123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565 |
- #ifndef _my_audit_h
- #define _my_audit_h
- #include "plugin.h"
- #include "mysql/mysql_lex_string.h"
- #ifndef MYSQL_ABI_CHECK
- #include "m_string.h"
- #endif
- #include "my_command.h"
- #include "my_sqlcommand.h"
- #define MYSQL_AUDIT_INTERFACE_VERSION 0x0401
- typedef enum
- {
- MYSQL_AUDIT_GENERAL_CLASS = 0,
- MYSQL_AUDIT_CONNECTION_CLASS = 1,
- MYSQL_AUDIT_PARSE_CLASS = 2,
- MYSQL_AUDIT_AUTHORIZATION_CLASS = 3,
- MYSQL_AUDIT_TABLE_ACCESS_CLASS = 4,
- MYSQL_AUDIT_GLOBAL_VARIABLE_CLASS = 5,
- MYSQL_AUDIT_SERVER_STARTUP_CLASS = 6,
- MYSQL_AUDIT_SERVER_SHUTDOWN_CLASS = 7,
- MYSQL_AUDIT_COMMAND_CLASS = 8,
- MYSQL_AUDIT_QUERY_CLASS = 9,
- MYSQL_AUDIT_STORED_PROGRAM_CLASS = 10,
-
- MYSQL_AUDIT_CLASS_MASK_SIZE
- } mysql_event_class_t;
- struct st_mysql_audit
- {
-
- int interface_version;
-
- void (*release_thd)(MYSQL_THD);
-
- int (*event_notify)(MYSQL_THD, mysql_event_class_t, const void *);
-
- unsigned long class_mask[MYSQL_AUDIT_CLASS_MASK_SIZE];
- };
- typedef enum enum_sql_command enum_sql_command_t;
- typedef enum
- {
-
- MYSQL_AUDIT_GENERAL_LOG = 1 << 0,
-
- MYSQL_AUDIT_GENERAL_ERROR = 1 << 1,
-
- MYSQL_AUDIT_GENERAL_RESULT = 1 << 2,
-
- MYSQL_AUDIT_GENERAL_STATUS = 1 << 3
- } mysql_event_general_subclass_t;
- #define MYSQL_AUDIT_GENERAL_ALL (MYSQL_AUDIT_GENERAL_LOG | \
- MYSQL_AUDIT_GENERAL_ERROR | \
- MYSQL_AUDIT_GENERAL_RESULT | \
- MYSQL_AUDIT_GENERAL_STATUS)
- struct mysql_event_general
- {
- mysql_event_general_subclass_t event_subclass;
- int general_error_code;
- unsigned long general_thread_id;
- MYSQL_LEX_CSTRING general_user;
- MYSQL_LEX_CSTRING general_command;
- MYSQL_LEX_CSTRING general_query;
- struct charset_info_st *general_charset;
- unsigned long long general_time;
- unsigned long long general_rows;
- MYSQL_LEX_CSTRING general_host;
- MYSQL_LEX_CSTRING general_sql_command;
- MYSQL_LEX_CSTRING general_external_user;
- MYSQL_LEX_CSTRING general_ip;
- };
- typedef enum
- {
-
- MYSQL_AUDIT_CONNECTION_CONNECT = 1 << 0,
-
- MYSQL_AUDIT_CONNECTION_DISCONNECT = 1 << 1,
-
- MYSQL_AUDIT_CONNECTION_CHANGE_USER = 1 << 2,
-
- MYSQL_AUDIT_CONNECTION_PRE_AUTHENTICATE = 1 << 3
- } mysql_event_connection_subclass_t;
- #define MYSQL_AUDIT_CONNECTION_ALL (MYSQL_AUDIT_CONNECTION_CONNECT | \
- MYSQL_AUDIT_CONNECTION_DISCONNECT | \
- MYSQL_AUDIT_CONNECTION_CHANGE_USER | \
- MYSQL_AUDIT_CONNECTION_PRE_AUTHENTICATE)
- struct mysql_event_connection
- {
-
- mysql_event_connection_subclass_t event_subclass;
-
- int status;
-
- unsigned long connection_id;
-
- MYSQL_LEX_CSTRING user;
-
- MYSQL_LEX_CSTRING priv_user;
-
- MYSQL_LEX_CSTRING external_user;
-
- MYSQL_LEX_CSTRING proxy_user;
-
- MYSQL_LEX_CSTRING host;
-
- MYSQL_LEX_CSTRING ip;
-
- MYSQL_LEX_CSTRING database;
-
- int connection_type;
- };
- typedef enum
- {
-
- MYSQL_AUDIT_PARSE_PREPARSE = 1 << 0,
-
- MYSQL_AUDIT_PARSE_POSTPARSE = 1 << 1
- } mysql_event_parse_subclass_t;
- #define MYSQL_AUDIT_PARSE_ALL (MYSQL_AUDIT_PARSE_PREPARSE | \
- MYSQL_AUDIT_PARSE_POSTPARSE)
- typedef enum
- {
- MYSQL_AUDIT_PARSE_REWRITE_PLUGIN_NONE = 0,
-
- MYSQL_AUDIT_PARSE_REWRITE_PLUGIN_QUERY_REWRITTEN = 1 << 0,
-
- MYSQL_AUDIT_PARSE_REWRITE_PLUGIN_IS_PREPARED_STATEMENT = 1 << 1
- } mysql_event_parse_rewrite_plugin_flag;
- struct mysql_event_parse
- {
-
- mysql_event_parse_subclass_t event_subclass;
-
- mysql_event_parse_rewrite_plugin_flag *flags;
-
- MYSQL_LEX_CSTRING query;
-
- MYSQL_LEX_CSTRING *rewritten_query;
- };
- typedef enum
- {
- MYSQL_AUDIT_AUTHORIZATION_USER = 1 << 0,
-
- MYSQL_AUDIT_AUTHORIZATION_DB = 1 << 1,
-
- MYSQL_AUDIT_AUTHORIZATION_TABLE = 1 << 2,
-
- MYSQL_AUDIT_AUTHORIZATION_COLUMN = 1 << 3,
-
- MYSQL_AUDIT_AUTHORIZATION_PROCEDURE = 1 << 4,
-
- MYSQL_AUDIT_AUTHORIZATION_PROXY = 1 << 5
- } mysql_event_authorization_subclass_t;
- #define MYSQL_AUDIT_AUTHORIZATION_ALL (MYSQL_AUDIT_AUTHORIZATION_USER | \
- MYSQL_AUDIT_AUTHORIZATION_DB | \
- MYSQL_AUDIT_AUTHORIZATION_TABLE | \
- MYSQL_AUDIT_AUTHORIZATION_COLUMN | \
- MYSQL_AUDIT_AUTHORIZATION_PROCEDURE | \
- MYSQL_AUDIT_AUTHORIZATION_PROXY)
- struct mysql_event_authorization
- {
-
- mysql_event_authorization_subclass_t event_subclass;
-
- int status;
-
- unsigned int connection_id;
-
- enum_sql_command_t sql_command_id;
-
- MYSQL_LEX_CSTRING query;
-
- const struct charset_info_st *query_charset;
-
- MYSQL_LEX_CSTRING database;
-
- MYSQL_LEX_CSTRING table;
-
- MYSQL_LEX_CSTRING object;
-
- unsigned long requested_privilege;
-
- unsigned long granted_privilege;
- };
- typedef enum
- {
-
- MYSQL_AUDIT_TABLE_ACCESS_READ = 1 << 0,
-
- MYSQL_AUDIT_TABLE_ACCESS_INSERT = 1 << 1,
-
- MYSQL_AUDIT_TABLE_ACCESS_UPDATE = 1 << 2,
-
- MYSQL_AUDIT_TABLE_ACCESS_DELETE = 1 << 3
- } mysql_event_table_access_subclass_t;
- #define MYSQL_AUDIT_TABLE_ACCESS_ALL (MYSQL_AUDIT_TABLE_ACCESS_READ | \
- MYSQL_AUDIT_TABLE_ACCESS_INSERT | \
- MYSQL_AUDIT_TABLE_ACCESS_UPDATE | \
- MYSQL_AUDIT_TABLE_ACCESS_DELETE)
- struct mysql_event_table_access
- {
-
- mysql_event_table_access_subclass_t event_subclass;
-
- unsigned long connection_id;
-
- enum_sql_command_t sql_command_id;
-
- MYSQL_LEX_CSTRING query;
-
- const struct charset_info_st *query_charset;
-
- MYSQL_LEX_CSTRING table_database;
-
- MYSQL_LEX_CSTRING table_name;
- };
- typedef enum
- {
-
- MYSQL_AUDIT_GLOBAL_VARIABLE_GET = 1 << 0,
-
- MYSQL_AUDIT_GLOBAL_VARIABLE_SET = 1 << 1
- } mysql_event_global_variable_subclass_t;
- #define MYSQL_AUDIT_GLOBAL_VARIABLE_ALL (MYSQL_AUDIT_GLOBAL_VARIABLE_GET | \
- MYSQL_AUDIT_GLOBAL_VARIABLE_SET)
- struct mysql_event_global_variable
- {
-
- mysql_event_global_variable_subclass_t event_subclass;
-
- unsigned long connection_id;
-
- enum_sql_command_t sql_command_id;
-
- MYSQL_LEX_CSTRING variable_name;
-
- MYSQL_LEX_CSTRING variable_value;
- };
- typedef enum
- {
-
- MYSQL_AUDIT_SERVER_STARTUP_STARTUP = 1 << 0
- } mysql_event_server_startup_subclass_t;
- #define MYSQL_AUDIT_SERVER_STARTUP_ALL (MYSQL_AUDIT_SERVER_STARTUP_STARTUP)
- struct mysql_event_server_startup
- {
-
- mysql_event_server_startup_subclass_t event_subclass;
-
- const char **argv;
-
- unsigned int argc;
- };
- typedef enum
- {
-
- MYSQL_AUDIT_SERVER_SHUTDOWN_SHUTDOWN = 1 << 0
- } mysql_event_server_shutdown_subclass_t;
- #define MYSQL_AUDIT_SERVER_SHUTDOWN_ALL (MYSQL_AUDIT_SERVER_SHUTDOWN_SHUTDOWN)
- typedef enum
- {
-
- MYSQL_AUDIT_SERVER_SHUTDOWN_REASON_SHUTDOWN,
-
- MYSQL_AUDIT_SERVER_SHUTDOWN_REASON_ABORT
- } mysql_server_shutdown_reason_t;
- struct mysql_event_server_shutdown
- {
-
- mysql_event_server_shutdown_subclass_t event_subclass;
-
- int exit_code;
-
- mysql_server_shutdown_reason_t reason;
- };
- typedef enum
- {
-
- MYSQL_AUDIT_COMMAND_START = 1 << 0,
-
- MYSQL_AUDIT_COMMAND_END = 1 << 1
- } mysql_event_command_subclass_t;
- #define MYSQL_AUDIT_COMMAND_ALL (MYSQL_AUDIT_COMMAND_START | \
- MYSQL_AUDIT_COMMAND_END)
- typedef enum enum_server_command enum_server_command_t;
- struct mysql_event_command
- {
-
- mysql_event_command_subclass_t event_subclass;
-
- int status;
-
- unsigned long connection_id;
-
- enum_server_command_t command_id;
- };
- typedef enum
- {
-
- MYSQL_AUDIT_QUERY_START = 1 << 0,
-
- MYSQL_AUDIT_QUERY_NESTED_START = 1 << 1,
-
- MYSQL_AUDIT_QUERY_STATUS_END = 1 << 2,
-
- MYSQL_AUDIT_QUERY_NESTED_STATUS_END = 1 << 3
- } mysql_event_query_subclass_t;
- #define MYSQL_AUDIT_QUERY_ALL (MYSQL_AUDIT_QUERY_START | \
- MYSQL_AUDIT_QUERY_NESTED_START | \
- MYSQL_AUDIT_QUERY_STATUS_END | \
- MYSQL_AUDIT_QUERY_NESTED_STATUS_END)
- struct mysql_event_query
- {
-
- mysql_event_query_subclass_t event_subclass;
-
- int status;
-
- unsigned long connection_id;
-
- enum_sql_command_t sql_command_id;
-
- MYSQL_LEX_CSTRING query;
-
- const struct charset_info_st *query_charset;
- };
- typedef enum
- {
-
- MYSQL_AUDIT_STORED_PROGRAM_EXECUTE = 1 << 0
- } mysql_event_stored_program_subclass_t;
- #define MYSQL_AUDIT_STORED_PROGRAM_ALL (MYSQL_AUDIT_STORED_PROGRAM_EXECUTE)
- struct mysql_event_stored_program
- {
-
- mysql_event_stored_program_subclass_t event_subclass;
-
- unsigned long connection_id;
-
- enum_sql_command_t sql_command_id;
-
- MYSQL_LEX_CSTRING query;
-
- const struct charset_info_st *query_charset;
-
- MYSQL_LEX_CSTRING database;
-
- MYSQL_LEX_CSTRING name;
-
- void *parameters;
- };
- #endif
|