EzDev.org

piwik

piwik - Liberating Web Analytics. Star us on Github? +1. Piwik is the leading open alternative to Google Analytics that gives you full control over your data. Piwik lets you easily collect data from websites, apps & the IoT and visualise this data and extract insights. Privacy is built-in. We love Pull Requests! Free Web Analytics Software


Add Google Analytics to SharePoint sites and subsites

My workplace currently hosts a few hundred SharePoint sites and subsites with WSS 3.0 and we'd like to start tracking site activity using Google Analytics or PIWIK. Either tool uses a snippet of JavaScript that you enter before the closing </body> tag.

Now each site/subsite has a master page that we can manually add this to, but given the hundreds of sites and that most of them have many subsites with their own master pages, what is the best way to inject this tracking code?

Am I going about this the wrong way? It it normally standard practice to just review weblogs for SharePoint sites for this very reason? Can I automatically inject this snippet on all pages of all sites?


Source: (StackOverflow)

Web analytics platform that can run on a load-balanced server cluster?

I'm using Piwik for my web-analytics, and recently I've discovered PHPFog/CloudControl as hosting providers that set up a load balanced, fully managed server for your applications to run on. Piwik requires certain directories to be writable in order to set configuration files, and this prevents me from using load-balancing to enhance my piwik response times.

Does anyone know of an analytics package like piwik (or maybe a different version of piwik) that supports load balancing?


Source: (StackOverflow)

Piwik installation using php

I have an below error while installing piwik web analytic in to my site

You need to configure and rebuild PHP with "iconv" support enabled, --with-iconv.

Please guide me.


Source: (StackOverflow)

How to track Angular route views and link click through using Piwik

Does anybody have a working example of Piwik integration with an Angular App? I have the following code in mine but only see views of the page and no route views ever show up. I'm new to Angular so any help would be greatly appreciated.

Angular

var app = angular.module('angularTest', ['ui.utils','ui.bootstrap','ui.router','piwik','ngSanitize', 'ui.highlight']);

Piwik settings

    var _paq = _paq || [];
_paq.push(['trackPageView']);
_paq.push(['enableLinkTracking']);
function onSuccess(data, request) {
    var spUserData = data.d;
    //get login name
    var loginName = spUserData.LoginName.split('|')[1];
    piwikEmpid = loginName.replace("domain\\","");
    //get display name
    piwikEmpname = spUserData.Title;
    var u="//piwikServer/";
    _paq.push(['setUserId', piwikEmpid]);
    _paq.push(['setTrackerUrl', u+'piwik.php']);
    _paq.push(['setSiteId', 1]);
    var d=document, g=d.createElement('script'), s=d.getElementsByTagName('script')[0];
    g.type='text/javascript'; g.async=true; g.defer=true; g.src=u+'piwik.js'; s.parentNode.insertBefore(g,s);
};
function onError() {
    var u="//piwikServer/";
    _paq.push(['setTrackerUrl', u+'piwik.php']);
    _paq.push(['setSiteId', 1]);
    var d=document, g=d.createElement('script'), s=d.getElementsByTagName('script')[0];
    g.type='text/javascript'; g.async=true; g.defer=true; g.src=u+'piwik.js'; s.parentNode.insertBefore(g,s);
};

Route menu

<ul class="nav nav-tabs" role="tablist" id="topTabMenu" data-position="right">
<li role="presentation" ui-sref-active="active"><a aria-controls="home" role="tab" ui-sref="home" onclick="javascript:_paq.push(['trackPageView', 'home']);"></a></li>                                              
<li role="presentation" ui-sref-active="active"><a aria-controls="home" role="tab" ui-sref="offices" onclick="javascript:_paq.push(['trackPageView', 'offices']);">
Offices</a></li>


Source: (StackOverflow)

Hosting piwik on a server with a read-only filesystem

I use CloudControl for hosting and I would like to set up a server (possibly with load balancing support) to host piwik for all of my websites. The only problem is that the only writable directory CloudControlled allows you to access is defined by $_SERVER['TMPDIR'].

Is it possible to modify piwik to use this directory for all of its file-writing needs?

And also will I run into any issues with using load balancing? Something like automatically generated reports being generated by each node behind my load balancer since they're not aware of each other?


Source: (StackOverflow)

Uncaught ReferenceError: piwikTracker is not defined

Piwik tracker allows custom tracking as such:

