search

jprante / elasticsearch-jdbc

JDBC importer for Elasticsearch
Apache License 2.0
2.84k stars 710 forks source link

Installation of elasticsearch-jdbc for elasticsearch 2.1.1‏ #747

Open awaaziz opened 8 years ago

awaaziz commented 8 years ago

Hello,

There is any one here that i can ask hem if he can provide me the installation procedure of elasticsearch-jdbc for elasticsearch 2.1.1

I followed the procedure set up on the site but I have not succeeded , i use Centos 7

jprante commented 8 years ago

What is the error message you got?

awaaziz commented 8 years ago

I followed the installation procedure detailed in the https://github.com/jprante/elasticsearch-jdbc link, but I could not understand the three steps below

if you do not find the JDBC driver jar in the lib directory, download it from your vendor's site and put the driver jar into the lib folder

modify script in the bin directory to your needs (Elasticsearch cluster address)

run script with a command that starts org.xbib.tools.JDBCImporter with the lib directory on the classpath

Can you help me please ...

jprante commented 8 years ago

If you follow the steps, what is the error message?

What is the JDBC driver you use?

What is the script you use?

awaaziz commented 8 years ago

I downloaded elasticsearch-jdbc-2.1.1.2.zip , I unzipped under /opt/elasticsearch-jdbc-2.1.1.2. now i want knwo how i can continue the installation ??? i want to use this to connect my database mysql to kibana

jprante commented 8 years ago

Again, what is your JDBC driver, where is it?

As in the doc written:

You must place the JDBC driver into the lib directory.

Then please look into the bin directory for example scripts. You have to modify them to your requirements.

I think the doc is very clear to follow.

awaaziz commented 8 years ago

I explain the situation , I want to use Kibana to display data from mysql, I downloaded the http://xbib.org/repository/org/xbib/elasticsearch/importer/elasticsearch-jdbc/2.1.1.2/elasticsearch-jdbc-2.1.1.2-dist.zip, I uncompressed in /opt/.(/opt/elasticsearch-jdbc-2.1.1.2 ). My ElasticSearch is installed in / usr / share / ElasticSearch .In /opt/elasticsearch-jdbc-2.1.1.2 there is a / bin and / lib folder , the same thing under / usr / share / ElasticSearch . I want to know :

How i can make the connection between mysql and ElasticSearch ?

What I need to change script in /bin , and what folder / bin I have to choose between the two?

jprante commented 8 years ago

If you read the doc of JDBC importer, the bin directory of JDBC importer is meant of course.

You can make the connection if you follow the steps in the doc. Install JDBC driver for mysql, set up a script, and run it. This is very very easy. Everything is in the bin directory examples. Please look.

awaaziz commented 8 years ago

OK thank you for this information