1

I have imported my csv files using the neo4j-admin according to the documentation using the following command

/bin/neo4j-admin import --mode=csv --nodes all_nodes_ne_header.csv,all_nodes_ne.csv --relationships all_relations_ne_header.csv,all_relations_ne.csv

the result looks like

IMPORT DONE in 15s 997ms.
Imported:
  19354 nodes
  11759454 relationships
  58062 properties
Peak memory usage: 1.03 GB

and I can see a file called graph.db in the data/databases folder.

I go to python and do:

from py2neo import Graph, Node, Relationship, Database
%matplotlib inline
%load_ext cypher

default_db = Database(db = Database())
graph = Graph("bolt://localhost:3637")

and after running my query I get the following:

Format: (http|https)://username:password@hostname:port/db/name
...
ConnectionError: HTTPConnectionPool(host='localhost', port=7474): Max retries exceeded with url: /db/data/ (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0x12e269790>: Failed to establish a new connection: [Errno 61] Connection refused'))

I guess I am not doing the connection correctly within Python and didn't find anywhere in the documentation how to do it. Basically, I have not set any password, username and even don't the port. I generated a report using neo4j-admin report and there was not anything relevant either. therefore, I appreciate your comments on how I can build the connection and start querying from python.

martineau
  • 119,623
  • 25
  • 170
  • 301
Areza
  • 5,623
  • 7
  • 48
  • 79

1 Answers1

1

One has to to the config file and edit the following line in the neo4j.config

# The name of the database to mount
dbms.active_database=graph.db

then can run ./bin/neo4j consol

the output should end like

Starting Neo4j.
2019-12-01 23:42:14.731+0000 INFO  ======== Neo4j 3.5.3 ========
2019-12-01 23:42:14.743+0000 INFO  Starting...
2019-12-01 23:42:16.599+0000 INFO  Bolt enabled on 127.0.0.1:7687.
2019-12-01 23:42:18.122+0000 INFO  Started.
2019-12-01 23:42:19.065+0000 INFO  Remote interface available at http://localhost:7474/

then going back to the jupyter notebook ...

Areza
  • 5,623
  • 7
  • 48
  • 79