Connecting to local DB via python bolt: Episode II

[Harrolee]

I read this: Connecting to local database via Python Bolt

I am new to neo4j and am struggling to connect to a local neo4j DB.
I was able to set a new password for the neo4j

What am I doing wrong?

When I run this:

from neo4j import GraphDatabase, basic_auth

_driver = GraphDatabase.driver('bolt://localhost:7687', auth=basic_auth('neo4j', 'pwd'))

print('hurray; connected!')

I get this:

Traceback (most recent call last):
  File "just.py", line 3, in <module>
    _driver = GraphDatabase.driver('bolt://localhost:7687', auth=basic_auth('neo4j', 'pwd'))
  File "C:\Users\Lee\Documents\coding\Environments\OpalDesk\lib\site-packages\neo4j\__init__.py", line 120, in driver
    return Driver(uri, **config)
  File "C:\Users\Lee\Documents\coding\Environments\OpalDesk\lib\site-packages\neo4j\__init__.py", line 161, in __new__
    return subclass(uri, **config)
  File "C:\Users\Lee\Documents\coding\Environments\OpalDesk\lib\site-packages\neo4j\__init__.py", line 235, in __new__
    pool.release(pool.acquire())
  File "C:\Users\Lee\Documents\coding\Environments\OpalDesk\lib\site-packages\neobolt\direct.py", line 715, in acquire
    return self.acquire_direct(self.address)
  File "C:\Users\Lee\Documents\coding\Environments\OpalDesk\lib\site-packages\neobolt\direct.py", line 608, in acquire_direct
    connection = self.connector(address, error_handler=self.connection_error_handler)
  File "C:\Users\Lee\Documents\coding\Environments\OpalDesk\lib\site-packages\neo4j\__init__.py", line 232, in connector
    return connect(address, **dict(config, **kwargs))
  File "C:\Users\Lee\Documents\coding\Environments\OpalDesk\lib\site-packages\neobolt\direct.py", line 972, in connect
    raise last_error
  File "C:\Users\Lee\Documents\coding\Environments\OpalDesk\lib\site-packages\neobolt\direct.py", line 963, in connect
    s, der_encoded_server_certificate = _secure(s, host, security_plan.ssl_context, **config)
  File "C:\Users\Lee\Documents\coding\Environments\OpalDesk\lib\site-packages\neobolt\direct.py", line 854, in _secure
    s = ssl_context.wrap_socket(s, server_hostname=host if HAS_SNI and host else None)
  File "c:\users\lee\appdata\local\programs\python\python37\Lib\ssl.py", line 412, in wrap_socket
    session=session
  File "c:\users\lee\appdata\local\programs\python\python37\Lib\ssl.py", line 853, in _create
    self.do_handshake()
  File "c:\users\lee\appdata\local\programs\python\python37\Lib\ssl.py", line 1117, in do_handshake
    self._sslobj.do_handshake()
OSError: [Errno 0] Error

[Harrolee · Accepted solution]

The python driver requires encryption.

This issue is the same as mine:

Connect to Neo4J hosted on a remote ec2 instance via python running on my current ec2 instance Neo4j Graph Platform

Hello everyone! I am getting started with NEO4J and I have made some good progress with the help of this community board. I have a confusion right now and would love for anyone to throw some light on that. So my NEO4J graph is up and running on a remote ec2 instance. When I ssh into that remote instance and login to the cypher shell using this command: "cypher-shell -u neo4j -p xxx", it shows me: " Connected to Neo4j 4.0.0 at neo4j://localhost:7687". So then I go to my browser and paste "ne…

His fix is to disable encryption. I'll probably do that for now.

A safer fix is to enable and configure an SSL policy, as suggested here:

github.com/neo4j/neo4j

Neo4J community server Connection issue (Says it's ssl but it's a trap)

opened 09:24PM - 07 Feb 20 UTC

closed 04:33PM - 21 Feb 20 UTC

pjuangph

bug team-drivers

#12208 Neo4j version: 4.0.0 Operating system: Red Hat Enterprise Linux 7 API/…Driver: neo4j 1.7.6 Python api ## Steps to reproduce Step 1. You can create a new environment with anaconda or any python. Install the neo4j library. Step 2. Run this code. Enter in your database ip address ``` from neo4j import GraphDatabase, basic_auth driver = GraphDatabase.driver("bolt://xxx.xxx.xxx.xxx:7687", auth=basic_auth("neo4j", "neo4j")) ``` ## Expected behavior IF I am using version 3.5, i can connect without any problems. In the new version 4.0, with the same configuration file. I cannot connect. I get this strange python ssl error. I am using python 3.7.4 ## Actual behavior Traceback (most recent call last): File "<stdin>", line 1, in <module> File "C:\Users\test\AppData\Local\Continuum\anaconda3\lib\site-packages\neo4j\__init__.py", line 120, in driver return Driver(uri, **config) File "C:\Users\test\AppData\Local\Continuum\anaconda3\lib\site-packages\neo4j\__init__.py", line 161, in __new__ return subclass(uri, **config) File "C:\Users\test\AppData\Local\Continuum\anaconda3\lib\site-packages\neo4j\__init__.py", line 235, in __new__ pool.release(pool.acquire()) File "C:\Users\test\AppData\Local\Continuum\anaconda3\lib\site-packages\neobolt\direct.py", line 715, in acquire return self.acquire_direct(self.address) File "C:\Users\test\AppData\Local\Continuum\anaconda3\lib\site-packages\neobolt\direct.py", line 608, in acquire_direct connection = self.connector(address, error_handler=self.connection_error_handler) File "C:\Users\test\AppData\Local\Continuum\anaconda3\lib\site-packages\neo4j\__init__.py", line 232, in connector return connect(address, **dict(config, **kwargs)) File "C:\Users\test\AppData\Local\Continuum\anaconda3\lib\site-packages\neobolt\direct.py", line 972, in connect raise last_error File "C:\Users\test\AppData\Local\Continuum\anaconda3\lib\site-packages\neobolt\direct.py", line 963, in connect s, der_encoded_server_certificate = _secure(s, host, security_plan.ssl_context, **config) File "C:\Users\test\AppData\Local\Continuum\anaconda3\lib\site-packages\neobolt\direct.py", line 854, in _secure s = ssl_context.wrap_socket(s, server_hostname=host if HAS_SNI and host else None) File "C:\Users\test\AppData\Local\Continuum\anaconda3\lib\ssl.py", line 423, in wrap_socket session=session File "C:\Users\test\AppData\Local\Continuum\anaconda3\lib\ssl.py", line 870, in _create self.do_handshake() File "C:\Users\test\AppData\Local\Continuum\anaconda3\lib\ssl.py", line 1139, in do_handshake self._sslobj.do_handshake() OSError: [Errno 0] Error