[MDEV-5313] Improving audit api - Jira

Details

Type: Task
Status: Stalled (View Workflow)
Priority: Critical
Resolution: Unresolved
Fix Version/s: None
Component/s: Plugin - Audit, Plugins
Labels:
None

Sprint:
5.5.48-0, 10.0.24, 10.2.0-6, 10.2.0-7, 5.5.50, 10.2.2-1, 10.2.2-2, 10.2.2-3, 10.2.2-4

Description

A lot of desired features of the audit plugin are stalled as the current API doesn't provide necessary capabilities.
The list of desired ones:

plugin data can be stored in the server table.
information about user's role
information about the tables/databases involved with the query
possible parser result of the query
export JSON functions
access to the information about the connection
encryption used
authentication method
connection type
connector used

I don't think there is any reason to extend the structures that are sent to the auditing
fucntions. The way to go is creating server functions that can be linken in the plugin - irectly or via the 'service'-s.

Attachments

Issue Links

blocks

MDEV-5983 Auditing plugin v2.0

Closed

MDEV-7389 Request: log warnings into SQL_ERROR_LOG

Closed

relates to

MDEV-5212 Role support for Audit Plugin API

Open

MDEV-10299 Make server_audit plugin support roles

Open

MDEV-12494 Include or exclude host names from auditing

Closed

MDEV-14713 MariaDB Audit Plugin audits SET GLOBAL

Open

MDEV-19442 server_audit plugin doesn't consider proxy users in server_audit_excl_users/server_audit_incl_users

Closed

MDEV-19443 server_audit plugin doesn't log proxy users

Closed

MDEV-19458 server_audit plugin should log when the server starts up and when the server shuts down

Open

MDEV-5216 5.5.34 merge

Closed

MDEV-5652 5.5.36 merge

Closed

(6 relates to)

Activity

Ascending order - Click to sort in descending order

Sergei Golubchik created issue - 2013-11-19 10:24

Sergei Golubchik made changes - 2013-11-19 10:27

Field	Original Value	New Value
Link		This issue relates to ~~MDEV-5216~~ [ ~~MDEV-5216~~ ]

Sergei Golubchik made changes - 2014-01-29 10:10

Fix Version/s		5.5.36 [ 14600 ]
Fix Version/s	5.5.35 [ 14000 ]

Sergei Golubchik made changes - 2014-02-11 16:28

Link

This issue relates to ~~MDEV-5652~~ [ ~~MDEV-5652~~ ]

Sergei Golubchik made changes - 2014-02-20 20:42

Fix Version/s		5.5.37 [ 15000 ]
Fix Version/s	5.5.36 [ 14600 ]

Sergei Golubchik made changes - 2014-04-15 23:53

Fix Version/s		5.5.38 [ 15400 ]
Fix Version/s	5.5.37 [ 15000 ]

Sergei Golubchik made changes - 2014-05-29 18:25

Fix Version/s		5.5.39 [ 15800 ]
Fix Version/s	5.5.38 [ 15400 ]

Sergei Golubchik made changes - 2014-06-13 15:06

Workflow

defaullt [ 29810 ]

MariaDB v2 [ 43937 ]

Sergei Golubchik made changes - 2015-04-28 17:17

Link

This issue blocks ~~MDEV-7389~~ [ ~~MDEV-7389~~ ]

Rasmus Johansson (Inactive) made changes - 2015-05-18 17:51

Workflow

MariaDB v2 [ 43937 ]

MariaDB v3 [ 63173 ]

Sergei Golubchik made changes - 2015-12-05 11:22

Assignee

Sergei Golubchik [ serg ]

Sergei Golubchik made changes - 2015-12-15 16:13

Assignee

Alexey Botchkov [ holyfoot ]

Rasmus Johansson (Inactive) made changes - 2016-02-03 13:43

Sprint

5.5.48-0 [ 33 ]

Rasmus Johansson (Inactive) made changes - 2016-02-03 13:43

Rank

Ranked higher

Rasmus Johansson (Inactive) made changes - 2016-02-10 10:23

Sprint

5.5.48-0 [ 33 ]

5.5.48-0, 10.0.24-0 [ 33, 35 ]

Alexey Botchkov made changes - 2016-02-16 16:08

Status

Open [ 1 ]

In Progress [ 3 ]

Alexey Botchkov made changes - 2016-02-16 19:20

Sprint

5.5.48-0, 10.0.24 [ 33, 35 ]

