[cvsnt] CVSNT Auditing....

Tony Hoyle tony.hoyle at march-hare.com
Fri Nov 10 11:42:17 GMT 2006

Community technical support mailing list was retired 2010 and replaced with a professional technical support team. For assistance please contact: Pre-sales Technical support via email to sales@march-hare.com.

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.


More information about the cvsnt mailing list
Download the latest CVSNT, TortosieCVS, WinCVS etc. for Windows 8 etc.
@CVSNT on Twitter   CVSNT on Facebook