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 
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 
>  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 )


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  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 )


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
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  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 )


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 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 )