[Metadata Source Plugin] BOL.com (NL)

[Pr.BarnArt]

Originally Posted by willempie

kan geen contact meer maken met BOL.COM. om gegevens te importeren naar Calibre.

I don't have problems connecting and retrieving data.
If you have problems, please add a book and author name

[willempie]

Kan in Calibre geen gegevens meer binnenhalen via Bol.nl.

[willempie]

Kan geen gegevens van boeken binnen halen via BOL.COM met Calibre.
Ook al heb ik het isbn nummer ingevoerd en druk ik op metagegevens invoeren krijg ik de boodschap: Fout: geen zoekresultaten. Kan geen boeken vinden die overeenkomen met uw zoekopdracht enz.
Kunt u mij helpen met dit vervelende probleem?
Alvast bedankt.
M.v.g. Wim Kuijlen

[Pr.BarnArt]

Originally Posted by willempie

Kan geen gegevens van boeken binnen halen via BOL.COM met Calibre.
Ook al heb ik het isbn nummer ingevoerd en druk ik op metagegevens invoeren krijg ik de boodschap: Fout: geen zoekresultaten. Kan geen boeken vinden die overeenkomen met uw zoekopdracht enz.
Kunt u mij helpen met dit vervelende probleem?
Alvast bedankt.
M.v.g. Wim Kuijlen

I have sent you a pm.

[janvm]

Hi Pr.BarnArt,
I'd like to inform you that plugin reports this error:
[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired
hope you can look into it,
kind regards

calibre, version 6.28.1
FOUT: Geen zoekresultaten gevonden: <p>Kan geen boeken vinden die overeenkomen met uw zoekopdracht. Probeer de zoekopdracht <b>minder specifiek</b> te maken. Gebruik bijvoorbeeld alleen de achternaam van de auteur en een enkel onderscheidend woord uit de titel.<p>Klik op 'Details weergeven' om het volledige logbestand weer te geven.

Running identify query with parameters:
{---knip---}
Using plugins: BOL_NL (5, 1, 3)
The log from individual plugins is below

****************************** BOL_NL (5, 1, 3) ******************************
Found 0 results
Downloading from BOL_NL took 0.08600211143493652
Querying: https://www.bol.com/nl/s/?searchtext...text=media_all
Plugin BOL_NL failed
Traceback (most recent call last):
File "mechanize\_urllib2_fork.py", line 1236, in do_open
File "http\client.py", line 1282, in request
File "http\client.py", line 1328, in _send_request
File "http\client.py", line 1277, in endheaders
File "http\client.py", line 1037, in _send_output
File "http\client.py", line 975, in send
File "http\client.py", line 1454, in connect
File "ssl.py", line 512, in wrap_socket
File "ssl.py", line 1070, in _create
File "ssl.py", line 1341, in do_handshake
ssl.SSLCertVerificationError: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:997)

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "calibre\ebooks\metadata\sources\identify.py", line 47, in run
File "calibre_plugins.BOL_NL.__init__", line 302, 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 28, in https_open
File "mechanize\_urllib2_fork.py", line 1240, in do_open
urllib.error.URLError: <urlopen error [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:997)>

************************************************** ******************************
The identify phase took 0.21 seconds
The longest time (0.086002) was taken by: BOL_NL
Merging results from different sources
We have 0 merged results, merging took: 0.00 seconds

[Pr.BarnArt]

Originally Posted by janvm