jQuery('div.orange').click(function() {
    piwikTracker.trackGoal(3); // Track click on this hitarea
});

In my WordPress environment, I'm loading this jQuery in a script separate from the piwik.js script for obvious reasons.

In Chrome, I receive the error

Uncaught ReferenceError: piwikTracker is not defined

on the script that I'm using custom tracking.

Is there a way I can define the function before calling the event handler function? Why only Chrome?

EDIT

I checked out the piwik php script that loads the JavaScript and it's actually loading the script in the footer. The function that calls for the custom tracking is loaded in the header. Does this matter? Do scripts in the header always get loaded before the footer?


Source: (StackOverflow)

piwik, how to get data per sub-domain?

I have many sub-domains and I want to event data for each sub-domain. what I did is execute HTTP request like this, for each sub-domain:

/? 
idSite=6& 
token_auth=out-outh-token& 
format=json& 
date=2014-10-13%2C2014-10-14& 
expanded=1& 
segment=eventCategory%3D%3Dgoals%3BpageUrl%3D%40some-sub-domain& 
method=Events.getCategory& 
module=API& 
period=range

which works fine for development, but as I execute many HTTP requests, they (the requests) start to time out. so I added waits every time it encountered a timeout, what made it slow... is there a way to get all this data in one request? is there a way to better handle this problem?


Source: (StackOverflow)

Google Analytics and Piwik Discrepancy

Hi guys, I was wondering if anyone have the same problem as I do. I have 2 trackers which are Google Analytics and Piwik but after sometime I found out there is a discrepancy. Please read below for more information.

Here is data for yesterday (with New Piwik Last Week v1.7.1 version then). GGA : 14 803 visits (Unique Visistors) Piwik : 10 254 visits (Unique Visistors)

31% discrepancy.

Question What do i have to do to match the records? or which of the statistics is the correct ones?

Any advice would be much appreciated.


Source: (StackOverflow)

Piwik: generate a counter image to display it on external sites

It is possible to generate a image (php gd) with a count of visitors of my piwik tracked site.
I want Embed a flag counter in a external site. On this page iframe or flash not allow. so i can't integrate the normal piwik widgets


Source: (StackOverflow)

Piwik: How do I track a visitor (User ID) across domains (PHP/JS)?

I'd like to link the current visitor's IP to a specified user ID (via PHP) which Piwik should track across several (sub)domains.

There are several (sub)domains and I want to give a visitor (IP), who is logging in at secure.example.com, a unique UserID to track him on all other domains. The link "IP -> UserID" at login should be made in PHP (Piwik Tracking PHP Client -> setUserId). The "normal" page tracking on all domains (including secure.example.com after login) should be based on JavaScript (Piwik JS tracking snippet).

Example domains:

  • www.example.com (siteId 1)
  • support.example.com (siteId 2)
  • secure.example.com (siteId 3)
  • www.anotherexample.com (siteId 4)

My current PHP login tracking code (called on secure.example.com/login):

<?php
require_once 'PiwikTracker.php';

$siteId = 3;
$apiUrl = 'http://piwik.example.com/';
$userId = '[TESTUSER]';

$piwik = new PiwikTracker($siteId, $apiUrl);
$piwik->enableCookies('*.example.com');
$piwik->setIp($_SERVER['REMOTE_ADDR']);
$piwik->setUserId($userId);
$piwik->doTrackEvent('Login', 'Login', $userId);
?>

The JS tracking code for all other pages and domains (siteId changes):

<script type="text/javascript">
var _paq = _paq || [];
(function(){ var u="//piwik.example.com/";
    _paq.push(['setSiteId', 1]);
    _paq.push(['setCookieDomain', '*.example.com']);
    _paq.push(['setDomains', '*.example.com']);
    _paq.push(['setTrackerUrl', u+'piwik.php']);
    _paq.push(['trackPageView']);
    _paq.push(['enableLinkTracking']);
    var d=document, g=d.createElement('script'), s=d.getElementsByTagName('script')[0]; g.type='text/javascript'; g.defer=true; g.async=true; g.src=u+'piwik.js';
    s.parentNode.insertBefore(g,s); }
)();
</script>

In Piwik config.ini.php I set the following values:

[Tracker]
enable_fingerprinting_across_websites=1
use_third_party_id_cookie = 1
visit_standard_length = 1800
window_look_back_for_visitor = 86400

