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