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://database-1.abcdef.ap-south-1.rds.amazonaws.com:3306/testdb"
# 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>