Hello,
We have an old OpenCA Installation ( 1.0.2) where we want to try to update this
to version 1.5.1.
Someone has set up the old installation with DBM files and now we want to
migrate the DBM files into a PostgreSQL Database I have installed with the new
OpenCA 1.5.1
So with a clean installation I got the following error when I try to import the
exported backup via the Node interface:
Test the archive ...
/bin/tar -tvf /tmp/openca_local
Importing archive ...
Load required variables ...
Changing to directory /opt/openca/ca3/var/openca/tmp/tmp_6914 ...
Running the import command(s) ...
/bin/tar -xvf /tmp/openca_local -C
/opt/openca/ca3/var/openca/tmp/tmp_6914
Importing valid CA_CERTIFICATE ...
Cleaning up the collected import logs ...
f3e178ba2f7a6f6abdbd0f9516754155eb5d7cb228d0dbad884cc008a6dd2f0a.pem
inserted
Importing expired CA_CERTIFICATE ...
Cleaning up the collected import logs ...
No objects are present.
Importing new CRR ...
Cleaning up the collected import logs ...
18176.crr inserted
Importing pending CRR ...
Cleaning up the collected import logs ...
No objects are present.
Importing signed CRR ...
Cleaning up the collected import logs ...
No objects are present.
Importing approved CRR ...
Cleaning up the collected import logs ...
No objects are present.
Importing archived CRR ...
Cleaning up the collected import logs ...
16384.crr inserted
FAILURE: Cannot insert object and object is not present in database
FILE: /opt/openca/ca3/var/openca/tmp/tmp_6914/CRR/ARCHIVED/7936.crr
FAILURE: Cannot insert object and object is not present in database
FILE: /opt/openca/ca3/var/openca/tmp/tmp_6914/CRR/ARCHIVED/4096.crr
FAILURE: Cannot insert object and object is not present in database
FILE: /opt/openca/ca3/var/openca/tmp/tmp_6914/CRR/ARCHIVED/13312.crr
FAILURE: Cannot insert object and object is not present in database
FILE:
/opt/openca/ca3/var/openca/tmp/tmp_6914/CRR/ARCHIVED/7424.crr
And much more of these errors.
/opt/openca/ca3/var/openca/log/stderr.log
shows that the operator with the given name and argiments do not match and that
the transaction was aborted. (DBD::Pg::st execute failed:
/opt/openca/ca/modules/perl5/OpenCA/DBI.pm at line 3345.
A colleague has also set up a OpenCA 1.0.2 and PostgreSQL. when backing up the
DBM files via the Node interface of our old installation and importing it to
the new OpenCA 1.0.2 with PostgreSQL then everything is stored in DBM files
instead of SQL.
The config.xml has the DBI option and when we create new certificates
everything is stored within the SQL database. Via the webgui we can see the new
created certificates from the SQL database and the imported certificates within
the DBM files. Its a biz strange.
So does someone now how to migrate the contents of the DBM files into a SQL
databse?
Thanks for help :)
------------------------------------------------------------------------------
_______________________________________________
Openca-Users mailing list
Openca-Users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openca-users
