[MXS-591] Inject comment into query for auditing purposes Created: 2016-02-25  Updated: 2018-06-13  Resolved: 2018-06-13

Status: Closed
Project: MariaDB MaxScale
Component/s: Filter
Affects Version/s: None
Fix Version/s: 2.3.0

Type: New Feature Priority: Major
Reporter: Michaël de groot Assignee: Marko Rajala (Inactive)
Resolution: Fixed Votes: 1
Labels: gsoc16

Sprint: MXS-SPRINT-60

 Description   

Hi everybody,

I would like MaxScale to add a query comment with some information that can be used for auditing.
I would like to be able to add the IP address, MaxScale service responsible. Perhaps you have some ideas for other information to add?

Thank you,
Michael

 Comments   
Comment by markus makela [ 2016-03-21 ]

There are a few ways this filter could work for auditing.

  • Injects one or more queries before the client session starts
  • Add comments to queries

Adding comments to queries seems like the simpler option and makes for a more robust filter. The filter should allow users to define the comments and what goes in them. Some sort of variable expansion should also be possible similar to how monitors expand server addresses for launchable scripts: https://mariadb.com/kb/en/mariadb-enterprise/mariadb-maxscale/common-monitor-parameters/

Generated at Thu Feb 08 04:00:28 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.