Uploading GeoIP data

I uploaded some honeypot data into kibana which works but now I want to add the GeoIP.

I've created the following config file but its not working :frowning:

input {
file {
path => "/vagrant/headdionaea.csv"
start_position => "beginning"
sincedb_path => "/dev/null"

}
}

filter {
csv {
separator => ","
#connection_type, connection_protocol, protocol, srcip, srcport, dstip, dstport, hostname
columns => ["timestamp","connection_protocol","protocol","srcip","srcport","dstip","dstport","hostname"]
}
date{
match => ["timestamp", "MM/dd/yyyy HH:mm:ss"]
}

geoip {
source => "srcip"
target => "geoip"
database => "/etc/logstash/GeoLiteCity.dat"
add_field => [ "[geoip][coordinates]", "%{[geoip][longitude]}" ]
add_field => [ "[geoip][coordinates]", "%{[geoip][latitude]}" ]
}

mutate {
convert => [ "[geoip][coordinates]", "float" ]
}
}

output {
elasticsearch {
hosts => "http://localhost:9200"
index => "honeypotgeo"
}
stdout {}
}

You might want to try this question over in the logstash section, you're more likely to get an answer there.

1 Like

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