5.5.48-0, 10.0.24, 10.1.12 [ 33, 35, 36 ]

Alexey Botchkov made changes - 2016-02-23 16:33

Sprint

5.5.48-0, 10.0.24, 10.1.12 [ 33, 35, 36 ]

5.5.48-0, 10.0.24, 10.2.0-6 [ 33, 35, 37 ]

Rasmus Johansson (Inactive) made changes - 2016-03-03 08:12

Sprint

5.5.48-0, 10.0.24, 10.2.0-6 [ 33, 35, 37 ]

5.5.48-0, 10.0.24, 10.2.0-6, 10.2.0-7 [ 33, 35, 37, 39 ]

Rasmus Johansson (Inactive) made changes - 2016-03-03 08:12

Rank

Ranked lower

Rasmus Johansson (Inactive) made changes - 2016-06-08 10:11

Sprint

5.5.48-0, 10.0.24, 10.2.0-6, 10.2.0-7 [ 33, 35, 37, 39 ]

5.5.48-0, 10.0.24, 10.2.0-6, 10.2.0-7, 5.5.50 [ 33, 35, 37, 39, 71 ]

Rasmus Johansson (Inactive) made changes - 2016-06-08 10:11

Rank

Ranked higher

Sergei Golubchik made changes - 2016-06-13 19:40

Assignee

Alexey Botchkov [ holyfoot ]

Sergei Golubchik [ serg ]

Sergei Golubchik made changes - 2016-06-13 19:40

Status

In Progress [ 3 ]

In Review [ 10002 ]

Sergei Golubchik made changes - 2016-06-13 19:40

Fix Version/s		10.2 [ 14601 ]
Fix Version/s	5.5 [ 15800 ]

Rasmus Johansson (Inactive) made changes - 2016-06-29 07:31

Sprint

5.5.48-0, 10.0.24, 10.2.0-6, 10.2.0-7, 5.5.50 [ 33, 35, 37, 39, 71 ]

5.5.48-0, 10.0.24, 10.2.0-6, 10.2.0-7, 5.5.50, 10.2.2-1 [ 33, 35, 37, 39, 71, 77 ]

Rasmus Johansson (Inactive) made changes - 2016-06-29 07:31

Rank

Ranked lower

Rasmus Johansson (Inactive) made changes - 2016-08-31 07:32

Sprint

5.5.48-0, 10.0.24, 10.2.0-6, 10.2.0-7, 5.5.50, 10.2.2-1 [ 33, 35, 37, 39, 71, 77 ]

5.5.48-0, 10.0.24, 10.2.0-6, 10.2.0-7, 5.5.50, 10.2.2-1, 10.2.2-2 [ 33, 35, 37, 39, 71, 77, 92 ]

Rasmus Johansson (Inactive) made changes - 2016-08-31 07:32

Rank

Ranked higher

Rasmus Johansson (Inactive) made changes - 2016-09-08 11:00

Sprint

5.5.48-0, 10.0.24, 10.2.0-6, 10.2.0-7, 5.5.50, 10.2.2-1, 10.2.2-2 [ 33, 35, 37, 39, 71, 77, 92 ]

5.5.48-0, 10.0.24, 10.2.0-6, 10.2.0-7, 5.5.50, 10.2.2-1, 10.2.2-2, 10.2.2-3 [ 33, 35, 37, 39, 71, 77, 92, 94 ]

Rasmus Johansson (Inactive) made changes - 2016-09-14 13:17

Sprint

5.5.48-0, 10.0.24, 10.2.0-6, 10.2.0-7, 5.5.50, 10.2.2-1, 10.2.2-2, 10.2.2-3 [ 33, 35, 37, 39, 71, 77, 92, 94 ]

5.5.48-0, 10.0.24, 10.2.0-6, 10.2.0-7, 5.5.50, 10.2.2-1, 10.2.2-2, 10.2.2-3, 10.2.2-4 [ 33, 35, 37, 39, 71, 77, 92, 94, 96 ]

Sergei Golubchik made changes - 2016-12-27 16:24

Fix Version/s		10.3 [ 22126 ]
Fix Version/s	10.2 [ 14601 ]

Sergei Golubchik made changes - 2017-03-09 11:47

Link

This issue relates to MDEV-12182 [ MDEV-12182 ]

Sergei Golubchik made changes - 2018-02-14 17:26

Fix Version/s		10.4 [ 22408 ]
Fix Version/s	10.3 [ 22126 ]