Hi Pr.BarnArt,
[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired

You have had this problem before, way back on 2016,24 march , see your post here https://www.mobileread.com/forums/showthread.php?
p=3286763&highlight=ssl#post3286763

The problem is not related to the plugin . It has to do with valid certificates , which seems missing on your computer. Do not know what operating system you use ( osX, windows or Linux)?

Originally Posted by JimmXinu

SSL problems are generally not the plugins fault. On windows they tend to be issues with the OS cert base.

Take a look at the solution from this earlier report of a similar problem.

and your solution was

Originally Posted by janvm

mine is windows 8.1
I made sure that ALL (optional) updates are installed, that didn't solve the SSL-verification-failed troubles.

Started certlm.msc from the command line
Cleared the profile (certlm.msc|opties|Bestanden verwijderen), and now the plugin returns info from the BOL-plugin.

I'm cluesless what caused the error to be honest, anyway, it works, yeah :-)

https://www.mobileread.com/forums/sh...sl#post3289531

[janvm]

This error is apparently due to an expired root certificate from Let’s Encrypt that might be stored in your Windows.

Calibre uses the Mechanize library to create a browser object and downloads pages using that. That object uses the root certificates from Windows and so is affected by the expired root certificate. The browsers have their own certificate store and so they are unaffected.

To delete the expired certificate:

Open the Certificates Manager by starting certmgr.msc. This shows the certificates in the stores on your Windows.
In the left pane, choose Intermediate Certification Authorities -> Certificates.
In the right pane, choose the R3 certificate from Let’s Encrypt. Make sure that its Expiration Date is in the past. If so, delete it.
Close the Certificates Manager.

After this, Calibre should be able to download the news.

source: https://codeyarns.com/tech/2022-03-1...html#gsc.tab=0

works for me

[leokennis]

Hi! Since some time the plugin fails to find book covers from Bol, I get this error in the log:

****************************** BOL_NL 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 1.3092751502990723 seconds
No cached cover found, running identify
Querying: https://www.bol.com/nl/s/?searchtext...text=media_all
BOL_NL url: 'https://www.bol.com/nl/nl/p/de-nadagen/9200000091698478/'
Error parsing cover for url: 'https://www.bol.com/nl/nl/p/de-nadagen/9200000091698478/'
Traceback (most recent call last):
File "calibre_plugins.BOL_NL.worker", line 203, in parse_details
self.cover_url = self.parse_cover(root)
File "calibre_plugins.BOL_NL.worker", line 965, in parse_cover
raw = response.decode('utf-8', errors='replace')
UnboundLocalError: local variable 'response' referenced before assignment

No cover found

************************************************** ******************************

[Pr.BarnArt]

Originally Posted by leokennis

Hi! Since some time the plugin fails to find book covers from Bol, I get this error in the log:

Can you try again, I myself have no problems getting the cover

[willempie]

Running identify query with parameters:
{'title': 'Huwelijk als prijs', 'authors': ['Madeleine Ker'], 'identifiers': {'isbn': '9789034706195'}, 'timeout': 30}
Using plugins: BOL_NL (5, 1, 3)
The log from individual plugins is below

****************************** BOL_NL (5, 1, 3) ******************************
Found 0 results
Downloading from BOL_NL took 0.19214987754821777
Querying: https://www.bol.com/nl/s/?searchtext...text=media_all
Plugin BOL_NL failed
Traceback (most recent call last):
File "mechanize\_urllib2_fork.py", line 1236, in do_open
File "http\client.py", line 1286, in request
File "http\client.py", line 1332, in _send_request
File "http\client.py", line 1281, in endheaders
File "http\client.py", line 1041, in _send_output
File "http\client.py", line 979, in send
File "http\client.py", line 1458, in connect
File "ssl.py", line 517, in wrap_socket
File "ssl.py", line 1108, in _create
File "ssl.py", line 1379, in do_handshake
ssl.SSLCertVerificationError: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:1006)

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "calibre\ebooks\metadata\sources\identify.py", line 47, in run
File "calibre_plugins.BOL_NL.__init__", line 302, 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 28, in https_open
File "mechanize\_urllib2_fork.py", line 1240, in do_open
urllib.error.URLError: <urlopen error [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:1006)>

************************************************** ******************************
The identify phase took 0.20 seconds
The longest time (0.192150) was taken by: BOL_NL
Merging results from different sources
We have 0 merged results, merging took: 0.00 seconds

[Pr.BarnArt]

Originally Posted by willempie

Running identify query with parameters:
{'title': 'Huwelijk als prijs', 'authors': ['Madeleine Ker'], 'identifiers': {'isbn': '9789034706195'}, 'timeout': 30}
Using plugins: BOL_NL (5, 1, 3)
The log from individual plugins is below

****************************** BOL_NL (5, 1, 3) ******************************
Found 0 results
Downloading from BOL_NL took 0.19214987754821777
Querying: https://www.bol.com/nl/s/?searchtext...text=media_all
Plugin BOL_NL failed
File "ssl.py", line 1379, in do_handshake
ssl.SSLCertVerificationError: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:1006)

File "mechanize\_urllib2_fork.py", line 1240, in do_open
urllib.error.URLError: <urlopen error [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:1006)>

Did you try this https://www.mobileread.com/forums/sh...&postcount=502 ?