# Change log level for logstash-jdbc-input plugin

**URL:** <https://discuss.elastic.co/t/change-log-level-for-logstash-jdbc-input-plugin/160359>\
**Category:** Logstash\
**Created:** [December 11, 2018, 11:27am UTC](https://discuss.elastic.co/t/change-log-level-for-logstash-jdbc-input-plugin/160359 "2018-12-11T11:27:46Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Maxim\_Kholod](https://avatars.discourse-cdn.com/v4/letter/m/edb3f5/32.png) [@Maxim\_Kholod](https://discuss.elastic.co/u/Maxim_Kholod)\
**Post date:** [December 11, 2018, 11:27am UTC](https://discuss.elastic.co/t/change-log-level-for-logstash-jdbc-input-plugin/160359/1 "2018-12-11T11:27:46Z")

</div>

Hi, how to access Log4j2 configuration for logstash-jdbc-input? I want to do the same as

logger.elasticsearchoutput.level = debug

but for logstash-jdbc-input plugin. What is the logger name for this plugin?

---

<div class="post-metadata">

**Author:** ![guyboertje](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/guyboertje/32/31592_2.png) [@guyboertje](https://discuss.elastic.co/u/guyboertje)\
**Post date:** [December 11, 2018, 12:48pm UTC](https://discuss.elastic.co/t/change-log-level-for-logstash-jdbc-input-plugin/160359/2 "2018-12-11T12:48:00Z")

</div>

Do this while your LS is running - `curl -XGET 'localhost:9600/_node/logging?pretty'`. You will see the name of the logger used by the jdbc input - add that name to log4j config along with the desired level.

---

<div class="post-metadata">

**Author:** ![Maxim\_Kholod](https://avatars.discourse-cdn.com/v4/letter/m/edb3f5/32.png) [@Maxim\_Kholod](https://discuss.elastic.co/u/Maxim_Kholod)\
**Post date:** [December 11, 2018, 2:27pm UTC](https://discuss.elastic.co/t/change-log-level-for-logstash-jdbc-input-plugin/160359/3 "2018-12-11T14:27:58Z")

</div>

Thank you for the advice! I'm running logstash inside a docker contaner, when doing `curl -XGET 'localhost:9600/_node/logging?pretty` I see

```auto
"loggers" : {
    "logstash.agent" : "INFO",
    "logstash.api.service" : "INFO",
    "logstash.codecs.plain" : "INFO",
    "logstash.codecs.rubydebug" : "INFO",
    "logstash.config.source.local.configpathloader" : "INFO",
    "logstash.config.source.multilocal" : "INFO",
    "logstash.config.sourceloader" : "INFO",
    "logstash.filters.environment" : "INFO",
    "logstash.filters.mutate" : "INFO",
    "logstash.inputs.jdbc" : "INFO",
    "logstash.instrument.periodicpoller.cgroup" : "INFO",
    "logstash.instrument.periodicpoller.deadletterqueue" : "INFO",
    "logstash.instrument.periodicpoller.jvm" : "INFO",
    "logstash.instrument.periodicpoller.os" : "INFO",
    "logstash.instrument.periodicpoller.persistentqueue" : "INFO",
    "logstash.modules.scaffold" : "INFO",
    "logstash.outputs.elasticsearch" : "INFO",
    "logstash.outputs.stdout" : "INFO",
    "logstash.pipeline" : "INFO",
    "logstash.plugins.registry" : "INFO",
    "logstash.runner" : "INFO",
    "logstash.setting.writabledirectory" : "INFO",
    "org.logstash.Event" : "INFO",
    "org.logstash.Logstash" : "INFO",
    "org.logstash.common.DeadLetterQueueFactory" : "INFO",
    "org.logstash.common.io.DeadLetterQueueWriter" : "INFO",
    "org.logstash.config.ir.CompiledPipeline" : "INFO",
    "org.logstash.instrument.metrics.gauge.LazyDelegatingGauge" : "INFO",
    "org.logstash.secret.store.SecretStoreFactory" : "INFO",
    "org.logstash.secret.store.backend.JavaKeyStore" : "INFO",
    "slowlog.logstash.codecs.plain" : "INFO",
    "slowlog.logstash.codecs.rubydebug" : "INFO",
    "slowlog.logstash.filters.environment" : "INFO",
    "slowlog.logstash.filters.mutate" : "INFO",
    "slowlog.logstash.inputs.jdbc" : "INFO",
    "slowlog.logstash.outputs.elasticsearch" : "INFO",
    "slowlog.logstash.outputs.stdout" : "INFO"
  }

```

but when I do `RUN echo "loggers.logstash.inputs.jdbc.level = warn" >> /usr/share/logstash/config/log4j2.properties` inside a container to change the logging level I don't get any change, it's still `"logstash.inputs.jdbc" : "INFO"`. In the example on [https://www.elastic.co/guide/en/logstash/current/logging.html](https://www.elastic.co/guide/en/logstash/current/logging.html) I see `logger.elasticsearchoutput.level = debug` though I don't see it in that format (elasticsearchoutput) anywhere, so where to take this value from?

---

<div class="post-metadata">

**Author:** ![guyboertje](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/guyboertje/32/31592_2.png) [@guyboertje](https://discuss.elastic.co/u/guyboertje)\
**Post date:** [December 11, 2018, 2:39pm UTC](https://discuss.elastic.co/t/change-log-level-for-logstash-jdbc-input-plugin/160359/4 "2018-12-11T14:39:24Z")

</div>

In this text:

```auto
logger.elasticsearchoutput.name = logstash.outputs.elasticsearch
logger.elasticsearchoutput.level = debug

```

`logger.elasticsearchoutput` is a namespace, it is your choice.

```auto
logger.covfefe.name = logstash.inputs.jdbc
logger.covfefe.level = WARN

```

but

```auto
logger.jdbcinput.name = logstash.inputs.jdbc
logger.jdbcinput.level = WARN

```

is probably better. 😄. Try both

---

<div class="post-metadata">

**Author:** ![Maxim\_Kholod](https://avatars.discourse-cdn.com/v4/letter/m/edb3f5/32.png) [@Maxim\_Kholod](https://discuss.elastic.co/u/Maxim_Kholod)\
**Post date:** [December 11, 2018, 3:33pm UTC](https://discuss.elastic.co/t/change-log-level-for-logstash-jdbc-input-plugin/160359/5 "2018-12-11T15:33:30Z")

</div>

Thanks for the help!

---

<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:** [January 8, 2019, 3:33pm UTC](https://discuss.elastic.co/t/change-log-level-for-logstash-jdbc-input-plugin/160359/6 "2019-01-08T15:33:31Z")

</div>

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