subject:"\[Dev\] Get geolocation based on ip returns null country"

Re: [Dev] Get geolocation based on ip returns null country

2017-12-05 Thread Chamalee De Silva

Hi all,
I have added this information in following docs.

APIM 2.1.0
APIM 2.0.0
IS 5.3.0
IS 5.2.0

And resolved the internal doc JIRA reported in [1].


[1] https://support.wso2.com/jira/browse/WSODOCINTERNAL-749



Thanks,
Chamalee

On Mon, Jun 26, 2017 at 10:25 PM, Praneesha Chandrasiri 
wrote:

> Copying APIM writers.
>
> On Wed, Jun 7, 2017 at 11:37 AM, Lakshman Udayakantha 
> 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+Geolocat
>> ion+Based+Statistics
>>
>> Thanks,
>>
>> Lakshman
>>
>>
>>
>>
>>
>> On Tue, Jun 6, 2017 at 10:13 PM, Lakshman Udayakantha > > 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 
>>> 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 
 @resolver1.opendns.com *

 Thanks

 Regards,
 Megala


 On Tue, Jun 6, 2017 at 4:36 PM, Lakshman Udayakantha <
 lakshm...@wso2.com> 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
> Dev@wso2.org
> 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 documentation+unsubscr...@wso2.com.
>> For more options, visit https://groups.google.com/a/wso2.com/d/optout.
>>
>
>
>
> --
> Thanks & Best Regards,
> *

Re: [Dev] Get geolocation based on ip returns null country

2017-06-26 Thread Praneesha Chandrasiri

Copying APIM writers.

On Wed, Jun 7, 2017 at 11:37 AM, Lakshman Udayakantha 
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 
> 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 
>> 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 
>>> @resolver1.opendns.com *
>>>
>>> Thanks
>>>
>>> Regards,
>>> Megala
>>>
>>>
>>> On Tue, Jun 6, 2017 at 4:36 PM, Lakshman Udayakantha >> > 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
 Dev@wso2.org
 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 documentation+unsubscr...@wso2.com.
> 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: pranee...@wso2.com *

___
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev

Re: [Dev] Get geolocation based on ip returns null country

2017-06-06 Thread Lakshman Udayakantha

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 
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 
> 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 
>> @resolver1.opendns.com *
>>
>> Thanks
>>
>> Regards,
>> Megala
>>
>>
>> On Tue, Jun 6, 2017 at 4:36 PM, Lakshman Udayakantha 
>> 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
>>> Dev@wso2.org
>>> 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*
___
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev

Re: [Dev] Get geolocation based on ip returns null country

2017-06-06 Thread Lakshman Udayakantha

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  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 
> @resolver1.opendns.com *
>
> Thanks
>
> Regards,
> Megala
>
>
> On Tue, Jun 6, 2017 at 4:36 PM, Lakshman Udayakantha 
> 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
>> Dev@wso2.org
>> 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*
___
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev

Re: [Dev] Get geolocation based on ip returns null country

2017-06-06 Thread Megala Uthayakumar

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 
@resolver1.opendns.com *

Thanks

Regards,
Megala


On Tue, Jun 6, 2017 at 4:36 PM, Lakshman Udayakantha 
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/
> components/spark-udf/org.wso2.carbon.analytics.shared.geolocation.udf
> [2] https://docs.wso2.com/display/AM200/Configuring+
> Geolocation+Based+Statistics
> [3] http://blog.rukspot.com/2016/10/configure-wso2-das-310-for-
> wso2-apim.html
>
> Thanks,
> Lakshman.
>
> --
> Lakshman Udayakantha
> WSO2 Inc. www.wso2.com
> lean.enterprise.middleware
> Mobile: *0717429601*
>
>
> ___
> Dev mailing list
> Dev@wso2.org
> http://wso2.org/cgi-bin/mailman/listinfo/dev
>
>


-- 
Megala Uthayakumar

Software Engineer
Mobile : 0779967122
___
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev

[Dev] Get geolocation based on ip returns null country

2017-06-06 Thread Lakshman Udayakantha

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/components/spark-udf/org.wso2.carbon.analytics.shared.geolocation.udf
[2]
https://docs.wso2.com/display/AM200/Configuring+Geolocation+Based+Statistics
[3]
http://blog.rukspot.com/2016/10/configure-wso2-das-310-for-wso2-apim.html

Thanks,
Lakshman.

-- 
Lakshman Udayakantha
WSO2 Inc. www.wso2.com
lean.enterprise.middleware
Mobile: *0717429601*
___
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev

Re: [Dev] Get geolocation based on ip returns null country

Re: [Dev] Get geolocation based on ip returns null country

Re: [Dev] Get geolocation based on ip returns null country

Re: [Dev] Get geolocation based on ip returns null country

Re: [Dev] Get geolocation based on ip returns null country

[Dev] Get geolocation based on ip returns null country

6 matches

Site Navigation

Mail list logo

Footer information