Netscaler GeoIP logging


I’ve pointed Netscaler Syslog to graylog and I’m retrieving logs. Now I’m trying to add GeoIP to the logging.

I want to do this on Client_ip value in the following message that’s being logged in the ‘message’ field.

09/01/2024:14:34:43 GMT VMPDCNADC01 0-PPE-0 : default SSLVPN TCPCONNSTAT 3486158 0 : Context - SessionId: 62198 - User - Client_ip 84.198.xx.xx - Nat_ip 84.198.xx.xx - Vserver - Source 84.198.xx.xx:59994 - Destination - Start_time "09/01/2024:14:34:43 GMT" - End_time "09/01/2024:14:34:43 GMT" - Duration 00:00:00  - Total_bytes_send 0 - Total_bytes_recv 2738 - Total_compressedbytes_send 0 - Total_compressedbytes_recv 0 - Compression_ratio_send 0.00% - Compression_ratio_recv 0.00% - Access Allowed - Group(s) "N/A"

I followed all the steps here, creating the pipeline:

I can confirm GeoIP lookup is working by testing this in the lookup table. It finds my country/city.

I’ve created the pipeline connected it to stage 0 and to the stream.

rule "src_ip"
let geo = lookup("src_ip", to_string($message.Client_ip));
set_field("src_ip_geo_location", geo["coordinates"]);
set_field("src_ip_geo_country", geo["country"].iso_code);
set_field("src_ip_geo_city", geo["city"].names.en);

But on new log messages no values are being displayed for GeoIP, the values are just missing.

Any idea what I’m doing wrong? I’m kinda new to Graylog so this is all a bit confusing to me. Thanks :slight_smile:

Greetings, i believe i responded to you on your reddit thread.

Same questions though:

  1. What happens if you go directly to the lookup table and put that same IP? Do you get a result back?
  2. What happens if you copy the message from the search page using the “copy message” button when expanding the message and paste that into the pipeline simulator?

Also, just to verify, your logs are being parsed and you have a field in the message named Client_ip, correct?

Ah right, sorry for the crosspost but my post here was marked as spam. So I posted it on Reddit. I guess they posted it anyway.

sorry about that! I replied to your reply there :slight_smile:

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