Score:0

How to insert audit filters into community edition?

in flag

When it comes to auditing, majority of documentation I find pertains to enterprise edition, not community. It is a different plugin and as such not all information I read matches up. Running MariaDB 10.3 with the server audit plugin (1.4 I believe). Enterprise documentation says I can insert filters (in json) into the mysql.server_audit_filters table. However, I have no such table. I can't find anything about how I can implement filters into the non-enterprise edition. In fact, I can't see any tables in the mysql database that relate to the audit plugin. Can someone point me in the right direction? Does this plugin simply have its own set of fixed filters and cannot be altered?

ua flag
"Free" products need a way to make money.
Phaelax z avatar
in flag
Uh ok? Not sure what free has to do with my question.
ua flag
"Community" is 'free'; "Enterprise" is not. The latter has plugins that the former does not have.
Phaelax z avatar
in flag
no kidding. I suppose that's why I mentioned the alternative plugin and asked about it.
danblack avatar
dz flag
Right direction? [Here's some code](https://github.com/MariaDB/server/blob/11.2/plugin/server_audit/server_audit.c), you can write the required features yourself. Please do make it into a free available product when you're finished. I hear there's quite a demand.
Phaelax z avatar
in flag
A simple "no that plugin can not do that, it logs everything by default" would have sufficed instead of a bunch of smartass answers.
I sit in a Tesla and translated this thread with Ai:

mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.