Hi,Johannes
Thank you for your answer,Yes,Set the "mode=force" can work.
So I change the file genDB:
*****************************************
my $mode = "NONE";
*****************************************
to
*****************************************
my $mode = "FORCE";
*****************************************
2006/2/8, [EMAIL PROTECTED] <[EMAIL PROTECTED]>:
Hi,
by default OpenCA doesn't drop a existing table but fails with this
error. That's probably a protection against accidentally wiping your
PKI. So you have to delete the tables manually if you want to start over
again.
Looking at the code in DBI.pm it seems that if you call the command
genDB with the parameter "FORCE" it will create the tables regardless
whether they exist or not.
( ca?cmd=genDB;mode=FORCE ).
Regards
Johannes Derek
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of
[EMAIL PROTECTED]
Sent: Wednesday, February 08, 2006 3:35 AM
To: [email protected]
Subject: [Openca-Users] Initialization database again problem
Initialize Database
Hi all
when I initialize Database again it show the below error,
******************************
Error 10021
General Error Error while initializing the database. The table
ca_certificate already exists.
**********************************
but when I do "Show SQL statements for database initialization"
operate,it show the below SQL Statements
**********************************
select * from ca_certificate;
drop table ca_certificate;
create table ca_certificate (ca_cert_key text PRIMARY KEY NOT NULL,
format text, data text, dn text, cn text, email text, status text,
public_key text, notafter int8);
**********************************
maybe the SQL Statements "drop table ca_certificate;" don't work
correctly,but I excute this SQL Stetements directly,it works.what 's the
reason.
--
Yihua Zheng
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://sel.as-us.falkag.net/sel?cmdlnk&kid3432&bid#0486&dat1642
_______________________________________________
Openca-Users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openca-users
--
Yihua Zheng
