How To Manage Neo4j Connections
How To Manage Neo4j Connections In NodeEra
The first thing you need to do in NodeEra is define your Neo4j connections. This allows NodeEra to login and run queries against a Neo4j Database.
To define connections, you select the Schema / Neo4j Connection Manager menu option (see above). This will display the Connection Manager dialog box (see below).
The grid displays a list of all the defined connections. The following table describes the columns in the Grid:
|Connection||This is the name you give to the connection definition.|
|Host Name||The host name or IP address of the server hosting the Neo4j database.|
|UserID||The userid that NodeEra will use to login to Neo4j.|
|URL||This is the URL returned by Neo4j after NodeEra successfully connects to the database. For newly defined connections, this will say “Never Connected” until a connection is made.|
The buttons to the right define the major use cases for this dialog:
Add – This will add a new connection definition
Edit – This will edit the selected connection
Test – This will test the selected connection
Remove – This will remove the selected connection definition from NodeEra
How To Add A New Neo4j Connection
Click the Add… button on the right-hand side of the screen. This will prompt you for a connection name (see below).
Enter a name for the new connection and press OK. This will display the edit connection dialog box (see below).
Enter the fields on the screen and press OK to save the definition.
The following table describes the fields on the screen:
|Connection Type:||This defines the protocol that NodeEra will use to talk to Neo4j.
|Use Secure Connection||If your server connection supports encryption (either BOLT or HTTPS) then check this checkbox.|
|Host Name:||This is the hostname or the IP address of the server that is hosting Neo4j. Use localhost if you are accessing a Neo4j Desktop server running on your laptop/desktop machine.|
|Port:||This is the port that the Neo4j server will respond on. The standard ports are:Bolt – 7687HTTP – 7474HTTPS – 7473|
|User ID:||This is the user ID that NodeEra will use to log in to Neo4j. NodeEra uses basic auth to authenticate to the server.|
|Password:||This is the password that NodeEra will use to log in to Neo4j.|
NodeEra stores the passwords you enter for each connection in clear text and stores them with the other NodeEra system settings (location varies by platform).
Passwords will not display as you enter them. You can change this by clicking on the “Show” button. This will show you the password that has been entered.
If you don’t want NodeEra to store the password, click on the “Prompt For Password” check box. This will clear any password that has been entered. When NodeEra uses this connection, it will prompt the user to enter the password, but will not store the password anywhere.
How To Define A Connection To A Local Neo4j Desktop Database.
You may have installed the Neo4j Desktop. This is a full enterprise Neo4j database that runs on your laptop and is free from Neo4j.
To define a connection that will work with your locally installed Neo4j Desktop simply use the values shown above. The password is what you defined when you created the graph database in the Neo4j Desktop.
Related Tutorial: How To Install The Neo4j Desktop
How To Edit A Neo4j Connection In NodeEra
To edit an existing connection simply click on the connection you want to edit and then click on the Edit… button on the right hand side. This will display the Edit Connection dialog box.
See the previous section How To Add A Neo4j Connection In NodeEra for an explanation of the fields on the Edit Connection dialog box.
How To Test A Neo4j Connection In NodeEra
To test a connection simply click on the connection you want to edit and then click on the Test… button on the right hand side. This will cause NodeEra to connect to the Neo4j database using the values provided in the connection definition. NodeEra will log in using the supplied credentials and will also run a simple query that attempts to return one node. This validates both the authentication and the ability to run queries.
Some common results are described below:
This message will appear if the connection attempt worked.
Bad Host Name
In this scenario we used an invalid host name (“localhostx”) and we got the following error back:
Base Exception :AddressError(“Cannot resolve address Address(host=’localhostx’, port=7687)”) – Graph Object Error
Correct the host name and try again.
In this scenario we used an invalid port and we got the following error back:
Base Exception: ServiceUnavailable(“Failed to establish connection to (‘127.0.0’,7688)
Correct the port number and try again.
Bad User ID or password
In this scenario we used an invalid user ID and we got the following error back:
Base Exception :AuthError(‘The client is unauthorized due to authentication failure.’) – Graph Object Error
Providing an invalid password will cause the same message to appear.
Correct the user ID and/or password and try again.