My problem is: When I log into secure.example.com and then visit support.example.com (or www.example.com etc.), Piwik does not link these visits to the UserID I set before. In addition if I overwrite the UserID for the current visitor, it won't change in Piwik backend.


Source: (StackOverflow)

Tracking email newsletter with piwik

I want to track email newsletter especially with piwik. Now there's the following image tracking code given (source):

<!-- Piwik Image Tracker -->
<img src="http://analytics.mysite.net/piwik.php?idsite={$IDSITE}amp;rec=1" style="border:0" alt="" />
<!-- End Piwik -->

I want to add something like _rcn to attach a campaign, to assign the email opening. The code could look like that (web beacon):

<img src="http://analytics.mysite.net/piwik.php?idsite=1&rec=1&_rcn=mycampaign" style="border: 0; display: none; width: 0px; height: 0px; margin: 0;padding: 0" alt="" />

But that doesn't work... Any Ideas?


Source: (StackOverflow)

Why is the piwik tracking script not usually directly included on the page?

Piwik (analytics software), works by including a small script just before the </body>:

<script type="text/javascript">
  var _paq = _paq || [];
  _paq.push(['trackPageView']);
  _paq.push(['enableLinkTracking']);
  (function() {
    var u="//piwik.example.com";
    _paq.push(['setTrackerUrl', u+'piwik.php']);
    _paq.push(['setSiteId', 1]);
    var d=document, g=d.createElement('script'), s=d.getElementsByTagName('script')[0];
    g.type='text/javascript'; g.async=true; g.defer=true; g.src=u+'piwik.js'; s.parentNode.insertBefore(g,s);
  })();
</script>

This script will then include piwik.js (basically this script) from your piwik installation on the page. piwik.js records a couple of things (screen size, ip, etc.) and sends that to your piwik installation in a GET request, to register the pageview.

Now I don't understand why you would not just include piwik.js on your page straightaway. Why go through the trouble of fetching it from a separate location when you can just concatenate and minify it with the rest of your scripts?

It is possible to host piwik.js on a cdn (see here and here), so I'm wondering why you wouldn't skip that step and concatenate it with the rest of your scripts and optimize from there?


Google analytics does the same thing I believe, so the answer doesn't need to be specific to Piwik as long as it applies to both.


Source: (StackOverflow)

How to create href link inside array

Actualy I have to populate table data using php array to my dashboard. The table contains the URL. I need to set href which is used to redirect to the dynamic link.(below is my while loop code). I have tried creating href using below the single line echo php code.It worked and I got the clickable link, but it didn't return data inside the table. It showed the data in the table without any alignment.

echo '<html><head></head><a rel='nofollow' href="'.$data['link'].'" target="_blank">'.$data['link'].'</a></html>';  

But I want to create href inside array kindly anyone help us.

public function getTemperatures()
{
    $mysql_hostname = "localhost";
    $mysql_user     = "root";
    $mysql_password = "";
    $mysql_database = "new";
    $bd = mysql_connect($mysql_hostname, $mysql_user, $mysql_password) or die("Oops some thing went wrong");
    mysql_select_db($mysql_database, $bd) or die("Oops some thing went wrong");// we are now connected to database

    $result = mysql_query("SELECT * FROM website"); // selecting data through mysql_query()
    $pie = mysql_query("select count(*) from website where status = 'Error'");

    while($data = mysql_fetch_array($result))
    {
        //echo '<html><head></head><a rel='nofollow' href="'.$data['link'].'" target="_blank">'.$data['link'].'</a></html>';
        $temperatures[] = array(
            'label1' => $data['link'],
            'label2' => $data['time'],
            'label3' => $data['os'],
            'label4' => $data['browser'],
            'label5' => $data['status'],
            'label6' => $data['location'],
            array('label6' => $data['widget_load_time'])
        );
    }    
    return DataTable::makeFromIndexedArray($temperatures);
}

Source: (StackOverflow)

piwik tracker status 500 installation error

I have to configure PIWIK for web analytics. I am configuring it on localhost so that I can understand it before finaly deployment. My OS is centos 7. During installation, I am facing following error in apache webserver (httpd)

[Mon Nov 23 16:45:54.946214 2015] [:error] [pid 16750] [client ::1:38222] PHP Fatal error: Uncaught exception 'Exception' with message 'The configuration file {/var/www/html/analytics/piwik/config/config.ini.php} has not been found or could not be read.' in /var/www/html/analytics/piwik/core/Application/Kernel/EnvironmentValidator.php:64 Stack trace:

