Each table view in XCA has an optionalĬolumn 'Primary key' that may be shown to get the ID of the item in the database.

The item names are not required to be unique anymore.

Sqlite3 ~/xca.xdb 'UPDATE items SET comment='My notes' WHERE id=3' Sqlite3 ~/xca.xdb 'SELECT crl FROM view_crls WHERE name='ca'' | base64 -d | openssl crl -inform DER Sqlite3 ~/xca.xdb 'SELECT private FROM view_private WHERE name='pk8key'' | base64 -d | openssl pkcs8 -inform DER Įxtract the private key with internal name 'pk8key' from the database Field definition features stored in the file's is data dictionary can. The sqlitebrowser may be used to examine the elements of the database.Īll cryptographic items are stored as base64 DER format and must beĭecoded before feeding them to OpenSSL: | base64 -d | openssl -inform DER. XDB will unveil the 08/2 versions of developmenttools. This is useful if XCA is used as default application for viewing certificates, keys or requests. Option given it will exit after finishing the import dialog. Usually after importing the items from command-line Just put all keys, certificates, requests and the database unsorted on the command-line.įor backwards compatibility those options are ignored when found. There are some deprecated legacy options: īefore XCA 0.9.0, the type of the items had to be given.

-I creates an OpenSSL index file for each CA in the given,Įxisting directory containing all issued certificates.

-i creates an OpenSSL index file containing all certificates.

-x exit after processing all command line options.

-d set the database filename (only needed to create a new db).

Next to the usual X command line options. XCA - X Certificate and key management: Command Line Options Next Previous Contents

How to open xdb file