Julien Fritsch made changes - 2018-07-05 12:56

Epic Link

PT-73 [ 68549 ]

Ralf Gebhardt made changes - 2018-08-23 13:07

Rank

Ranked higher

Sergei Golubchik made changes - 2018-08-23 13:43

Assignee	Sergei Golubchik [ serg ]	Alexey Botchkov [ holyfoot ]
Status	In Review [ 10002 ]	Stalled [ 10000 ]

Sergei Golubchik made changes - 2018-11-12 09:32

Link

This issue blocks MDEV-12182 [ MDEV-12182 ]

Sergei Golubchik made changes - 2018-11-12 09:32

Link

This issue relates to MDEV-12182 [ MDEV-12182 ]

Ralf Gebhardt made changes - 2018-11-13 07:08

Rank

Ranked higher

Ralf Gebhardt made changes - 2018-11-13 13:31

Rank

Ranked higher

Alexey Botchkov made changes - 2018-11-27 14:04

Summary

merge audit api changes from 5.5.34

Improving merge audit api.

Alexey Botchkov made changes - 2018-11-27 14:17

Description

merge audit api changes from 5.5.34

A lot of desired features of the audit plugin are stalled as the current API doesn't provide necessary capabilities.
The list of desired ones:
  - plugin data can be stored in the server table.
  - information about user's role
  - information about the tables/databases involved with the query
  - possible parser result of the query
  - export JSON functions
  - access to the information about the connection
      encryption used
      authentication method
      connection type
      connector used

I don't think there is any reason to extend the structures that are sent to the auditing
fucntions. The way to go is creating server functions that can be linken in the plugin - irectly or via the 'service'-s.

Alexey Botchkov made changes - 2018-12-02 23:13

Status

Stalled [ 10000 ]

In Progress [ 3 ]

Alexey Botchkov made changes - 2018-12-02 23:15

Assignee	Alexey Botchkov [ holyfoot ]	Sergei Golubchik [ serg ]
Status	In Progress [ 3 ]	In Review [ 10002 ]

Sergei Golubchik made changes - 2018-12-10 10:30

Assignee	Sergei Golubchik [ serg ]	Alexey Botchkov [ holyfoot ]
Status	In Review [ 10002 ]	Stalled [ 10000 ]

Alexey Botchkov made changes - 2018-12-11 22:26

Summary

Improving merge audit api.

Improving audit api.

Alexey Botchkov made changes - 2018-12-12 10:37

Component/s		Plugins [ 10118 ]
Fix Version/s		10.4.0 [ 23115 ]
Fix Version/s	10.4 [ 22408 ]
Resolution		Fixed [ 1 ]
Status	Stalled [ 10000 ]	Closed [ 6 ]

Sergei Golubchik made changes - 2018-12-12 12:32

Resolution	Fixed [ 1 ]
Status	Closed [ 6 ]	Stalled [ 10000 ]

Sergei Golubchik made changes - 2018-12-12 12:32

Fix Version/s		10.4 [ 22408 ]
Fix Version/s	10.4.0 [ 23115 ]

Ralf Gebhardt made changes - 2019-01-08 10:15

Priority

Major [ 3 ]

Critical [ 2 ]

Ralf Gebhardt made changes - 2019-01-10 12:13

Component/s

Plugin - Audit [ 10131 ]

Alexey Botchkov made changes - 2019-01-15 13:20

Status

Stalled [ 10000 ]

In Progress [ 3 ]

Alexey Botchkov made changes - 2019-01-19 23:24

Assignee	Alexey Botchkov [ holyfoot ]	Sergei Golubchik [ serg ]
Status	In Progress [ 3 ]	In Review [ 10002 ]

Alexey Botchkov made changes - 2019-01-22 20:08

Link

This issue blocks ~~MDEV-5983~~ [ ~~MDEV-5983~~ ]

Sergei Golubchik made changes - 2019-01-29 16:33

Assignee	Sergei Golubchik [ serg ]	Alexey Botchkov [ holyfoot ]
Status	In Review [ 10002 ]	Stalled [ 10000 ]

Alexey Botchkov made changes - 2019-02-01 13:23

Status

Stalled [ 10000 ]

In Progress [ 3 ]

Ralf Gebhardt made changes - 2019-05-07 20:44

Link

This issue blocks MENT-56 [ MENT-56 ]

Geoff Montee (Inactive) made changes - 2019-05-14 17:38

Link

This issue relates to ~~MDEV-19442~~ [ ~~MDEV-19442~~ ]