#0 /var/www/html/analytics/piwik/core/Application/Kernel/EnvironmentValidator.php(45): Piwik\Application\Kernel\EnvironmentValidator->checkConfigFileExists('/var/www/html/a...', false)

#1 /var/www/html/analytics/piwik/core/Application/Environment.php(185): Piwik\Application\Kernel\EnvironmentValidator->validate()

#2 /var/www/html/analytics/piwik/core/Application/Environment.php(94): Piwik\Application\Environment->validateEnvironment()

#3 /var/www/html/analytics/piwik/piwik.php(56): Piwik\Application\Environment->init()\n#4 {main}\n thrown in /var/www/html/analytics/piwik/core/Application/Kernel/EnvironmentValidator.php on line 64, referer: http://localhost/analytics/piwik

A warning is show that tracker status 500 is also shown. What is the problem and with my installation. I have changed permission of config/ and tmp/ to 777 also.


Source: (StackOverflow)

docker-piwik - unable to access document

What is my problem?

I want to use Docker to deploy the web analytics tool Piwik on my CentOs 7 Server.

To achieve this I have followed this page, which states that in order to run the piwik container, a mysql container must be running. So I ran the mysql-docker-container first in this fashion:

docker run --name some-mysql -e MYSQL_ROOT_PASSWORD=my-secret-pw -d mysql:latest

After that I ran the piwik-docker-container like so:

docker run --name some-piwik --link some-mysql:mysql -p 6969:9000 -d piwik

According to the site it should now be possible to browse to http://localhost:6969 to see the Piwik Login page.

Unfortunately using my browser of choice (lynx), I get this error message:

[root@localhost /]# lynx localhost:6969

Looking up localhost first
Looking up localhost:6969
Making HTTP connection to localhost:6969
Sending HTTP request.
HTTP request sent; waiting for response.
Alert!: Unexpected network read error; connection aborted.
Can't Access `http://localhost:6969/'
Alert!: Unable to access document.

lynx: Can't access startfile


What have I done to debug it?

To debug this behaviour I listed all running containers:

[root@localhost /]# docker ps
CONTAINER ID        IMAGE                    COMMAND                  CREATED             STATUS              PORTS                    NAMES
091d56f024f7        piwik                    "/entrypoint.sh php-f"   About an hour ago   Up About an hour    0.0.0.0:6969->9000/tcp   some-piwik
0d869ba11123        mysql:latest             "/entrypoint.sh mysql"   About an hour ago   Up About an hour    3306/tcp                 some-mysql

Conclusion: It seems like the ports are mapped and both containers are running.


In search of another possible hint to the source of my problem I checked the logs of the containers:

[root@localhost gitlab]# docker logs some-piwik
[22-Mar-2016 14:53:08] NOTICE: fpm is running, pid 1
[22-Mar-2016 14:53:08] NOTICE: ready to handle connections

Conclusion: It seems like the piwik container is ready.

