Install Matomo - Self-Hosted Google Analytics Alternative

Uploaded November 2023 | Updated September 2026, 2 weeks ago

#Matomo #Analytics #Linux

Full steps can be found at i12bretro.github.io/tutorials/0239.html

--------------------------------------------------------------------
What is Matomo?
--------------------------------------------------------------------
Matomo is the ethical alternative where you won't make privacy sacrifices or compromise your site. Matomo's the Google Analytics alternative that protects your data and your customer's privacy. A powerful web analytics platform with 100% data ownership. - matomo.org

--------------------------------------------------------------------
Installing Matomo
--------------------------------------------------------------------
   01. Log into the Debian device
   02. Run the following commands in a terminal:
         # update software repositories
         sudo apt update
         # install available updates
         sudo apt upgrade -y
         # install Apache HTTPD and MySQL
         sudo apt install apache2 mariadb-server mariadb-client -y
         # install PHP components
         sudo apt install php php-curl php-gd php-cli php-mysql php-xml php-mbstring -y
         # configure the MySQL database
         sudo su
         mysql_secure_installation
   03. Press Enter to login as root
   04. Type Y and press Enter to set a root password, type the password twice to confirm
   05. Type Y and press Enter to remove anonymous users
   06. Type Y and press Enter to disallow root login remotely
   07. Type Y and press Enter to remove the test database
   08. Type Y and press Enter to reload privilege tables
   09. Run the following command to login into MySQL:
         mysql -u root -p
   10. Authenticate with the root password set earlier
   11. Run the following commands to create the Matomo database and database user
         CREATE DATABASE analytics;
         GRANT ALL ON analytics.* to 'analytics'@'localhost' IDENTIFIED BY 'An@lyt1c$!';
         FLUSH PRIVILEGES;
         EXIT;
         exit
   12. Continue with the following commands to download and extract Matomo in the Apache webroot
         # download latest matomo build
         wget builds.matomo.org/matomo.zip
         # extract downloaded zip
         sudo unzip matomo.zip -d /var/www/html
         # move to webroot
         sudo mv /var/www/html/matomo /var/www/html/analytics
         # set the owner of the new analytics directory to www-data
         sudo chown -R www-data:www-data /var/www/html/analytics
   13. Open a web browser and navigate to http://DNSorIP/analytics
   14. Click the Next button on the Welcome screen
   15. Click the Next button on the System Check screen
   16. Fill in the database connection form as follows and click the Next button
         Database Server: 127.0.0.1
         Login: analytics
         Password: An@lyt1c$!
         Database Name: analytics
         Table Prefix:
         Adapter: MySQLI
   17. Click the Next button
   18. Create an administrative logon and set the password ≫ Click the Next button
   19. Complete the form to add the first website to collect analytics on ≫ Click the Next button
   20. Copy the generated code into the header of the application to monitor
   21. Click Next ≫ Click Next on the Congratulations page
   22. Login with the admin logon created earlier
   23. Welcome to free self-hosted web analytics

--------------------------------------------------------------------
Installing Dark Theme (Optional)
--------------------------------------------------------------------
   01. Click the gear icon in the top right
   02. Select Platform ≫ Marketplace from the left navigation menu
   03. Change the Show dropdown to Themes and search for Dark Theme
   04. Find Dark Theme and click the Install button
   05. Type the admin password to confirm the installation
   06. Click the Activate Theme button

Source: matomo.org/docs/installation/#getting-started

### Connect with me and others ###
★ Discord: discord.com/invite/EzenvmSHW8
★ Reddit: reddit.com/r/i12bretro
★ Twitter: twitter.com/i12bretro

Install Matomo - Self-Hosted Google Analytics Alternative - on Linux

Run the Official Debian Rolling Release - Sid - in a VirtualBox VM

$Run SolidInvoice - Open Source Invoicing Software - in Docker #SolidInvoice #Invoicing #Docker Full steps can be found at https://i12bretro.github.io/tutorials/0909.html What is SolidInvoice? SolidInvoice is a sophisticated open-source invoicing application designed to assist small businesses and freelancers in efficiently managing their daily billing operations. With its comprehensive range of features, this elegant online platform ensures that you receive timely payments. - https://github.com/SolidInvoice/SolidInvoice Installing Docker 01. Log into the Linux based device 02. Run the following commands in the terminal # install prerequisites sudo apt install apt-transport-https ca-certificates curl software-properties-common gnupg-agent -y # add docker gpg key curl -fsSL https://download.docker.com/linux/$(awk -F= /^ID=/{ print $NF } /etc/os-release)/gpg | sudo apt-key add - # add docker software repository sudo add-apt-repository deb [arch=$(dpkg print-architecture)] https://download.docker.com/linux/$(awk -F= /^ID=/{ print $NF } /etc/os-release) $(lsb_release -cs) stable # install docker sudo apt install docker-ce docker-compose containerd.io -y # enable and start docker service sudo systemctl enable docker && sudo systemctl start docker # add the current user to the docker group sudo usermod -aG docker $USER # reauthenticate for the new group membership to take effect su - $USER Running SolidInvoice 01. Now that Docker is installed, run the following commands to setup the SolidInvoice Docker container and run it # create working directories mkdir ~/docker/mariadb -p # set owner of working directories sudo chown $USER:$USER ~/docker -R # run the mariadb docker container docker run -d name mariadb -e MYSQL_ROOT_PASSWORD=r00tp@ss -e MYSQL_USER=solidinvoice_rw -e MYSQL_PASSWORD=SolidInv0ic3! -e MYSQL_DATABASE=solidinvoice -v ~/docker/mariadb:/var/lib/mysql restart=unless-stopped mariadb:latest # run the solidinvoice docker container docker run -d name solidinvoice link mariadb:solidinvoice -e DB_PASSWORD=SolidInv0ic3! -e DB_USER=solidinvoice_rw -p 8080:80 restart=unless-stopped solidinvoice/solidinvoice 02. Open a web browser and navigate to http://DNSorIP:8080 03. Click the Next button at the lower right corner of the System Requirements page 04. Complete the Database settings as follows: Driver: Mysql Host: mariadb Port: 3306 User: solidinvoice_rw Password: SolidInv0ic3! Database Name: solidinvoice 05. Click Next 06. After the database schema is created successfully ≫ Click Next 07. Click the Log In Now button 08. Login with the admin credentials created earlier 09. Enter a Company Name and select the default currency ≫ Click Create 10. Welcome to SolidInvoice Documentation: https://hub.docker.com/r/solidinvoice/solidinvoice/ ### Connect with me and others ### ★ Discord: https://discord.com/invite/EzenvmSHW8 ★ Reddit: https://reddit.com/r/i12bretro ★ Twitter: https://twitter.com/i12bretro$

Install Web Based Download Utility with Aria2 WebUI on Windows

Host Your Own Hoppscotch - Browser Based Open Source Alternative to Postman

Install Raspberry Pi OS on the Microsoft Surface RT Tablet

Install FreshRSS - RSS Feed Aggregator - on Windows

Running Virtual Machines on Debian/Ubuntu using QEMU, libvirt and Virt Manager

Install GitLab GitHub Alternative on Raspberry Pi

Setup FTP File Transfers To/From SteamDeck