Issue to connect AWS RDS mysql from Logstash

Hello, I am setting up logstash conf file to fetch the logs from my AWS RDS MYSQL database. Please let me know what needs to be corrected. ELK is configured in the AWS ec2 single machine. All services are up and running. I used the debugging command sudo bin/logstash -f <path_to_config_file>

this is the conf file settings and error below:
input {
jdbc {
jdbc_connection_string => "jdbc:mysql://"
# The user we wish to execute our statement as
jdbc_user => "abcd"
jdbc_password => "abcd"
# The path to our downloaded jdbc driver
jdbc_driver_library => "\etc\logstash\mysql-connector-java-5.1.30.jar"
jdbc_driver_class => "com.mysql.jdbc.Driver"
# our query
schedule => "* * * *"
statement => "SELECT * FROM users"
output {
stdout { codec => json_lines }
elasticsearch {
"hosts" => "localhost:9200"
"index" => "test"
"document_type" => "data"

LogStash::Error: Don't know how to handle Java::JavaLang::IllegalStateException for PipelineAction::Create<main>

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