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.

Sign up for GitHub

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

Jump to bottom

Wrong IP address in the Visitor Log #7709

Closed
cuhkrain opened this issue Apr 20, 2015 · 1 comment
Closed

Wrong IP address in the Visitor Log #7709

cuhkrain opened this issue Apr 20, 2015 · 1 comment
Labels
worksforme The issue cannot be reproduced and things work as intended.

Comments

@cuhkrain
Copy link

Dear All,

I find the ip address in the Visitor log is quite strange for our users(the system is for internal use).

When i run the sql-SELECT inet_ntoa(conv(hex(location_ip), 16, 10)) as ip, conv(hex(idvisitor), 16, 10) as visitorId FROM piwik_log_visit;

The correct IP address shown in DB, e.g. 202.45.47.90, 202.45.47.29, 202.45.47.44...(as the below screenshot shown)
piwik db

However, the ip address in attached Visitor Log is shown as -'175.159.128.71' and '175.159.128.101'(as the below screenshot shown). We cannot use them at all.
piwik ip

Please advise if this is setting issue or bug?

Thanks and regards,
Rain
@mattab
Copy link
Member

mattab commented Jul 14, 2015

Hi @cuhkrain

Maybe you are looking at different visitors and the IP address is actually correct in the Visitor log? can you show more of your DB columns so we can be sure you are showing the same visitors?

@mattab mattab closed this as completed Jul 15, 2015
@mattab mattab added the worksforme The issue cannot be reproduced and things work as intended. label Jul 15, 2015
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
worksforme The issue cannot be reproduced and things work as intended.
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@mattab @cuhkrain