No Geo Location data for Web Insight with on-prem ADM

[ANDREW SWANSON1709155308]

Hi

I'm using ADM on-prem 13.1 45.61 with ADM Agent - Web Insight stats are working with the exception of Geo location which shows an "*" for clients.

 

I've tried

 

• adding an IP Block under Settings > Analytics Settings > IP Blocks
• upgrading the GeoLocation database with the latest geolite2 database as per the link below

 

https://community.netscaler.com/s/question/0D58b0000AYc5h0CQB/how-to-convert-maxmind-geolite2-database-format-to-citrix-adc-database-format

 

I still can't get any geo location data for web insight -  can anyone advise please? I can see the client public IP Addresses ok in Web Insight - Geo location still lists them as "*".

 

Thanks
Andy

[ANDREW SWANSON1709155308]

When I access the Web Insight page with Chrome debug enabled, the following errors appear. Both ADM and PC with chrome have internet access. 

 

Refused to connect to 'https://maps.googleapis.com/maps/api/mapsjs/gen_204?csp_test=true' because it violates the following Content Security Policy directive: "connect-src 'self' https://*.pendo.io https://*.citrix.com https://www.gstatic.com https://www.google-analytics.com https://*.cloud.com".

 

Google Maps JavaScript API has been loaded directly without a callback. This is not supported and can lead to race conditions and suboptimal performance. For supported loading patterns please see https://goo.gle/js-api-loading

 

Geocoding Service: You must use an API key to authenticate each request to Google Maps Platform APIs. For additional information, please refer to http://g.co/dev/maps-no-account

 

Google Maps JavaScript API warning: NoApiKeys https://developers.google.com/maps/documentation/javascript/error-messages#no-api-keys

 

Google Maps JavaScript API warning: InvalidKey https://developers.google.com/maps/documentation/javascript/error-messages#invalid-key

[ANDREW SWANSON1709155308]

When I originally posted here, the setup was:

 

ADC -> ADM Agent -> ADM

 

With Web Insight enabled the Geo Location map remained empty (including for manually added IP Blocks).

 

I then took ADM Agent out of the picture:

 

ADC -> ADM

 

Web Insight started to show Geo location for the manually added IP Blocks (but nothing else).

 

I restored the original /var/mps/locdb/Citrix_InBuilt_GeoIP_DB.csv and rebooted ADM - manually added IP Blocks were still showing up on the map but everyhting else showing as "*".

 

Can anyone help in getting Web Insight Geo Location map working?

 

Thanks
Andy

 

software used:
ADC: NS13.1: Build 45.64.nc
ADM Agent: 13.1-46.20
ADM: 13.1 45.61

[ANDREW SWANSON1709155308]

I got this working by modifying Citrix_InBuilt_GeoIP_DB.csv.

 

The client public IP address range I was using was listed but had missing attributes/qualifiers:

 

<PUBLIC_IP_RANGE>,,GB,,,,,-0.1224,51.4964

 

Qualifiers 3,4 and 5 (see below) were missing:

 

Qualifier1=Continent
Qualifier2=Country_Code
Qualifier3=Subdivision_1_Name
Qualifier4=Subdivision_2_Name
Qualifier5=City

 

I added the correct qualifiers and updated the coordinates - after uploading the file to /var/mps/locdb and reloading ADM, the client IP Address range appears correctly on the Web Insight Geo Location map.

 

I brought the ADM Agent back in between ADC and ADM but this broke the maps again - I made the same changes to Citrix_InBuilt_GeoIP_DB.csv on the Agent and that fixed the issue.

 

Cheers
Andy