[Neo4j] Fwd: Sync databases
I recently posted the following topic on the Gremlin users list and I've been directed here. Apparently Michael Hunger is the man I want to talk to :) It seems there are a few other people interested in finding out my results as well. Forwarded conversation Subject: Sync databases From: *Eddy Respondek* eddy.respon...@gmail.com Date: Wed, Sep 14, 2011 at 11:30 AM To: gremlin-us...@googlegroups.com This may be a little off topic but maybe someone has done something similar before. Basically I have a separate Wordpress site (php/mysql) which I've been extending significantly and I've setup another server on the same network for graph db testing (neo4j/tinkerpop/python-bulbs). I'm confident with my graph setup now and would like to attempt to get something small into development so I can monitor the results. I want to do a simple like relationship between users and articles. That means I need to keep an identical index of user ids and article ids in the graph db. I know how to update the id's when a new user or article is created, deleted, etc. What I don't know is the correct way to ensure data integrity in case something goes wrong like the graph db server crashes, etc. Does anyone have any thoughts on the best way to do this? -- From: *Marko Rodriguez* okramma...@gmail.com Date: Wed, Sep 14, 2011 at 11:44 AM To: gremlin-us...@googlegroups.com Hey Eddy, Someone might be able to help you here, but the guy who will give you the two page rattle on such matters is Michael Hunger on the Neo4j users list. I've read him talking about similar things --- cross db transactions-style stuff. You might want to post your thoughts to that list. Marko. http://markorodriguez.com -- From: *James Thornton* james.thorn...@gmail.com Date: Wed, Sep 14, 2011 at 12:34 PM To: gremlin-us...@googlegroups.com Hi Eddy - You should definitely post this question to the Neo4j list as well because I would be interested in Michael's ideas on this. One approach would be to use a message-passing library like ZeroMQ ( http://www.zeromq.org/) to set up a communication channel between PHP and Python. This will allow you to write to both MySQL and Neo4j when you create a new user. ZeroMQ is stupid fast. You can send millions of requests per second ( http://www.zeromq.org/results:10gbe-tests-v031), and it supports pub/sub and muticast so you can write to multiple devices/programs at once ( http://zguide.zeromq.org/page:all). Here are the PHP and Python bindings: * http://www.zeromq.org/bindings:php * http://www.zeromq.org/bindings:python JSON is probably the easiest way to serialize data, or you could use a binary serialization library like MessagePack. I'm working on creating a batch loader for Bulbs that uses ZeroMQ to send requests to a Java/Jython server running the Neo4jBatchGraph implementation Marko just added ( https://groups.google.com/d/topic/gremlin-users/muuylAEZKrQ/discussionZeroMQ) -- I'll post an example soon. - James ___ Neo4j mailing list User@lists.neo4j.org https://lists.neo4j.org/mailman/listinfo/user
[Neo4j] missing required jta.jar for debian?
I'm currently getting the following error message in Debian Lenny when trying to run a class file. Exception in thread main java.lang.NoClassDefFoundError: javax/transaction/TransactionManager As far as I can tell Debian is missing a jta.jar file which is apparently apart Java EE 6 but this isn't one of Debian packages. Do I need to manually install Java EE 6 or can I get JTA.jar somewhere separately? More info javac -cp /usr/share/java/neo4j-kernel.jar:/usr/share/java/jta.jar /tmp/gpneo4jimport.java java -cp /tmp:/usr/share/java/neo4j-kernel.jar:/usr/share/java/jta.jar gpneo4jimport java version 1.6.0_22 Java(TM) SE Runtime Environment (build 1.6.0_22-b04) Java HotSpot(TM) 64-Bit Server VM (build 17.1-b03, mixed mode) ___ Neo4j mailing list User@lists.neo4j.org https://lists.neo4j.org/mailman/listinfo/user
[Neo4j] Neo4j web admin connection error
I've just installed Neo4j on Debian Lenny and I'm trying to expose the Web Admin on a sub-domain via Apache2 proxypass. Web Admin is served but I'm getting a Unknown connection problem message. Do you have any suggestions to resolve this? What error logs or configuration files should I be checking to see whats going wrong? My settings are: ProxyRequests Off Proxy * AddDefaultCharset off Order deny,allow Deny from all Allow from all /Proxy ProxyVia On VirtualHost *:80 ServerName graph.example.com ProxyPass / http://localhost:7474/ ProxyPassReverse / http://localhost:7474/ /VirtualHost I'm not sure if it's helpful but the url has localhost in it like this: http://graph.example.com/webadmin/#p=dashboards=http%3A//localhost%3A7474/db/manage/ Thanks ___ Neo4j mailing list User@lists.neo4j.org https://lists.neo4j.org/mailman/listinfo/user
Re: [Neo4j] Neo4j web admin connection error
That didn't work. I tried a couple different combination until I found the error log. There is a line saying that it can't find neo4j.properties which might be causing the problem? DEBUG WrapperSimpleAppMain org.apache.commons.configuration.ConfigurationUtils - ConfigurationUtils.locate(): base is /usr/bin/neo4j-1.3.M01/conf, name is neo4j-server.pr$ DEBUG WrapperSimpleAppMain org.apache.commons.configuration.ConfigurationUtils - Loading configuration from the path /usr/bin/neo4j-1.3.M01/conf/neo4j-server.properties WARN WrapperSimpleAppMain org.neo4j.server.configuration.Configurator - The specified file for database performance tuning properties [neo4j.properties] does not exist. INFO WrapperSimpleAppMain org.neo4j.server.database.Database - Creating database at /usr/bin/neo4j-1.3.M01/../data/graph.db WARN WrapperSimpleAppMain org.neo4j.server.database.Database - No database tuning properties set in the property file, using defaults. Please specify the performance prop$ INFO WrapperSimpleAppMain org.neo4j.server.NeoServer - Starting Neo Server on port [7474] INFO WrapperSimpleAppMain org.neo4j.server.NeoServer - Mounting webadmin at [webadmin-html] INFO WrapperSimpleAppMain org.neo4j.server.NeoServer - Mounting management API at [http://localhost:7474/db/manage/] INFO WrapperSimpleAppMain org.neo4j.server.web.Jetty6WebServer - Adding JAXRS package [org.neo4j.server.webadmin.rest] at [/db/manage] INFO WrapperSimpleAppMain org.neo4j.server.NeoServer - Mounting REST API at [http://localhost:7474/db/data/] INFO WrapperSimpleAppMain org.neo4j.server.web.Jetty6WebServer - Adding JAXRS package [org.neo4j.server.rest.web] at [/db/data] INFO WrapperSimpleAppMain org.neo4j.server.web.Jetty6WebServer - Adding Redirector at [/] INFO WrapperSimpleAppMain org.neo4j.server.web.Jetty6WebServer - Mounting static content at [/webadmin] from [webadmin-html] INFO WrapperSimpleAppMain org.neo4j.server.web.Jetty6WebServer - Found [jar:file:/usr/bin/neo4j-1.3.M01/system/lib/neo4j-server-0.6-1.3.M01-static-web.jar!/webadmin-html] INFO WrapperSimpleAppMain org.neo4j.server.web.Jetty6WebServer - Mounting static content from [jar:file:/usr/bin/neo4j-1.3.M01/system/lib/neo4j-server-0.6-1.3.M01-static-$ INFO WrapperSimpleAppMain org.neo4j.server.web.Jetty6WebServer - Mounting servlet at [/db/manage] INFO WrapperSimpleAppMain org.neo4j.server.web.Jetty6WebServer - Mounting servlet at [/db/data] INFO WrapperSimpleAppMain org.neo4j.server.web.Jetty6WebServer - Mounting servlet at [/] On Wed, Feb 2, 2011 at 4:27 PM, user-requ...@lists.neo4j.org wrote: Send User mailing list submissions to user@lists.neo4j.org To subscribe or unsubscribe via the World Wide Web, visit https://lists.neo4j.org/mailman/listinfo/user or, via email, send a message with subject or body 'help' to user-requ...@lists.neo4j.org You can reach the person managing the list at user-ow...@lists.neo4j.org When replying, please edit your Subject line so it is more specific than Re: Contents of User digest... Today's Topics: 1. Neo4j web admin connection error (Eddy Respondek) 2. Re: Neo4j web admin connection error (Peter Neubauer) 3. Re: Exact numeric indexing? (Mattias Persson) 4. Re: Shortest Path Query with property filters (Peter Neubauer) 5. Re: Neo4j 1.2 server on Linux X86 - 64 bit (Peter Neubauer) -- Message: 1 Date: Wed, 2 Feb 2011 15:28:55 +0700 From: Eddy Respondek eddy.respon...@gmail.com Subject: [Neo4j] Neo4j web admin connection error To: user@lists.neo4j.org Message-ID: aanlktin6cjpytgh34zgityszouexoqye+nzkxrjpd...@mail.gmail.comaanlktin6cjpytgh34zgityszouexoqye%2bnzkxrjpd...@mail.gmail.com Content-Type: text/plain; charset=UTF-8 I've just installed Neo4j on Debian Lenny and I'm trying to expose the Web Admin on a sub-domain via Apache2 proxypass. Web Admin is served but I'm getting a Unknown connection problem message. Do you have any suggestions to resolve this? What error logs or configuration files should I be checking to see whats going wrong? My settings are: ProxyRequests Off Proxy * AddDefaultCharset off Order deny,allow Deny from all Allow from all /Proxy ProxyVia On VirtualHost *:80 ServerName graph.example.com ProxyPass / http://localhost:7474/ ProxyPassReverse / http://localhost:7474/ /VirtualHost I'm not sure if it's helpful but the url has localhost in it like this: http://graph.example.com/webadmin/#p=dashboards=http%3A//localhost%3A7474/db/manage/ Thanks -- Message: 2 Date: Wed, 2 Feb 2011 10:01:26 +0100 From: Peter Neubauer peter.neuba...@neotechnology.com Subject: Re: [Neo4j] Neo4j web admin connection error To: Neo4j user discussions user@lists.neo4j.org Message-ID: AANLkTi=-C=_ovsarp-ho7qjwtlvjo-k3gp4u4+ks7...@mail.gmail.comovsarp-ho7qjwtlvjo-k3gp4u4%2bks7...@mail.gmail.com Content-Type: text
Re: [Neo4j] Neo4j web admin connection error
The file is definitely there. Is there are difference between the latest http copy and the svn? Eddy On Wed, Feb 2, 2011 at 6:29 PM, user-requ...@lists.neo4j.org wrote: Does the file /usr/bin/neo4j-1.3.M01/conf/neo4j-server.properties exist? Either way, I think Michael Hunger has solved this problem all-together, I just need to merge his changes into the main server branch. I'll be digging in to that after lunch today. Will keep you posted! /Jacob On Wed, Feb 2, 2011 at 12:12 PM, Eddy Respondek eddy.respon...@gmail.com wrote: That didn't work. I tried a couple different combination until I found the error log. There is a line saying that it can't find neo4j.properties which might be causing the problem? DEBUG WrapperSimpleAppMain org.apache.commons.configuration.ConfigurationUtils - ConfigurationUtils.locate(): base is /usr/bin/neo4j-1.3.M01/conf, name is neo4j-server.pr$ DEBUG WrapperSimpleAppMain org.apache.commons.configuration.ConfigurationUtils - Loading configuration from the path /usr/bin/neo4j-1.3.M01/conf/neo4j-server.properties WARN WrapperSimpleAppMain org.neo4j.server.configuration.Configurator - The specified file for database performance tuning properties [neo4j.properties] does not exist. INFO WrapperSimpleAppMain org.neo4j.server.database.Database - Creating database at /usr/bin/neo4j-1.3.M01/../data/graph.db WARN WrapperSimpleAppMain org.neo4j.server.database.Database - No database tuning properties set in the property file, using defaults. Please specify the performance prop$ INFO WrapperSimpleAppMain org.neo4j.server.NeoServer - Starting Neo Server on port [7474] INFO WrapperSimpleAppMain org.neo4j.server.NeoServer - Mounting webadmin at [webadmin-html] INFO WrapperSimpleAppMain org.neo4j.server.NeoServer - Mounting management API at [http://localhost:7474/db/manage/] INFO WrapperSimpleAppMain org.neo4j.server.web.Jetty6WebServer - Adding JAXRS package [org.neo4j.server.webadmin.rest] at [/db/manage] INFO WrapperSimpleAppMain org.neo4j.server.NeoServer - Mounting REST API at [http://localhost:7474/db/data/] INFO WrapperSimpleAppMain org.neo4j.server.web.Jetty6WebServer - Adding JAXRS package [org.neo4j.server.rest.web] at [/db/data] INFO WrapperSimpleAppMain org.neo4j.server.web.Jetty6WebServer - Adding Redirector at [/] INFO WrapperSimpleAppMain org.neo4j.server.web.Jetty6WebServer - Mounting static content at [/webadmin] from [webadmin-html] INFO WrapperSimpleAppMain org.neo4j.server.web.Jetty6WebServer - Found [jar:file:/usr/bin/neo4j-1.3.M01/system/lib/neo4j-server-0.6-1.3.M01-static-web.jar!/webadmin-html] INFO WrapperSimpleAppMain org.neo4j.server.web.Jetty6WebServer - Mounting static content from [jar:file:/usr/bin/neo4j-1.3.M01/system/lib/neo4j-server-0.6-1.3.M01-static-$ INFO WrapperSimpleAppMain org.neo4j.server.web.Jetty6WebServer - Mounting servlet at [/db/manage] INFO WrapperSimpleAppMain org.neo4j.server.web.Jetty6WebServer - Mounting servlet at [/db/data] INFO WrapperSimpleAppMain org.neo4j.server.web.Jetty6WebServer - Mounting servlet at [/] On Wed, Feb 2, 2011 at 4:27 PM, user-requ...@lists.neo4j.org wrote: Send User mailing list submissions to user@lists.neo4j.org To subscribe or unsubscribe via the World Wide Web, visit https://lists.neo4j.org/mailman/listinfo/user or, via email, send a message with subject or body 'help' to user-requ...@lists.neo4j.org You can reach the person managing the list at user-ow...@lists.neo4j.org When replying, please edit your Subject line so it is more specific than Re: Contents of User digest... Today's Topics: 1. Neo4j web admin connection error (Eddy Respondek) 2. Re: Neo4j web admin connection error (Peter Neubauer) 3. Re: Exact numeric indexing? (Mattias Persson) 4. Re: Shortest Path Query with property filters (Peter Neubauer) 5. Re: Neo4j 1.2 server on Linux X86 - 64 bit (Peter Neubauer) -- Message: 1 Date: Wed, 2 Feb 2011 15:28:55 +0700 From: Eddy Respondek eddy.respon...@gmail.com Subject: [Neo4j] Neo4j web admin connection error To: user@lists.neo4j.org Message-ID: aanlktin6cjpytgh34zgityszouexoqye+nzkxrjpd...@mail.gmail.comaanlktin6cjpytgh34zgityszouexoqye%2bnzkxrjpd...@mail.gmail.com aanlktin6cjpytgh34zgityszouexoqye%2bnzkxrjpd...@mail.gmail.comaanlktin6cjpytgh34zgityszouexoqye%252bnzkxrjpd...@mail.gmail.com aanlktin6cjpytgh34zgityszouexoqye%2bnzkxrjpd...@mail.gmail.comaanlktin6cjpytgh34zgityszouexoqye%252bnzkxrjpd...@mail.gmail.com aanlktin6cjpytgh34zgityszouexoqye%252bnzkxrjpd...@mail.gmail.comaanlktin6cjpytgh34zgityszouexoqye%25252bnzkxrjpd...@mail.gmail.com Content-Type: text/plain; charset=UTF-8 I've just installed Neo4j on Debian Lenny and I'm
