# Logstash upload csv not working on the cloud

**URL:** <https://discuss.elastic.co/t/logstash-upload-csv-not-working-on-the-cloud/76943>\
**Category:** Logstash\
**Created:** [March 1, 2017, 8:42am UTC](https://discuss.elastic.co/t/logstash-upload-csv-not-working-on-the-cloud/76943 "2017-03-01T08:42:18Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![davidker](https://avatars.discourse-cdn.com/v4/letter/d/c5a1d2/32.png) [@davidker](https://discuss.elastic.co/u/davidker)\
**Post date:** [March 1, 2017, 8:42am UTC](https://discuss.elastic.co/t/logstash-upload-csv-not-working-on-the-cloud/76943/1 "2017-03-01T08:42:18Z")

</div>

I have a trial set up and wanted to inport a CSV file  
I have a local copy of logstash running and want it to load data into the hosted elasticsearch cluster.  
I got the following error :  
Attempted to resurrect connection to dead ES instance, but got an error. {:url=\>#\<URI::HTTPS:0x41fa0d79 URL:[https://6157668e02f6de81b1c14d0e3b4513e4.eu-west-1.aws.found.io:9243/](https://6157668e02f6de81b1c14d0e3b4513e4.eu-west-1.aws.found.io:9243/)\>, :error\_type=\>LogStash::Outputs::ElasticSearch::HttpClient::Pool::BadResponseCodeError, :error=\>"Got response code '401' contacting Elasticsearch at URL '[https://6157668e02f6de81b1c14d0e3b4513e4.eu-west-1.aws.found.io:9243/](https://6157668e02f6de81b1c14d0e3b4513e4.eu-west-1.aws.found.io:9243/)'"}  
[2017-02-28T18:12:15,174][INFO][logstash.outputs.elasticsearch] Running health check to see if an Elasticsearch connection is working {:healthcheck\_url=\>[https://6157668e02f6de81b1c14d0e3b4513e4.eu-west-1.aws.found.io:9243/](https://6157668e02f6de81b1c14d0e3b4513e4.eu-west-1.aws.found.io:9243/), :path=\>"/"}

My conf file : put {  
file {  
codec =\> plain{charset =\>"UTF-8"}  
path =\> ["/Users/poste6/Desktop/finess.csv"]  
start\_position =\> "beginning"  
}  
}

filter {

if [message] =~ /^"nofinesset","nofinessej"/ {  
drop { }  
}  
csv {  
columns =\> ["nofinesset","nofinessej","raison sociale","raison sociale longue","comp rais soc","complement de distribution","no de voie","type de voie","libelle de voie","complement de voie","lieu di bp","code commune","dpt","dpt label","ligne achem","tel","telecopie","categorie d et","et categorie label","cat label ag","cat agreg","siret","ape","mft","mft label","sph","sph label","dateouv","date aut","date maj ", "Field\_32","Hopital "]  
separator =\>";"  
source =\> message  
}  
}

output {  
elasticsearch {  
#embedded =\>false  
#protocol =\>"https"  
action =\>"index"  
user =\>"RCD"  
hosts =\>["[https://615xxxxx02f6de81b1c14d0e3b4513e4.eu-west-1.aws.found.io:9243](https://615xxxxx02f6de81b1c14d0e3b4513e4.eu-west-1.aws.found.io:9243)"]  
index =\>"ban"

```
workers =>1
document_id =>"%{id}"

```

}  
}

---

<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:** [March 1, 2017, 8:50am UTC](https://discuss.elastic.co/t/logstash-upload-csv-not-working-on-the-cloud/76943/2 "2017-03-01T08:50:20Z")

</div>

You're not specifying a password in your elasticsearch output?

---

<div class="post-metadata">

**Author:** ![davidker](https://avatars.discourse-cdn.com/v4/letter/d/c5a1d2/32.png) [@davidker](https://discuss.elastic.co/u/davidker)\
**Post date:** [March 1, 2017, 8:53am UTC](https://discuss.elastic.co/t/logstash-upload-csv-not-working-on-the-cloud/76943/3 "2017-03-01T08:53:50Z")

</div>

I try with my id and password but it is not working too

---

<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:** [March 29, 2017, 8:54am UTC](https://discuss.elastic.co/t/logstash-upload-csv-not-working-on-the-cloud/76943/4 "2017-03-29T08:54:06Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.