Unable to provision certificate

[mountaincode2]

I am trying to follow the steps in the following document to create a certificate using Certificate Manager:

https://cloud.google.com/certificate-manager/docs/deploy-google-managed-dns-auth#create-cert-dns-aut...

I have a query regarding "Add the CNAME record to your DNS configuration"

https://cloud.google.com/certificate-manager/docs/deploy-google-managed-dns-auth#cname-record 

I have create a public zone using Cloud DNS, but my domain is from Hostinger.

I have added a CNAME record as shown in the documentation.

When i run the command to verify whether my certificate is added, i still don't see the ACTIVE state even after several hours:

createTime: '2024-08-25T03:26:07.788998638Z'
managed:
  authorizationAttemptInfo:
  - domain: <domain>
    state: AUTHORIZING
  dnsAuthorizations:
  - projects/xxxxx/locations/global/dnsAuthorizations/test-dns-auth
  domains:
  - <domain>
  state: PROVISIONING
name: projects/<project>/locations/global/certificates/test-cert
sanDnsnames:
- <domain>
updateTime: '2024-08-25T03:26:08.245783381Z'

After some time, i got the message that the authorization has failed:

createTime: '2024-08-25T03:26:07.788998638Z'
managed:
  authorizationAttemptInfo:
  - domain: <domain>
    failureReason: CONFIG
    state: FAILED
  dnsAuthorizations:
  - projects/xxxxxxxx/locations/global/dnsAuthorizations/test-dns-auth
  domains:
  - <domain>
  provisioningIssue:
    reason: AUTHORIZATION_ISSUE
  state: PROVISIONING
name: projects/<project>/locations/global/certificates/test-cert
sanDnsnames:
- <domain>
updateTime: '2024-08-25T03:26:08.245783381Z'

Where am i going wrong here.