[
https://issues.apache.org/jira/browse/CASSANDRA-16682?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17348833#comment-17348833
]
Sarma Pydipally edited comment on CASSANDRA-16682 at 5/20/21, 11:13 PM:
------------------------------------------------------------------------
$ cat ~/conf/cassandra.yaml | grep excluded_categories
– bad settings : only uses first entry and ignores other values after first
space
excluded_categories: OTHER, QUERY, DDL
excluded_categories: "OTHER, QUERY, DDL"
– correct setting : string_comma_separated_without_spaces
excluded_categories: OTHER,DML,DDL
$
----------------------------
MY TEST RESULTS :
excluded_categories: QUERY,DML
Duration : 90 minutes
Various # Transactions : 80,000
following type of audit logs are recorded :
type:LOGIN_ERROR|category:AUTH
type:LOGIN_SUCCESS|category:AUTH
type:PREPARE_STATEMENT|category:PREPARE
type:USE_KEYSPACE|category:OTHER
NO QUERIES AND DMLS in the audit.log
TEST RESULT : SUCCESSFUL
----------------------------
was (Author: oramad):
$ cat ~/conf/cassandra.yaml | grep excluded_categories
-- bad settings : only uses first entry and ignores other values after first
space
excluded_categories: OTHER, QUERY, DDL
excluded_categories: "OTHER, QUERY, DDL"
-- correct setting : string_comma_separated_without_spaces
excluded_categories: OTHER,DML,DDL
$
----------------------------
MY TEST RESULTS :
excluded_categories: QUERY,DML
Duration : 90 minutes
Various # Transactions : 80,000
following type of audit logs are recorded :
type:LOGIN_ERROR|category:AUTH
type:LOGIN_SUCCESS|category:AUTH
type:PREPARE_STATEMENT|category:PREPARE
type:USE_KEYSPACE|category:OTHER
NO QUERIES AND DMLS
TEST RESULT : SUCCESSFUL
----------------------------
> Cassandra 4.0 RC1 ... Audit Logs going to wrong location
> --------------------------------------------------------
>
> Key: CASSANDRA-16682
> URL: https://issues.apache.org/jira/browse/CASSANDRA-16682
> Project: Cassandra
> Issue Type: Bug
> Components: Tool/auditlogging
> Reporter: Sarma Pydipally
> Assignee: Ekaterina Dimitrova
> Priority: Normal
> Fix For: 4.0-rc
>
>
> Version : Cassandra 4.0 RC1
> Settings in my : <CASSANDRA_HOME>/conf/cassandra.yaml
> {code:yaml}
> audit_logging_options:
> enabled: true
> logger:
> - class_name: FileAuditLogger
> excluded_categories: QUERY, DML
> audit_logs_dir: "/apps/opt/cassandra/logs/audit"
> roll_cycle: DAILY
> block: false
> {code}
> After restart of Cassandra ... I can see the Audit Logs. But they are going
> into system.log and debug.log. They are NOT going into
> {noformat}
> "/apps/opt/cassandra/logs/audit/audit.log"{noformat}
>
> Also noticed that : it does not ignore the "excluded_categories" and logs
> everything ...
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
