Page Comparison

Follow the procedure below in order to configure WSO2 API Manager to receive geolocation based alerts.

Download the Geolocation data from here.
Unzip the file you downloaded.
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.
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.
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.

Configure datasource in the <DAS_HOME>/repository/conf/datasources/geolocation-datasources.xml file as follows.

Code Block

language	xml

<datasources-configuration xmlns:svns="http://org.wso2.securevault/configuration">
    <datasources>
        <datasource>
            <name>GEO_LOCATION_DATA</name>
            <description>The datasource used for Geo location database</description>
            <jndiConfig>
                <name>jdbc/GEO_LOCATION_DATA</name>
            </jndiConfig>
            <definition type="RDBMS">
                <configuration>
                    <url>jdbc:mysql://localhost:3306/GEO_LOCATION_DATA</url>
                    <username>wso2carbon</username>
                    <password>wso2carbon</password>
                    <driverClassName>com.mysql.jdbc.Driver</driverClassName>
                    <maxActive>50</maxActive>
                    <maxWait>60000</maxWait>
                    <testOnBorrow>true</testOnBorrow>
                    <validationQuery>SELECT 1</validationQuery>
                    <validationInterval>30000</validationInterval>
                    <defaultAutoCommit>false</defaultAutoCommit>
                </configuration>
            </definition>
        </datasource>
    </datasources>
</datasources-configuration>

Log into the WSO2 API Manager Admin Portal using the https://localhost:<SERVER_PORT>/admin URL.
Under Analytics, click Configure Alerts to open the Alert Configurations page.
Image RemovedClick In the Geo Location Configurations section, click Activate for APIM_GEO_LOCATION_STATS. This This opens the Edit Configuration page page with the default configuration for geolocation statistics as followsdemonstrated below. Modify the cron expression is
Image Added

Modify parameter values as required.
Image Removed
Click Save Configuration.

Versions Compared

Old Version 7

New Version 8

Key