Farnell/Element14 API Error

[PressurisedAngus]

I've setup a partdb instance on a debian server using proxmox and started connecting to the part distributor APIs. Mouser, LCSC, and TME works fine, however Farnell is proving to be an issue. I have created an application API with farnell's partner program and loaded in the key into the .env.local using uk.farnell.com.

When requesting data from farnell through info providers form, I get a status 500 error and the output to the log is:
partdblog.txt

The request can be seen at [2025-02-21T10:12:29.055824+00:00].

PHP version: 8.2.26
Browser: Chrome V132.0.6834.197
OS: Debian 12
PartDB: V1.15.2

[jbtronics]

I think the relevant issue here is "SSL certificate problem: unable to get local issuer certificate for"?
So it seems that the CA mouser uses to sign their TLS request, is not recognized as valid by your system.
So you should probably check tht your system CA storage is up to date.

Do you run Part-DB as server on Windows 10 22H2? Directly without docker?
Does your PHP has the curl extension available and usable. (Its not really a hard dependencies, but the non-curl methods to make http requests, are a bit odd sometimes...)

[PressurisedAngus]

Apologies, i provided the incorrect information on the OS. It has been updated in the original post. Just to check, the Mouser API works fine, however the farnell API is the issue. The PHP on the server has the latest version of curl, V1.88.1-10+deb12u8.

[jbtronics]

You should still check your certificate store, just because mouser certificates are accepted, this doesnt necesarilly mean, that farnell have to do to. They use different CAs for their certificates...

[PressurisedAngus]

I ran update-ca-certificates which didn't find any that needed replaced. There aren't any in the list that obviously pertain to farnell. Is there a specific one i should check for?

[jbtronics]

"SSL.com TLS RSA Root CA 2022" as root CA and maybe "Entrust OV TLS Issuing RSA CA 1" as intermediate certificates. These are the certs that signed the api.element14.com TLS cert.