# Something is wrong with my confifg file - Oracle DB Connection

**URL:** <https://discuss.elastic.co/t/something-is-wrong-with-my-confifg-file-oracle-db-connection/182436>\
**Category:** Logstash\
**Created:** [May 23, 2019, 12:27pm UTC](https://discuss.elastic.co/t/something-is-wrong-with-my-confifg-file-oracle-db-connection/182436 "2019-05-23T12:27:38Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![boyaronur](https://avatars.discourse-cdn.com/v4/letter/b/858c86/32.png) [@boyaronur](https://discuss.elastic.co/u/boyaronur)\
**Post date:** [May 23, 2019, 12:27pm UTC](https://discuss.elastic.co/t/something-is-wrong-with-my-confifg-file-oracle-db-connection/182436/1 "2019-05-23T12:27:38Z")

</div>

Hello,

I try to connect Oracle DB. I am using config file for that reason. My config is

```
input {
jdbc {
    jdbc_connection_string => "jdbc:oracle:thin:@//00.000.00.0:0000/PRELIVE1"
    jdbc_user => " *****"
    jdbc_password => " ****"
    jdbc_driver_library => "C:\Users\Hakansu\Downloads\ojdbc6.jar"
    jdbc_driver_class => "Java::oracle.jdbc.driver.OracleDriver"
    statement => "SELECT * from Sales"
}
}
output {
    elasticsearch {
        protocol => http
        index => "contacts"
        document_type => "contact"
        document_id => "%{uid}"
        host => "my_first_node"
    }
}

```

When I run this file I get

> [2019-05-23T15:20:26,312][WARN][logstash.config.source.multilocal] Ignoring the 'pipelines.yml' file because modules or command line options are specified  
> [2019-05-23T15:20:26,327][INFO][logstash.runner] Starting Logstash {"logstash.version"=\>"7.0.1"}  
> [2019-05-23T15:20:31,471][ERROR][logstash.outputs.elasticsearch] Unknown setting 'host' for elasticsearch  
> [2019-05-23T15:20:31,471][ERROR][logstash.outputs.elasticsearch] Unknown setting 'protocol' for elasticsearch  
> [2019-05-23T15:20:31,487][ERROR][logstash.agent] Failed to execute action {:action=\>LogStash::PipelineAction::Create/pipeline\_id:main, :exception=\>"LogStash::ConfigurationError", :message=\>"Something is wrong with your configuration.", :backtrace=\>["C:/Users/Hakansu/Desktop/logstash-7.0.1/logstash-7.0.1/logstash-core/lib/logstash/config/mixin.rb:86:in `config_init'", "C:/Users/Hakansu/Desktop/logstash-7.0.1/logstash-7.0.1/logstash-core/lib/logstash/outputs/base.rb:60:in `initialize'", "org/logstash/config/ir/compiler/OutputStrategyExt.java:232:in `initialize'", "org/logstash/config/ir/compiler/OutputDelegatorExt.java:48:in `initialize'", "org/logstash/config/ir/compiler/OutputDelegatorExt.java:30:in `initialize'", "org/logstash/plugins/PluginFactoryExt.java:239:in `plugin'", "org/logstash/plugins/PluginFactoryExt.java:137:in `buildOutput'", "org/logstash/execution/JavaBasePipelineExt.java:50:in `initialize'", "C:/Users/Hakansu/Desktop/logstash-7.0.1/logstash-7.0.1/logstash-core/lib/logstash/java\_pipeline.rb:23:in `initialize'", "C:/Users/Hakansu/Desktop/logstash-7.0.1/logstash-7.0.1/logstash-core/lib/logstash/pipeline_action/create.rb:36:in `execute'", "C:/Users/Hakansu/Desktop/logstash-7.0.1/logstash-7.0.1/logstash-core/lib/logstash/agent.rb:325:in `block in converge\_state'"]}  
> [2019-05-23T15:20:31,802][INFO][logstash.agent] Successfully started Logstash API endpoint {:port=\>9600}  
> [2019-05-23T15:20:36,709][INFO][logstash.runner] Logstash shut down.

I couldn't solve the problem. Any help is appreciated.

Best

---

<div class="post-metadata">

**Author:** ![Badger](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/badger/32/25190_2.png) [@Badger](https://discuss.elastic.co/u/Badger)\
**Post date:** [May 23, 2019, 12:45pm UTC](https://discuss.elastic.co/t/something-is-wrong-with-my-confifg-file-oracle-db-connection/182436/2 "2019-05-23T12:45:31Z")

</div>

> [@boyaronur](#):
>
> [2019-05-23T15:20:31,471][ERROR][logstash.outputs.elasticsearch] Unknown setting 'host' for elasticsearch  
> [2019-05-23T15:20:31,471][ERROR][logstash.outputs.elasticsearch] Unknown setting 'protocol' for elasticsearch

"host" should be hosts. There is no "protocol" option for the elasticsearch output.

---

<div class="post-metadata">

**Author:** ![boyaronur](https://avatars.discourse-cdn.com/v4/letter/b/858c86/32.png) [@boyaronur](https://discuss.elastic.co/u/boyaronur)\
**Post date:** [May 23, 2019, 1:10pm UTC](https://discuss.elastic.co/t/something-is-wrong-with-my-confifg-file-oracle-db-connection/182436/3 "2019-05-23T13:10:00Z")

</div>

Thanks for the answer. After configuring my file I get

:exception=\>"ArgumentError", :message=\>"URI is not valid - host is not specified",

error

---

<div class="post-metadata">

**Author:** ![boyaronur](https://avatars.discourse-cdn.com/v4/letter/b/858c86/32.png) [@boyaronur](https://discuss.elastic.co/u/boyaronur)\
**Post date:** [May 23, 2019, 1:21pm UTC](https://discuss.elastic.co/t/something-is-wrong-with-my-confifg-file-oracle-db-connection/182436/4 "2019-05-23T13:21:41Z")

</div>

Seems like I solved it, thanks

---

<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:** [June 20, 2019, 1:21pm UTC](https://discuss.elastic.co/t/something-is-wrong-with-my-confifg-file-oracle-db-connection/182436/5 "2019-06-20T13:21:51Z")

</div>

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