Geoff Montee (Inactive) made changes - 2019-05-14 17:38

Link

This issue relates to ~~MDEV-19443~~ [ ~~MDEV-19443~~ ]

Geoff Montee (Inactive) made changes - 2019-05-14 17:38

Link

This issue relates to MDEV-14713 [ MDEV-14713 ]

Geoff Montee (Inactive) made changes - 2019-05-14 17:38

Link

This issue relates to MDEV-5212 [ MDEV-5212 ]

Geoff Montee (Inactive) made changes - 2019-05-14 17:38

Link

This issue relates to ~~MDEV-12494~~ [ ~~MDEV-12494~~ ]

Geoff Montee (Inactive) made changes - 2019-05-14 17:38

Link

This issue relates to MDEV-10299 [ MDEV-10299 ]

Geoff Montee (Inactive) made changes - 2019-05-14 17:38

Link

This issue relates to MDEV-19458 [ MDEV-19458 ]

Julien Fritsch made changes - 2019-05-23 09:29

Priority

Critical [ 2 ]

Blocker [ 1 ]

Ralf Gebhardt made changes - 2019-06-04 05:36

Link

This issue blocks MENT-116 [ MENT-116 ]

Sergei Golubchik made changes - 2019-06-11 13:42

Fix Version/s		10.5 [ 23123 ]
Fix Version/s	10.4 [ 22408 ]

Ralf Gebhardt made changes - 2019-06-21 17:37

Epic Link

PT-73 [ 68549 ]

Sergei Golubchik made changes - 2019-08-05 15:36

Priority

Blocker [ 1 ]

Major [ 3 ]

Sergei Golubchik made changes - 2019-08-05 15:36

Fix Version/s

10.5 [ 23123 ]

Sergei Golubchik made changes - 2019-08-05 15:36

Status

In Progress [ 3 ]

Stalled [ 10000 ]

Julien Fritsch made changes - 2019-12-05 13:18

Priority

Major [ 3 ]

Critical [ 2 ]

Julien Fritsch made changes - 2020-05-05 07:22

Link

This issue blocks MENT-56 [ MENT-56 ]

Julien Fritsch made changes - 2020-05-05 07:22

Link

This issue blocks MENT-116 [ MENT-116 ]

Sergei Golubchik made changes - 2021-06-03 18:15

Summary

Improving audit api.

Improving audit api

Sergei Golubchik made changes - 2021-12-06 21:22

Workflow

MariaDB v3 [ 63173 ]

MariaDB v4 [ 131629 ]

Julien Fritsch made changes - 2023-04-11 16:55

Assignee

Alexey Botchkov [ holyfoot ]

Dmitry Shulga [ JIRAUSER47315 ]

Ralf Gebhardt made changes - 2023-04-24 16:53

Assignee	Dmitry Shulga [ JIRAUSER47315 ]	Ralf Gebhardt [ ralf.gebhardt@mariadb.com ]
Priority	Critical [ 2 ]	Major [ 3 ]

Ralf Gebhardt made changes - 2023-04-24 17:56

Assignee

Ralf Gebhardt [ ralf.gebhardt@mariadb.com ]

Daniel Black made changes - 2024-04-05 11:03

Link

This issue relates to MDEV-33834 [ MDEV-33834 ]

Sergei Golubchik made changes - 2024-09-11 13:13

Link

This issue blocks MDEV-33834 [ MDEV-33834 ]

Sergei Golubchik made changes - 2024-09-11 13:13

Link

This issue relates to MDEV-33834 [ MDEV-33834 ]

JiraAutomate made changes - 2024-09-11 17:07

Priority

Major [ 3 ]

Critical [ 2 ]

Julien Fritsch made changes - 2024-10-03 08:40

Assignee

Ralf Gebhardt [ ralf.gebhardt@mariadb.com ]

Sergei Golubchik made changes - 2024-12-03 18:39

Link

This issue blocks MDEV-33834 [ MDEV-33834 ]

Sergei Golubchik made changes - 2025-03-10 19:36

Link

This issue blocks MDEV-12182 [ MDEV-12182 ]

People

Assignee:: Ralf Gebhardt

Reporter:: Sergei Golubchik

Votes:: 0 Vote for this issue

Watchers:: 5 Start watching this issue

Dates

Created:: 2013-11-19 10:24

Updated:: 2025-03-17 00:06

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server

Details

Description

Attachments

Issue Links

Activity

People

Dates

Git Integration