(Excel) Validate Certificate using OCSP Protocol

Demonstrates how to validate a certificate (check the revoked status) using the OCSP protocol.

Note: This example requires Chilkat v9.5.0.75 or greater

Download Excel Class Modules Chilkat Excel Class Modules

' Note: Requires Chilkat v9.5.0.75 or greater.

' This requires the Chilkat API to have been previously unlocked.
' See Global Unlock Sample for sample code.

' This example will check the revoked status of a certificate loaded from a file.
Dim cert As Chilkat.Cert
Set cert = Chilkat.NewCert

success = cert.LoadFromFile("qa_data/certs/google.crt")
If (success <> True) Then
    Debug.Print cert.LastErrorText
    Exit Sub
End If

' Get the cert's OCSP URL.

ocspUrl = cert.OcspUrl

' Build the JSON that will be the OCSP request.
Dim prng As Chilkat.Prng
Set prng = Chilkat.NewPrng
Dim json As Chilkat.JsonObject
Set json = Chilkat.NewJsonObject
json.EmitCompact = False
success = json.UpdateString("extensions.ocspNonce",prng.GenRandom(36,"base64"))
json.I = 0
success = json.UpdateString("request[i].cert.hashAlg","sha1")
success = json.UpdateString("request[i].cert.issuerNameHash",cert.HashOf("IssuerDN","sha1","base64"))
success = json.UpdateString("request[i].cert.issuerKeyHash",cert.HashOf("IssuerPublicKey","sha1","base64"))
success = json.UpdateString("request[i].cert.serialNumber",cert.SerialNumber)

Debug.Print json.Emit()

' Our OCSP request looks like this:
' {
'   "extensions": {
'     "ocspNonce": "qZDfbpO+nUxRzz6c/SPjE5QCAsPfpkQlRDxTnGl0gnxt7iXO"
'   },
'   "request": [
'     {
'       "cert": {
'         "hashAlg": "sha1",
'         "issuerNameHash": "9u2wY2IygZo19o11oJ0CShGqbK0=",
'         "issuerKeyHash": "d8K4UJpndnaxLcKG0IOgfqZ+uks=",
'         "serialNumber": "6175535D87BF94B6"
'       }
'     }
'   ]
' }

Dim ocspRequest As Chilkat.BinData
Set ocspRequest = Chilkat.NewBinData
Dim http As Chilkat.Http
Set http = Chilkat.NewHttp

' Convert our JSON to a binary (ASN.1) OCSP request
success = http.CreateOcspRequest(json,ocspRequest)

' Send the OCSP request to the OCSP server

Set resp = http.PBinaryBd("POST",ocspUrl,ocspRequest,"application/ocsp-request",False,False)
If (http.LastMethodSuccess <> True) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

' Get the binary (ASN.1) OCSP reply
Dim ocspReply As Chilkat.BinData
Set ocspReply = Chilkat.NewBinData
success = resp.GetBodyBd(ocspReply)

' Convert the binary reply to JSON.
' Also returns the overall OCSP response status.
Dim jsonReply As Chilkat.JsonObject
Set jsonReply = Chilkat.NewJsonObject

ocspStatus = http.ParseOcspReply(ocspReply,jsonReply)

' The ocspStatus can have one of these values:
' -1:  The ARG1 does not contain a valid OCSP reply.
' 0:  Successful - Response has valid confirmations..
' 1: Malformed request - Illegal confirmation request.
' 2: Internal error - Internal error in issuer.
' 3: Try later -  Try again later.
' 4: Not used - This value is never returned.
' 5: Sig required - Must sign the request.
' 6: Unauthorized - Request unauthorized.

If (ocspStatus < 0) Then
    Debug.Print "Invalid OCSP reply."
    Exit Sub
End If

Debug.Print "Overall OCSP Response Status: "; ocspStatus

' Let's examine the OCSP response (in JSON).
jsonReply.EmitCompact = False
Debug.Print jsonReply.Emit()

' The JSON reply looks like this:
' (Use the online tool at https://tools.chilkat.io/jsonParse.cshtml
' to generate JSON parsing code.)

' {
'   "responseStatus": 0,
'   "responseTypeOid": "1.3.6.1.5.5.7.48.1.1",
'   "responseTypeName": "ocspBasic",
'   "response": {
'     "responderIdChoice": "KeyHash",
'     "responderKeyHash": "d8K4UJpndnaxLcKG0IOgfqZ+uks=",
'     "dateTime": "20180803193937Z",
'     "cert": [
'       {
'         "hashOid": "1.3.14.3.2.26",
'         "hashAlg": "SHA-1",
'         "issuerNameHash": "9u2wY2IygZo19o11oJ0CShGqbK0=",
'         "issuerKeyHash": "d8K4UJpndnaxLcKG0IOgfqZ+uks=",
'         "serialNumber": "6175535D87BF94B6",
'         "status": 0,
'         "thisUpdate": "20180803193937Z",
'         "nextUpdate": "20180810193937Z"
'       }
'     ]
'   }
' }
' 

' The certificate status:

certStatus = jsonReply.IntOf("response.cert[0].status")

' Possible certStatus values are:
' 0: Good
' 1: Revoked
' 2: Unknown.
Debug.Print "Certificate Status: "; certStatus