New conf not working even when I specify the config file path

Hi, I am trying to using Logstash to import data from MySQL to Elasticsearch. I make a test on my config file, but the output is not from my configure file.

My test command:
current directory: /home/pwangbo/data/elastic/logstash-6.2.4
./bin/logstash -f config/myconf/logstash_test.conf

My configure file:

input {
    jdbc {
        jdbc_connection_string => "jdbc:mysql://my mysql uri"
        jdbc_user => "my username"
        jdbc_password => "my password"
        jdbc_driver_library => "/home/pwangbo/elastic/logstash-6.2.4/mysql-connector-java-5.1.44.jar"
        jdbc_driver_class => "com.mysql.jdbc.Driver"
        statement => "SELECT * from didi"
    }
}
output {
    stdout { codec => json_lines }
}

My logstash.yml: (only two lines, other lines are comments)

path.config: /home/pwangbo/data/elastic/logstash-6.2.4/config/myconf/*.conf
queue.type: persisted

I want to get data from my database named didi and print result to console, but the output is something from another database. There has someone using logstash before me, I am wondering if I missed something important.

By the way, there is no /etc/logstash/conf.d/ directory and even /etc/logstash on my server. Does that mean I need to create it and my configure file to it?

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