Copying APIM writers. On Wed, Jun 7, 2017 at 11:37 AM, Lakshman Udayakantha <[email protected]> wrote:
> Hi All, > > After offline discussion with Tharindu, we identified this was a data > import issue. After using below commands to import data from CSV, we could > get the country without any issue. > > *mysqlimport -u root -p --ignore-lines=2 --fields-terminated-by=, > --fields-optionally-enclosed-by='"' --local GEO_LOCATION_DATA > /Users/Lakshman/Downloads/GeolocationData/data/LOCATION.csv * > > *mysqlimport -u root -p --ignore-lines=2 --fields-terminated-by=, > --fields-optionally-enclosed-by='"' --local GEO_LOCATION_DATA > /Users/Lakshman/Downloads/GeolocationData/data/BLOCKS.csv* > > In that case, we need to check data imported properly or not, we can use > below query, > > *SELECT loc.country_name,loc.subdivision_1_name FROM BLOCKS block , > LOCATION loc WHERE block.network_blocks = '203.94' AND 3411959556 BETWEEN > block.network AND block.broadcast AND block.geoname_id=loc.geoname_id;* > > It should return following result set > > +--------------+--------------------+ > > | country_name | subdivision_1_name | > > +--------------+--------------------+ > > | Sri Lanka | | > > +--------------+--------------------+ > > 1 row in set (0.02 sec) > > @Doc Team: Note that This was not mentioned in docs[1], we should clear > about how data import and check whether data imported or not properly. > Please include this in docs. > > [1] https://docs.wso2.com/display/AM210/Configuring+ > Geolocation+Based+Statistics > > Thanks, > > Lakshman > > > > > > On Tue, Jun 6, 2017 at 10:13 PM, Lakshman Udayakantha <[email protected]> > wrote: > >> Hi Megala, >> >> No. That is not the issue. When I use online services [1] I can see the >> country. >> >> [1] https://www.iplocation.net/ >> >> Thanks, >> Lakshman >> >> On Tue, Jun 6, 2017 at 10:04 PM, Megala Uthayakumar <[email protected]> >> wrote: >> >>> Hi Lakshman, >>> >>> "getCountry" method will return empty value if we have used an internal >>> ip address. We need to give the public ip address as the parameter. We can >>> get the public ip address using following command, >>> >>> *dig +short myip.opendns.com <http://myip.opendns.com> >>> @resolver1.opendns.com <http://resolver1.opendns.com>* >>> >>> Thanks >>> >>> Regards, >>> Megala >>> >>> >>> On Tue, Jun 6, 2017 at 4:36 PM, Lakshman Udayakantha <[email protected] >>> > wrote: >>> >>>> Hi Tharindu, >>>> >>>> I tried this feature [1] with the instructions given [2], [3]. Note >>>> that I need to check only getCountry method. Below is the steps I have done >>>> >>>> 1. Created a data source called GEO_LOCATION_DATA and imported >>>> CSV files downloaded from given location in [2]. >>>> 2. Installed following features in DAS 3.1.0. >>>> >>>> - Analytics Spark Geolocation UDF >>>> - Analytics Spark scripts Common >>>> - Analytics Spark Useragent >>>> >>>> 3. Invoked the getCountry method from analytics console in DAS 3.1.0. >>>> But it returns an empty country in the console. What am I missing here? >>>> Or any hint to troubleshoot. According to the code, it searches for an >>>> entry in IP_LOCATION table. but we are not importing data to that table as >>>> specified in the doc? >>>> >>>> [1] https://github.com/wso2/shared-analytics/tree/v1.0.0/com >>>> ponents/spark-udf/org.wso2.carbon.analytics.shared.geolocation.udf >>>> [2] https://docs.wso2.com/display/AM200/Configuring+Geolocat >>>> ion+Based+Statistics >>>> [3] http://blog.rukspot.com/2016/10/configure-wso2-das-310-for-w >>>> so2-apim.html >>>> >>>> Thanks, >>>> Lakshman. >>>> >>>> -- >>>> Lakshman Udayakantha >>>> WSO2 Inc. www.wso2.com >>>> lean.enterprise.middleware >>>> Mobile: *0717429601* >>>> >>>> >>>> _______________________________________________ >>>> Dev mailing list >>>> [email protected] >>>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>>> >>>> >>> >>> >>> -- >>> Megala Uthayakumar >>> >>> Software Engineer >>> Mobile : 0779967122 >>> >> >> >> >> -- >> Lakshman Udayakantha >> WSO2 Inc. www.wso2.com >> lean.enterprise.middleware >> Mobile: *0717429601* >> >> > > > -- > Lakshman Udayakantha > WSO2 Inc. www.wso2.com > lean.enterprise.middleware > Mobile: *0717429601* > > -- > You received this message because you are subscribed to the Google Groups > "WSO2 Documentation Group" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/a/wso2.com/d/optout. > -- Thanks & Best Regards, *Praneesha Chandrasiri* *Technical Writer* *WSO2 Inc. * *Mobile: +(94) 718156888* *E-mail: [email protected] <[email protected]>* <http://wso2.com/signature>
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
