Re: [Zope] Audit changes

2009-05-05 Thread csl
We had a similar situation and a local users group member recommended this 
(Plone, I believe):

In unrestricted code (if
you're using zeo, try zopectl debug), you can call
object._p_jar.db().history(object._p_oid, None, 10)
to get metadata about the last 10 changes to an object.
You'll get a list of dictionaries back.
Each dictionary has the keys: 'description', 'version', 'time', 'tid', 
'user_name', 'size'

The most interesting of these are time, user_name, and tid (transaction id).

To get the old state of an object (as a dictionary of its attribute names and 
values), call
object._p_jar.oldstate(object, tid)


- Original Message -
From: iarly selbir | ski0s iar...@gmail.com
Date: Wednesday, April 29, 2009 14:24
Subject: Re: [Zope] Audit changes
To: zope@zope.org

 has It stored on log file like linux logs or is stored on db ( 
 in my case
 MySQL )?
 
 Today a developer make changes in something that I can't anymore 
 access to
 web interface, so I need of a other way to see all changes.
 
 My solution today was restore a MySQL backup of yesterday, so I 
 lost all
 audit changes.
 
 Thanks in advance.
 
 
 Regards,
 
 - -
 iarly selbir | ski0s
 
 :wq!
 
 
 On Wed, Apr 29, 2009 at 3:08 PM, Tres Seaver 
 tsea...@palladion.com wrote:
 
  -BEGIN PGP SIGNED MESSAGE-
  Hash: SHA1
 
  iarly selbir | ski0s wrote:
   There are a feature to audit all changes done on web manage 
 interface of
   Zope/Plone?
 
  The Undo tab lets you see a list of all transactions 
 committed, along
  with the time and the user, and to undo them:  it doesn't 
 show the
  objects which were changed, although it (usually) shows the 
 path of the
  view which triggered the transaction.
 
 
  Tres.
  - --
  ===
  Tres 
 Seaver  +1 
 540-429-
 0999  tsea...@palladion.com
  Palladion Software   Excellence by 
 Design    http://palladion.com
  -BEGIN PGP SIGNATURE-
  Version: GnuPG v1.4.6 (GNU/Linux)
  Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
 
  iD8DBQFJ+JeT+gerLs4ltQ4RAtXuAKDEIKgTPF4knNZ/PnDpL/0TwFEnOQCg11vl
  JfdV4R2FWA9ipp34H6/T6GU=
  =uJGq
  -END PGP SIGNATURE-
 
  ___
  Zope maillist  -  Zope@zope.org
  http://mail.zope.org/mailman/listinfo/zope
  **   No cross posts or HTML encoding!  **
  (Related lists -
   http://mail.zope.org/mailman/listinfo/zope-announce
   http://mail.zope.org/mailman/listinfo/zope-dev )
 

___
Zope maillist  -  Zope@zope.org
http://mail.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://mail.zope.org/mailman/listinfo/zope-announce
 http://mail.zope.org/mailman/listinfo/zope-dev )


[Zope] Audit changes

2009-04-29 Thread iarly selbir | ski0s
There are a feature to audit all changes done on web manage interface of
Zope/Plone?


Thanks in advance.

Regards,

- -
iarly selbir | ski0s

:wq!
___
Zope maillist  -  Zope@zope.org
http://mail.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://mail.zope.org/mailman/listinfo/zope-announce
 http://mail.zope.org/mailman/listinfo/zope-dev )


Re: [Zope] Audit changes

2009-04-29 Thread Tres Seaver
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

iarly selbir | ski0s wrote:
 There are a feature to audit all changes done on web manage interface of
 Zope/Plone?

The Undo tab lets you see a list of all transactions committed, along
with the time and the user, and to undo them:  it doesn't show the
objects which were changed, although it (usually) shows the path of the
view which triggered the transaction.


Tres.
- --
===
Tres Seaver  +1 540-429-0999  tsea...@palladion.com
Palladion Software   Excellence by Designhttp://palladion.com
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFJ+JeT+gerLs4ltQ4RAtXuAKDEIKgTPF4knNZ/PnDpL/0TwFEnOQCg11vl
JfdV4R2FWA9ipp34H6/T6GU=
=uJGq
-END PGP SIGNATURE-

___
Zope maillist  -  Zope@zope.org
http://mail.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://mail.zope.org/mailman/listinfo/zope-announce
 http://mail.zope.org/mailman/listinfo/zope-dev )


Re: [Zope] Audit changes

2009-04-29 Thread iarly selbir | ski0s
has It stored on log file like linux logs or is stored on db ( in my case
MySQL )?

Today a developer make changes in something that I can't anymore access to
web interface, so I need of a other way to see all changes.

My solution today was restore a MySQL backup of yesterday, so I lost all
audit changes.

Thanks in advance.


Regards,

- -
iarly selbir | ski0s

:wq!


On Wed, Apr 29, 2009 at 3:08 PM, Tres Seaver tsea...@palladion.com wrote:

 -BEGIN PGP SIGNED MESSAGE-
 Hash: SHA1

 iarly selbir | ski0s wrote:
  There are a feature to audit all changes done on web manage interface of
  Zope/Plone?

 The Undo tab lets you see a list of all transactions committed, along
 with the time and the user, and to undo them:  it doesn't show the
 objects which were changed, although it (usually) shows the path of the
 view which triggered the transaction.


 Tres.
 - --
 ===
 Tres Seaver  +1 540-429-0999  tsea...@palladion.com
 Palladion Software   Excellence by Designhttp://palladion.com
 -BEGIN PGP SIGNATURE-
 Version: GnuPG v1.4.6 (GNU/Linux)
 Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

 iD8DBQFJ+JeT+gerLs4ltQ4RAtXuAKDEIKgTPF4knNZ/PnDpL/0TwFEnOQCg11vl
 JfdV4R2FWA9ipp34H6/T6GU=
 =uJGq
 -END PGP SIGNATURE-

 ___
 Zope maillist  -  Zope@zope.org
 http://mail.zope.org/mailman/listinfo/zope
 **   No cross posts or HTML encoding!  **
 (Related lists -
  http://mail.zope.org/mailman/listinfo/zope-announce
  http://mail.zope.org/mailman/listinfo/zope-dev )

___
Zope maillist  -  Zope@zope.org
http://mail.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://mail.zope.org/mailman/listinfo/zope-announce
 http://mail.zope.org/mailman/listinfo/zope-dev )


Re: [Zope] Audit changes

2009-04-29 Thread Andreas Jung
On 29.04.2009 20:24 Uhr, iarly selbir | ski0s wrote:
 has It stored on log file like linux logs or is stored on db ( in my
case MySQL )?

 Today a developer make changes in something that I can't anymore access
to web interface, so I need of a other way to see all changes.

 My solution today was restore a MySQL backup of yesterday, so I lost
all audit changes.



The undo tabs tells you nothing about the values changed (old vs. new).
There is
basically no tool for giving you those information. In Plone you have
versioning support
for content-types (only) and there is some History functionality for
showing changes
on fields managed by an Archetypes schema.

-aj
begin:vcard
fn:Andreas Jung
n:Jung;Andreas
org:ZOPYX Ltd.  Co. KG
adr;quoted-printable:;;Charlottenstr. 37/1;T=C3=BCbingen;;72070;Germany
email;internet:i...@zopyx.com
title:CEO
tel;work:+49-7071-793376
tel;fax:+49-7071-7936840
tel;home:+49-7071-793257
x-mozilla-html:FALSE
url:www.zopyx.com
version:2.1
end:vcard

___
Zope maillist  -  Zope@zope.org
http://mail.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://mail.zope.org/mailman/listinfo/zope-announce
 http://mail.zope.org/mailman/listinfo/zope-dev )


Re: [Zope] Audit changes

2009-04-29 Thread iarly selbir | ski0s
Thanks for help all.


Regards,

- -
iarly selbir | ski0s

:wq!


On Wed, Apr 29, 2009 at 3:27 PM, Andreas Jung li...@zopyx.com wrote:

 On 29.04.2009 20:24 Uhr, iarly selbir | ski0s wrote:
  has It stored on log file like linux logs or is stored on db ( in my
 case MySQL )?
 
  Today a developer make changes in something that I can't anymore access
 to web interface, so I need of a other way to see all changes.
 
  My solution today was restore a MySQL backup of yesterday, so I lost
 all audit changes.
 
 

 The undo tabs tells you nothing about the values changed (old vs. new).
 There is
 basically no tool for giving you those information. In Plone you have
 versioning support
 for content-types (only) and there is some History functionality for
 showing changes
 on fields managed by an Archetypes schema.

 -aj

___
Zope maillist  -  Zope@zope.org
http://mail.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://mail.zope.org/mailman/listinfo/zope-announce
 http://mail.zope.org/mailman/listinfo/zope-dev )