[
https://issues.apache.org/jira/browse/CASSANDRA-12151?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16431899#comment-16431899
]
Stefan Podkowinski commented on CASSANDRA-12151:
------------------------------------------------
The native transport integration for diagnostic events is basically just
pushing events one by one over the control connection to the subscribed client.
It's not really designed as a generic, fully scalable server-side data push
solution. There are also no delivery guarantees, as it's really just supposed
for debugging and analysis and not for implementing any control instances on
top if it. The use case I have in mind is to have 1-2 clients subscribing to
some kind of event, either ad-hoc or constantly running in the background. But
I don't really see any use case for having a large fanout of e.g. compaction
events. For that, the solution proposed in CASSANDRA-13459 should be
sufficient. But we should probably discuss further details there, as it's
slightly off-topic for this ticket.
{quote}I think specifying a shell script is probably OK although if someone
specifies the script we should run it immediately once Chronicle rolls the
file. Also if the script is specified we probably shouldn't delete artifacts.
{quote}
I've created a new ticket (CASSANDRA-14373) for this, as it's not strictly an
auditing feature.
> Audit logging for database activity
> -----------------------------------
>
> Key: CASSANDRA-12151
> URL: https://issues.apache.org/jira/browse/CASSANDRA-12151
> Project: Cassandra
> Issue Type: New Feature
> Reporter: stefan setyadi
> Assignee: Vinay Chella
> Priority: Major
> Fix For: 4.x
>
> Attachments: 12151.txt, CASSANDRA_12151-benchmark.html,
> DesignProposal_AuditingFeature_ApacheCassandra_v1.docx
>
>
> we would like a way to enable cassandra to log database activity being done
> on our server.
> It should show username, remote address, timestamp, action type, keyspace,
> column family, and the query statement.
> it should also be able to log connection attempt and changes to the
> user/roles.
> I was thinking of making a new keyspace and insert an entry for every
> activity that occurs.
> Then It would be possible to query for specific activity or a query targeting
> a specific keyspace and column family.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
