# I have no connection to elastisearch logstash

**URL:** <https://discuss.elastic.co/t/i-have-no-connection-to-elastisearch-logstash/50459>\
**Category:** Logstash\
**Created:** [May 19, 2016, 3:27pm UTC](https://discuss.elastic.co/t/i-have-no-connection-to-elastisearch-logstash/50459 "2016-05-19T15:27:05Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![Diego\_Gomez](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/diego_gomez/32/12893_2.png) [@Diego\_Gomez](https://discuss.elastic.co/u/Diego_Gomez)\
**Post date:** [May 19, 2016, 3:27pm UTC](https://discuss.elastic.co/t/i-have-no-connection-to-elastisearch-logstash/50459/1 "2016-05-19T15:27:05Z")

</div>

Hello everyone I have a problem I can not connect the logstash to elastisearch even tell me the logstash that the configuration is ok and starts perfect, but I do not see myself or elasticsearch or Kibana , here I leave my settings and versions. Install the plug elasticsearch\_java .

input {  
file {  
path =\> "/home/rack/table.csv"  
start\_position =\> "beginning"  
}  
}  
output {  
elasticsearch\_java {  
action =\> "index"  
network\_host =\> "localhost:9200"  
index =\> "stock"  
workers =\> 1  
}  
stdout {}  
}

Elasticsearch versions are 2.3.1 , 2.3.1 and Kibana 4.5.0 logstash  
Thanks hopefully help.

---

<div class="post-metadata">

**Author:** ![magnusbaeck](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/magnusbaeck/32/44943_2.png) [@magnusbaeck](https://discuss.elastic.co/u/magnusbaeck)\
**Post date:** [May 20, 2016, 5:53am UTC](https://discuss.elastic.co/t/i-have-no-connection-to-elastisearch-logstash/50459/2 "2016-05-20T05:53:00Z")

</div>

> network\_host =\> "localhost:9200"

Two problems here:

- `network_host` shouldn't contain a port number.
- Port 9200 is used for HTTP and not the native protocol that typically uses port 9300.

Why use the elasticsearch\_java output rather than the default elasticsearch one that uses HTTP?

---

<div class="post-metadata">

**Author:** ![Diego\_Gomez](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/diego_gomez/32/12893_2.png) [@Diego\_Gomez](https://discuss.elastic.co/u/Diego_Gomez)\
**Post date:** [May 20, 2016, 3:26pm UTC](https://discuss.elastic.co/t/i-have-no-connection-to-elastisearch-logstash/50459/3 "2016-05-20T15:26:33Z")

</div>

> [@magnusbaeck](#):
>
> network\_host shouldn't contain a port number.

This is the result with that output but does not show me anything in the Kibana

output {  
elasticsearch {  
action =\> "index"  
hosts =\> "localhost:9200"  
index =\> "stock"  
workers =\> 1  
}  
stdout {}  
}

rack@rack-Specified:~/logstash-2.3.1$ bin/logstash -f /home/rack/logstash-2.3.1/logstash.conf  
Settings: Default pipeline workers: 2  
Pipeline main started

---

<div class="post-metadata">

**Author:** ![magnusbaeck](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/magnusbaeck/32/44943_2.png) [@magnusbaeck](https://discuss.elastic.co/u/magnusbaeck)\
**Post date:** [May 21, 2016, 4:01pm UTC](https://discuss.elastic.co/t/i-have-no-connection-to-elastisearch-logstash/50459/4 "2016-05-21T16:01:35Z")

</div>

That's most likely because Logstash is tailing the input file. Make sure you understand sincedb and how the file input tracks the current position in the files. Comment out the elasticsearch output until you've verified that Logstash is actually reading the data.

---

<div class="post-metadata">

**Author:** ![Diego\_Gomez](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/diego_gomez/32/12893_2.png) [@Diego\_Gomez](https://discuss.elastic.co/u/Diego_Gomez)\
**Post date:** [May 23, 2016, 7:27pm UTC](https://discuss.elastic.co/t/i-have-no-connection-to-elastisearch-logstash/50459/5 "2016-05-23T19:27:29Z")

</div>

Magnus Sorry if I upset a lot, but I earned every attempt , consult you index a table as an .xls file Exel to logstash or directly in elasticsearch , thank you for your answers.

---

<div class="post-metadata">

**Author:** ![magnusbaeck](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/magnusbaeck/32/44943_2.png) [@magnusbaeck](https://discuss.elastic.co/u/magnusbaeck)\
**Post date:** [May 24, 2016, 6:07am UTC](https://discuss.elastic.co/t/i-have-no-connection-to-elastisearch-logstash/50459/6 "2016-05-24T06:07:12Z")

</div>

> consult you index a table as an .xls file Exel to logstash or directly in elasticsearch

I don't understand what you're saying.

---

<div class="post-metadata">

**Author:** ![Diego\_Gomez](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/diego_gomez/32/12893_2.png) [@Diego\_Gomez](https://discuss.elastic.co/u/Diego_Gomez)\
**Post date:** [May 24, 2016, 1:35pm UTC](https://discuss.elastic.co/t/i-have-no-connection-to-elastisearch-logstash/50459/7 "2016-05-24T13:35:01Z")

</div>

sorry my English is poor. What would be the code to enter an .xls or .csv file to logstash? Or how should I put it into elasticsearch?

---

<div class="post-metadata">

**Author:** ![magnusbaeck](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/magnusbaeck/32/44943_2.png) [@magnusbaeck](https://discuss.elastic.co/u/magnusbaeck)\
**Post date:** [May 24, 2016, 8:24pm UTC](https://discuss.elastic.co/t/i-have-no-connection-to-elastisearch-logstash/50459/8 "2016-05-24T20:24:30Z")

</div>

Logstash has no native support for reading Excel files. To read CSV files, use a file input and a csv filter.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 6, 2017, 4:56am UTC](https://discuss.elastic.co/t/i-have-no-connection-to-elastisearch-logstash/50459/9 "2017-07-06T04:56:23Z")

</div>


