# Can't config my logstash.conf correctly

**URL:** <https://discuss.elastic.co/t/cant-config-my-logstash-conf-correctly/205126>\
**Category:** Elasticsearch\
**Created:** [October 24, 2019, 6:09pm UTC](https://discuss.elastic.co/t/cant-config-my-logstash-conf-correctly/205126 "2019-10-24T18:09:58Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![AgustinCerda](https://avatars.discourse-cdn.com/v4/letter/a/b5a626/32.png) [@AgustinCerda](https://discuss.elastic.co/u/AgustinCerda)\
**Post date:** [October 24, 2019, 6:09pm UTC](https://discuss.elastic.co/t/cant-config-my-logstash-conf-correctly/205126/1 "2019-10-24T18:09:58Z")

</div>

Hi, I'm new with elk stack, i'm trying to pull data from a view in oracle, now i'm stuck with the logstash.conf file.

input {  
jdbc {  
jdbc\_validate\_connection =\> true  
jdbc\_driver\_library =\> "/etc/logstash/conf.d/jdbc/ojdbc8.jar"  
jdbc\_driver\_class =\> "Java:oracle.jdbc.driver.OracleDriver"  
jdbc\_connection\_string =\> "jdbc:oracle:thin:@10.000.0.00:1521/name"  
jdbc\_user =\> "user"  
jdbc\_password =\>"pass"  
schedule =\> " \*/2 \* \* \* \*"  
statement =\> "select ID, ID\_EJECUCION, FECHA\_INICIO, FECHA\_FIN, PROCESO, ESTADO, OBSERVACIONES, DIM\_TIEMPOS, MINUTOS FROM V\_LOG WHERE trunc(FECHA\_INICIO)=trunc(sysdate) and (proceso like 'Precarga%' or proceso like '0 -ORACLE%' or proceso like '4%' or proceso like 'Extraccion%)' order by ID"  
}

}

output {  
elasticsearch {  
index =\> "exampleindex"  
document\_id =\> "%{ID}"  
}  
}  
this is the output log in logstash\_plain.log  
[2019-10-24T10:42:47,039][WARN][org.logstash.execution.ShutdownWatcherExt] {"inflight\_count"=\>0, "stalling\_threads\_info"=\>{"other"=\>[{"thread\_id"=\>47, "name"=\>"[main]\<jdbc", "current\_call"=\>"[...]/vendor/bundle/jruby/2.5.0/gems/rufus-scheduler-3.0.9/lib/rufus/scheduler.rb:170:in `join'"}, {"thread_id"=>31, "name"=>"[main]>worker0", "current_call"=>"[...]/logstash-core/lib/logstash/java_pipeline.rb:243:in`block in start\_workers'"}, {"thread\_id"=\>32, "name"=\>"[main]\>worker1", "current\_call"=\>"[...]/logstash-core/lib/logstash/java\_pipeline.rb:243:in `block in start_workers'"}, {"thread_id"=>33, "name"=>"[main]>worker2", "current_call"=>"[...]/logstash-core/lib/logstash/java_pipeline.rb:243:in`block in start\_workers'"}, {"thread\_id"=\>34, "name"=\>"[main]\>worker3", "current\_call"=\>"[...]/logstash-core/lib/logstash/java\_pipeline.rb:243:in `block in start_workers'"}, {"thread_id"=>35, "name"=>"[main]>worker4", "current_call"=>"[...]/logstash-core/lib/logstash/java_pipeline.rb:243:in`block in start\_workers'"}, {"thread\_id"=\>36, "name"=\>"[main]\>worker5", "current\_call"=\>"[...]/logstash-core/lib/logstash/java\_pipeline.rb:243:in `block in start_workers'"}, {"thread_id"=>37, "name"=>"[main]>worker6", "current_call"=>"[...]/logstash-core/lib/logstash/java_pipeline.rb:243:in`block in start\_workers'"}, {"thread\_id"=\>38, "name"=\>"[main]\>worker7", "current\_call"=\>"[...]/logstash-core/lib/logstash/java\_pipeline.rb:243:in `block in start_workers'"}, {"thread_id"=>39, "name"=>"[main]>worker8", "current_call"=>"[...]/logstash-core/lib/logstash/java_pipeline.rb:243:in`block in start\_workers'"}, {"thread\_id"=\>40, "name"=\>"[main]\>worker9", "current\_call"=\>"[...]/logstash-core/lib/logstash/java\_pipeline.rb:243:in `block in start_workers'"}, {"thread_id"=>41, "name"=>"[main]>worker10", "current_call"=>"[...]/logstash-core/lib/logstash/java_pipeline.rb:243:in`block in start\_workers'"}, {"thread\_id"=\>42, "name"=\>"[main]\>worker11", "current\_call"=\>"[...]/logstash-core/lib/logstash/java\_pipeline.rb:243:in `block in start_workers'"}, {"thread_id"=>43, "name"=>"[main]>worker12", "current_call"=>"[...]/logstash-core/lib/logstash/java_pipeline.rb:243:in`block in start\_workers'"}, {"thread\_id"=\>44, "name"=\>"[main]\>worker13", "current\_call"=\>"[...]/logstash-core/lib/logstash/java\_pipeline.rb:243:in `block in start_workers'"}, {"thread_id"=>45, "name"=>"[main]>worker14", "current_call"=>"[...]/logstash-core/lib/logstash/java_pipeline.rb:243:in`block in start\_workers'"}, {"thread\_id"=\>46, "name"=\>"[main]\>worker15", "current\_call"=\>"[...]/logstash-core/lib/logstash/java\_pipeline.rb:243:in `block in start\_workers'"}]}}

Any comment will be helpful!  
Best Regards!

---

<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:** [November 21, 2019, 6:10pm UTC](https://discuss.elastic.co/t/cant-config-my-logstash-conf-correctly/205126/2 "2019-11-21T18:10:10Z")

</div>

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