[cvsnt] audit_trigger error (session): Commands out of sync afterupgrading to 2.5.04

[Eric B.]

Hi Bo,

> >I just upgrade CVSNT from 2.5.03.2382 to 2.5.04.3236 and am having problems 
> >with the audit plugin.  Any commands give me the following error msg:
> >audit_trigger error (session): Commands out of sync;  You can't run this 
> >command now
> >Audit trigger initialiasation failed: Database initialisation failed
> >cvs rtag: Pre-command check failed
> >
> I cannot tell you exactly what you should do to fix the problem.
> Basically it depends very much on what database engine you are using
> and you have not specified this. I am using MSSQLServer and the
> discussion below is based on MSSQL.
> For other databases there are possibly other methods.
> 
> However, the problem is that from 2.5.03 to 2.5.04 there were changes
> made to the audit database table *structure* and this will now cause
> the problems you have seen.

 

I am actually running MySQL 5.1, and after searching further, I noticed that the table structure for the SessionLog table was modified, so I manually modified the structure myself.  I renamed the Date field to StartTime and added in an EndTime field so that it matches the new structure properly.  However, that didn't particuarly help; the audit trigger still fails when Session logging is enabled.

 

I am trying to get the CVSNT_2_0_x branch to build successfully in Visual Studio to see if I can get the fix that Arthur reported added/merged into the branch if required.  Right now, I am having difficulty getting the project to compile properly (see my post on the dev list).  Once I get that up and running, I'll see if the fix mentioned in Arthur's post recitifies the situation.

 

Thanks for your insight.  If you have any clues what I can do to help config VS, let me know please.  I know you wrote that howto, but apparently, Arthur mentioned that it was outdated and no longer truly applicable.

 

Thanks,

 

Eric


_________________________________________________________________
Windows Live helps you keep up with all your friends, in one place.
http://go.microsoft.com/?linkid=9660826