# Facing input-jdbc redshift docker problem

**URL:** <https://discuss.elastic.co/t/facing-input-jdbc-redshift-docker-problem/153183>\
**Category:** Logstash\
**Created:** [October 19, 2018, 1:53pm UTC](https://discuss.elastic.co/t/facing-input-jdbc-redshift-docker-problem/153183 "2018-10-19T13:53:03Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Julius\_JF](https://avatars.discourse-cdn.com/v4/letter/j/f17d59/32.png) [@Julius\_JF](https://discuss.elastic.co/u/Julius_JF)\
**Post date:** [October 19, 2018, 1:53pm UTC](https://discuss.elastic.co/t/facing-input-jdbc-redshift-docker-problem/153183/1 "2018-10-19T13:53:03Z")

</div>

Hi guys,

I'm asking for an advice and assistance of logstash gurus with jdbc-input plugin 🙂

There is a such structure:

- Logstash is running in docker container, and it's composed with docker-compose.
- there is couple of share folders with configs, including redshift-jdbc driver, .last\_run file, query.sql and pipeline.yml.

Pipeline:

```
input {
  jdbc {
    jdbc_driver_library => "/data/driver.jar"
    jdbc_driver_class => "com.amazon.redshift.jdbc.Driver"
    jdbc_connection_string => "jdbc:redshift://10.101.5.237:5671/main"
    jdbc_user => "user"
    jdbc_password => "password"
    statement_filepath => "/data/query.sql"
    last_run_metadata_path => "/data/.last_run"
    jdbc_paging_enabled => "true"
    jdbc_page_size => "50000"
  }
}
output {
    amazon_es {
        hosts => ["instanceurl.es.amazonaws.com"]
        region => "eu-west-1"
        index => "index"
        document_type => "document"
        document_id => "%{id}"
    }
} 

```

Dockerfile:

```
FROM docker.elastic.co/logstash/logstash-oss:6.4.2
RUN logstash-plugin install logstash-input-jdbc logstash-output-amazon_es
USER root # For changing folder mode
RUN mkdir /data ; chown -R logstash:logstash /data ; chmod -R 757 /data

```

docker-compose.yml:

```
version: '3'

services:
 logstash:
    container_name: my_db_logstash
    build:
      context: .
    restart: always
    volumes:
      - ./config/logstash.yml:/usr/share/logstash/config/logstash.yml:ro
      - ./pipeline:/usr/share/logstash/pipeline:ro
      - ./data:/data:rw
    ports:
      - "5004:5000"
    environment:
      LS_JAVA_OPTS: "-Xmx256m -Xms256m"

```

driver.jar is downloaded from amazon [website](https://docs.aws.amazon.com/en_us/redshift/latest/mgmt/configure-jdbc-connection.html):

```
wget https://s3.amazonaws.com/redshift-downloads/drivers/jdbc/1.2.16.1027/RedshiftJDBC42-no-awssdk-1.2.16.1027.jar -O data/driver.jar

```

All code is also available in [github](https://github.com/AZhyrenkov/db-logstash/)

But it throws an errors:

```
 logstash | Error: Java::JavaSql::SQLException: No suitable driver found for jdbc:redshift://10.101.5.237:5671/main
 logstash | Exception: Sequel::DatabaseConnectionError
 logstash | Stack: java.sql.DriverManager.getConnection(java/sql/DriverManager.java:689)
 logstash | java.sql.DriverManager.getConnection(java/sql/DriverManager.java:247)

```

I have tried also Postgresql driver as it suitable for Redshift, but it doesn't work as well.  
By the way - exactly the same structure, but for mysql jdbc driver works fine.

I have feeling I'm missing something about jdbc\_lobrary and jdbc\_class part.

---

<div class="post-metadata">

**Author:** ![Sachin\_Khanna](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/sachin_khanna/32/36843_2.png) [@Sachin\_Khanna](https://discuss.elastic.co/u/Sachin_Khanna)\
**Post date:** [October 23, 2018, 2:16pm UTC](https://discuss.elastic.co/t/facing-input-jdbc-redshift-docker-problem/153183/2 "2018-10-23T14:16:13Z")

</div>

Facing same issue

* * *

Sachin ([Channa Mereya Lyrics](https://lyricsbud.in/2017/07/channa-mereya-lyrics.html))

---

<div class="post-metadata">

**Author:** ![Julius\_JF](https://avatars.discourse-cdn.com/v4/letter/j/f17d59/32.png) [@Julius\_JF](https://discuss.elastic.co/u/Julius_JF)\
**Post date:** [November 2, 2018, 4:03pm UTC](https://discuss.elastic.co/t/facing-input-jdbc-redshift-docker-problem/153183/3 "2018-11-02T16:03:09Z")

</div>

I also opened an issue in github repo of this plugin, [here](https://github.com/logstash-plugins/logstash-input-jdbc/issues/308) is it.

---

<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 30, 2018, 4:03pm UTC](https://discuss.elastic.co/t/facing-input-jdbc-redshift-docker-problem/153183/4 "2018-11-30T16:03:16Z")

</div>

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