Attempts to download metadata and covers fail

Eskoe · 10-01-2021, 10:51 AM

I've been using Calibre for years without problem, including keeping a semi-large library organized. After several months of not needing to change any metadata, I decided to do a bit of updating and ran into problems I've never had before:

#################### Log for How To Prove It ####################

Spoiler:

kovidgoyal · 10-01-2021, 12:47 PM

Thats a problem with the windows certificate store on your machine. Try visiting the involved sites in edge to refresh the certificates.

PeterT · 10-01-2021, 02:51 PM

Additionally see if these steps help. I realize it's from a different plugin but it might be worth a try.

Quote:

Originally Posted by jhowell

The problem in accessing OverDrive libraries via this plugin is apparently caused by an expired Let's Encrypt certificate used by OverDrive. For some reason an associated expired intermediate certificate has been left behind causing problems with creating a secure connection via Python and therefore calibre under Windows 11.

I was able to resolve this problem on my system by doing the following:

Click in the Windows search box in the task bar and enter certmgr.msc to open the certificate manager for the current user.
In the left panel select Certificates under Intermediate Certification Authorities.
In the right pane scroll down to R3. Double click to open it and note that the Valid from/to dates are both in the past.
Click OK to close the dialog.
Press DEL to delete the R3 entry.
Select YES to confirm deletion.
Close certmgr.

Sent from my Pixel 4a using Tapatalk

Eskoe · 10-02-2021, 02:25 AM

Quote:

Originally Posted by kovidgoyal

Thats a problem with the windows certificate store on your machine. Try visiting the involved sites in edge to refresh the certificates.

I visited the sites with Edge (and re-looked at Chrome) and both browsers say the certs are valid.

Quote:

Originally Posted by PeterT

Additionally see if these steps help. I realize it's from a different plugin but it might be worth a try.

There was no 'R3' in my Intermediate Certification Authorities folder, unfortunately.

