Geoip to geopoint in logstash kibana 7.7

Hi

I am using the latest 7.7.1 version of elk stack and my logstash geoip snippet looks as below:

if [log_type] == "querylog" {
grok{
match => {"message" => "%{TIMESTAMP_ISO8601:Activity-Time}%{SPACE}USERID=%{QUOTEDSTRING:USERID}%{SPACE}IP="%{IP:IP}"%{SPACE}ACTION=%{QS:ACTION}%{SPACE}URL=%{QS:URL}%{SPACE}DEVICETYPE=%{QS:DEVICETYPE}%{SPACE}KEYS=%{QS:KEYS}"}
}
geoip{
source => "IP"
}

}

I get details in kibana discover tab but i cannot visualize it in Maps, somehow Maps in Visualiztion is different then 5.6.16 version where i didnt had to do much straightaway i was getting the visualization as soon as geoip data is discovered,

I do need guidance on what to change in logstash, as i tried targeting it to geo point field of ECS as well but still no visualization i can see even though i selected grid or docs in Maps, please help with the code or guidance

1 Like

The default index template, which is applied to logstash-* (so not an index called logstash) configures [geoip][location] as a geo_point. Check the mapping of your index to see if it includes this.

1 Like

@Badger I checked the mapping in fields.yml , i have created a field like:

  • name: geoip.coordinates
    level: core
    type: geo_point
    description: Longitude and latitude.
    example: '{ "lon": -73.614830, "lat": 45.505918 }'

And my logstash looks like this:

geoip{
source => "IP"
target => "geoip.coordinates"
}

Kindly help, still i dont see geo point in kibana and another thing is in Maps Visualization what should i select Grid, GeoJson etc. Some how Kibana 5.6.16 was working like a charm for maps, but 7.X has something more to be added

What do you see for that field when you query elasticsearch about the mapping for the index?

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