[SAC] [OSGeo] #2830: Install Matomo for web analytics

#2830: Install Matomo for web analytics
---------------------------+---------------------------------------
Reporter: robe | Owner: sac@…
     Type: task | Status: new
Priority: normal | Milestone: Sysadmin Contract 2022-II
Component: Systems Admin | Keywords:
---------------------------+---------------------------------------
As discussed, it would be useful to have a Matomo instance running to grab
analytics

https://matomo.org

As discussed here -
[SAC] Deploying Matomo for download statistics?

Requirements are:

* PHP > 7.2
* MySQL > 5.5
* Apache2 or NGINX

There is also a plugin for wordpress

Installing Matomo for Wordpress - Analytics Platform - Matomo

I'm unclear if the wordpress one can only be used for the wordpress
instance, I assume so or if it can be used for any website.

At anyrate, putting in on the wordpress instance on osgeo7, might make the
most sense.

Right now the wordpress instance is running PHP 7.3, I forget which MySQL,
definitely newer than 5.5, and apache2 2.4 I think. It is currently
buster.

I do plan to upgrade it, first on dev, so maybe I can experiment on dev
installing matomo after the upgrade.

It looks however that it relies on some javascript string to be added, so
not sure how it will collect download stats such as what happens on
download.osgeo.org. I would think such a tool would need access to the
raw weblogs as what awstats used to process.
--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2830&gt;
OSGeo <Gter - OSGeo;
OSGeo committee and general foundation issue tracker.

#2830: Install Matomo for web analytics
---------------------------+---------------------------------------
Reporter: robe | Owner: sac@…
     Type: task | Status: new
Priority: normal | Milestone: Sysadmin Contract 2023-I
Component: Systems Admin | Resolution:
Keywords: |
---------------------------+---------------------------------------
Comment (by neteler):

Hi @robe, it would be great to have Matomo in place for OSGeo projects.
--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2830#comment:2&gt;
OSGeo <https://osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.

#2830: Install Matomo for web analytics
---------------------------+---------------------------------------
Reporter: robe | Owner: sac@…
     Type: task | Status: new
Priority: normal | Milestone: Sysadmin Contract 2023-I
Component: Systems Admin | Resolution:
Keywords: |
---------------------------+---------------------------------------
Comment (by strk):

Vicky: any chance this could be put on your plate as well ?
See also https://trac.osgeo.org/postgis/ticket/5559#comment:13
--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2830#comment:3&gt;
OSGeo <https://osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.

#2830: Install Matomo for web analytics
---------------------------+---------------------------------------
Reporter: robe | Owner: sac@…
     Type: task | Status: new
Priority: normal | Milestone: Sysadmin Contract 2023-I
Component: Systems Admin | Resolution:
Keywords: |
---------------------------+---------------------------------------
Comment (by strk):

https://en.wikipedia.org/wiki/Matomo_(software) seem to be still a good
choice, latest release was 2 months ago
--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2830#comment:4&gt;
OSGeo <https://osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.

#2830: Install Matomo for web analytics
---------------------------+---------------------------------------
Reporter: robe | Owner: sac@…
     Type: task | Status: new
Priority: normal | Milestone: Sysadmin Contract 2023-I
Component: Systems Admin | Resolution:
Keywords: |
---------------------------+---------------------------------------
Comment (by robe):

Also mentioned on postgis-development https://lists.osgeo.org/pipermail
/postgis-devel/2023-October/030123.html is Plausible.io
https://plausible.io/.

One thing I like about Plausible over Matomo is that it uses postgres as
its backend. Matomo uses MySQL/MariaDb. Plausible general deployment is
with docker.

I think when I was looking at plausible.io I thought it was only offered
as a service, but similar to Matomo, you can host on your own server.

The Matomo licensing is GLPv3 while the Plausible.io is AGPL license. I
think for our purposes both licensing models are fine.
--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2830#comment:5&gt;
OSGeo <https://osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.

