Send Netdot-devel mailing list submissions to
[email protected]
To subscribe or unsubscribe via the World Wide Web, visit
https://osl.uoregon.edu/mailman/listinfo/netdot-devel
or, via email, send a message with subject or body 'help' to
[email protected]
You can reach the person managing the list at
[email protected]
When replying, please edit your Subject line so it is more specific
than "Re: Contents of Netdot-devel digest..."
Today's Topics:
1. I'd like to discuss the philosophy behind the "Audit" table
feature (William Bulley)
2. Re: I'd like to discuss the philosophy behind the "Audit"
table feature (Carlos Vicente)
3. Re: I'd like to discuss the philosophy behind the "Audit"
table feature (William Bulley)
4. [Netdot - Feature #1807] (New) the "audit" system logs
changes (inserts/updates) to the database, but it does not log
previous/old values ([email protected])
5. [Netdot] 'DebianPerlPackaging ' wiki page has been updated
([email protected])
----------------------------------------------------------------------
Message: 1
Date: Thu, 8 May 2014 16:04:09 -0400
From: William Bulley <[email protected]>
Subject: [Netdot-devel] I'd like to discuss the philosophy behind the
"Audit" table feature
To: [email protected]
Cc: Carlos Vicente <[email protected]>
Message-ID: <[email protected]>
Content-Type: text/plain; charset=us-ascii
In looking at the Perl code for the _audit() method in the v1.0.6
"lib/Netdot/Model.pm" Perl module, it appears that only the new or
changed values are recorded in the "Audit" table (along with the
other columns: tstamp, username, tablename, label, operation, and
object_id).
According to the "etc/netdot.meta" file of v1.0.6 the "fields" column
of the "Audit" table records the 'Fields changed' while the "vals"
column records the 'Values that changed', but it might be useful or
at least worth considering to have an additional column, say, "old"
or "old_vals" that would allow post-mortem style investigations for
potential forensic purposes. Does anyone care to discuss this topic?
There is also the concept in the database "industry" of "auditing"
only the "essential" columns (as contrasted with all columns as in
the case of "insert"s in v1.0.6 -- but I may have this point wrong).
Also, I don't see how "delete"s are recorded in the "Audit" table.
I'm not sure how this concept would relate to Netdot, but that also
might be worth a bit of discussion.
Thanks in advance. :-)
Regards,
web...
--
William Bulley Email: [email protected]
72 characters width template ----------------------------------------->|
------------------------------
Message: 2
Date: Thu, 8 May 2014 16:10:59 -0400
From: Carlos Vicente <[email protected]>
Subject: Re: [Netdot-devel] I'd like to discuss the philosophy behind
the "Audit" table feature
To: William Bulley <[email protected]>
Cc: [email protected]
Message-ID: <[email protected]>
Content-Type: text/plain; charset=us-ascii
Hi Web,
On May 8, 2014, at 4:04 PM, William Bulley <[email protected]> wrote:
> According to the "etc/netdot.meta" file of v1.0.6 the "fields" column
> of the "Audit" table records the 'Fields changed' while the "vals"
> column records the 'Values that changed', but it might be useful or
> at least worth considering to have an additional column, say, "old"
> or "old_vals" that would allow post-mortem style investigations for
> potential forensic purposes. Does anyone care to discuss this topic?
Yes, I agree that it would make sense to show the old values.
Put it in a ticket, or better yet, send a pull request.
cv
------------------------------
Message: 3
Date: Thu, 8 May 2014 18:03:44 -0400
From: William Bulley <[email protected]>
Subject: Re: [Netdot-devel] I'd like to discuss the philosophy behind
the "Audit" table feature
To: Carlos Vicente <[email protected]>
Cc: [email protected]
Message-ID: <[email protected]>
Content-Type: text/plain; charset=us-ascii
According to Carlos Vicente <[email protected]> on Thu, 05/08/14 at 16:10:
>
> Yes, I agree that it would make sense to show the old values.
s/show/save/ ??
or
s/show/store/ ??
<grin>
> Put it in a ticket, or better yet, send a pull request.
Ticket, yes, -- please accept my apology, but I have trouble with the
whole "pull request" thing -- it is like learning to smoke, I guess,
your first drag makes you very sick and you start coughing wildly!
Later on, smoking becomes second nature... :-)
In some areas, I'm still a luddite, sorry... :-(
Regards,
web...
--
William Bulley Email: [email protected]
72 characters width template ----------------------------------------->|
------------------------------
Message: 4
Date: Fri, 9 May 2014 04:51:32 -0700
From: [email protected]
Subject: [Netdot-devel] [Netdot - Feature #1807] (New) the "audit"
system logs changes (inserts/updates) to the database, but it does not
log previous/old values
To: [email protected], [email protected], [email protected]
Message-ID: <[email protected]>
Content-Type: text/plain; charset=utf-8
Issue #1807 has been reported by William Bulley.
----------------------------------------
Feature #1807: the "audit" system logs changes (inserts/updates) to the
database, but it does not log previous/old values
https://osl.uoregon.edu/redmine/issues/1807
Author: William Bulley
Status: New
Priority: Low
Assignee: Carlos Vicente
Category: Netdot
Target version: 1.0.6
Resolution:
The code in the "lib/Netdot/UI.pm" Perl module _audit() method saves the
new/changed values for any
database change (insert/update), but does not record the old/previous values in
the "Audit" table.
It also is uncler to me how the "audit" feature records "delete" database
operations in the "Audit" table
but I may have missed that in the code.
--
You have received this notification because you have either subscribed to it,
or are involved in it.
To change your notification preferences, please click here:
http://osl.uoregon.edu/redmine/my/account
------------------------------
Message: 5
Date: Fri, 9 May 2014 10:37:59 -0700
From: [email protected]
Subject: [Netdot-devel] [Netdot] 'DebianPerlPackaging ' wiki page has
been updated
To: [email protected]
Message-ID: <[email protected]>
Content-Type: text/plain; charset=utf-8
The 'DebianPerlPackaging ' wiki page has been updated by Carlos Vicente.
DebianPerlPackaging :
https://osl.uoregon.edu/redmine/projects/netdot/wiki/DebianPerlPackaging_
View differences:
https://osl.uoregon.edu/redmine/projects/netdot/wiki/DebianPerlPackaging_/diff/4
--
You have received this notification because you have either subscribed to it,
or are involved in it.
To change your notification preferences, please click here:
http://osl.uoregon.edu/redmine/my/account
------------------------------
_______________________________________________
Netdot-devel mailing list
[email protected]
https://osl.uoregon.edu/mailman/listinfo/netdot-devel
End of Netdot-devel Digest, Vol 86, Issue 7
*******************************************
