2013-06-26 02:25 AEST by Glen Starrett - When using the CVS Suite Server applet, in the Plugin > Audit > Configure
dialog, you can specify a SQLite database.  The "name" field is supposed to
point to a file.

If that file the "name" field points to doesn't exist you get a message:
"Connection failed: open failed".

If that file that "name" field points to isn't completely empty, you get a
different message:  "Error while trying to create tables.  file is encrypted or
is not a database.  Create Table SchemaVersion(Version Integer)".

Under Windows it's awkward to create a completely empty file.  It would be
helpful to offer "File does not exist, create?" on the "create tables" step.

Creating an empty file under Linux/UNIX is simply "touch FILENAME".  On Windows
you need to "copy CON FILENAME" then press CTRL-Z and enter to create a blank
file, or you can do "type NUL > FILENAME".  Using "echo. > FILENAME" does NOT
produce an empty file.

2013-06-27 14:27 AEST by Arthur Barrett - change bug description

from: Audit Create Tables for SQLite does not work if file is bank or invalid

to: enh: audit: sqlite: 'test' or 'create tables' if no file, ask 'create?'


Also: this bug is related to bug 5977: enh: audit/sqlite - if 'fail to connect' hint: create empty file

Note: since the cvsnt 'control panel' only runs on windows, this is a windows only bug - but in future 
these functions may be available from a 'web based' applet for non-windows targets.