How do I fix the issue “Response was ‘curl_exec: SSL certificate problem: unable to get local issuer certificate. Hostname requested was:” in the archiver?

When you setup auto archiving of your reports, you may find it fails to run with the following error: Response was 'curl_exec: SSL certificate problem: unable to get local issuer certificate. Hostname requested was: host.example

When you experience this issue, there are two solutions

1. If possible, address the SSL certificate issue and get a SSL certificate for your domain name running Matomo. Then the core:archive script will be able to talk to Matomo over HTTPS without error.

2. Or if for some reason you cannot, then you can edit your crontab and add the following parameter --accept-invalid-ssl-certificate to the core:archive command for example:

   /usr/bin/php /path/to/matomo/console core:archive --accept-invalid-ssl-certificate --url=http://example.org/matomo/ > /dev/null

   Once the script knows to ignore the SSL certificate problem using this parameter, the error should be gone and the archiving script should hopefully proceed and succeed.