How to connect Neo4j aura to a cluster

[Nyarish]

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.

[Nyarish]

any help guys?

[-werners-]

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

Aura needs some additional setup on your cluster.

[Nyarish]

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 ?

[-werners-]

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.

[Nyarish]

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

[-werners-]

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.

[Nyarish]

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

[-werners-]

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.

[Nyarish]

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}"

fi

[-werners-]

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?

[Nyarish]

[-werners-]

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)

[Nyarish]

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

[-werners-]

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

It should be here: