Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

GeoIP issues #356

Open
wimbley opened this Issue Aug 23, 2018 · 14 comments

Comments

Projects
None yet
2 participants
@wimbley
Copy link

wimbley commented Aug 23, 2018

I have:
owa>owa-data>maxmind>GeoLite2-City.mmdb
owa>owa-data>maxmind>GeoLite2-Country.mmdb
owa>owa-data>maxmind>GeoLite2-ASN.mmdb

and have added to my:
owa>owa-config.php the following code:

define('OWA_MAXMIND_DATA_DIR', '/owa-data/owa-data/maxmind/'); // Maxmind GeoLite City GEOLOCATION path

and I have the Modules>Maxmind GeoIP turned on, as well as:

ADMIN>Geo-location (perform geo-location lookup) turned on.

I still see 'not set' for all country, city, etc. data.

I have used secondary dimension select: IP Address and see the Ip addresses of my visitors.

What am I doing wrong? Thanks in advance for any help!

@padams

This comment has been minimized.

Copy link
Owner

padams commented Aug 23, 2018

@wimbley

This comment has been minimized.

Copy link
Author

wimbley commented Aug 25, 2018

I turned on logging and get the following:

21:30:31 2018-08-24 30602 [debug_log] About to perform action: base.apiRequest
21:30:31 2018-08-24 30602 [debug_log] Getting state - store: u key:
21:30:31 2018-08-24 30602 [debug_log] Getting state - store: p key:
21:30:31 2018-08-24 30602 [debug_log] loading last value in initial state container for store: p
21:30:31 2018-08-24 30602 [debug_log] populating state for store: p, name: , value: 6e0d4df35ba38327cfb8479143e9ddabc2dac3627d0b78f50e3c1947dfe6b2b9, store type: cookie, is_perm:
21:30:31 2018-08-24 30602 [debug_log] Getting state - store: u key:
21:30:31 2018-08-24 30602 [debug_log] Getting state - store: p key:
21:30:31 2018-08-24 30602 [debug_log] check cache file: /data/57/3/5/80/3820080/user/4244390/htdocs/bestsignmonuments/owa/owa-data/caches/1/owa_user/b947f150c0d1f0c8a85c2466597ff41a.php
21:30:31 2018-08-24 30602 [debug_log] Cache File not found for Collection: owa_user, id: b947f150c0d1f0c8a85c2466597ff41a, file: /data/57/3/5/80/3820080/user/4244390/htdocs/bestsignmonuments/owa/owa-data/caches/1/owa_user/b947f150c0d1f0c8a85c2466597ff41a.php
21:30:31 2018-08-24 30602 [debug_log] CACHE MISS - object not found for Collection: owa_user, id: b947f150c0d1f0c8a85c2466597ff41a
21:30:31 2018-08-24 30602 [debug_log] Col: user_id, value: admin
21:30:31 2018-08-24 30602 [debug_log] Query: SET SESSION sql_mode=''
21:30:31 2018-08-24 30602 [debug_log] Query: SELECT * FROM owa_user WHERE user_id = 'admin' LIMIT 1
21:30:31 2018-08-24 30602 [debug_log] set key: user_id1
21:30:31 2018-08-24 30602 [debug_log] set hkey: c30da9265ba0a4704db9229f864c9eb7
21:30:31 2018-08-24 30602 [debug_log] Added Object to Cache - Collection: owa_user, id: c30da9265ba0a4704db9229f864c9eb7
21:30:31 2018-08-24 30602 [debug_log] Added Object to Dirty List - Collection: owa_user, id: c30da9265ba0a4704db9229f864c9eb7
21:30:31 2018-08-24 30602 [debug_log] entity loaded from db
21:30:31 2018-08-24 30602 [debug_log] check cache file: /data/57/3/5/80/3820080/user/4244390/htdocs/bestsignmonuments/owa/owa-data/caches/1/owa_user/b947f150c0d1f0c8a85c2466597ff41a.php
21:30:31 2018-08-24 30602 [debug_log] Cache File not found for Collection: owa_user, id: b947f150c0d1f0c8a85c2466597ff41a, file: /data/57/3/5/80/3820080/user/4244390/htdocs/bestsignmonuments/owa/owa-data/caches/1/owa_user/b947f150c0d1f0c8a85c2466597ff41a.php
21:30:31 2018-08-24 30602 [debug_log] CACHE MISS - object not found for Collection: owa_user, id: b947f150c0d1f0c8a85c2466597ff41a
21:30:31 2018-08-24 30602 [debug_log] Col: user_id, value: admin
21:30:31 2018-08-24 30602 [debug_log] Query: SELECT * FROM owa_user WHERE user_id = 'admin' LIMIT 1
21:30:31 2018-08-24 30602 [debug_log] set key: user_id1
21:30:31 2018-08-24 30602 [debug_log] set hkey: c30da9265ba0a4704db9229f864c9eb7
21:30:31 2018-08-24 30602 [debug_log] Added Object to Cache - Collection: owa_user, id: c30da9265ba0a4704db9229f864c9eb7
21:30:31 2018-08-24 30602 [debug_log] Added Object to Dirty List - Collection: owa_user, id: c30da9265ba0a4704db9229f864c9eb7
21:30:31 2018-08-24 30602 [debug_log] entity loaded from db
21:30:31 2018-08-24 30602 [debug_log] loading assigned sites
21:30:31 2018-08-24 30602 [debug_log] Query: SELECT * FROM owa_site_user WHERE user_id = '1'
21:30:31 2018-08-24 30602 [debug_log] Filtering allowed_sites_list
21:30:31 2018-08-24 30602 [debug_log] Filtering auth_status
21:30:31 2018-08-24 30602 [debug_log] Checking if user is capable of: view_reports
21:30:31 2018-08-24 30602 [debug_log] No capability passed or user is an admin and capable of everything.
21:30:31 2018-08-24 30602 [debug_log] no start/end params passed to owa_metric::setTimePeriod
21:30:31 2018-08-24 30602 [debug_log] getting metric entities for visits
21:30:31 2018-08-24 30602 [debug_log] getting metric entities for pagesPerVisit
21:30:31 2018-08-24 30602 [debug_log] getting metric entities for pageViews
21:30:31 2018-08-24 30602 [debug_log] getting metric entities for visits
21:30:31 2018-08-24 30602 [debug_log] getting metric entities for visitDuration
21:30:31 2018-08-24 30602 [debug_log] getting metric entities for bounceRate
21:30:31 2018-08-24 30602 [debug_log] getting metric entities for bounces
21:30:31 2018-08-24 30602 [debug_log] getting metric entities for visits
21:30:31 2018-08-24 30602 [debug_log] getting metric entities for uniqueVisitors
21:30:31 2018-08-24 30602 [debug_log] pre-reduce set of entities to choose from: Array
(
[uniqueVisitors] => Array
(
[0] => base.session
[1] => base.request
[2] => base.action_fact
[3] => base.domstream
[4] => base.click
[5] => base.commerce_transaction_fact
[6] => base.commerce_line_item_fact
)

[visits] => Array
    (
        [0] => base.session
        [1] => base.request
    )

[bounces] => Array
    (
        [0] => base.session
    )

[visitDuration] => Array
    (
        [0] => base.session
    )

[pageViews] => Array
    (
        [0] => base.request
        [1] => base.session
    )

)

21:30:31 2018-08-24 30602 [debug_log] post-reduce set of entities to choose from: Array
(
[1] => base.session
)

21:30:31 2018-08-24 30602 [debug_log] Entities summary levels: Array
(
[base.session] => 1
)

21:30:31 2018-08-24 30602 [debug_log] Dimensions: Array
(
[0] => date
)

21:30:31 2018-08-24 30602 [debug_log] Checking the following dimensions for relation to base.session: Array
(
[0] => date
[2] => siteId
)

21:30:31 2018-08-24 30602 [debug_log] Dimension: date is denormalized into base.session
21:30:31 2018-08-24 30602 [debug_log] Dimension: date is related to base.session.
21:30:31 2018-08-24 30602 [debug_log] Dimension: siteId is denormalized into base.session
21:30:31 2018-08-24 30602 [debug_log] Dimension: siteId is related to base.session.
21:30:31 2018-08-24 30602 [debug_log] optimal base entity is: base.session
21:30:31 2018-08-24 30602 [debug_log] Using base.session as base entity for making result set.
21:30:31 2018-08-24 30602 [debug_log] about to apply constraints
21:30:31 2018-08-24 30602 [debug_log] about to apply selects
21:30:31 2018-08-24 30602 [debug_log] Added pageViews to ChildMetrics array
21:30:31 2018-08-24 30602 [debug_log] Added bounces to ChildMetrics array
21:30:31 2018-08-24 30602 [debug_log] Query: SELECT COUNT(DISTINCT session.id) as visits, round(avg(session.last_req - session.timestamp)) as visitDuration, COUNT(DISTINCT session.visitor_id) as uniqueVisitors, SUM(session.num_pageviews) as pageViews, sum(CASE session.is_bounce WHEN TRUE THEN 1 ELSE 0 END) as bounces FROM owa_session as session WHERE session.yyyymmdd BETWEEN '20180817' AND '20180824' AND session.site_id = 'c6a81fda34196cc71411617c1a0c9688' LIMIT 1
21:30:31 2018-08-24 30602 [debug_log] Added pageViews to ChildMetrics array
21:30:31 2018-08-24 30602 [debug_log] Added bounces to ChildMetrics array
21:30:31 2018-08-24 30602 [debug_log] Query: SELECT session.yyyymmdd as date, COUNT(DISTINCT session.id) as visits, round(avg(session.last_req - session.timestamp)) as visitDuration, COUNT(DISTINCT session.visitor_id) as uniqueVisitors, SUM(session.num_pageviews) as pageViews, sum(CASE session.is_bounce WHEN TRUE THEN 1 ELSE 0 END) as bounces FROM owa_session as session WHERE session.yyyymmdd BETWEEN '20180817' AND '20180824' AND session.site_id = 'c6a81fda34196cc71411617c1a0c9688' GROUP BY session.yyyymmdd ORDER BY date ASC
21:30:32 2018-08-24 30602 [debug_log] Total session time: 1.3175208568573
21:30:32 2018-08-24 30602 [debug_log] goodbye from OWA
21:30:32 2018-08-24 30602 [debug_log] starting to persist cache...
21:30:32 2018-08-24 30602 [debug_log] Dirty Objects: Array
(
[owa_user] => Array
(
[c30da9265ba0a4704db9229f864c9eb7] => c30da9265ba0a4704db9229f864c9eb7
)

)

21:30:32 2018-08-24 30602 [debug_log] starting to persist cache...
21:30:32 2018-08-24 30602 [debug_log] writing file for: owa_userc30da9265ba0a4704db9229f864c9eb7
21:30:32 2018-08-24 30602 [debug_log] Cache File Removed: /data/57/3/5/80/3820080/user/4244390/htdocs/bestsignmonuments/owa/owa-data/caches/1/owa_user/c30da9265ba0a4704db9229f864c9eb7.php
21:30:32 2018-08-24 30602 [debug_log] changing file permissions on cache file
21:30:32 2018-08-24 30602 [debug_log] Cache Statistics:
Total Hits: 3 (Warm/Cold: 1/2)
Total Miss: 2
Total Added to Cache: 2
Total Replaced: 0
Total Persisted: 2
Total Removed: 1

@wimbley

This comment has been minimized.

Copy link
Author

wimbley commented Aug 25, 2018

I don't see any errors but it is still not working. Please help!

@padams

This comment has been minimized.

Copy link
Owner

padams commented Aug 25, 2018

@wimbley

This comment has been minimized.

Copy link
Author

wimbley commented Aug 25, 2018

@padams

This comment has been minimized.

Copy link
Owner

padams commented Aug 25, 2018

@wimbley

This comment has been minimized.

Copy link
Author

wimbley commented Aug 26, 2018

@wimbley

This comment has been minimized.

Copy link
Author

wimbley commented Aug 26, 2018

@padams

This comment has been minimized.

Copy link
Owner

padams commented Aug 26, 2018

@wimbley

This comment has been minimized.

Copy link
Author

wimbley commented Aug 26, 2018

@padams

This comment has been minimized.

Copy link
Owner

padams commented Aug 26, 2018

@wimbley

This comment has been minimized.

Copy link
Author

wimbley commented Aug 26, 2018

@padams

This comment has been minimized.

Copy link
Owner

padams commented Aug 26, 2018

padams pushed a commit that referenced this issue Aug 26, 2018

@padams

This comment has been minimized.

Copy link
Owner

padams commented Aug 26, 2018

I just added support for this in master. Update from master and see if that fixes your issue.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.
You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session.