Hi,

> What makes me wonder is: if I put only the certificate file in the tar
> file, how should the server know what to do with the file?! Isn't it
> necessary to put it in a directory structure like
> CA_CERTIFICATE/VALID/my_cacert.pem so the server would know where to
> place it in its database?

I think you used the wrong import command. Create the tar
file/floppy as described, one single file 'cacert.pem' in the top
level directory, not compressed.
On the CA interface:
General/Initialization/Initialize Certification Authority/Import
CA Certificate (approved by Root CA)

This should import your CA certificate into the database. Because
of the menu item you chose OpenCA knows exactly what to expect
on the transfer medium.

> Another thing that occured to me is that maybe the table layout differs
> between the different versions.
> Could anyone please send me the output of "describe ca_certificate" on
> the database for a 0.9.2.1 version ra server? I would like to make a
> comparison with the old layout from 0.9.1.8.

When importing the CA Certificate this should not matter, but
anyhow:

mysql> describe ca_certificate;
+-------------+--------------+------+-----+---------+-------+
| Field       | Type         | Null | Key | Default | Extra |
+-------------+--------------+------+-----+---------+-------+
| ca_cert_key | varchar(255) |      | PRI |         |       |
| format      | text         | YES  |     | NULL    |       |
| data        | text         | YES  |     | NULL    |       |
| dn          | text         | YES  |     | NULL    |       |
| cn          | text         | YES  |     | NULL    |       |
| email       | text         | YES  |     | NULL    |       |
| status      | text         | YES  |     | NULL    |       |
| public_key  | text         | YES  |     | NULL    |       |
| notafter    | bigint(20)   | YES  |     | NULL    |       |
+-------------+--------------+------+-----+---------+-------+


cheers

Martin



-------------------------------------------------------
The SF.Net email is sponsored by: Beat the post-holiday blues
Get a FREE limited edition SourceForge.net t-shirt from ThinkGeek.
It's fun and FREE -- well, almost....http://www.thinkgeek.com/sfshirt
_______________________________________________
Openca-Users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openca-users

Reply via email to