Hallo Michael,
On Wed, 4 Apr 2007, Michael Bell wrote:
> > [EMAIL PROTECTED] ~]# sqlite3 /var/lib/openxpki/sqlite.db .tables
>
> This is the wrong database. There must be at minimum three databases if
> you are using SQLite (because of the poor concurrency support):
>
> - data
> - logging (audit trail)
> - workflow
>
> Usually it is enough to copy the db files after the intialization to the
> other two names.
Thanks for the pointer, that was the problem as the sqlite.db._log_
database was empty while the other two were copies of the sqlite.db file.
Please apply the following patch to automatically generate the log
database as well:
[EMAIL PROTECTED] OpenXPKI]$ gendiff openxpki-deployment-0.9.790 .orig
--- openxpki-deployment-0.9.790/bin/openxpkiadm.in.orig 2007-04-04
19:01:07.000000000 +0200
+++ openxpki-deployment-0.9.790/bin/openxpkiadm.in 2007-04-04
19:01:24.000000000 +0200
@@ -72,7 +72,7 @@
# SQLite needs special treatment: three databases instead of one must
# be initialized
if ($type =~ m{ SQLite }xms) {
- push @databases, 'workflow', 'backend';
+ push @databases, 'workflow', 'backend', 'log';
}
DB:
regards,
Andreas
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
OpenXPKI-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openxpki-users