10-01-2021, 10:51 AM	#1
Eskoe Member Posts: 14 Karma: 10 Join Date: Jan 2011 Device: Sony Reader	Attempts to download metadata and covers fail I've been using Calibre for years without problem, including keeping a semi-large library organized. After several months of not needing to change any metadata, I decided to do a bit of updating and ran into problems I've never had before: #################### Log for How To Prove It #################### Spoiler: Running identify query with parameters: {'title': 'How To Prove It', 'authors': ['Daniel J. Velleman'], 'identifiers': {}, 'timeout': 30} Using plugins: Goodreads (1, 5, 1) The log from individual plugins is below **************************** Goodreads (1, 5, 1) ************************** Found 0 results Downloading from Goodreads took 1.1773455142974854 identify - start. title=How To Prove It, authors=['Daniel J. Velleman'], identifiers={} Querying: https://www.goodreads.com/search?sea...e=books&search[query]=How+To+Prove+It+Daniel+Velleman Failed to make identify query: 'https://www.goodreads.com/search?search_type=books&search[query]=How+To+Prove+It+Daniel+Velleman' Traceback (most recent call last): File "mechanize\_urllib2_fork.py", line 1236, in do_open File "http\client.py", line 1255, in request File "http\client.py", line 1301, in _send_request File "http\client.py", line 1250, in endheaders File "http\client.py", line 1010, in _send_output File "http\client.py", line 950, in send File "http\client.py", line 1424, in connect File "ssl.py", line 500, in wrap_socket File "ssl.py", line 1040, in _create File "ssl.py", line 1309, in do_handshake ssl.SSLCertVerificationError: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get issuer certificate (_ssl.c:1123) During handling of the above exception, another exception occurred: Traceback (most recent call last): File "calibre_plugins.goodreads.__init__", line 218, in identify File "mechanize\_mechanize.py", line 241, in open_novisit File "mechanize\_mechanize.py", line 287, in _mech_open File "mechanize\_opener.py", line 193, in open File "mechanize\_urllib2_fork.py", line 425, in _open File "mechanize\_urllib2_fork.py", line 414, in _call_chain File "calibre\utils\browser.py", line 29, in https_open File "mechanize\_urllib2_fork.py", line 1240, in do_open urllib.error.URLError: ********************************************** ************************** The identify phase took 1.24 seconds The longest time (1.177346) was taken by: Goodreads Merging results from different sources We have 0 merged results, merging took: 0.00 seconds Failed to download metadata for How To Prove It ************************** Goodreads Covers ************************** Request extra headers: [('User-agent', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.87 Safari/537.36')] Failed to download valid cover Took 0.17229866981506348 seconds No cached cover found, running identify identify - start. title=How To Prove It, authors=['Daniel J. Velleman'], identifiers={} Querying: https://www.goodreads.com/search?sea...e=books&search[query]=How+To+Prove+It+Daniel+Velleman Failed to make identify query: 'https://www.goodreads.com/search?search_type=books&search[query]=How+To+Prove+It+Daniel+Velleman' Traceback (most recent call last): File "mechanize\_urllib2_fork.py", line 1236, in do_open File "http\client.py", line 1255, in request File "http\client.py", line 1301, in _send_request File "http\client.py", line 1250, in endheaders File "http\client.py", line 1010, in _send_output File "http\client.py", line 950, in send File "http\client.py", line 1424, in connect File "ssl.py", line 500, in wrap_socket File "ssl.py", line 1040, in _create File "ssl.py", line 1309, in do_handshake ssl.SSLCertVerificationError: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get issuer certificate (_ssl.c:1123) During handling of the above exception, another exception occurred: Traceback (most recent call last): File "calibre_plugins.goodreads.__init__", line 218, in identify File "mechanize\_mechanize.py", line 241, in open_novisit File "mechanize\_mechanize.py", line 287, in _mech_open File "mechanize\_opener.py", line 193, in open File "mechanize\_urllib2_fork.py", line 425, in _open File "mechanize\_urllib2_fork.py", line 414, in _call_chain File "calibre\utils\browser.py", line 29, in https_open File "mechanize\_urllib2_fork.py", line 1240, in do_open urllib.error.URLError: No cover found ********************************************** ************************** ************************** Kindle hi-res covers Covers ************************** Request extra headers: [('User-agent', 'Mozilla/5.0 (Windows NT 10.0; WOW64; Trident/7.0; rv:11.0) like Gecko')] Failed to download valid cover Took 0.15785479545593262 seconds ASIN not present in metadata Goodreads id not present in metadata ISBN not present in metadata Searching Goodreads for book: https://www.goodreads.com/search?q=H...el+J.+Velleman Failed to download cover from Kindle hi-res covers Traceback (most recent call last): File "mechanize\_urllib2_fork.py", line 1236, in do_open File "http\client.py", line 1255, in request File "http\client.py", line 1301, in _send_request File "http\client.py", line 1250, in endheaders File "http\client.py", line 1010, in _send_output File "http\client.py", line 950, in send File "http\client.py", line 1424, in connect File "ssl.py", line 500, in wrap_socket File "ssl.py", line 1040, in _create File "ssl.py", line 1309, in do_handshake ssl.SSLCertVerificationError: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get issuer certificate (_ssl.c:1123) During handling of the above exception, another exception occurred: Traceback (most recent call last): File "calibre\ebooks\metadata\sources\covers.py", line 42, in run File "calibre_plugins.dummy1.__init__", line 28, in download_cover File "calibre_plugins.dummy1.__init__", line 75, in get_cover_urls File "calibre_plugins.dummy1.__init__", line 97, in search_edition_goodreads File "mechanize\_mechanize.py", line 257, in open File "mechanize\_mechanize.py", line 287, in _mech_open File "mechanize\_opener.py", line 193, in open File "mechanize\_urllib2_fork.py", line 425, in _open File "mechanize\_urllib2_fork.py", line 414, in _call_chain File "calibre\utils\browser.py", line 29, in https_open File "mechanize\_urllib2_fork.py", line 1240, in do_open urllib.error.URLError: ********************************************** ************************** ************************** Google Images Covers ************************** Request extra headers: [('User-agent', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.212 Safari/537.36')] Downloaded cover: 1200x1920 Took 1.2633206844329834 seconds Search URL: https://www.google.com/search?as_st=...,iar:t,ift:jpg Downloading 1 covers Downloaded cover from: https://kbimages1-a.akamaihd.net/135...o-prove-it.jpg ********************************************** **************************** Last edited by theducks; 10-01-2021 at 12:17 PM. Reason: spoilered

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Cannot download metadata or covers	MOJOJE	Library Management	10	04-10-2021 01:52 PM
download of metadata and covers	paai	Library Management	0	03-26-2021 09:06 AM
Metadata download - no covers	blaubach	Calibre	4	07-08-2013 04:06 AM
Metadata download fail	lathom	Library Management	6	11-15-2011 04:25 PM
Does "Download Metadata & Covers" also download social metadata?	iridius	Library Management	3	02-22-2011 01:50 PM

10-01-2021, 12:47 PM	#2
kovidgoyal creator of calibre Posts: 44,564 Karma: 24495948 Join Date: Oct 2006 Location: Mumbai, India Device: Various	Thats a problem with the windows certificate store on your machine. Try visiting the involved sites in edge to refresh the certificates.

Advert