Hi all,
I'm new to ELK and I installed everything. I now want to fetch my first table from a mySQL db. I created a sample.conf file whitch I run from my command window with:
C:\...\logstash-6.4.1\bin\logstash.bat -f sample.conf
I get the following output from cmd:
Sending Logstash logs to C:/.../logstash-6.4.1/logs which is now configured via log
[2018-09-24T14:26:37,840][WARN ][logstash.config.source.multilocal] Ignoring the 'pipelines.yml' file because modules o
specified
[2018-09-24T14:26:38,230][INFO ][logstash.runner ] Starting Logstash {"logstash.version"=>"6.4.1"}
[2018-09-24T14:26:38,277][INFO ][logstash.config.source.local.configpathloader] No config files found in path {:path=>"
ash-sample.conf"}
[2018-09-24T14:26:38,292][ERROR][logstash.config.sourceloader] No configuration found in the configured sources.
[2018-09-24T14:26:38,511][INFO ][logstash.agent ] Successfully started Logstash API endpoint {:port=>9600}
My .conf file looks like this:
input {
jdbc {
jdbc_driver_library => "mysql-connector-java-8.0.12-bin.jar"
jdbc_driver_class => "com.mysql.jdbc.Driver"
jdbc_connection_string => jdbc:mysql://http://localhost/phpmyadmin/db_structure.php?db=db"
jdbc_user => "root"
jdbc_password => ""
statement => "SELECT title FROM `cgp1r_content` WHERE 1"
}
}
filter{
}
output{
stdout { codec => json_lines }
elasticsearch {
hosts => ["localhost:9200"]
index => "content"
}
}
The Index is set up on Elasticsearch and the table in mySQL exits. I don't think my problem is there.
I'm using
- Elasticsearch 6.4.0
- Kibana 6.4.1
- Logstash 6.4.1
I looked through various posts already but i can't find the exact problem anywhere else.
If you have any tips, suggestions or anything else I'd be really happy.
If you need more information just ask.
Thanks in advance