Versions Compared

Old Version 1

changes.mady.by.user Former user

Saved on

compared with

New Version 2

changes.mady.by.user Former user

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
  1. Download the Geolocation data from here.
  2. Unzip the file you downloaded.

  3. Create the database by executing one of the scripts in the Geolocation Data/dbscripts directory. In this example, mysql.sql is executed.

    Tip

    This can be done using the MySQL Workbench.

    For detailed instructions to run the database script, see MySQL Documentation - The Workbench Scripting Shell.

  4. Restore data to the BLOCKS and LOCATION tables by importing data from the following files.
     

    • Geolocation Data/data/BLOCKS.csv
    • Geolocation Data/data/LOCATION.csv
    Tip

    For more information, see MySQL Documentation - Data Export and Import.

  5. Download a JDBC provider depending on the database you are using (MySQL in this example), and copy it to <APIM_HOME>/repository/components/lib directory.
  6. Configure datasource in the <Product-home>/repository/conf/datasources/geolocation-datasources.xml file as follows.
  7. Log into the WSO2 API Manager Admin Dashboard using the https://localhost:<SERVER_PORT>/admin-dashboard URL.
  8. Under Analytics, click Configure Alerts to open the Alert Configurations page.
  9. Click Activate for APIM_GEO_LOCATION_STATS.