[root@localhost gitlab]# docker logs some-mysql
Initializing database
2016-03-22T14:31:30.234530Z 0 [Warning] InnoDB: New log files created, LSN=45790
2016-03-22T14:31:30.715480Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2016-03-22T14:31:30.803664Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: c4f82d8d-f03a-11e5-b9ab-0242ac110003.
2016-03-22T14:31:30.807955Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2016-03-22T14:31:30.808521Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
2016-03-22T14:31:32.217007Z 1 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode.
2016-03-22T14:31:32.217054Z 1 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode.
2016-03-22T14:31:32.217074Z 1 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode.
2016-03-22T14:31:32.217092Z 1 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode.
2016-03-22T14:31:32.217148Z 1 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode.
Database initialized
MySQL init process in progress...
2016-03-22T14:31:34.152405Z 0 [Note] mysqld (mysqld 5.7.11) starting as process 45 ...
2016-03-22T14:31:34.157555Z 0 [Note] InnoDB: PUNCH HOLE support available
2016-03-22T14:31:34.157593Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-03-22T14:31:34.157601Z 0 [Note] InnoDB: Uses event mutexes
2016-03-22T14:31:34.157608Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2016-03-22T14:31:34.157617Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
2016-03-22T14:31:34.157623Z 0 [Note] InnoDB: Using Linux native AIO
2016-03-22T14:31:34.157969Z 0 [Note] InnoDB: Number of pools: 1
2016-03-22T14:31:34.158117Z 0 [Note] InnoDB: Using CPU crc32 instructions
2016-03-22T14:31:34.171400Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2016-03-22T14:31:34.183239Z 0 [Note] InnoDB: Completed initialization of buffer pool
2016-03-22T14:31:34.186125Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2016-03-22T14:31:34.198794Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2016-03-22T14:31:34.212704Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2016-03-22T14:31:34.212824Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2016-03-22T14:31:34.543252Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2016-03-22T14:31:34.544661Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2016-03-22T14:31:34.544685Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2016-03-22T14:31:34.545567Z 0 [Note] InnoDB: Waiting for purge to start
2016-03-22T14:31:34.595786Z 0 [Note] InnoDB: 5.7.11 started; log sequence number 2492554
2016-03-22T14:31:34.595979Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2016-03-22T14:31:34.596205Z 0 [Note] Plugin 'FEDERATED' is disabled.
2016-03-22T14:31:34.597885Z 0 [Note] InnoDB: Buffer pool(s) load completed at 160322 14:31:34
2016-03-22T14:31:34.598226Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2016-03-22T14:31:34.622636Z 0 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode.
2016-03-22T14:31:34.622697Z 0 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode.
2016-03-22T14:31:34.622731Z 0 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode.
2016-03-22T14:31:34.622762Z 0 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode.
2016-03-22T14:31:34.624174Z 0 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode.
2016-03-22T14:31:34.631086Z 0 [Note] Event Scheduler: Loaded 0 events
2016-03-22T14:31:34.631311Z 0 [Note] mysqld: ready for connections.
Version: '5.7.11'  socket: '/var/run/mysqld/mysqld.sock'  port: 0  MySQL Community Server (GPL)
Warning: Unable to load '/usr/share/zoneinfo/Factory' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/leap-seconds.list' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/posix/Factory' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/right/Factory' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it.
2016-03-22T14:31:40.318193Z 4 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode.
2016-03-22T14:31:40.318230Z 4 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode.
2016-03-22T14:31:40.318272Z 4 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode.

