Uploaded January 2024 | Updated November 2026, 2 days ago
#Matomo #Analytics #Windows
Full steps can be found at i12bretro.github.io/tutorials/0325.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
--------------------------------------------------------------------
Installation
--------------------------------------------------------------------
01. Download XAMPP sourceforge.net/projects/xampp/files/XAMPP%20Windows
02. Download Matomo github.com/matomo-org/matomo/releases/latest
03. Download Microsoft Visual C++ https://aka.ms/vs/16/release/vc_redist.x64.exe
04. Install Microsoft Visual C++
05. Right click the downloaded XAMPP file ≫ Extract All...
06. Right click the downloaded Matomo .zip file ≫ Extract All...
07. Cut the matomo folder inside the XAMPP/htdocs directory
08. Copy the extracted XAMPP directory to a safe location to run from, C:\Program Files for example
09. Run XAMPP/setup_xampp.bat to update the configuration files with the new server location
10. Run XAMPP/xampp-control.exe
11. Click the Start button next to Apache and MySQL
12. Navigate to XAMPP/mysql/bin
13. Hold the SHIFT key and right click in the white space ≫ Open PowerShell windows here...
14. Type the following in the PowerShell window to setup the database
.\mysql -u root
CREATE DATABASE analytics DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE USER 'analytics_rw'@'localhost' IDENTIFIED BY 'An@lyt1c$!';
GRANT ALL ON analytics.* TO 'analytics_rw'@'localhost';
FLUSH PRIVILEGES;
exit;
15. Open a web browser and navigate to http://DNSorIP/matomo
16. Click the Next button on the Welcome screen
17. Click the Next button on the System Check screen
18. Fill in the database connection form as follows and click the Next button
Database Server: 127.0.0.1
Login: analytics_rw
Password: An@lyt1c$!
Database Name: analytics
Table Prefix:
Adapter: MySQLI
19. Click Next on the Creating the Tables page
20. Enter a Superuser login, password and email ≫ Click Next
21. Complete the form to setup the first site to start tracking analytics ≫ Click Next
22. Click Next then Continue to Matomo
23. Login with the Superuser username and password created earlier
24. Welcome to Matomo
--------------------------------------------------------------------
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
#Matomo #Analytics #Windows
Full steps can be found at i12bretro.github.io/tutorials/0325.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
--------------------------------------------------------------------
Installation
--------------------------------------------------------------------
01. Download XAMPP sourceforge.net/projects/xampp/files/XAMPP%20Windows
02. Download Matomo github.com/matomo-org/matomo/releases/latest
03. Download Microsoft Visual C++ https://aka.ms/vs/16/release/vc_redist.x64.exe
04. Install Microsoft Visual C++
05. Right click the downloaded XAMPP file ≫ Extract All...
06. Right click the downloaded Matomo .zip file ≫ Extract All...
07. Cut the matomo folder inside the XAMPP/htdocs directory
08. Copy the extracted XAMPP directory to a safe location to run from, C:\Program Files for example
09. Run XAMPP/setup_xampp.bat to update the configuration files with the new server location
10. Run XAMPP/xampp-control.exe
11. Click the Start button next to Apache and MySQL
12. Navigate to XAMPP/mysql/bin
13. Hold the SHIFT key and right click in the white space ≫ Open PowerShell windows here...
14. Type the following in the PowerShell window to setup the database
.\mysql -u root
CREATE DATABASE analytics DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE USER 'analytics_rw'@'localhost' IDENTIFIED BY 'An@lyt1c$!';
GRANT ALL ON analytics.* TO 'analytics_rw'@'localhost';
FLUSH PRIVILEGES;
exit;
15. Open a web browser and navigate to http://DNSorIP/matomo
16. Click the Next button on the Welcome screen
17. Click the Next button on the System Check screen
18. Fill in the database connection form as follows and click the Next button
Database Server: 127.0.0.1
Login: analytics_rw
Password: An@lyt1c$!
Database Name: analytics
Table Prefix:
Adapter: MySQLI
19. Click Next on the Creating the Tables page
20. Enter a Superuser login, password and email ≫ Click Next
21. Complete the form to setup the first site to start tracking analytics ≫ Click Next
22. Click Next then Continue to Matomo
23. Login with the Superuser username and password created earlier
24. Welcome to Matomo
--------------------------------------------------------------------
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

