Several Questions


#1

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: 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"]

[/quote]

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: