Add a location file to create a static proximity database
A static proximity database is a UNIX-based ASCII file. Entries added to this database from a location file are called static entries. Only one location file can be loaded on a Citrix ADC appliance. Adding a new location file overrides the existing file. The number of entries in the static proximity database is limited by the configured memory in the Citrix ADC appliance.
The static proximity database can be created in the default format or in a format derived from commercially configured third party databases (such as www.maxmind.com and www.ip2location.com).
The Citrix ADC appliance includes the following two IP geolocation database files. These are GeoLite2 files, published by MaxMind.
- Citrix_Netscaler_InBuilt_GeoIP_DB_IPv4
- Citrix_Netscaler_InBuilt_GeoIP_DB_IPv6
These database files are available in a format supported by the Citrix ADC appliance in the directory /var/netscaler/inbuilt_db.
You can use these IP geolocation databases as the location file for the static proximity based GSLB method, or in location based policies.
These databases vary in the details they provide. There is no strict enforcement of the database file format, except that the default file has format tags. The database files are ASCII files that use a comma as the field delimiter. There are differences in the structure of fields and the representation of IP addresses in the locations.
The format parameter describes the structure of the file to the Citrix ADC appliance. Specifying an incorrect value for the format option can corrupt the internal data.
Note
- After an upgrade, if the /var/netscaler/inbuilt_db/ directory contains the database file (Citrix_Netscaler_InBuilt_GeoIP_DB.csv) from the earlier Citrix ADC software versions, the file is retained.
- The default location of the database file is /var/netscaler/locdb, and on a high availability (HA) setup, an identical copy of the file must be present in the same location on both Citrix ADC appliances.
- If the location file is stored in a location other than the default location, then specify the path of the location file.
- For admin partitions, the default path is: /var/partitions/
/netscaler/locdb.- Some databases provide short country names according to ISO-3166 and long country names as well. The Citrix ADC uses short names when storing and matching qualifiers.
- To create a static proximity database, log on to the UNIX shell of the Citrix ADC appliance and use an editor to create a file with the location details in one of the Citrix ADC supported formats.
- Citrix ADC appliance is shipped with the GeoLite2 database (IPv4 and IPv6) but Citrix does not maintain or update the MaxMind GeoLite2 database regularly. If necessary, you can get the GeoLite2 database fromwww.maxmind.comand convert it to Citrix ADC database format. For more information, seeScript to convert MaxMind GeoLite2 database format to Citrix ADC database format.
To add a static location file by using the CLI
At the command prompt, type:
add locationFile [-format ] - show locationFile Example:
add locationFile /var/netscaler/locdb/nsgeo1.0 -format netscaler Done show locationFile Location File: /var/netscaler/locdb/nsgeo1.0 Format: netscaler Done > Example:
add locationFile /var/netscaler/inbuilt_db/Citrix_Netscaler_InBuilt_GeoIP_DB_IPv4 -format netscaler add locationFile6 /var/netscaler/inbuilt_db/Citrix_Netscaler_InBuilt_GeoIP_DB_IPv6 -format netscaler To add a static location file by using the GUI:
- Navigate toAppExpert>Location, click theStatic Databasetab.
- ClickAddto add a static location file.
You can view an imported location file database by using theView Databasedialog box in the configuration utility. There is no CLI equivalent.
To view a static location file by using the GUI:
- Navigate toAppExpert>Location, click theStatic Databasetab.
- Select a static location file, and from theActionlist, clickView Database.
To convert a location file into the Citrix ADC format:
By default, when you add a location file, it is saved in the Citrix ADC format. You can convert a location file of other formats into the Citrix ADC format.
Note: The
nsmapoption can be accessed only from the command line interface. The conversion is possible only into the Citrix ADC format.
To convert the static database format, at the CLI prompt, type the following command:
nsmap -f -o Example:
nsmap -f ip-country-region-city -o nsfile.ns ip-country-region-city.csv Script to convert MaxMind GeoLite2 database format to Citrix ADC database format
MaxMind GeoIP database cannot be used directly in Citrix ADC. The MaxMind GeoIP database must be converted into Citrix ADC format and then loaded for IP location detection in the GSLB static proximity method and other features like policies. You can use a script to convert the GeoLite2 database format to Citrix ADC database format. This script can be used to convert both IPv4 and IPv6 files. The script is available in the location:https://github.com/citrix/MaxMind-GeoIP-Database-Conversion-Citrix-ADC-Format
Steps to convert GeoIP2 database to Citrix ADC format
1. Download the GeoLite2 City or GeoLite2 Country database in .csv format fromhttps://dev.maxmind.com/geoip/geoip2/geolite2/.
2. Copy the file in a Citrix ADC directory (say /var). Unzip the file using the following shell command, which would create a directory with the same name.
tar -xf 3. Download the script Convert_GeoIPDB_To_Netscaler_Format.pl fromhttps://github.com/citrix/MaxMind-GeoIP-Database-Conversion-Citrix-ADC-Formatand copy it to the directory created in step #2.
4. To check the acceptable options for the script execution, run the following command:
perl Convert_GeoIPDB_To_Netscaler_Format.pl –help Various options available are;
-p
-logfile
-debug Prints all the messages to STDOUT
4. Run the following command to convert the GeoLite2 database format to Citrix ADC database format.
perl Convert_GeoIPDB_To_Netscaler_Format.pl Note: The operation can take up to 5 minutes.
The default file names used in the script are that of the MaxMind GeoLite2 City based database. If you have downloaded the GeoLite2 Country database, you must provide the input file names accordingly as listed.
- -b
- -i
- -l
Example:
perl Convert_GeoIPDB_To_Netscaler_Format.pl -b GeoLite2-Country-Blocks-IPv4.csv -i GeoLite2-Country-Blocks-IPv6.csv -l GeoLite2-Country-Locations-en.csv The following are the output files generated after running the script.
- Netscaler_Maxmind_GeoIP_DB_IPv4.csv
- Netscaler_Maxmind_GeoIP_DB_IPv6.csv
5. Once the conversion of the database into Citrix ADC format is complete, use the following command to start using it.
add locationFile Add a third-party static database file on a Citrix ADC appliance
Perform the following steps to add a third-party static database file on a Citrix ADC appliance.
- Obtain the location database file from a third-party vendor, such as www.maxmind.com or www.ip2location.com.
Copy the location database file to the Citrix ADC appliance using the WinSCP utility.
Note
The default location of the database file on the appliance is/var/netscaler/locdb.
Run the following command to add a static location file:
add location file-format LocationFormat Run the following command to ensure that the location database is loaded:
show location parameterThis command displays the parameters, such as the number of static entries. If the database is not loaded correctly, this command also displays an error message. A maximum of 3M-1 (3 million minus one) entries can be loaded.
Run the following command to view the location of the GSLB site:
show gslb serviceNote
- If the database is loaded correctly, the location of the GSLB sites is automatically populated in the database.
- You can specify only one location file in the configuration on the appliance.
- If the appliances are in a high availability setup, then one appliance must copy the database from the other appliance.
- If no match is found for an incoming IP address, the request is processed using the Round Robin method.
Run the following command to configure the GSLB method on the appliance:
set gslb vserver GSLBVserverName -lbMethod MethodType