I have today noticed what appears to be a recent change on the SotaData site is causing a problem for updating the database for my SOTA CSV Editor (it worked on 14th January the last time I updated my own Database).
The problem is that the download of SummitsList.csv from the http version of the SotaData site redirected to the https version of the site and the curl library used in SOTA CSV Editor is unable to validate the SSL Certificate and so generates an Error (Errorcode 60).
Until I can manage to fathom out how to make the curl library accept the SSL Certificate for SotaData site, the following process will be required to update the Database for SOTA CSV Editor:
Stewart, the old website is closing in 28days. It’s probably not worth your time to make changes to your code apart from the satisfaction from supporting your users to the end of life of the old database site.
I see that the link on the New database site for the CSV still points to the SotaData site and I was kind of assuming that the download will still be https after the changes and so I will still need to make the program able to download from https enabled site no matter where the eventual download is from.
I folowed your process but in SOTA_CSV2MDB I got the message “The CSV should not need updating (as it is less than 24 hours old)”.
The process continued and completed successfully in any case - I presume the message is simply due to the fact that I manually downloaded the summits list file, rather than the SOTA_CSV2MDB doing it?
P.S. This manual process certainly worked as I can select the latest Brazialian summit without any problem:
That’s true, you will need to do anyway. Not sure how we are doing the https on the old one but it will probably be different from the new one. So I would only work on the new one. IIRC the new one redirects to the old one but there is a real CSV generated on the new one but I can’t remember where! A search on here may show the link.
There’s examples for libcurl, but like many examples, they assume you know what you should do anyway!
I don’t see that it is a Mingw32 matter as such (as it is libcurl that is doing the work).
I cannot get the latest libcurl version to even link in my Mingw32 project (I just get lots of errors about missing http2 functions).
I have given up (for the time being) trying to fathom out how to get libcurl to accept the certificate (as I have failed to find relevant and understandable documentation) and just issued a changed version of SOTA CSV Editor that does not verify the SSL certificate.
Having looked again it seems I would have have to include the certificate download from your first link in the files installed by the SOTA CSV Editor installer and re-build the code to load it (just seems too messy).
Dropping the mozilla cacert.pem from the second link into the install directory is no different to installing another configuration file.
Without that, you’ll never verify an SSL site. You can either drop the file in the same directory as the software you install and use the path in CURLOPT_CAINFO, or you can ignore verification. The latter is considered very poor form. The former is one extra file, licensed to be distributable, so hardly messy.
This was caused due to the fact that due to other software requirements, the new database server is running CentOS 7.7, which has an older version of the web server software that does not, by default, send the entire certificate chain when requested. I have now updated the configuration to send the full certificate chain and I suspect this will also resolve the SOTA Goat issue too.