Unable to view logs on Elastic/Kibana using JDBC Logstash plugin


(Aaron Hurley) #1

Hello,

I have successfully connected Logstash to my back-end Vertica database using the JDBC plugin for Logstash. Anytime a new entry is made in the table I am pointing at in Vertica I can view the Logstash update in var/log/logstash/logstash.stdout. However I cannot view the same log change on Elastic/Kibana. Do I need to update the output configuration? My current output configuration looks like:

output {

if [type] == "A" {
elasticsearch {
hosts => ["localhost"]
sniffing => true
manage_template => false
index => "%{[@metadata][beat]}-%{+YYYY.MM.dd}"
document_type => "%{[@metadata][type]}"
}
}
stdout { codec => rubydebug }
}

Many thanks,
Aaron


(Mark Walkom) #2

Does the type match?


(Aaron Hurley) #3

Hello,

Managed to get this working. Updated the output to:

output {
if [type] == "A" {
elasticsearch { }
}
}
stdout { codec => rubydebug }
}

And used default elastic configurations.

Many thanks!


(John Jack) #4

Hello Aaron, can I ask you to share the configuration (properties) that allowed you to connect to Vertica? I am trying to do the same. Thanks.


(system) #5