Connect to other machine running OpenRefine

1,034 views
Skip to first unread message

janma...@live.de

unread,
Oct 15, 2015, 7:53:58 AM10/15/15
to OpenRefine
Hi,
how do I setup OpenRefine on a server such that I can connect to it with another machine?
We want to refine the data on this centralized server. Copying it around the network would become a huge mess.

Thad Guidry

unread,
Oct 15, 2015, 10:46:35 AM10/15/15
to openrefine
​OpenRefine's IP address and Port can be configured in the refine.ini file (or on the command line with its -h options)


If you are looking to have Remote access where you are hosting a Refine server and need a security layer, then this email thread should get you started:  https://groups.google.com/forum/#!topic/openrefine/C5mGef-pWd8

Another option to avoid network configuration is to use www.RefinePro.com who provides a hosted offsite or in-house solution.

--
You received this message because you are subscribed to the Google Groups "OpenRefine" group.
To unsubscribe from this group and stop receiving emails from it, send an email to openrefine+...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Tom Morris

unread,
Oct 15, 2015, 12:22:35 PM10/15/15
to openr...@googlegroups.com
On Thu, Oct 15, 2015 at 10:46 AM, Thad Guidry <thadg...@gmail.com> wrote:
​OpenRefine's IP address and Port can be configured in the refine.ini file (or on the command line with its -h options)


If you are looking to have Remote access where you are hosting a Refine server and need a security layer, then this email thread should get you started:  https://groups.google.com/forum/#!topic/openrefine/C5mGef-pWd8

That thread covers using HTTP Basic Auth,  but there are other ways to do this as well.  If you're running on Amazon's AWS, you can set up your security group to allow access from only a certain set of IP addresses.  You can use a VPN or other networking technologies to restrict access before connections even get to your machine. 

Note that if you've got multiple people accessing the same data, you'll need to coordinate access manually.  Refine doesn't have any collaboration or locking mechanisms built in.

Tom

Nikhil VJ

unread,
Dec 1, 2018, 12:41:19 AM12/1/18
to OpenRefine
Go it! Sharing an explanation for non-techies:

Use 0.0.0.0 as the IP address. My guess is it defaults to localhost.

In Linux,

./refine -i 0.0.0.0


In windows,

refine /i 0.0.0.0


After this, find out your machine's ip address on your local network (lan or wifi, both are ok).

Windows : ipconfig /all (it'll be something like 192.168.1.2 for normal routers; office routers may assign other kinds of addresses)

Linux: ifconfig is the command. You may have to install it first by : sudo apt install ifconfig .


More info here: https://github.com/OpenRefine/OpenRefine/wiki/FAQ#how-do-i-change-the-ip-address-that-openrefine-uses


You can also permanently set this in openrefine.ini file. Open it in a simple text editor (like Notepad). Removing the commenting # and changing the value on this line:

#REFINE_HOST=127.0.0.1


change it to:

REFINE_HOST=0.0.0.0


And save and close the openrefine.ini

Note: windows users, after changing openrefine.ini you have to run refine.bat , not the .exe file.


I'm going to do a hackathon session on this, was looking for ways to run it on my laptop and have everyone else open it on browser. I understand Tom's note on multiple people : we have to ensure that different people don't operate on the same words etc, and also after doing a file-wide edit like trimming spaces it's better to have everyone re-enter the facets etc.



- Nikhil VJ

Pune, India


Reply all
Reply to author
Forward
0 new messages