Skip to content

Problem with the SSL CA cert when using LOAD CSV #3791

@tonilastre

Description

@tonilastre

Memgraph version
Memgraph 3.8.0

Environment
Docker on ARM, image: memgraph/memgraph:3.8.0. Connected to it via Lab 3.8.0.

Describe the bug
Loading prepared datasets in the Lab fails with the error Couldn't perform request: Problem with the SSL CA cert. I extracted one of the Cypher queries (LOAD CSV) and replicated the same bug. It doesn't happen on memgraph/memgraph:3.7.0 or Memgraph debian package.

To Reproduce
Steps to reproduce the behavior:

  1. Run the following query
LOAD CSV FROM "https://download.memgraph.com/datasets/icij-pandora-papers/csv/nodes-country.csv.gz"
WITH HEADER IGNORE BAD AS row
CREATE (:Country {
  name: row.name,
  iso_2_code: row.iso_2_code,
  iso_3_code: row.iso_3_code,
  region: row.region,
  sub_region: row.sub_region
});

Expected behavior
HTTP request to pass because the certificates are valid, so it should trust the destination (download.memgraph.com).

Logs

[memgraph_log] [debug] [Run - memgraph] 'LOAD CSV FROM "https://download.memgraph.com/datasets/icij-pandora-papers/csv/nodes-country.csv.gz"
WITH HEADER IGNORE BAD AS row
CREATE (:Country {
  name: row.name,
  iso_2_code: row.iso_2_code,
  iso_3_code: row.iso_3_code,
  region: row.region,
  sub_region: row.sub_region
})' - {queryId:"586b4448-b674-4e4f-99f9-6d83e86f0a12", source:"lab-user"}
[memgraph_log] [warning] [:200] Couldn't perform request: Problem with the SSL CA cert (path? access rights?)

Lab screenshot:

Image

Additional context
None.

Verification Environment
Once we fix it, what do you need to verify the fix?
Do you need:

  • Plain memgraph Docker image? Docker
  • Which architecture do you use ARM | x86? ARM

Metadata

Metadata

Assignees

Type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions