cancel
Showing results for 
Search instead for 
Did you mean: 

Join the community at Nodes 2022, our free virtual event on November 16 - 17.

How to load Community database into Desktop?

e25548
Node

I created a database using Community Edition, which appears to be located at
C:\neo4j\neo4j-community-4.2.7\data\databases\neo4j

I load data into the database using py2neo, which includes this line:
graph = Graph("bolt://localhost:7687", auth=("neo4j", "xxx"))

I would like to use Desktop so that I can use tools such as Bloom. How can I make this database one that Desktop opens?

14 REPLIES 14

koji
Ninja
Ninja

Hi @e25548

You can add "Remote connection" in the Neo4j Desktop.

e25548
Node

Gives this error:
Unable to establish remote connection: Neo4jError: WebSocket connection failure. Due to security constraints in your web browser, the reason for the failure is not available to this Neo4j Driver. Please use your browsers development console to determine the root cause of the failure. Common reasons include the database being unavailable, using the wrong connection URL or temporary network problems. If you have enabled encryption, ensure your browser is configured to trust the certificate Neo4j is configured to use. WebSocket readyState is: 3

e25548
Node

I tried this:

To have Bolt accept non-local connections, uncomment this line:

dbms.connector.bolt.address=0.0.0.0:7687

Still the same error.

@e25548

I created the environment on my Windows.

Windows 10 Pro, 21H1
Neo4j Desktop 1.4.6
Neo4j Community Edition 4.2.8

I have not made any changes to the neo4j.conf file.
I only changed the initial password.
It works well.

e25548
Node

I appreciate your response. Mine gives this error:

Unable to establish remote connection: Neo4jError: WebSocket connection failure. Due to security constraints in your web browser, the reason for the failure is not available to this Neo4j Driver. Please use your browsers development console to determine the root cause of the failure. Common reasons include the database being unavailable, using the wrong connection URL or temporary network problems. If you have enabled encryption, ensure your browser is configured to trust the certificate Neo4j is configured to use. WebSocket readyState is: 3

e25548
Node

Hi @e25548

Can you access the community server from Google Crome?

http://localhost:7474
bolt://localhost:7687

e25548
Node

Yes, Community works fine in Chrome.

I think the Desktop logs will help you solve the problem.

e25548
Node

No, they don't. I'm not saying they would not help someone, but they make no sense to me.

e25548
Node

2021-06-30 15:00:20.431+0000 INFO [c.n.k.i.p.PageCacheWarmer] [mydatabase] Page cache warmup started.
2021-06-30 15:00:20.433+0000 INFO [o.n.i.i.l.LabelScanStore] [neo4j] Label index cleanup job registered
2021-06-30 15:00:20.433+0000 INFO [o.n.i.i.l.LabelScanStore] [neo4j] Label index cleanup job started
2021-06-30 15:00:20.435+0000 INFO [o.n.i.i.l.LabelScanStore] [neo4j] Label index cleanup job finished: Number of pages visited: 2, Number of tree nodes: 1, Number of cleaned crashed pointers: 0, Time spent: 1ms
2021-06-30 15:00:20.435+0000 INFO [o.n.i.i.l.LabelScanStore] [neo4j] Label index cleanup job closed
2021-06-30 15:00:20.444+0000 INFO [o.n.k.a.DatabaseAvailabilityGuard] [neo4j] Requirement Database unavailable makes database neo4j unavailable.
2021-06-30 15:00:20.445+0000 INFO [o.n.k.a.DatabaseAvailabilityGuard] [neo4j] Database neo4j is unavailable.
2021-06-30 15:00:20.452+0000 WARN [o.n.k.i.s.MetaDataStore] [neo4j] Missing counts store, rebuilding it.
2021-06-30 15:00:20.453+0000 WARN [o.n.k.i.s.MetaDataStore] [neo4j] Counts store rebuild completed.
2021-06-30 15:00:20.457+0000 INFO [o.n.k.a.DatabaseAvailabilityGuard] [neo4j] Fulfilling of requirement 'Database unavailable' makes database neo4j available.
2021-06-30 15:00:20.458+0000 INFO [o.n.k.a.DatabaseAvailabilityGuard] [neo4j] Database neo4j is ready.
2021-06-30 15:00:20.458+0000 INFO [o.n.m.DatabaseHealth] [neo4j] Database health set to OK
2021-06-30 15:00:20.459+0000 INFO [c.n.k.i.p.PageCacheWarmer] [neo4j] Page cache warmup started.
2021-06-30 15:00:20.459+0000 INFO [o.n.b.t.DefaultReconciledTransactionTracker] Enabling with transaction ID 48
2021-06-30 15:00:20.537+0000 INFO [c.n.k.i.p.PageCacheWarmer] [mydatabase] Page cache warmup completed. 100 pages loaded. Duration: 104ms.
2021-06-30 15:00:20.577+0000 INFO [c.n.k.i.p.PageCacheWarmer] [neo4j] Page cache warmup completed. 100 pages loaded. Duration: 117ms.
2021-06-30 15:00:20.873+0000 INFO [c.n.m.g.GlobalMetricsExtension] Sending metrics to CSV file at C:\Users\lek25548.Neo4jDesktop\relate-data\dbmss\dbms-20ce4b91-d6e8-4c7f-ace6-334866df921e\metrics
2021-06-30 15:00:20.899+0000 INFO [o.n.b.BoltServer] Bolt enabled on localhost:7687.
2021-06-30 15:00:20.899+0000 INFO [o.n.s.AbstractNeoWebServer$ServerComponentsLifecycleAdapter] Starting web server
2021-06-30 15:00:21.859+0000 INFO [c.n.s.e.EnterpriseNeoWebServer] Remote interface available at http://localhost:7474/
2021-06-30 15:00:21.860+0000 INFO [o.n.s.AbstractNeoWebServer$ServerComponentsLifecycleAdapter] Web server started.

