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…
However, the ip address in attached Visitor Log is shown as -‘175.159.128.71’ and ‘175.159.128.101’. We cannot use them at all.
Please advise if this is setting issue or bug?
Thanks and regards,
Rain