#2830: Install Matomo or Plausible for web analytics
---------------------------+---------------------------------------
Reporter: robe | Owner: sac@…
     Type: task | Status: new
Priority: normal | Milestone: Sysadmin Contract 2023-I
Component: Systems Admin | Resolution:
Keywords: |
---------------------------+---------------------------------------
Changes (by robe):

* summary: Install Matomo for web analytics => Install Matomo or Plausible
     for web analytics

--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2830#comment:6&gt;
OSGeo <https://osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.

#2830: Install Matomo or Plausible for web analytics
---------------------------+---------------------------------------
Reporter: robe | Owner: sac@…
     Type: task | Status: new
Priority: normal | Milestone: Sysadmin Contract 2023-I
Component: Systems Admin | Resolution:
Keywords: |
---------------------------+---------------------------------------
Comment (by strk):

Plausible is missing from
https://en.wikipedia.org/wiki/List_of_web_analytics_software - if anyone
is thrilled by being able to add something to our beloved human knowledge
base !
--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2830#comment:7&gt;
OSGeo <https://osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.

#2830: Install Matomo or Plausible for web analytics
---------------------------+---------------------------------------
Reporter: robe | Owner: sac@…
     Type: task | Status: new
Priority: normal | Milestone: Sysadmin Contract 2023-I
Component: Systems Admin | Resolution:
Keywords: |
---------------------------+---------------------------------------
Comment (by strk):

Plausible business model is intentionally keeping valued features out of
the free software edition: https://github.com/plausible/analytics

> Selected premium features are not available as we aim to ensure a
protective barrier around our cloud offering.

I'd rather use MariaDB ...
--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2830#comment:8&gt;
OSGeo <https://osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.

#2830: Install Matomo or Plausible for web analytics
---------------------------+---------------------------------------
Reporter: robe | Owner: sac@…
     Type: task | Status: new
Priority: normal | Milestone: Sysadmin Contract 2023-I
Component: Systems Admin | Resolution:
Keywords: |
---------------------------+---------------------------------------
Comment (by neteler):

FWIW: Matomo is pretty cool while the "community" Plausible seems to be
rather limited.
--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2830#comment:9&gt;
OSGeo <https://osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.

#2830: Install Matomo or Plausible for web analytics
---------------------------+---------------------------------------
Reporter: robe | Owner: sac@…
     Type: task | Status: new
Priority: normal | Milestone: Sysadmin Contract 2023-I
Component: Systems Admin | Resolution:
Keywords: |
---------------------------+---------------------------------------
Comment (by strk):

Show your support for the idea of adding PostgreSQL backend here:
https://github.com/matomo-org/matomo/issues/500
--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2830#comment:10&gt;
OSGeo <https://osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.

#2830: Install Matomo or Plausible for web analytics
---------------------------+---------------------------------------
Reporter: robe | Owner: sac@…
     Type: task | Status: new
Priority: normal | Milestone: Sysadmin Contract 2023-I
Component: Systems Admin | Resolution:
Keywords: |
---------------------------+---------------------------------------
Comment (by robe):

Replying to [comment:10 strk]:
> Show your support for the idea of adding PostgreSQL backend here:
https://github.com/matomo-org/matomo/issues/500

I put my +1 on it, but I honestly think they aren't interested at all in
supporting PostgreSQL. So I feel that will go no where.
--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2830#comment:11&gt;
OSGeo <https://osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.

#2830: Install Matomo or Plausible for web analytics
----------------------+---------------------------------------
Reporter: robe | Owner: sac@…
     Type: task | Status: new
Priority: normal | Milestone: Sysadmin Contract 2023-I
Component: SysAdmin | Resolution:
Keywords: |
----------------------+---------------------------------------
Comment (by gdt):

Interesting commentary at:
   https://blog.fidelramos.net/software/privacy-respecting-self-hosted-web-
analytics
--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2830#comment:12&gt;
OSGeo <https://osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.