[cvsnt] 2.5.04.3229 (RC9) Fail to init new repository whenaudit database enabled.

[andysnews at southby.me.uk]

Arthur,

[Now using CVSNT 2.5.04.3236]

I have checked connectivity an it seems fine.

I have discovered that auditing works as long as I don't check the
'Sessions' checkbox on the 'Audit settings' dialog. i.e. 'Commits', 'Store
checkin differences', 'Tags' and 'History' all enabled.

I have checked the database content after a number of module, directory,
file adds; commits and tagging operations and all the tables appear to be in
order (as far as I can tell).

As soon as the 'Session' check box is enabled, any operation fails with the
following:

C:\Sandpit>cvs -d :sspi:drv1884:/TestRepos ls
audit_trigger error (session): Commands out of sync;  You can't run this
command now Audit trigger initialisation failed: Database initialisation
failed cvs server: Pre-command check failed cvs [ls aborted]: received
interrupt signal

I can't see how this can be a configuration issue at my end especially as
this works perfectly with CVSNT 2.5.03.2382 with the same database and user
(obviously dropping the tables first and recreating them with the 'Create
Tables' button).

Any ideas? I'm completely out of ideas.
Andy.

Long -ttt trace:

C:\Sandpit>cvs -ttt -d :sspi:drv1884:/TestRepos ls
08:17:14:   -> Tracelevel set to 3.  PID is 3988
08:17:14:   -> Session ID is f94491d340a02bf
08:17:14:   -> Session time is Fri Nov 14 08:17:14 2008
08:17:14:   -> Client was compiled Nov  3 2008 23:29:25
08:17:14:   -> Client was compiled with MSVC C/C++ 1310
08:17:14:   -> Client build platform is microsoft-windows-x86
08:17:14:   -> Client running on "Microsoft Windows XP Professional Service
Pack 3 (Build 2600) [5.1.2600] (Service Pack 3)"
08:17:14:   -> Loading protocol sspi as sspi.dll
08:17:14:   -> CLibraryAccess::Load loading
C:\PROGRA~1\CVSNT/protocols/sspi.dll
08:17:14:   -> main loop with CVSROOT=:sspi:drv1884:/TestRepos
08:17:14:   -> start_server(0)
08:17:14:   -> client start - client_protocol->connect
08:17:15:   -> client start - Loop, getting responses from the server.
08:17:15:   -> client start - got "I LOVE YOU"
08:17:15:   -> client start - continue login.
08:17:15:   -> client start - server started.
08:17:15:   -> client start - send Valid-responses to server.
08:17:15:   -> client start - send valid-requests to server.
08:17:15:   -> client start - rootless_encryption.
08:17:15:   -> Server codepage is CP1252
08:17:15:   -> Client codepage is CP1252
08:17:15:   -> Server version is CVSNT 2.5.04 (Zen) Build 3236 ()
08:17:15:   -> Client version is CVSNT 2.5.04 (Zen) Build 3236 ()
08:17:15:   -> Requesting server cvsignore
08:17:15:   -> wrap_add(*.a -kb, 0, 0, 0, 0)
...
08:17:15:   -> wrap_add(*.Z -kb, 0, 0, 0, 0)
08:17:15:   -> Requesting server cvswrappers
08:17:15:   -> Requesting server cvsrc (read-cvsrc2)
08:17:15:   -> Parsing global cvsrc started
08:17:15:   -> Parsing global cvsrc finished
08:17:15: S -> server_main started
08:17:15: S -> run precommand proc server
08:17:15: S -> run_trigger()
08:17:15: S -> LoadTrigger info trigger, phys repos=C:/CVSNTRepos/TestRepos.
08:17:15: S -> LoadTrigger(info.dll)
08:17:15: S -> CLibraryAccess::Load loading
C:\PROGRA~1\CVSNT/triggers/info.dll
08:17:15: S -> call library init with
physical_repository=C:/CVSNTRepos/TestRepos.
08:17:15: S -> info_trigger: init,
physical_repository=C:/CVSNTRepos/TestRepos
08:17:15: S -> LoadTrigger(audit.dll)
08:17:15: S -> CLibraryAccess::Load loading
C:\PROGRA~1\CVSNT/triggers/audit.dll
08:17:15: S -> call library init with
physical_repository=C:/CVSNTRepos/TestRepos.
08:17:15: S -> Connecting to mysql
08:17:15: S -> CLibraryAccess::Load loading
C:\PROGRA~1\CVSNT/database/mysql.dll
08:17:15: S -> Select Version From SchemaVersion
08:17:15: S -> Audit SchemaVersion=3
08:17:15: S -> Insert Into SessionLog (Command, StartTime, Hostname,
Username, SessionId, VirtRepos, PhysRepos, Client) Values ('ls' ,'2008-11-14
08:17:14','DRV1884','Andy','e2c491d340a02bf','/TestRepos','C:/CVSNTRepos/Tes
tRepos','CVSNT 2.5.04 (Zen) Build 3236 ()')

audit_trigger error (session): Commands out of sync;  You can't run this
command now
08:17:15: S -> LoadTrigger(checkout.dll)
08:17:15: S -> CLibraryAccess::Load loading
C:\PROGRA~1\CVSNT/triggers/checkout.dll
08:17:15: S -> call library init with
physical_repository=C:/CVSNTRepos/TestRepos.
08:17:15: S -> Checkout trigger not enabled.
08:17:15: S -> Couldn't load trigger checkout.dll
08:17:15: S -> LoadTrigger(email.dll)
08:17:15: S -> CLibraryAccess::Load loading
C:\PROGRA~1\CVSNT/triggers/email.dll
08:17:15: S -> call library init with
physical_repository=C:/CVSNTRepos/TestRepos.
08:17:15: S -> Email trigger not enabled.
08:17:15: S -> Couldn't load trigger email.dll
08:17:15: S -> LoadTrigger(script.dll)
08:17:15: S -> CLibraryAccess::Load loading
C:\PROGRA~1\CVSNT/triggers/script.dll
08:17:15: S -> Not loading disabled trigger script.dll.
08:17:15: S -> Couldn't load trigger script.dll
08:17:15: S -> Call pre-loaded 'audit.dll'
08:17:15: S -> precommand_proc()
08:17:15: S -> Audit precommand, g_pDb=00000000
Audit trigger initialiasation failed: Database initialisation failed
08:17:15: S -> Call pre-loaded 'info.dll'
08:17:15: S -> precommand_proc()
08:17:15: S -> default_trigger: parse_info(CVSROOT/precommand,%r
%c,%<a,<null>) cwd(C:\CVSNTTemp\cvs-serv3628)
08:17:15: S -> default_trigger:
open(C:/CVSNTRepos/TestRepos/CVSROOT/precommand)
cwd(C:\CVSNTTemp\cvs-serv3628) cvs server: Pre-command check failed
08:17:15: S -> run postcommand proc server
08:17:15: S -> run_trigger()
08:17:15: S -> Call pre-loaded 'audit.dll'
08:17:15: S -> postcommand_proc()
08:17:15: S -> Exception caught - in minidumper
08:17:45: S -> send=1
08:17:45: S -> Dumping to
C:\CVSNTTemp\cvsnt-2.5.04.3236-DRV1884-e2c491d340a02bf-small.dmp
08:17:45: S -> Start dump
08:17:45: S -> Dump succeeded.  Zipping to
C:\CVSNTTemp\cvsnt-2.5.04.3236-DRV1884-e2c491d340a02bf-small.dmp.gz
08:17:45: S ->
copy_and_zip(C:\CVSNTTemp\cvsnt-2.5.04.3236-DRV1884-e2c491d340a02bf-small.dm
p,C:\CVSNTTemp\cvsnt-2.5.04.3236-DRV1884-
e2c491d340a02bf-small.dmp.gz)
08:17:45: S -> wnt_fstat(4)
08:17:45: S -> _statcore(00000758,(null))
08:17:45: S -> Using file handle to retrieve information
08:17:45: S -> File attributes = 00000020
08:17:45: S ->  - read/write file
08:17:45: S -> GetUnixFileModeNtEA(b,FFFFFFFF) returns 0000
08:17:45: S ->
unlink_file(C:\CVSNTTemp\cvsnt-2.5.04.3236-DRV1884-e2c491d340a02bf-small.dmp
.gz)
08:17:45: S ->
wnt_chmod(C:\CVSNTTemp\cvsnt-2.5.04.3236-DRV1884-e2c491d340a02bf-small.dmp.g
z,100666)
08:17:45: S -> SetUnixFileModeNtEA(C,100666)
08:17:45: S ->
SendFileToCvsnt(C:\CVSNTTemp\cvsnt-2.5.04.3236-DRV1884-e2c491d340a02bf-small
.dmp.gz,cvsnt-2.5.04.3236-DRV1884-e2c491d
340a02bf-small)
08:17:45: S -> Crashdump file size is 10016
08:17:45: S -> Crash reporting failed - HttpSendRequestEx returned 00002ee7
cvs [ls aborted]: end of file from server (consult above messages if any)

C:\Sandpit>