XenMobile - Deleting the certificate entries directly from the Database

book

Article ID: CTX223426

calendar_today

Updated On:

Description

When we try to upload new SSL cert on XenMobile server, it fails to to get uploaded because of present certificate and because of data corruption in DB we are not able to delete the old certificate from the XenMobile console so in such scenario, we need to delete it from database directly.

Note: However it is not recommended but if there is no other option left, we can delete the certificate from database but please ensure to take Full backup of the database before this activity.

Resolution

Delete the certificate entries from the database by running the below SQL Query.

'11' is used in this example but it can be any number; this depends on your own Database column number.
You will first need to examine your own database table directly so that you can correctly identify the correct value to use here.

Select * from dbo.certificate_chain_association where ssl_cert_id='11' (It will present the SSL cert column)
Delete from dbo.certificate_chain_association where ssl_cert_id='11'

This will remove the association of the certificate from the Root and Intermediate chain.

Select * from dbo.certificate where id='11'
delete from dbo.certificate where id='11'

This query will remove the certificate from the Database completely and from Console as well.

Problem Cause

The certificate entry might have gone corrupted in the Database.

Was this article helpful?

thumb_up Yes

thumb_down No

Welcome to "KB Articles"