Thanks Tyler Hobbs.
We need to capture what are the queries ran by a user in a session and its time taken. (don't need query plan or so). Is that possible? With Authenticator we can capture only the session creation right? Thanks Ajay On Sat, Jan 10, 2015 at 6:07 AM, Tyler Hobbs <ty...@datastax.com> wrote: > system_traces is for query tracing, which is for diagnosing performance > problems, not logging activity. > > Cassandra is designed to allow you to write your own Authenticator pretty > easily. You can just subclass PasswordAuthenticator and add logging where > desired. Compile that into a jar, put it in the lib/ directory for > Cassandra, and change cassandra.yaml to use that class. > > On Thu, Jan 8, 2015 at 6:34 AM, Ajay <ajay.ga...@gmail.com> wrote: > >> Hi, >> >> Is there a way to enable user audit or trace if we have enabled >> PasswordAuthenticator in cassandra.yaml and set up the users as well. I >> noticed there are keyspaces system_auth and system_trace. But there is no >> way to find out which user initiated which session. Is there anyway to find >> out?. Also is it recommended to enable system_trace in production or to >> know how many sessions started by a user? >> >> Thanks >> Ajay >> > > > > -- > Tyler Hobbs > DataStax <http://datastax.com/> >
