Due to recent updates, all users are required to create an Altair One account to login to the RapidMiner community. Click the Register button to create your account using the same email that you have previously used to login to the RapidMiner community. This will ensure that any previously created content will be synced to your Altair One account. Once you login, you will be asked to provide a username that identifies you to other Community users. Email us at Community with questions.
Read data from Neo4j in Rapidminer
amitpathak
Member Posts: 4 Contributor I
in Help
I am using licensed version of RapidMiner Studio v9.9 and Neo4j 4+. I have successfully established a connection between Neo4j and RapidMiner. Now I want to read a data from Neo4j by passing a cypher script. Step I followed -
Process failed.
org.neo4j. driver. exceptions. SecurityException: Permission denied. The credentials you provided were valid, but must be changed before you can use this instance. If this is the first time you are using Neo4j, this is to ensure you are not using the default credentials in production. If you are not using default credentials, you are getting this message because an administrator requires a password change. Changing your password is easy to do via the Neo] Browser. If you are connecting via a shell or programmatically via a driver, just issue a 'ALTER CURRENT USER SET PASSWORD FROM 'current password TO 'new password" statement against the system database in the current session, and then restart your driver with the new password configured.
I changed the password in Neo4j but continue to get this error. However, I also noticed a strange thing. Now, if I am testing my connection with new and old password, both are working. I have three different passwords working for the same user whereas throws an error in Neo4j if I use the old passwords.
Also, while setting the Operator Parameter: Define Connection to predefined I am neither getting any option to select in Connection dropdown nor able to add a new connection.
- Added Read Database operator to the process and connected its out to res.
- Operator Parameter: Define connection - repository
- Operator Parameter: Connection Entry - //Local Repository/Connections/Neo4jTrial (where test connection is passing)
- Operator Parameter: Define Query - query
- I double clicked on the operator and mentioned "MATCH (n:Movie) RETURN n.guid LIMIT 25" in SQL query.
- Run
Process failed.
org.neo4j. driver. exceptions. SecurityException: Permission denied. The credentials you provided were valid, but must be changed before you can use this instance. If this is the first time you are using Neo4j, this is to ensure you are not using the default credentials in production. If you are not using default credentials, you are getting this message because an administrator requires a password change. Changing your password is easy to do via the Neo] Browser. If you are connecting via a shell or programmatically via a driver, just issue a 'ALTER CURRENT USER SET PASSWORD FROM 'current password TO 'new password" statement against the system database in the current session, and then restart your driver with the new password configured.
I changed the password in Neo4j but continue to get this error. However, I also noticed a strange thing. Now, if I am testing my connection with new and old password, both are working. I have three different passwords working for the same user whereas throws an error in Neo4j if I use the old passwords.
Also, while setting the Operator Parameter: Define Connection to predefined I am neither getting any option to select in Connection dropdown nor able to add a new connection.
0
Answers
Thank you for the response.
No, the connection fails if no password is provided, or any other password / username is given. Only works for the user and password combination that I have created but just that old password also works after changing it.
Yes, it does show me a warning -
"These connections use the old mechanism, which is now deprecated. To convert an existing connection, select it and press the Convert button. To create a new connection with the new mechanism, go to Connections - Create Connection, or right click on any repository."
But I am not able to locate the Convert button (marked in bold).