topic Re: How to connect Neo4j aura to a cluster in Data Engineering

How to connect Neo4j aura to a cluster

Nyarish — Sun, 12 Sep 2021 04:42:00 GMT

Please help resolve this error :

org.neo4j.driver.exceptions.SecurityException: Failed to establish secured connection with the server

This occurs when I want to establish a connection to neo4j aura to my cluster .

Thank you.

Re: How to connect Neo4j aura to a cluster

Nyarish — Mon, 13 Sep 2021 04:20:53 GMT

any help guys?

Re: How to connect Neo4j aura to a cluster

-werners- — Mon, 13 Sep 2021 06:55:28 GMT

https://aura.support.neo4j.com/hc/en-us/articles/1500003161121

Aura needs some additional setup on your cluster.

Re: How to connect Neo4j aura to a cluster

Nyarish — Mon, 13 Sep 2021 07:00:51 GMT

hi @Werner Stinckens thanks for the feedback. I've gone through that articles several times, but I still get the same error. what could I be missing with my Databricks setup ?

Re: How to connect Neo4j aura to a cluster

-werners- — Mon, 13 Sep 2021 07:07:43 GMT

The shell script will disable some encryption algorithms.

What you can do is check the logs if the bash script gives any errors.

Also check if the /databricks/spark/dbconf/java/extra.security is actually there.

And also check the settings which are set in the script.

That's about it what I can think of. You could also try to use different versions of databricks, or check the databricks log, because maybe you have to disable/enable a certain algorithm which is not in the bash script.

Thinking out loud here though.

Re: How to connect Neo4j aura to a cluster

Nyarish — Mon, 13 Sep 2021 07:14:10 GMT

I am new in this...

/databricks/spark/dbconf/java/extra.security is actually there.

And also check the settings which are set in the script.

please can you shed more light

Re: How to connect Neo4j aura to a cluster

-werners- — Mon, 13 Sep 2021 08:15:18 GMT

you can check the content of the extra.security file using a notebook:

%sh

cat /databricks/spark/dbconf/java/extra.security

This should be what is in the article.

The script will set the jdk.tls.dsiabledAlgorithms parameter in java.

So you can check the java parameters on your cluster with

%sh

java -XshowSettings:all -version

the disabledAlgorithms should be set.

If everything is set as it should be, you will have to check logs on databricks side and neo4j side to see what is going on.

Re: How to connect Neo4j aura to a cluster

Nyarish — Mon, 13 Sep 2021 08:24:03 GMT

First of all, thank you for taking the time to help. Please if you don't mind, I am newbie, kindly guide me on the steps that I need or what to do next...

Here is a screenshot ...what next from here

here is the error from notebook to neo4j aura database

Re: How to connect Neo4j aura to a cluster

-werners- — Mon, 13 Sep 2021 08:44:54 GMT

the value GCM being present, don't know if it is that. The comment in the file says it has to be present though.

are you sure it is not an issue at the neo4j side? f.e. allowing external connections etc.

Re: How to connect Neo4j aura to a cluster

Nyarish — Mon, 13 Sep 2021 08:49:08 GMT

let me ask...how would you run this code of block in the the notebook. since I get an error loading this script

#!/bin/sh

PROPERTIES_FILE="/databricks/spark/dbconf/java/extra.security"

DISABLED_ALGOS="SSLv3, RC4, DES, MD5withRSA, DH keySize < 1024, EC keySize < 224, 3DES_EDE_CBC, anon, NULL"

echo "Configure Databricks java for Aura access"

if [[ -f "${PROPERTIES_FILE}" ]]; then

echo "setting jdk.tls.disabledAlgorithms..."

echo "jdk.tls.disabledAlgorithms=${DISABLED_ALGOS}" | tee "${PROPERTIES_FILE}"

else

>&2 echo "ERROR failed to find ${PROPERTIES_FILE}"

Re: How to connect Neo4j aura to a cluster

-werners- — Mon, 13 Sep 2021 08:54:26 GMT

this script has to run at cluster startup.

What is does is changing this properties_file. I don't think you can run it in a notebook.

what error do you get when loading the script?

Re: How to connect Neo4j aura to a cluster

Nyarish — Mon, 13 Sep 2021 08:59:24 GMT

Re: How to connect Neo4j aura to a cluster

-werners- — Mon, 13 Sep 2021 09:22:30 GMT

you can't run this script in a notebook.

You have to provide it to the cluster in the cluster settings (Init Scripts).

The script has to be present on the location you put it (f.e. Filestore in dbfs)

Re: How to connect Neo4j aura to a cluster

Nyarish — Mon, 13 Sep 2021 09:29:07 GMT

I guess this setting option is not on the Community version?

Re: How to connect Neo4j aura to a cluster

-werners- — Mon, 13 Sep 2021 09:31:08 GMT

can't say, I am not on that version.

It should be here:

Re: How to connect Neo4j aura to a cluster

Nyarish — Mon, 13 Sep 2021 09:36:55 GMT

I think I might have to upgrade, since I don't have that option.

Re: How to connect Neo4j aura to a cluster

-werners- — Mon, 13 Sep 2021 10:06:05 GMT

ok so I tested it for you.

with the init script this is in extra.security:

jdk.tls.disabledAlgorithms=SSLv3, RC4, DES, MD5withRSA, DH keySize < 1024, EC keySize < 224, 3DES_EDE_CBC, anon, NULL

without the init script, I get the same as you.

So the script itself works.

Re: How to connect Neo4j aura to a cluster

Anonymous — Mon, 13 Sep 2021 13:09:39 GMT

@Werner Stinckens and @Nyaribo Maseru - You two are awesome! Thank you for working so hard together.

Re: How to connect Neo4j aura to a cluster

saab123 — Fri, 04 Apr 2025 19:04:32 GMT

I have added the init script on cluster start up in Spark->config->init.scripts. But my clsuter won't start after this.

Cluster scoped init script /Volumes/xxx/xxx/neo4j/neo4j-init.sh failed: Script exit status is non-zero. Could you please help me or provide the original script?