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?cmd=lnk&kid3432&bid#0486&dat1642 _______________________________________________ Openca-Users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/openca-users
