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.
/var/www/vhosts/domain.tld/log/access.log
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/import_logs.py --add-sites-new-hosts --config=/var/www/statistics/config/config.ini.php --url=stats.my.tld --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: http://piwik.org/setup-auto-archiving/ 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"]
[/quote]
And then it’s silent again. Despite the generated pageviews, no new visitors are showing up. Any ideas?
