I still have problems importing logfiles produced behind a squid proxy server with import_logs.py. The squid server produces files in common apache format, cf. squid.conf:
logformat common %>a %ui %un [%tl] “%rm %ru HTTP/%rv” %Hs %<st %Ss:%Sh
As a squid server does not have an URL, I simply inserted % for the URL when configuring the squid server as a new website in piwik. Now, when importing the line (IP & URL anonymized), using the option --log-format-name=common,
000.000.000.000 - - [27/Mar/2013:10:35:23 +0100] “GET http://www.xxx.xxx.xxx.gov/stat? HTTP/1.1” 200 642 TCP_MISS:DIRECT
there is the line
http://%http//www.xxx.xxx.xxx.gov/stat
in the piwik visitor log.
Has anybody an idea how to correct these kinds of imports?
Thank you!