[cvsnt] CVSNT Auditing....

[Bo Berglund]

Tony,
in my case after doing a single update after enabling the auditing I
have only one record in the sessionlog and *nothing* in the other tables
even though I checked all checkboxes in the config dialog. 


Best regards,

Bo Berglund


-----Original Message-----
From: cvsnt-bounces at cvsnt.org [mailto:cvsnt-bounces at cvsnt.org] On Behalf
Of Tony Hoyle
Sent: den 10 november 2006 12:42
To: cvsnt at cvsnt.org
Subject: Re: [cvsnt] CVSNT Auditing....

Bo Berglund wrote:
> 1. Relations missing
> --------------------
> The Sessionlog table is supposed to record all activity in the server
> and it has a primary key on the column 'Id'.
> The other tables have a 'SessionID' column that stores the
Sessionlog.Id
> value
> In normal cases the SessionId should have a foreign key set to
> Sessionlog.Id, but there is no relation at all here!
> Is this by design or an oversight?

Some databases don't handle them so I've never bothered adding them
(since the sql creation scripts are all derived from each other).

> 2. Access logging missing
> -------------------------
> I noted that cvs update is recorded in the Sessionlog table as
expected,
> but there is no indication at all on *what* was updated, so the
auditing
> can therefore not record when people are retrieving data from the
> server.

There's data in HistoryLog for that I think.  audit only has access to
the data given it by the API and that has limits.

Tony
_______________________________________________
cvsnt mailing list
cvsnt at cvsnt.org
http://www.cvsnt.org/cgi-bin/mailman/listinfo/cvsnt