Logstash Error while configuring the JDBC connection

Elastic Stack Logstash
1

Hi , When i try to connect the JDBC connection and test the logstash conf file i'm getting the below error. i have tried the some forum solution but nothing worked.

[logstash.runner ] The given configuration is invalid. Reason: Expected one of [ \t\r\n], "#", "{", "}" at line 1, column 439 (byte 43 [database_name] AS "tabaseName=qa-co-38;user=;password=******".jar"

also attached the logstash conf information

input {
jdbc {
jdbc_driver_library => "C:\Program Files (x86)\Microsoft JDBC driver 4.2\sqljdbc_4.2\enu\jre8sqljdbc42.jar"
jdbc_driver_class => "com.microsoft.sqlserver.jdbc.SQLServerDriver"
jdbc_connection_string => "jdbc:sqlserver://localhost;databaseName=qa-co-38;user=;password=*******"
jdbc_user => ""
jdbc_password => "******"
schedule => " * * * *"
statement => " SELECT * FROM [dbo].[srv_event]"
}
}

filter {
}
output {
elasticsearch {
hosts => ["localhost:9200"]
index => "SQL DB Check"
}
stdout { codec => rubydebug }
}

please help me on this.

2

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