Several Questions


First things first: Piwik is a great piece of software!

Is there any possibility to connect to a MySQL database via a SSL connection? It shouldn’t be that hard, I think. The MySQL DB is not local.

I’m setting up a new server at the moment. My vhosts setup from apache is like this.


Every site has its own log (access and error separeted). I’m planning to use the LogAnalyzer, but it isn’t quite clear to me so far. Anyhow, I understood that I need an access log where all sites are combined together, true? How do I accomplish that? Any directions? Do I just need to specify multiple CustomLogs, one to the vhosts’ own log directory and another to a centralized logfile? E.g.: /var/log/piwik/log? I don’t have a central syslog server.

I tried piped logs directly to the loganalyzer, but without any success. It seems to be only doing something when I restart apache. Perhaps cron is a better way?

In the case of piped log, as what user is the analyzer running? Any way to limit this?

Edit: Just found out the log_importer isn’t doing anything.

CustomLog “|/var/www/statistics/misc/log-analytics/ --add-sites-new-hosts --config=/var/www/statistics/config/config.ini.php --enable-http-errors --enable-http-redirects --enable-static --enable-bots --log-format-name=common_vhost --output=/var/log/apache2/piwik_debug -” combined

piwik_debug output:

[quote="Performance summary

Total time: 0 seconds
Requests imported per second: 0.0 requests per second"][/quote]

Only upon Apache reboot, it seems to be actually doing something:

[quote="Performance summary

Total time: 0 seconds
Requests imported per second: 0.0 requests per second

Purging Piwik archives for dates: 2014-01-23
To re-process these reports with your new update data, execute the piwik/misc/cron/archive.php script, or see: How to Set up Auto-Archiving of Your Reports - Analytics Platform - Matomo for more info.

Logs import summary

28 requests imported successfully


Website import summary

28 requests imported to 2 sites
    2 sites already existed
    0 sites were created:

0 distinct hostnames did not match any existing site:

Performance summary

Total time: 71 seconds
Requests imported per second: 0.39 requests per second"]


And then it’s silent again. Despite the generated pageviews, no new visitors are showing up. Any ideas?

(Matthieu Aubry) #2

Are you like asking 10 questions in one post? :wink: