Certificate Expiration Email

Hi Mike,

Please show a picture of the email message you're receiving.

Cheers - Bob

Here is a screen shot of the email

Well I did get a result for the get_objects command, but no results for the get_object_by_name commands.  Here is a screenshot:

I would've thought it would be one of those, Mike.  Here's the complete list of all of the types of ca:

crl            host_key_cert               rsa
csr           http_verification_ca      signing_ca
group       meta_crl                       verification_ca
host_cert  meta_x509

You might try the other ones...

Cheers - Bob

Good afternoon Bob.  I have tried all the other ca types you listed, but I am still getting the same results.

Strange!  The following command will list the entire cert for each and you should be able to pick the one out by the 'enddate' and get the 'type' at the bottom of that entry.

     cc get_objects ca|grep -B 8 -A 14 'B8C3B0C19BA3F1BE'

HOLD THAT THOUGHT!  FACEPALM!  I just realized I used the wrong name in the get_object_by_name commands!  I had '83040476DC6B5D6F' instead of 'B8C3B0C19BA3F1BE'.  I've corrected that in my post above.

Cheers - Bob

Looks like we got something on that run.  I still don't see that in Certificate Management, so obviously I am looking in the wrong place.

So it looks like this is the Proxy CA...

Usually, the notification explicitly calls it the Proxy CA, so I wonder if this isn't an old one no longer in use.

To confirm, run certificates in Windows, and open the MRM2 Inc Proxy CA in 'Certificates' in 'Trusted Root Certification Authorities' to confirm that it's about to expire.  If so, you might download the PEM of the Proxy CA on the 'HTTPS CAs' tab of Web Filtering and open it with Notepad to confirm that it's the same one in your Windows Certs.  If so, then [Regenerate] and install the new Procy CA on all clients.

Cheers - Bob

Recently got a similar message from both nodes of a HA system.
However this system has only a network protection license, so all fields in the web protection page are greyed out.
How can I renew (or at least delete) the Proxy CA via CC and command line?

Well I do not happen to have it on this computer, and have checked a few of the servers.  But I did download the PEM and opened it with Notepad.  The Serial Number matches.  And I now have a clear date as to when it will drop dead.  

Just out of curiosity, would this be at all tied to any expiring licensing for Sophos?

Alan, ask your reseller for a 2-day demo license that includes Web Protection so that you can regenerate the Proxy CA.  Alternatively, you could open a Support ticket for them to fix this at the command line.

Cheers - Bob

Alan, ask your reseller for a 2-day demo license that includes Web Protection so that you can regenerate the Proxy CA.  Alternatively, you could open a Support ticket for them to fix this at the command line.

Cheers - Bob