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.