Logstash oracle db jdbc plugin eeror

Elastic Stack Logstash
1

I am getting the following error :

Failed to execute action {:action=>LogStash::PipelineAction::Create/pipeline_id:main, :exception=>"LogStash::ConfigurationError", :message=>"Expected one of [ \t\r\n], "#", [A-Za-z0-9_-], '"', "'", [A-Za-z_], "-", [0-9], "[", "{" at line 4, column 12 (byte 31) after input {\r\njdbc \r\n{\r\njdbc_user=>", :backtrace=>["C:/HAMZA_OFFICE/LOGSTSH/logstash_files/logstashww/logstash-core/lib/logstash/compiler.rb:32:in compile_imperative'", "org/logstash/execution/AbstractPipelineExt.java:189:in initialize'", "org/logstash/execution/JavaBasePipelineExt.java:72:in initialize'", "C:/HAMZA_OFFICE/LOGSTSH/logstash_files/logstashww/logstash-core/lib/logstash/java_pipeline.rb:47:in initialize'", "C:/HAMZA_OFFICE/LOGSTSH/logstash_files/logstashww/logstash-core/lib/logstash/pipeline_action/create.rb:50:in execute'", "C:/HAMZA_OFFICE/LOGSTSH/logstash_files/logstashww/logstash-core/lib/logstash/agent.rb:376:in block in converge_state'"]}
[2022-03-21T18:56:23,799][INFO ][logstash.runner ] Logstash shut down.

This is my Config File ;

input {
jdbc
{
jdbc_driver_library => “C:\HAMZA_OFFICE\LOGSTSH\logstash_files\logstashww\logstash-core\lib\jars\ojdbc6.jar”
jdbc_driver_class => “Java::oracle.jdbc.OracleDriver”
jdbc_connection_string=>“system@//localhost:1521/orcl"
jdbc_user=>“system”
jdbc_password => “orcl”
statement => “select * from employee”
}
}

output {
stdout { codec => rubydebug }
Elasticsearch {
hosts => ["http://localhost:9200"]
index => "oracleinde"
}
}

2

That does not match the config file that you posted. It is

input {
jdbc 
{
jdbc_user=>

The most likely explanation would be an unquoted username that contains punctuation or other special characters.

3

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