/entrypoint.sh: ignoring /docker-entrypoint-initdb.d/*

2016-03-22T14:31:40.319867Z 0 [Note] Giving 0 client threads a chance to die gracefully
2016-03-22T14:31:40.319901Z 0 [Note] Shutting down slave threads
2016-03-22T14:31:40.319912Z 0 [Note] Forcefully disconnecting 0 remaining clients
2016-03-22T14:31:40.319921Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2016-03-22T14:31:40.320014Z 0 [Note] Binlog end
2016-03-22T14:31:40.322853Z 0 [Note] Shutting down plugin 'ngram'
2016-03-22T14:31:40.322884Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2016-03-22T14:31:40.322895Z 0 [Note] Shutting down plugin 'partition'
2016-03-22T14:31:40.322903Z 0 [Note] Shutting down plugin 'ARCHIVE'
2016-03-22T14:31:40.322909Z 0 [Note] Shutting down plugin 'MEMORY'
2016-03-22T14:31:40.322923Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2016-03-22T14:31:40.322931Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2016-03-22T14:31:40.322940Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2016-03-22T14:31:40.322946Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2016-03-22T14:31:40.322953Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2016-03-22T14:31:40.322959Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2016-03-22T14:31:40.322965Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2016-03-22T14:31:40.322970Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2016-03-22T14:31:40.322976Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2016-03-22T14:31:40.322982Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2016-03-22T14:31:40.322987Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2016-03-22T14:31:40.322995Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2016-03-22T14:31:40.323002Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2016-03-22T14:31:40.323008Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2016-03-22T14:31:40.323014Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2016-03-22T14:31:40.323022Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2016-03-22T14:31:40.323028Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2016-03-22T14:31:40.323035Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2016-03-22T14:31:40.323041Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2016-03-22T14:31:40.323046Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2016-03-22T14:31:40.323051Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2016-03-22T14:31:40.323056Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2016-03-22T14:31:40.323062Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2016-03-22T14:31:40.323070Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2016-03-22T14:31:40.323077Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2016-03-22T14:31:40.323083Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2016-03-22T14:31:40.323089Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2016-03-22T14:31:40.323097Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2016-03-22T14:31:40.323104Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2016-03-22T14:31:40.323111Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2016-03-22T14:31:40.323117Z 0 [Note] Shutting down plugin 'InnoDB'
2016-03-22T14:31:40.323250Z 0 [Note] InnoDB: FTS optimize thread exiting.
2016-03-22T14:31:40.323446Z 0 [Note] InnoDB: Starting shutdown...
2016-03-22T14:31:40.423749Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2016-03-22T14:31:40.424428Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 160322 14:31:40
2016-03-22T14:31:42.259424Z 0 [Note] InnoDB: Shutdown completed; log sequence number 11991678
2016-03-22T14:31:42.263166Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2016-03-22T14:31:42.263192Z 0 [Note] Shutting down plugin 'MyISAM'
2016-03-22T14:31:42.263204Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2016-03-22T14:31:42.263211Z 0 [Note] Shutting down plugin 'CSV'
2016-03-22T14:31:42.263217Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2016-03-22T14:31:42.263290Z 0 [Note] Shutting down plugin 'sha256_password'
2016-03-22T14:31:42.263306Z 0 [Note] Shutting down plugin 'mysql_native_password'
2016-03-22T14:31:42.263311Z 0 [Note] Shutting down plugin 'keyring_file'
2016-03-22T14:31:42.263600Z 0 [Note] Shutting down plugin 'binlog'
2016-03-22T14:31:42.264545Z 0 [Note] mysqld: Shutdown complete


MySQL init process done. Ready for start up.

2016-03-22T14:31:42.543163Z 0 [Note] mysqld (mysqld 5.7.11) starting as process 1 ...
2016-03-22T14:31:42.548164Z 0 [Note] InnoDB: PUNCH HOLE support available
2016-03-22T14:31:42.548207Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-03-22T14:31:42.548216Z 0 [Note] InnoDB: Uses event mutexes
2016-03-22T14:31:42.548225Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2016-03-22T14:31:42.548234Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
2016-03-22T14:31:42.548250Z 0 [Note] InnoDB: Using Linux native AIO
2016-03-22T14:31:42.548634Z 0 [Note] InnoDB: Number of pools: 1
2016-03-22T14:31:42.548800Z 0 [Note] InnoDB: Using CPU crc32 instructions
2016-03-22T14:31:42.563003Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2016-03-22T14:31:42.574946Z 0 [Note] InnoDB: Completed initialization of buffer pool
2016-03-22T14:31:42.578836Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2016-03-22T14:31:42.591488Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2016-03-22T14:31:42.605952Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2016-03-22T14:31:42.606098Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2016-03-22T14:31:42.935219Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2016-03-22T14:31:42.936243Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2016-03-22T14:31:42.936261Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2016-03-22T14:31:42.937391Z 0 [Note] InnoDB: Waiting for purge to start
2016-03-22T14:31:42.987575Z 0 [Note] InnoDB: 5.7.11 started; log sequence number 11991678
2016-03-22T14:31:42.988186Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2016-03-22T14:31:42.988381Z 0 [Note] Plugin 'FEDERATED' is disabled.
2016-03-22T14:31:42.990760Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2016-03-22T14:31:42.990791Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2016-03-22T14:31:42.990873Z 0 [Note] IPv6 is available.
2016-03-22T14:31:42.990895Z 0 [Note]   - '::' resolves to '::';
2016-03-22T14:31:42.990909Z 0 [Note] Server socket created on IP: '::'.
2016-03-22T14:31:42.993822Z 0 [Note] InnoDB: Buffer pool(s) load completed at 160322 14:31:42
2016-03-22T14:31:43.027560Z 0 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode.
2016-03-22T14:31:43.027600Z 0 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode.
2016-03-22T14:31:43.030086Z 0 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode.
2016-03-22T14:31:43.037089Z 0 [Note] Event Scheduler: Loaded 0 events
2016-03-22T14:31:43.037341Z 0 [Note] mysqld: ready for connections.
Version: '5.7.11'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  MySQL Community Server (GPL)

Conclusion: Strangely, the mysql-container log does not contain any messages that the piwik container somehow connected to it. So this suggests the linking between those containers did not happen, despite the fact that the piwik-container was run with the --link some-mysql:mysql flag.



All of this leads to the questions:

  1. How can I make the browsing to the Piwik Login Page work?
  2. What can I do to find other clues on why its not working?
  3. Have I totally misunderstood the usage of the docker-Piwik conatiner?

Source: (StackOverflow)