Type:
Priority:
Resolution:
Unresolved
Fix Version/s:
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
A lot of desired features of the audit plugin are stalled as the current API doesn't provide necessary capabilities.
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
I don't think there is any reason to extend the structures that are sent to the auditing
made changes -
2014-01-29 10:10
Fix Version/s
5.5.36
[ 14600
]
Fix Version/s
5.5.35
[ 14000
]
made changes -
2014-02-20 20:42
Fix Version/s
5.5.37
[ 15000
]
Fix Version/s
5.5.36
[ 14600
]
made changes -
2014-04-15 23:53
Fix Version/s
5.5.38
[ 15400
]
Fix Version/s
5.5.37
[ 15000
]
made changes -
2014-05-29 18:25
Fix Version/s
5.5.39
[ 15800
]
Fix Version/s
5.5.38
[ 15400
]
made changes -
2014-06-13 15:06
Workflow
defaullt
[ 29810
]
MariaDB v2
[ 43937
]
made changes -
2015-12-05 11:22
Assignee
Sergei Golubchik
[ serg
]
made changes -
2015-12-15 16:13
Assignee
Alexey Botchkov
[ holyfoot
]
made changes -
2016-02-16 16:08
Status
Open
[ 1
]
In Progress
[ 3
]
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
]
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
]
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
]
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
]
made changes -
2016-06-13 19:40
Assignee
Alexey Botchkov
[ holyfoot
]
Sergei Golubchik
[ serg
]
made changes -
2016-06-13 19:40
Status
In Progress
[ 3
]
In Review
[ 10002
]
made changes -
2016-06-13 19:40
Fix Version/s
10.2
[ 14601
]
Fix Version/s
5.5
[ 15800
]
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
]
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
]
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
]
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
]
made changes -
2016-12-27 16:24
Fix Version/s
10.3
[ 22126
]
Fix Version/s
10.2
[ 14601
]
made changes -
2018-02-14 17:26
Fix Version/s
10.4
[ 22408
]
Fix Version/s
10.3
[ 22126
]
made changes -
2018-07-05 12:56
Epic Link
PT-73
[ 68549
]
made changes -
2018-08-23 13:43
Assignee
Sergei Golubchik
[ serg
]
Alexey Botchkov
[ holyfoot
]
Status
In Review
[ 10002
]
Stalled
[ 10000
]
made changes -
2018-11-27 14:04
Summary
merge audit api changes from 5.5.34
Improving merge audit api.
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.
made changes -
2018-12-02 23:13
Status
Stalled
[ 10000
]
In Progress
[ 3
]
made changes -
2018-12-02 23:15
Assignee
Alexey Botchkov
[ holyfoot
]
Sergei Golubchik
[ serg
]
Status
In Progress
[ 3
]
In Review
[ 10002
]
made changes -
2018-12-10 10:30
Assignee
Sergei Golubchik
[ serg
]
Alexey Botchkov
[ holyfoot
]
Status
In Review
[ 10002
]
Stalled
[ 10000
]
made changes -
2018-12-11 22:26
Summary
Improving merge audit api.
Improving audit api.
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
]
made changes -
2018-12-12 12:32
Resolution
Fixed
[ 1
]
Status
Closed
[ 6
]
Stalled
[ 10000
]
made changes -
2018-12-12 12:32
Fix Version/s
10.4
[ 22408
]
Fix Version/s
10.4.0
[ 23115
]
made changes -
2019-01-08 10:15
Priority
Major
[ 3
]
Critical
[ 2
]
made changes -
2019-01-10 12:13
Component/s
Plugin - Audit
[ 10131
]
made changes -
2019-01-15 13:20
Status
Stalled
[ 10000
]
In Progress
[ 3
]
made changes -
2019-01-19 23:24
Assignee
Alexey Botchkov
[ holyfoot
]
Sergei Golubchik
[ serg
]
Status
In Progress
[ 3
]
In Review
[ 10002
]
made changes -
2019-01-29 16:33
Assignee
Sergei Golubchik
[ serg
]
Alexey Botchkov
[ holyfoot
]
Status
In Review
[ 10002
]
Stalled
[ 10000
]
made changes -
2019-02-01 13:23
Status
Stalled
[ 10000
]
In Progress
[ 3
]
made changes -
2019-05-07 20:44
Link
This issue blocks MENT-56
[ MENT-56
]
made changes -
2019-05-23 09:29
Priority
Critical
[ 2
]
Blocker
[ 1
]
made changes -
2019-06-04 05:36
Link
This issue blocks MENT-116
[ MENT-116
]
made changes -
2019-06-11 13:42
Fix Version/s
10.5
[ 23123
]
Fix Version/s
10.4
[ 22408
]
made changes -
2019-06-21 17:37
Epic Link
PT-73
[ 68549
]
made changes -
2019-08-05 15:36
Priority
Blocker
[ 1
]
Major
[ 3
]
made changes -
2019-08-05 15:36
Status
In Progress
[ 3
]
Stalled
[ 10000
]
made changes -
2019-12-05 13:18
Priority
Major
[ 3
]
Critical
[ 2
]
made changes -
2020-05-05 07:22
Link
This issue blocks MENT-56
[ MENT-56
]
made changes -
2020-05-05 07:22
Link
This issue blocks MENT-116
[ MENT-116
]
made changes -
2021-06-03 18:15
Summary
Improving audit api.
Improving audit api
made changes -
2021-12-06 21:22
Workflow
MariaDB v3
[ 63173
]
MariaDB v4
[ 131629
]
made changes -
2023-04-11 16:55
Assignee
Alexey Botchkov
[ holyfoot
]
Dmitry Shulga
[ JIRAUSER47315
]
made changes -
2024-09-11 17:07
Priority
Major
[ 3
]
Critical
[ 2
]
{"report":{"fcp":1381.8000001907349,"ttfb":577.5,"pageVisibility":"visible","entityId":26510,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":32,"apdex":0.5,"journeyId":"50fbf0fb-7942-4acb-8f16-e91379cfcfc0","navigationType":0,"readyForUser":1480.0999999046326,"redirectCount":0,"resourceLoadedEnd":1290.5,"resourceLoadedStart":583.5999999046326,"resourceTiming":[{"duration":202,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":583.5999999046326,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":583.5999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":785.5999999046326,"responseStart":0,"secureConnectionStart":0},{"duration":202.19999980926514,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2cib/820016/12ta74/494e4c556ecbb29f90a3d3b4f09cb99c/_/download/contextbatch/css/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true&whisper-enabled=true","startTime":583.8000001907349,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":583.8000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":786,"responseStart":0,"secureConnectionStart":0},{"duration":301.59999990463257,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":584.0999999046326,"connectEnd":584.0999999046326,"connectStart":584.0999999046326,"domainLookupEnd":584.0999999046326,"domainLookupStart":584.0999999046326,"fetchStart":584.0999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":789.0999999046326,"responseEnd":885.6999998092651,"responseStart":800.9000000953674,"secureConnectionStart":584.0999999046326},{"duration":432.09999990463257,"initiatorType":"script","name":"https://jira.mariadb.org/s/2d8175ec2fa4c816e8023260bd8c1786-CDN/lu2cib/820016/12ta74/494e4c556ecbb29f90a3d3b4f09cb99c/_/download/contextbatch/js/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true&whisper-enabled=true","startTime":584.3000001907349,"connectEnd":584.3000001907349,"connectStart":584.3000001907349,"domainLookupEnd":584.3000001907349,"domainLookupStart":584.3000001907349,"fetchStart":584.3000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":789.5999999046326,"responseEnd":1016.4000000953674,"responseStart":809.1999998092651,"secureConnectionStart":584.3000001907349},{"duration":219,"initiatorType":"script","name":"https://jira.mariadb.org/s/a9324d6758d385eb45c462685ad88f1d-CDN/lu2cib/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":584.4000000953674,"connectEnd":584.4000000953674,"connectStart":584.4000000953674,"domainLookupEnd":584.4000000953674,"domainLookupStart":584.4000000953674,"fetchStart":584.4000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":790.0999999046326,"responseEnd":803.4000000953674,"responseStart":802.4000000953674,"secureConnectionStart":584.4000000953674},{"duration":220.09999990463257,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":584.5999999046326,"connectEnd":584.5999999046326,"connectStart":584.5999999046326,"domainLookupEnd":584.5999999046326,"domainLookupStart":584.5999999046326,"fetchStart":584.5999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":790.8000001907349,"responseEnd":804.6999998092651,"responseStart":803.5,"secureConnectionStart":584.5999999046326},{"duration":226.09999990463257,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":584.9000000953674,"connectEnd":584.9000000953674,"connectStart":584.9000000953674,"domainLookupEnd":584.9000000953674,"domainLookupStart":584.9000000953674,"fetchStart":584.9000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":791.8000001907349,"responseEnd":811,"responseStart":808.5,"secureConnectionStart":584.9000000953674},{"duration":206.30000019073486,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2cib/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":585,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":585,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":791.3000001907349,"responseStart":0,"secureConnectionStart":0},{"duration":228.60000038146973,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":585.1999998092651,"connectEnd":585.1999998092651,"connectStart":585.1999998092651,"domainLookupEnd":585.1999998092651,"domainLookupStart":585.1999998092651,"fetchStart":585.1999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":794.0999999046326,"responseEnd":813.8000001907349,"responseStart":812.5999999046326,"secureConnectionStart":585.1999998092651},{"duration":207.09999990463257,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2cib/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/css/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.css?jira.create.linked.issue=true","startTime":585.4000000953674,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":585.4000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":792.5,"responseStart":0,"secureConnectionStart":0},{"duration":245.90000009536743,"initiatorType":"script","name":"https://jira.mariadb.org/s/5d5e8fe91fbc506585e83ea3b62ccc4b-CDN/lu2cib/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/js/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.js?jira.create.linked.issue=true&locale=en","startTime":585.5,"connectEnd":585.5,"connectStart":585.5,"domainLookupEnd":585.5,"domainLookupStart":585.5,"fetchStart":585.5,"redirectEnd":0,"redirectStart":0,"requestStart":797.1999998092651,"responseEnd":831.4000000953674,"responseStart":830.1999998092651,"secureConnectionStart":585.5},{"duration":438.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":587.0999999046326,"connectEnd":587.0999999046326,"connectStart":587.0999999046326,"domainLookupEnd":587.0999999046326,"domainLookupStart":587.0999999046326,"fetchStart":587.0999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":927.9000000953674,"responseEnd":1025.5999999046326,"responseStart":1023.1999998092651,"secureConnectionStart":587.0999999046326},{"duration":696.9000000953674,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":593.5999999046326,"connectEnd":593.5999999046326,"connectStart":593.5999999046326,"domainLookupEnd":593.5999999046326,"domainLookupStart":593.5999999046326,"fetchStart":593.5999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":1279.1999998092651,"responseEnd":1290.5,"responseStart":1289.9000000953674,"secureConnectionStart":593.5999999046326},{"duration":287,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":1023.1999998092651,"connectEnd":1023.1999998092651,"connectStart":1023.1999998092651,"domainLookupEnd":1023.1999998092651,"domainLookupStart":1023.1999998092651,"fetchStart":1023.1999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":1279.4000000953674,"responseEnd":1310.1999998092651,"responseStart":1309.5,"secureConnectionStart":1023.1999998092651},{"duration":306,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":1374.0999999046326,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1374.0999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1680.0999999046326,"responseStart":0,"secureConnectionStart":0},{"duration":291.80000019073486,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":1384.6999998092651,"connectEnd":1384.6999998092651,"connectStart":1384.6999998092651,"domainLookupEnd":1384.6999998092651,"domainLookupStart":1384.6999998092651,"fetchStart":1384.6999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":1644.0999999046326,"responseEnd":1676.5,"responseStart":1675.8000001907349,"secureConnectionStart":1384.6999998092651}],"fetchStart":1,"domainLookupStart":1,"domainLookupEnd":1,"connectStart":1,"connectEnd":1,"requestStart":155,"responseStart":578,"responseEnd":592,"domLoading":582,"domInteractive":1688,"domContentLoadedEventStart":1688,"domContentLoadedEventEnd":1774,"domComplete":2235,"loadEventStart":2235,"loadEventEnd":2236,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1603},{"name":"bigPipe.sidebar-id.end","time":1603.8000001907349},{"name":"bigPipe.activity-panel-pipe-id.start","time":1603.9000000953674},{"name":"bigPipe.activity-panel-pipe-id.end","time":1621},{"name":"activityTabFullyLoaded","time":1811.3000001907349}],"measures":[],"correlationId":"61ee6d8e162036","effectiveType":"4g","downlink":9.5,"rtt":0,"serverDuration":355,"dbReadsTimeInMs":100,"dbConnsTimeInMs":118,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Task
Critical
MDEV-19442 server_audit plugin doesn't consider proxy users in server_audit_excl_users/server_audit_incl_users
Patch proposal:
http://lists.askmonty.org/pipermail/commits/2016-February/009025.html