Converting Exported Certificate Information From Sybase DB to Readable .cer file

  • 7017256
  • 12-Feb-2016
  • 21-Mar-2016

Environment

Novell ZENworks Configuration Management 11

Situation

For troubleshooting purposes where the certificate information from the database is needed in the .cer file format.

Resolution

1. Open a text editor with a blank new file.

2. Copy and paste the following into the open file:

-----BEGIN CERTIFICATE-----

-----END CERTIFICATE-----

3. Do the following query to get the certificate information: " SELECT * from zCertificate; " (this will pull on all certificates in that table along with other info)

4.  Use the "Copy from Cell" right click option on the desired 'Certificate' information and paste that in between the begin and end statement

5. Save file as .cer file

Cause

The way ZENworks stores certificate information includes end of line statements (\x0a, \x0d). It also contains single quotes at the beginning and end. Furthermore it does not contain the begin and end statements as found in valid certificates.

Feedback service temporarily unavailable. For content questions or problems, please contact Support.