Return-Path: X-Original-To: apmail-cassandra-user-archive@www.apache.org Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 0DFDE18EC6 for ; Wed, 24 Feb 2016 10:42:02 +0000 (UTC) Received: (qmail 84833 invoked by uid 500); 24 Feb 2016 10:41:57 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 84790 invoked by uid 500); 24 Feb 2016 10:41:57 -0000 Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cassandra.apache.org Delivered-To: mailing list user@cassandra.apache.org Received: (qmail 84780 invoked by uid 99); 24 Feb 2016 10:41:57 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd2-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 24 Feb 2016 10:41:57 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd2-us-west.apache.org (ASF Mail Server at spamd2-us-west.apache.org) with ESMTP id 8C8E11A04AC for ; Wed, 24 Feb 2016 10:41:56 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.198 X-Spam-Level: * X-Spam-Status: No, score=1.198 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_LOW=-0.7, RCVD_IN_MSPIKE_H2=-0.001, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd2-us-west.apache.org (amavisd-new); dkim=pass (1024-bit key) header.d=snapdeal.com Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id 40izmKb2Z-B3 for ; Wed, 24 Feb 2016 10:41:54 +0000 (UTC) Received: from mail-vk0-f44.google.com (mail-vk0-f44.google.com [209.85.213.44]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTPS id 908015FB65 for ; Wed, 24 Feb 2016 10:41:54 +0000 (UTC) Received: by mail-vk0-f44.google.com with SMTP id k196so13005955vka.0 for ; Wed, 24 Feb 2016 02:41:54 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=snapdeal.com; s=google; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :content-type; bh=+Ybvzhemu6KSgsnwoxw7KbbmhWV/8stvNGXcz+g2DrM=; b=HvMF0/cJtIQDwmX9mlyk2MEj4ad2/GHOZVSt7/FHL5cElQLv1jYYg2lUowIV9WQBbd 6Q/chyguHwx7R+Xw4lUAlkqM4cGWvEj23r2zXaa6OSBrjwAbNnk5P8u/CfAdEVmKQyVM Q5iyNzzrpNBd8oJ/N16yUPt4SaLT2+ZhZ/EMA= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to:content-type; bh=+Ybvzhemu6KSgsnwoxw7KbbmhWV/8stvNGXcz+g2DrM=; b=QLnH4lVJxBEnNWBh1kafhmI+pe8+ShKf70R/qRTTwGfcMMW9kFMNayuzzkioMj/BcG sZVzhQDP54JhDRGwSpX0pUpUwcyOnQnJLidOcWJcA/kvwzwde92DQopzZrhIjVsGlkPa 5+WEndseGYpVGjndKvQ2tjsOEoATN+BeQa5jJD/P9yqrhF6GWBx50Eyb13Es1mSPAqj6 csI/VPLql00e66z32Z/siQ427UVaQ3Nvf1bg5bAuFUAnLKyVBpT+a7IzMAjyDJAnrDyQ xG0OkhTzioHlLkQ8X61JcNkMs1g8T2acSiodlnld/VzR6s2dB9Xj4L6yTJRnpCKBRaKp qILA== X-Gm-Message-State: AG10YORZPislb2EThs87Ke4bYrzagN6qK2ahbbJjU1MZ7z/+hKXzY3XyHs97nihia0xrN+GSDC3vXXinwEcARAxp X-Received: by 10.31.155.131 with SMTP id d125mr26938039vke.146.1456310513999; Wed, 24 Feb 2016 02:41:53 -0800 (PST) MIME-Version: 1.0 Received: by 10.31.94.11 with HTTP; Wed, 24 Feb 2016 02:41:34 -0800 (PST) In-Reply-To: References: <7eba864569fd4a70bec39753997715ba@XCH-RCD-002.cisco.com> From: Raman Gugnani Date: Wed, 24 Feb 2016 16:11:34 +0530 Message-ID: Subject: Re: Cassandra Data Audit To: user@cassandra.apache.org Content-Type: multipart/alternative; boundary=001a113d391cdeb1a4052c81b6ef --001a113d391cdeb1a4052c81b6ef Content-Type: text/plain; charset=UTF-8 Hi Alain, As per the document. Which column of the dse_audit.audit_log will hold the previous or new data. On Wed, Feb 24, 2016 at 3:59 PM, Alain RODRIGUEZ wrote: > Hi Charu, > > Are you using DSE or Open source Cassandra ? > > I never used it, but DSE brings a feature that seems to be what you are > looking for --> > http://docs.datastax.com/en/datastax_enterprise/4.6/datastax_enterprise/sec/secAuditingCassandraTable.html > > Never heard about such a thing in the Open source version though. > > C*heers, > ----------------- > Alain Rodriguez > France > > The Last Pickle > http://www.thelastpickle.com > > 2016-02-24 6:36 GMT+01:00 Charulata Sharma (charshar) > : > >> To all Cassandra experts out there, >> >> Can you please let me know if there is any inbuilt Cassandra >> feature that allows audits on Column family data ? >> >> >> >> When I change any data in a CF, I want to record that change. Probably >> store the old value as well as the changed one. >> >> One way of doing this is to create new CFs , but I wanted to know if >> there is any standard C* feature that could be used. >> >> Any guidance in this and implementation approaches would really help. >> >> >> >> Thanks, >> >> Charu >> > > -- Thanks & Regards Raman Gugnani *Senior Software Engineer | CaMS* M: +91 8588892293 | T: 0124-6600000 | EXT: 14255 ASF Centre A | 2nd Floor | CA-2130 | Udyog Vihar Phase IV | Gurgaon | Haryana | India *Disclaimer:* This communication is for the sole use of the addressee and is confidential and privileged information. If you are not the intended recipient of this communication, you are prohibited from disclosing it and are required to delete it forthwith. Please note that the contents of this communication do not necessarily represent the views of Jasper Infotech Private Limited ("Company"). E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The Company, therefore, does not accept liability for any loss caused due to this communication. *Jasper Infotech Private Limited, Registered Office: 1st Floor, Plot 238, Okhla Industrial Estate, New Delhi - 110020 INDIA CIN: U72300DL2007PTC168097* --001a113d391cdeb1a4052c81b6ef Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi Alain,

As per the document. Which column = of the=C2=A0dse_audit.audit_log <= font color=3D"#000000">will hold the previous or new data.

On Wed, = Feb 24, 2016 at 3:59 PM, Alain RODRIGUEZ <arodrime@gmail.com> wrote:
Hi Charu,
=
Are you using DSE or Open source Cassandra ?

<= /div>
I never used it, but DSE brings a feature that seems to be what y= ou are looking for -->=C2=A0http://docs.datastax.com/en/datastax_enterprise/4.6/datas= tax_enterprise/sec/secAuditingCassandraTable.html

<= div>Never heard about such a thing in the Open source version though.
=

C*heers,
-----------------
Ala= in Rodriguez
France


2016-02-24 6= :36 GMT+01:00 Charulata Sharma (charshar) <charshar@cisco.com>:

To all Cassandra experts out there,

=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0 Can you please let me know if there is any inbuilt Ca= ssandra feature that allows audits on Column family data ?

=C2=A0

When I change any data in a CF, I want to record tha= t change. Probably store the old value as well as the changed one.

One way of doing this is to create new CFs , but I w= anted to know if there is any standard C* feature that could be used.

Any guidance in this and implementation approaches w= ould really help.

=C2=A0

Thanks,

Charu





--
=
=
Thanks & Regard= s

Raman Gugnani
Senior Software En= gineer | CaMS
M: +91 8588892293 | T: 0124-660000= 0 | EXT: 14255
ASF Centre A | 2nd Floor | CA-2130 | Udyog Vihar Phase IV= |=C2=A0
Gurgaon | Haryana | India
=C2=A0
Disclaim= er:=C2=A0This communication is for the sole use of the addressee a= nd is confidential and privileged information. If you are not the intended = recipient of this communication, you are prohibited from disclosing it and = are required to delete it forthwith. Please note that the contents of this = communication do not necessarily represent the views of Jasper Infotech Pri= vate Limited ("Company"). E-mail transmission cannot be guarantee= d to be secure or error-free as information could be intercepted, corrupted= , lost, destroyed, arrive late or incomplete, or contain viruses. The Compa= ny, therefore, does not accept liability for any loss caused due to this co= mmunication.=C2=A0Jasper Infotech Private Limited, Registered Offic= e: 1st Floor, Plot 238, Okhla Industrial Estate, New Delhi - 110020 INDIA C= IN: U72300DL2007PTC168097
--001a113d391cdeb1a4052c81b6ef--