![Run MeshCentral - Remote Management Site - in Docker
#MeshCentral #HomeLab #Docker
Full steps can be found at https://i12bretro.github.io/tutorials/0963.html
What is MeshCentral?
MeshCentral is a full computer management web site. With MeshCentral, you can run your own web server to remotely manage and control computers on a local network or anywhere on the internet. - https://github.com/Ylianst/MeshCentral
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 git 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 MeshCentral
01. Now that Docker is installed, run the following commands to setup the MeshCentral Docker container and run it
# create working directories
mkdir ~/docker/meshcentral/{data,user_files} -p && mkdir ~/docker/mongodb -p
# set owner of working directories
sudo chown $USER:$USER ~/docker -R
# create docker network
docker network create containers
# run mongodb container
docker run -d name=mongodb network containers -v ~/docker/mongodb:/data/db restart=unless-stopped mongo
# run meshcentral container
# update the HOSTNAME variable
docker run -d name=meshcentral network containers -p 8086:443 -e HOSTNAME=ubuntuserver.local -e REVERSE_PROXY=false -e IFRAME=false -e ALLOW_NEW_ACCOUNTS=false -e WEBRTC=false -e NODE_ENV=production -v ~/docker/meshcentral/data:/opt/meshcentral/meshcentral-data -v ~/docker/meshcentral/user_files:/opt/meshcentral/meshcentral-files restart=unless-stopped typhonragewind/meshcentral:mongodb-latest
# update the config file
sed -Ei s/(NewAccounts: false,)/NewAccounts: false,ntallowedOrigin: true,/ ~/docker/meshcentral/data/config.json
# restart the container
docker restart meshcentral
02. Open a web browser and navigate to https://DNSorIP:8086
03. Accept the certificate warning
04. Click the link to create an account
05. Complete the form by entering an username, email and password ≫ Click Create Account
06. Welcome to MeshCentral running in Docker
Source: https://github.com/Typhonragewind/meshcentral-docker
### Connect with me and others ###
★ Discord: https://discord.com/invite/EzenvmSHW8
★ Reddit: https://reddit.com/r/i12bretro
★ Twitter: https://twitter.com/i12bretro Run MeshCentral - Remote Management Site - in Docker](https://i.ytimg.com/vi/V94q02P1zwM/mqdefault.jpg)


![Install Odoo - Open Source Business Application Suite - on Linux
#Odoo #Python #Linux
Full steps can be found at https://i12bretro.github.io/tutorials/0924.html
What is Odoo?
Odoo is a suite of web based open source business apps. The main Odoo Apps include an Open Source CRM, Website Builder, eCommerce, Warehouse Management, Project Management, Billing & Accounting, Point of Sale, Human Resources, Marketing, Manufacturing. Odoo Apps can be used as stand-alone applications, but they also integrate seamlessly so you get a full-featured Open Source ERP when you install several Apps. - https://github.com/odoo/odoo
Installation
01. Log into the Linux device
02. Run the following commands in terminal
# update software repositories
sudo apt update
# install available software updates
sudo apt upgrade
# install prerequisites
sudo apt install wget git apt-transport-https -y
# install postgresql
sudo apt install postgresql postgresql-client -y
# enable the postgresql service and start it
sudo systemctl enable postgresql now
# connect to postgresql
sudo -u postgres psql postgres
# create odoo database user
create user odoo_rw with password 0dooDB_rw$;
# create odoo database
create database odoo with encoding=UTF8 template=template0 owner=odoo_rw;
# close postgresql connection
exit
# install python
sudo apt install python3-full python3-pip libldap2-dev libpq-dev libsasl2-dev -y
# create odoo user
sudo useradd -M odoo
# create /opt/odoo directory
sudo mkdir /opt/odoo -p
# set owner of /opt/odoo
sudo chown odoo /opt/odoo -R && sudo chgrp odoo /opt/odoo -R && sudo usermod -d /opt/odoo odoo
# switch to odoo user
sudo su - odoo
# clone odoo from github
git clone https://github.com/odoo/odoo.git .
# prepare the working directory
python3 -m venv odoo-venv
. odoo-venv/bin/activate
# install wheel
pip3 install wheel
# install odoo
pip install -r requirements.txt
# create a config file
touch ./odoo.conf
# write database config to config file
echo [options]ndb_user = odoo_rwndb_password = 0dooDB_rw$ndb_name = odoondb_host = localhost ≫ ./odoo.conf
# run odoo
./odoo-bin config ./odoo.conf -i base
03. Open a web browser and navigate to http://DNSorIP:8069
04. Login with the username admin and password admin
05. Click the user icon at the top right corner of the screen ≫ Preferences
06. Update the Email and Email Signature ≫ Click Save
07. Click the Account Security tab ≫ Click the Change Password button
08. Enter admin as the current password ≫ Click Confirm Password
09. Enter and confirm a new password ≫ Click Change Password
10. Login using the updated email address and password
11. Welcome to Odoo
Running Odoo as a Service
01. Back in the Terminal, press CTRL+C to kill the running Odoo process
02. Continue with the following commands in terminal
# exit the odoo user shell
exit
# create odoo service file
sudo nano /etc/systemd/system/odoo.service
03. Paste the following into odoo.service
[Unit]
Description=Odoo
Requires=postgresql.service
After=network.target postgresql.service
[Service]
User=odoo
Group=odoo
ExecStart=/opt/odoo/odoo-venv/bin/python3 /opt/odoo/odoo-bin -c /opt/odoo/odoo.conf
[Install]
WantedBy=multi-user.target
04. Press CTRL+O, Enter, CTRL+X to write the changes
05. Continue with the following commands
# reload systemd services
sudo systemctl daemon-reload
# start odoo service on boot and now
sudo systemctl enable odoo now
06. Back in the web browser, refresh the Odoo tab
07. If prompted, log back in using the updated email address and password
Source: https://www.odoo.com/documentation/17.0/administration/on_premise/source.html
### Connect with me and others ###
★ Discord: https://discord.com/invite/EzenvmSHW8
★ Reddit: https://reddit.com/r/i12bretro
★ Twitter: https://twitter.com/i12bretro Install Odoo - Open Source Business Application Suite - on Linux](https://i.ytimg.com/vi/WPBEQawJ7p4/mqdefault.jpg)

![Running Shinobi CCTV in Docker
#Shinobi #CCTV #Docker
Full steps can be found at https://i12bretro.github.io/tutorials/0549.html
What is Shinobi?
Shinobi is Open Source, written in Node.js, and real easy to use. It is the future of CCTV and NVR for developers and end-users alike. It is catered to by professionals and most importantly by the one who created it. - https://shinobi.video/
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 the Shinobi Container
01. Now that Docker is installed, run the following commands to setup the Shinobi Docker container and run it
# create working directories
sudo mkdir /home/$USER/docker/shinobi/config -p && sudo mkdir /home/$USER/docker/shinobi/data && sudo mkdir /home/$USER/docker/shinobi/videos
# run the Run Shinobi docker container
docker run -d -p 8080:8080 -v /etc/localtime:/etc/localtime:ro -v /etc/timezone:/etc/timezone:ro -v /home/$USER/docker/shinobi/config:/config -v /home/$USER/docker/shinobi/data:/var/lib/mysql -v /home/$USER/docker/shinobi/videos:/opt/shinobi/videos -v /dev/shm/shinobiDockerTemp:/dev/shm/streams migoller/shinobidocker
02. Open a web browser and navigate to http://DNSorIP:8080/super
03. Login with the username admin@shinobi.video and password admin
04. Select Preferences from the top navigation menu
05. Change the admin user email address and enter and confirm a new password
06. Click Save at the top of the page
07. Welcome to Shinobi
Documentation: https://registry.hub.docker.com/r/migoller/shinobidocker/
### Connect with me and others ###
★ Discord: https://discord.com/invite/EzenvmSHW8
★ Reddit: https://reddit.com/r/i12bretro
★ Twitter: https://twitter.com/i12bretro Running Shinobi CCTV in Docker](https://i.ytimg.com/vi/WeK-JnaYaow/mqdefault.jpg)
![Running Homepage Application Dashboard on Windows
#Homepage #Dashboard #Windows
Full steps can be found at https://i12bretro.github.io/tutorials/0882.html
What is Homepage?
[Homepage is] a modern, fully static, fast, secure fully proxied, highly customizable application dashboard with integrations for over 100 services and translations into multiple languages. Easily configured via YAML files or through docker label discovery. - https://github.com/benphelps/homepage
Installing Homepage
01. Log into the Windows device
02. Download the latest Homepage release https://github.com/benphelps/homepage/releases/latest
03. Download NodeJS https://nodejs.org/en/download/current/
04. Install NodeJS ≫ During the install, make sure to check the Tools for Native Modules option
05. At the Native Modules prompt, press any key to begin the installation process
NOTE: This process takes quite a while to install, be patient. Proceed once the PowerShell window closes
06. Extract the downloaded Homepage files
07. Rename the extracted folder homepage
08. Cut the homepage folder to a location it can safely run from, C:Program Fileshomepage in this example
09. Hold the SHIFT key and right click in the white space ≫ Open PowerShell window here...
10. Run the following commands in the PowerShell window
# install dependencies
npm install
# create .env file from example
Copy-Item .srcskeleton -Destination .config -Recurse
# build homepage
npm run build
# run homepage
npm start
11. Open a web browser and navigate to http://DNSorIP:3000
12. Welcome to Homepage
Run Homepage on System Startup (Optional, but recommended)
01. Press CTRL + C to kill the running Homepage process
02. Open a text editor and paste the following
:: Start homepage server
cd /D %~dp0
start homepage /b npm start
03. Save the file as homepage.bat in the homepage directory, C:Program Fileshomepage in this example
04. Click on the Start Button ≫ Type task ≫ Launch Task Scheduler
05. Right click the Task Scheduler Library folder in the left pane ≫ Create Basic Task...
06. Set the name to Homepage and optionally set a Description ≫ Click Next
07. For the Trigger, select When the computer starts ≫ Click Next
08. For the Action, select Start a program ≫ Click Next
09. Complete the form fields as follows:
Program/script: %ProgramFiles%homepagehomepage.bat
Add arguments:
Start in:
10. Click Next
11. Check the Open the Properties dialog checkbox ≫ Click Finish
12. In the Properties dialog, click the Change User or Group... button
13. Type System in the Object name field ≫ Click OK
14. Check the Run with highest privileges box
15. Click OK to create the scheduled task
16. Right click the Homepage task ≫ Run
17. Refresh the open web browser to verify Homepage is now running from the scheduled task
Source: https://github.com/gethomepage/homepage?tab=readme-ov-file#with-node
### Connect with me and others ###
★ Discord: https://discord.com/invite/EzenvmSHW8
★ Reddit: https://reddit.com/r/i12bretro
★ Twitter: https://twitter.com/i12bretro Running Homepage Application Dashboard on Windows](https://i.ytimg.com/vi/WkuNY6tnxU0/mqdefault.jpg)
![Running an Amazon Linux (AL2) VM in Proxmox
#AmazonLinux #Proxmox #AL2VM
Full steps can be found at https://i12bretro.github.io/tutorials/0155.html
What is Amazon Linux?
Amazon Linux 2 is a Linux operating system from Amazon Web Services (AWS). It provides a security-focused, stable, and high-performance execution environment to develop and run cloud applications. - https://aws.amazon.com/amazon-linux-2
Creating the VM
01. Open a web browser and navigate to the ProxMox web UI (ie https://ProxMoxDNSorIP:8006/)
02. Right click the Proxmox node name ≫ Create VM
03. Give the VM a unique ID and Name ≫ Next
04. On the OS tab, Select Do not use any media, leave the Type as Linux and the Version as 5.x - 2.6 Kernel ≫ Next
05. On the System tab, leave the defaults and check the Qemu Agent box to enable it ≫ Next
06. On the Hard Disk tab, delete the scsi0 disk ≫ Next
07. On the CPU tab, set Cores to 1 or more and Type to host ≫ Next
08. On the Memory tab, set the Memory to 512 or more ≫ Next
09. Leave the defaults on the Network tab ≫ Next
10. Verify the summary and click Finish
11. Click the Proxmox node in the left navigation menu ≫ Shell
12. Run the following commands in the web shell
# lookup the latest amazon linux file name
regex=≪td≫≪a href=([^/]*.qcow2)≫[^/]*≪/a≫≪/td≫ && response=$(curl -s -L https://cdn.amazonlinux.com/os-images/latest/kvm/) && [[ $response =~ $regex ]] && downloadURL=${BASH_REMATCH[1]}
# download the amazon linux virtual disk
wget -O /tmp/al2.qcow2 https://cdn.amazonlinux.com/os-images/latest/kvm/$downloadURL
# import the downloaded virtual disk
# update the vmid and destination storage pool to match your environment
# usage
# qm importdisk ≪%target vmid%≫ ≪%path to source disk%≫ ≪%destination storage device%≫ [OPTIONS]
qm importdisk 2000 /tmp/al2.qcow2 SSD_100GB
13. Once the import completes, select the newly created Amazon Linux VM from the left navigation panel
14. Select Hardware from the left sub-navigation menu
15. Double click the Unused Disk to edit it ≫ Click the Add button
16. Click the Add dropdown ≫ CloudInit Drive
17. Set the target storage for the CloudInit drive ≫ Click the Add button
18. Select Cloud-Init from the left sub-navigation menu
19. Edit each of the Cloud-Init fields to set a username, password and DNS/network parameters
20. Select Options from the left sub-navigation menu
21. Double click Boot Order
22. Check the Enabled box next to the hard disk and drag it up in the boot order as needed, typically below the CD-ROM device
23. Click OK
24. Click the Start button in the top right of the screen
25. Select Console from the left sub-navigation menu to watch the boot process
Setting Up Amazon Linux 2
01. Once the boot process completes, login with the username and password set in the Cloud-Init settings earlier
02. Run the following commands in the terminal
# elavate to root
sudo su
# enable hostname preservation in cloud-init config
echo -e npreserve_hostname: true ≫≫ /etc/cloud/cloud.cfg
# set the hostname
hostnamectl set-hostname amazon-linux
# output hostname details
hostnamectl
# update software repositories
yum check-update
# install available updates
yum update
# install qemu-guest-agent
yum install qemu-guest-agent -y
# shutdown
shutdown now
03. Once the VM has shutdown completely, power it back up on clicking the Start button at the top right of the screen
04. After the boot process completes, login back in
05. Continue with the following command in the terminal
# verify hostname details were retained
sudo hostnamectl
06. Welcome to Amazon Linux running in Proxmox
### Connect with me and others ###
★ Discord: https://discord.com/invite/EzenvmSHW8
★ Reddit: https://reddit.com/r/i12bretro
★ Twitter: https://twitter.com/i12bretro Running an Amazon Linux (AL2) VM in Proxmox](https://i.ytimg.com/vi/Wrjt6S4wwHs/mqdefault.jpg)

