You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@nifi.apache.org by "dale.chang13" <da...@outlook.com> on 2017/05/03 22:22:47 UTC
NiFi-Neo4j Issues
Hi All,
At the bottom you can find my question. Note, I am positive this is more a
network issue, but I cannot seem to figure out the solution. I tried posting
this to the Neo4j Google+ board
<https://groups.google.com/forum/#!forum/neo4j> , and as a relevant
NiFi-Neo4j Github issue <https://github.com/jonathantelfer/nifi-neo4j> (I
know this is not an official NiFi-supported processor, so you can handle
this thread how you wish); however, no luck. First, here is the structure of
my architecture:
Windows 8 host machine with Windows Hyper-V Manager. Hyper-V Manager has 6
RHEL nodes running a Hadoop cluster--Hortonworks. I have NiFi
1.0.0.2.0.1.0-12 (no SSL enabled) on HDF (Hortonworks Data Flow). On the
Windows host machine, I have Neo4j Enterprise (trial) edition 3.1.3.
Windows/Neo4j configuration:
- I found that my windows IP address i (windows.ip.address)
- I started Neo4j EE and confirmed that the browser client works.
- I went into the neo4j.conf file and enabled the property
"dbms.bolt.connector.listen_address=0.0.0.0:7687, which allows Neo4j to
listen on all networks
- I also went into the Neo4j browser, went down to the settings tab, and
configured the database URI to be bolt://(windows.ip.address):7687 (default
is bolt://localhost:7687)
- Additionally I did a netstat -a to see that the TCP connection is active
and I have a service listening to 0.0.0.0:7687 and [::]:7687
Linux/NiFi configuration:
- According to the NiFi-Neo4j Github I linked above, I created a
Neo4jBoltSessionPool Controller Service and specified the Bolt DB Connection
URL to be a variety of things (0.0.0.0:7687, localhost:7687,
(windows.ip.address):7687, (foreign.ip.address):7687, etc)
- Created a PutCypher processor and put in a simple LOAD CSV WITH HEADERS
FROM ${file_path} cypher query
When I pass in a FlowFile (I have confirmed that the file path is saved as
the file_path FlowFile attribute) and run the PutCypher processor, I get an
error saying that the neo4j driver was "unable to connect to
(ip.address):7687, ensure the database is running and that there is a
working network connection to it"
Is my configuration wrong or could it be that the Windows firewall is
preventing communication to the bolt address:port?
--
View this message in context: http://apache-nifi-developer-list.39713.n7.nabble.com/NiFi-Neo4j-Issues-tp15654.html
Sent from the Apache NiFi Developer List mailing list archive at Nabble.com.
Re: NiFi-Neo4j Issues
Posted by Matt Burgess <ma...@gmail.com>.
Can you ping the Neo4j node from the NiFi node? Can you telnet from the NiFi node to the Neo4j port? I suspect it's a firewall issue too, just want to take NiFi out of the equation for now.
Regards,
Matt
> On May 3, 2017, at 6:22 PM, dale.chang13 <da...@outlook.com> wrote:
>
> Hi All,
>
> At the bottom you can find my question. Note, I am positive this is more a
> network issue, but I cannot seem to figure out the solution. I tried posting
> this to the Neo4j Google+ board
> <https://groups.google.com/forum/#!forum/neo4j> , and as a relevant
> NiFi-Neo4j Github issue <https://github.com/jonathantelfer/nifi-neo4j> (I
> know this is not an official NiFi-supported processor, so you can handle
> this thread how you wish); however, no luck. First, here is the structure of
> my architecture:
>
> Windows 8 host machine with Windows Hyper-V Manager. Hyper-V Manager has 6
> RHEL nodes running a Hadoop cluster--Hortonworks. I have NiFi
> 1.0.0.2.0.1.0-12 (no SSL enabled) on HDF (Hortonworks Data Flow). On the
> Windows host machine, I have Neo4j Enterprise (trial) edition 3.1.3.
>
> Windows/Neo4j configuration:
> - I found that my windows IP address i (windows.ip.address)
> - I started Neo4j EE and confirmed that the browser client works.
> - I went into the neo4j.conf file and enabled the property
> "dbms.bolt.connector.listen_address=0.0.0.0:7687, which allows Neo4j to
> listen on all networks
> - I also went into the Neo4j browser, went down to the settings tab, and
> configured the database URI to be bolt://(windows.ip.address):7687 (default
> is bolt://localhost:7687)
> - Additionally I did a netstat -a to see that the TCP connection is active
> and I have a service listening to 0.0.0.0:7687 and [::]:7687
>
> Linux/NiFi configuration:
> - According to the NiFi-Neo4j Github I linked above, I created a
> Neo4jBoltSessionPool Controller Service and specified the Bolt DB Connection
> URL to be a variety of things (0.0.0.0:7687, localhost:7687,
> (windows.ip.address):7687, (foreign.ip.address):7687, etc)
> - Created a PutCypher processor and put in a simple LOAD CSV WITH HEADERS
> FROM ${file_path} cypher query
>
> When I pass in a FlowFile (I have confirmed that the file path is saved as
> the file_path FlowFile attribute) and run the PutCypher processor, I get an
> error saying that the neo4j driver was "unable to connect to
> (ip.address):7687, ensure the database is running and that there is a
> working network connection to it"
>
> Is my configuration wrong or could it be that the Windows firewall is
> preventing communication to the bolt address:port?
>
>
>
> --
> View this message in context: http://apache-nifi-developer-list.39713.n7.nabble.com/NiFi-Neo4j-Issues-tp15654.html
> Sent from the Apache NiFi Developer List mailing list archive at Nabble.com.