e25548
Node

The most recent lines from the debug.log, printed after running the command with error.

e25548
Node

From the clicking on the file shown in the error message:
[2021-06-30 17:46:09.037] [info] Retrieving status for DBMS[database-5a317d5f-1739-4685-b10c-93893a524a41]
[2021-06-30 17:46:09.040] [info] Retrieving status for DBMS[database-5a317d5f-1739-4685-b10c-93893a524a41]
[2021-06-30 17:46:09.042] [info] Retrieving status for DBMS[database-5a317d5f-1739-4685-b10c-93893a524a41]
[2021-06-30 17:46:09.044] [info] Retrieving status for DBMS[database-5a317d5f-1739-4685-b10c-93893a524a41]
[2021-06-30 17:46:09.116] [info] Retrieved status for DBMS[database-5a317d5f-1739-4685-b10c-93893a524a41]: false
[2021-06-30 17:46:09.122] [info] Retrieved status for DBMS[database-5a317d5f-1739-4685-b10c-93893a524a41]: false
[2021-06-30 17:46:09.128] [info] Retrieved status for DBMS[database-5a317d5f-1739-4685-b10c-93893a524a41]: false
[2021-06-30 17:46:09.134] [info] Retrieved status for DBMS[database-5a317d5f-1739-4685-b10c-93893a524a41]: false
[2021-06-30 17:46:37.921] [info] Online check request: https://dist.neo4j.org/neo4j-desktop/win/latest.yml
[2021-06-30 17:46:38.120] [info] Online check response: 200 version: 1.4.7
files
[2021-06-30 17:47:17.922] [info] Online check request: https://dist.neo4j.org/neo4j-desktop/win/latest.yml
[2021-06-30 17:47:18.185] [info] Online check response: 200 version: 1.4.7
files
[2021-06-30 17:47:57.922] [info] Online check request: https://dist.neo4j.org/neo4j-desktop/win/latest.yml
[2021-06-30 17:47:58.412] [info] Online check response: 200 version: 1.4.7
files
[2021-06-30 17:48:37.923] [info] Online check request: https://dist.neo4j.org/neo4j-desktop/win/latest.yml
[2021-06-30 17:48:38.446] [info] Online check response: 200 version: 1.4.7
files
[2021-06-30 17:49:17.923] [info] Online check request: https://dist.neo4j.org/neo4j-desktop/win/latest.yml
[2021-06-30 17:49:18.413] [info] Online check response: 200 version: 1.4.7
files
[2021-06-30 17:49:57.925] [info] Online check request: https://dist.neo4j.org/neo4j-desktop/win/latest.yml
[2021-06-30 17:49:58.168] [info] Online check response: 200 version: 1.4.7
files
[2021-06-30 17:50:37.927] [info] Online check request: https://dist.neo4j.org/neo4j-desktop/win/latest.yml
[2021-06-30 17:50:38.150] [info] Online check response: 200 version: 1.4.7
files
[2021-06-30 17:51:17.930] [info] Online check request: https://dist.neo4j.org/neo4j-desktop/win/latest.yml
[2021-06-30 17:51:19.704] [info] Online check response: 200 version: 1.4.7
files

e25548
Node

From the file log.old.log:
[2021-06-24 13:47:39.684] [info] Online check request: http://dist.neo4j.org/neo4j-desktop/win/latest.yml
[2021-06-24 13:47:44.689] [error] Online check error: MemoryInfo {
name: 'TimeoutError',
message: 'Promise timed out after 5000 milliseconds',
stack: 'TimeoutError: Promise timed out after 5000 milliseconds\n' +
' at Timeout._onTimeout (C:\Program Files\Neo4j Desktop\resources\app.asar\node_modules\p-timeout\index.js:27:54)\n' +
' at listOnTimeout (internal/timers.js:531:17)\n' +
' at processTimers (internal/timers.js:475:7)'
}
[2021-06-24 13:48:14.676] [info] Online check request: https://dist.neo4j.org/neo4j-desktop/win/latest.yml
[2021-06-24 13:48:19.681] [error] Online check error: MemoryInfo {
name: 'TimeoutError',
message: 'Promise timed out after 5000 milliseconds',
stack: 'TimeoutError: Promise timed out after 5000 milliseconds\n' +
' at Timeout._onTimeout (C:\Program Files\Neo4j Desktop\resources\app.asar\node_modules\p-timeout\index.js:27:54)\n' +
' at listOnTimeout (internal/timers.js:531:17)\n' +
' at processTimers (internal/timers.js:475:7)'
}
[2021-06-24 13:48:19.684] [info] Online check request: http://dist.neo4j.org/neo4j-desktop/win/latest.yml
[2021-06-24 13:48:24.687] [error] Online check error: MemoryInfo {
name: 'TimeoutError',
message: 'Promise timed out after 5000 milliseconds',
stack: 'TimeoutError: Promise timed out after 5000 milliseconds\n' +
' at Timeout._onTimeout (C:\Program Files\Neo4j Desktop\resources\app.asar\node_modules\p-timeout\index.js:27:54)\n' +
' at listOnTimeout (internal/timers.js:531:17)\n' +
' at processTimers (internal/timers.js:475:7)'
}
[2021-06-24 13:48:54.663] [info] Online check request: https://dist.neo4j.org/neo4j-desktop/win/latest.yml