sqlite3 fails to install -- sqlite-autoconf-3420000.tar.gz missing from mirrors

[jeremyhu (Jeremy Huddleston Sequoia)]

I hit this when updating ports on my 10.13 machine:

~/src/macports/dports/databases/sqlite3 (master) $ sudo port -v -s checksum
--->  Fetching distfiles for sqlite3
--->  sqlite-autoconf-3420000.tar.gz does not exist in /opt/local/var/macports/distfiles/sqlite3
--->  Attempting to fetch sqlite-autoconf-3420000.tar.gz from http://distfiles.macports.org/sqlite3
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
  0     0    0     0    0     0      0      0 --:--:-- --:--:-- --:--:--     0
--->  Attempting to fetch sqlite-autoconf-3420000.tar.gz from http://mirror.fcix.net/macports/distfiles/sqlite3
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
  0     0    0     0    0     0      0      0 --:--:-- --:--:-- --:--:--     0
--->  Attempting to fetch sqlite-autoconf-3420000.tar.gz from https://www.sqlite.org/2023
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
  0     0    0     0    0     0      0      0 --:--:-- --:--:-- --:--:--     0
--->  Attempting to fetch sqlite-autoconf-3420000.tar.gz from http://ywg.ca.distfiles.macports.org/mirror/macports/distfiles/sqlite3
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
  0     0    0     0    0     0      0      0 --:--:-- --:--:-- --:--:--     0
--->  Attempting to fetch sqlite-autoconf-3420000.tar.gz from http://ykf.ca.distfiles.macports.org/MacPorts/mpdistfiles/sqlite3
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
  0     0    0     0    0     0      0      0 --:--:-- --:--:-- --:--:--     0
--->  Attempting to fetch sqlite-autoconf-3420000.tar.gz from http://kmq.jp.distfiles.macports.org/sqlite3
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
  0     0    0     0    0     0      0      0 --:--:-- --:--:-- --:--:--     0
--->  Attempting to fetch sqlite-autoconf-3420000.tar.gz from http://mse.uk.distfiles.macports.org/sqlite3
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
  0     0    0     0    0     0      0      0 --:--:-- --:--:-- --:--:--     0
--->  Attempting to fetch sqlite-autoconf-3420000.tar.gz from http://ema.uk.distfiles.macports.org/sqlite3
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
  0     0    0     0    0     0      0      0 --:--:-- --:--:-- --:--:--     0
--->  Attempting to fetch sqlite-autoconf-3420000.tar.gz from http://fra.de.distfiles.macports.org/sqlite3
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
  0     0    0     0    0     0      0      0 --:--:-- --:--:-- --:--:--     0
--->  Attempting to fetch sqlite-autoconf-3420000.tar.gz from http://nue.de.distfiles.macports.org/sqlite3
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
  0     0    0     0    0     0      0      0 --:--:-- --:--:-- --:--:--     0
--->  Attempting to fetch sqlite-autoconf-3420000.tar.gz from http://cph.dk.distfiles.macports.org/sqlite3
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
  0     0    0     0    0     0      0      0 --:--:-- --:--:-- --:--:--     0
--->  Attempting to fetch sqlite-autoconf-3420000.tar.gz from http://aarnet.au.distfiles.macports.org/pub/macports/distfiles/sqlite3
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
  0     0    0     0    0     0      0      0 --:--:-- --:--:-- --:--:--     0
--->  Attempting to fetch sqlite-autoconf-3420000.tar.gz from http://cjj.kr.distfiles.macports.org/sqlite3
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
  0     0    0     0    0     0      0      0 --:--:-- --:--:-- --:--:--     0
--->  Attempting to fetch sqlite-autoconf-3420000.tar.gz from http://fco.it.distfiles.macports.org/sqlite3
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
  0     0    0     0    0     0      0      0 --:--:-- --:--:-- --:--:--     0
--->  Attempting to fetch sqlite-autoconf-3420000.tar.gz from http://jog.id.distfiles.macports.org/macports/distfiles/sqlite3
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
  0     0    0     0    0     0      0      0 --:--:-- --:--:-- --:--:--     0
--->  Attempting to fetch sqlite-autoconf-3420000.tar.gz from http://pek.cn.distfiles.macports.org/macports/distfiles/sqlite3
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
  0     0    0     0    0     0      0      0 --:--:-- --:--:-- --:--:--     0
--->  Attempting to fetch sqlite-autoconf-3420000.tar.gz from http://atl.us.distfiles.macports.org/sqlite3
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
  0     0    0     0    0     0      0      0 --:--:-- --:--:-- --:--:--     0
Error: Failed to fetch sqlite3: The requested URL returned error: 404 Not Found
Error: See /opt/local/var/macports/logs/_Users_jeremy_src_macports_macports-ports_databases_sqlite3/sqlite3/main.log for details.
Error: Follow https://guide.macports.org/#project.tickets if you believe there is a bug.
Error: Processing of port sqlite3 failed
‘‘‘

[jeremyhu (Jeremy Huddleston Sequoia)]

$ /usr/bin/curl -LO https://www.sqlite.org/2023/sqlite-autoconf-3420000.tar.gz
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
  0     0    0     0    0     0      0      0 --:--:-- --:--:-- --:--:--     0
curl: (60) SSL certificate problem: certificate has expired
More details here: https://curl.haxx.se/docs/sslcerts.html

curl performs SSL certificate verification by default, using a "bundle"
 of Certificate Authority (CA) public keys (CA certs). If the default
 bundle file isn't adequate, you can specify an alternate file
 using the --cacert option.
If this HTTPS server uses a certificate signed by a CA represented in
 the bundle, the certificate verification probably failed due to a
 problem with the certificate (it might be expired, or the name might
 not match the domain name in the URL).
If you'd like to turn off curl's verification of the certificate, use
 the -k (or --insecure) option.
HTTPS-proxy has similar options --proxy-cacert and --proxy-insecure.

sigh...

[jeremyhu (Jeremy Huddleston Sequoia)]

workaround: Change from https to http... =/

[Schamschula (Marius Schamschula)]

Ugh. I saw no errors when testing this on my build machine.

[Schamschula (Marius Schamschula)]

The build bots cleanly built this update (except for a patch issue for 10.6, which I'll look into).

I tried your direct curl fetch. I see no errors here.

[jmroot (Joshua Root)]

It's on the mirrors now at least.

[ryandesign (Ryan Carsten Schmidt)]

Replying to jeremyhu:

I hit this when updating ports on my 10.13 machine:

Have you done this?

ProblemHotlist#letsencrypt