[Metadata Source Plugin] Goodreads

[Terisa de morgan]

Originally Posted by kovidgoyal

If I had to guess it will likely be that *some* GR servers have an invalid certificate and some do not. Depending on which you connect to, you get working or not. Hopefully they will fix it.

It happened with Fantastic Fiction too, and Amazon and Kobo returned 503 error, so something strange happened in my computer.

[Comfy.n]

Might be worth noting that the GR author notes plugin is working fine here, probably because it bundles a lot of dependencies or whatever it's called

[Terisa de morgan]

Originally Posted by Comfy.n

Might be worth noting that the GR author notes plugin is working fine here, probably because it bundles a lot of dependencies or whatever it's called

Not only that. My previous situation (certificate failing), goodreads_sync plugin:

• Look for a title: works
• Switch edition: Fails with certificated failure

As I say, something in my system (no idea what).

[Comfy.n]

Phew! Here's how I solved it on my Windows machine, using Waterfox (the same steps should apply to Firefox):

Went to Goodreads website -> pressed Ctrl+I to open More Info dialog > selected "Security" -> clicked View Certificate -> then on Miscellaneous section: downloaded PEM cert. (there are three inner "tabs" in that about:certificate page: www.goodreads.com, Amazon RSA 2048 M03 and Amazon Root CA 1. I used www.goodreads.com.)

Then I imported the certs following these instructions

certutil –addstore -enterprise –f "Root" c:\cert\www-goodreads-com-chain.pem
certutil –addstore -enterprise –f "Root" c:\cert\www-goodreads-com.pem

Tried downloading metadata. No good. Restarted computer. Tried again... no good!

Then I ran certmgr.msc (winkey + r), went to Trusted Root Certification Authorities -> Certificates -> double clicked the last one on the list www.goodreads.com, and after that I tried again and it worked!!

[Comfy.n]

And I guess I found out why GR Author Notes plugin was working fine even when I was getting the _ssl.c:1006 error on metadata downloads: it comes with its own bundle of certificates located in \plugins\gr_author_notes-libs-py3.11\certifi\cacert.pem

[Terisa de morgan]

Originally Posted by Comfy.n

Phew! Here's how I solved it on my Windows machine, using Waterfox (the same steps should apply to Firefox):

Went to Goodreads website -> pressed Ctrl+I to open More Info dialog > selected "Security" -> clicked View Certificate -> then on Miscellaneous section: downloaded PEM cert. (there are three inner "tabs" in that about:certificate page: www.goodreads.com, Amazon RSA 2048 M03 and Amazon Root CA 1. I used www.goodreads.com.)

Then I imported the certs following these instructions

certutil –addstore -enterprise –f "Root" c:\cert\www-goodreads-com-chain.pem
certutil –addstore -enterprise –f "Root" c:\cert\www-goodreads-com.pem

Tried downloading metadata. No good. Restarted computer. Tried again... no good!

Then I ran certmgr.msc (winkey + r), went to Trusted Root Certification Authorities -> Certificates -> double clicked the last one on the list www.goodreads.com, and after that I tried again and it worked!!

Puff, I'll have to save this just in case.

[jeannetten2012]

I'm not getting any metadata from goodread. Anyone having this issue?

[DNSB]

For me. opening goodreads.com in Edge seemed to have updated the certificate store so the plugin is fetching metadata again. At least, I now show Amazon Root Ca 1 in Trusted Root Certification Authorities (expiry 2038) & Amazon RSA 2048 M03 Intermediate Certification Authorities (expiry 2030) respectively. Since Firefox manages it's own certificate store, opening the site in Firefox and it's cousins doesn't help with the system certificate store.

[Comfy.n]

I guess the Edge fix should be enough for most users. In my system I pretty much disable all Edge built-in related stuff and use only a portable Edge version on occasion.

[DNSB]

Since Firefox is my goto web browser, I could probably disable Edge as a web browser but I use it for testing so will leave it for now.

[Eskarina]

I too am having trouble getting metadata from Goodreads. I noticed this about 2-3 days ago. I use edge browser and the edge "fix" mentioned above (using edge to go to goodreads.com) doesn't work for me. I'm on Windows 10 machine and just downloaded calibre 7.19. Still no luck.

One (hopefully temporary) workaround is to change the metadata source to Amazon and Google metadata and that seems to work fine but however, I find that Goodreads as a source is superior.

[kiwidude]

I haven't seen a single issue personally, I did a bunch of metadata downloads today with Goodreads and they all worked flawlessly. So while I sympathise with some people having issues I can't fix what isn't broken for me

[Terisa de morgan]

Originally Posted by Comfy.n

Phew! Here's how I solved it on my Windows machine, using Waterfox (the same steps should apply to Firefox):

Went to Goodreads website -> pressed Ctrl+I to open More Info dialog > selected "Security" -> clicked View Certificate -> then on Miscellaneous section: downloaded PEM cert. (there are three inner "tabs" in that about:certificate page: www.goodreads.com, Amazon RSA 2048 M03 and Amazon Root CA 1. I used www.goodreads.com.)

Then I imported the certs following these instructions

certutil –addstore -enterprise –f "Root" c:\cert\www-goodreads-com-chain.pem
certutil –addstore -enterprise –f "Root" c:\cert\www-goodreads-com.pem

Tried downloading metadata. No good. Restarted computer. Tried again... no good!

Then I ran certmgr.msc (winkey + r), went to Trusted Root Certification Authorities -> Certificates -> double clicked the last one on the list www.goodreads.com, and after that I tried again and it worked!!

As I use more than one computer, I had the same problem in another one today. The thing that solved it was curl a goodreads address, that's all.

[JSWolf]

Originally Posted by Terisa de morgan

Currently, I'm getting "ssl.SSLCertVerificationError: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1006) " every time I try to download data from goodreads. And I'm authorized in the website as I've connected to it in Chrome. Same is happening with FatasticFiction plugin, so I don't know if it's somthing which has been messed in my installation.

Shouldn't you be authorized in Edge as that's what Windows uses?

[JSWolf]

Originally Posted by Comfy.n

B&N works but I miss the ratings and votes from GR.

You have to be very careful with ratings and votes on GR. They can be so very wrong is the book is new enough because the staff allow crap with new books even before they are released. It takes quite a while to get rid of the crap because the people who out in the crap have to read the book and then overwrite the crap with a real review and a real rating.