Uploaded July 2024 | Updated November 2026, 2 days ago
#Umami #Analytics #Windows
Full steps can be found at i12bretro.github.io/tutorials/0384.html
--------------------------------------------------------------------
What is Umami?
--------------------------------------------------------------------
Umami is a simple, fast, privacy-focused alternative to Google Analytics. - github.com/umami-software/umami
--------------------------------------------------------------------
Installation
--------------------------------------------------------------------
01. Log into the Windows device
02. Download the latest Umami release github.com/umami-software/umami/releases/latest
03. Download NodeJS nodejs.org/en/download/prebuilt-installer/current
04. Download the latest MySQL .msi installer dev.mysql.com/downloads/mysql
05. Download Microsoft Visual C++ https://aka.ms/vs/16/release/vc_redist.x64.exe
06. Install Microsoft Visual C++
07. Run the downloaded MySQL installer, accepting the defaults and selecting the Typical installation when prompted
08. When the installation completes, make sure "Run MySQL Configurator" is checked ≫ Click Finish
09. Step through the installer accepting all the defaults
10. Enter and confirm a root password when prompted
11. Launch a Terminal or PowerShell window
12. Run the following commands to login into MySQL
# change directory to mysql\bin
cd "C:\Program Files\MySQL\MySQL Server*\bin"
# connect to the database
.\mysql -u root -p
13. Authenticate with the root password set during the database configuration
14. Run the following commands to create the database and database user
CREATE DATABASE umami DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
CREATE USER 'umami_rw'@'localhost' IDENTIFIED BY 'um@m1!';
GRANT ALL ON umami.* TO 'umami_rw'@localhost;
FLUSH PRIVILEGES;
EXIT;
exit
15. Back in File Explorer, navigate to the Downloads directory
16. Install NodeJS, accepting all defaults
17. Extract the downloaded Umami files
18. Rename the extracted folder Umami
19. Cut the Umami folder to a location it can safely run from, C:\apps\Umami in this example
20. Hold the SHIFT key and right click in the white space ≫ Open PowerShell windows here...
21. Run the following commands in the PowerShell window
# create .env file
notepad .\.env
22. Paste the following into the .env file
DATABASE_URL=mysql://umami_rw:um@m1!@localhost:3306/umami
HASH_SALT=SomethingSecure
23. Save the changes to .env and close Notepad
24. Continue with the following commands in the PowerShell window
# make sure .env didn't get a .txt extension
mv .\.env.txt .\.env
# install dependencies
npm install --force
# build umami
npm run build
# run umami
npm start
25. Open a web browser and navigate to http://DNSorIP:3000
26. Login with the username admin and password umami
27. Navigate to Settings ≫ Profile and click the Change Password button
28. Enter the current password (umami) and enter and confirm the new password ≫ Click save
29. Welcome to Umami
--------------------------------------------------------------------
Run Umami on System Startup (Optional, but recommended)
--------------------------------------------------------------------
01. Press CTRL + C to kill the running Umami process in the open PowerShell window
02. Open a text editor and paste the following
:: Start Umami server
cd /D "%~dp0"
start "Umami" /b npm start
03. Save the file as umami.bat in the Umami directory, C:\apps\umami 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 Umami 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: "C:\apps\Umami\umami.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 Umami task ≫ Run
17. Refresh the open web browser to verify Umami is now running from the scheduled task
Documentation: github.com/umami-software/umami
### Connect with me and others ###
★ Discord: discord.com/invite/EzenvmSHW8
★ Reddit: reddit.com/r/i12bretro
★ Twitter: twitter.com/i12bretro
#Umami #Analytics #Windows
Full steps can be found at i12bretro.github.io/tutorials/0384.html
--------------------------------------------------------------------
What is Umami?
--------------------------------------------------------------------
Umami is a simple, fast, privacy-focused alternative to Google Analytics. - github.com/umami-software/umami
--------------------------------------------------------------------
Installation
--------------------------------------------------------------------
01. Log into the Windows device
02. Download the latest Umami release github.com/umami-software/umami/releases/latest
03. Download NodeJS nodejs.org/en/download/prebuilt-installer/current
04. Download the latest MySQL .msi installer dev.mysql.com/downloads/mysql
05. Download Microsoft Visual C++ https://aka.ms/vs/16/release/vc_redist.x64.exe
06. Install Microsoft Visual C++
07. Run the downloaded MySQL installer, accepting the defaults and selecting the Typical installation when prompted
08. When the installation completes, make sure "Run MySQL Configurator" is checked ≫ Click Finish
09. Step through the installer accepting all the defaults
10. Enter and confirm a root password when prompted
11. Launch a Terminal or PowerShell window
12. Run the following commands to login into MySQL
# change directory to mysql\bin
cd "C:\Program Files\MySQL\MySQL Server*\bin"
# connect to the database
.\mysql -u root -p
13. Authenticate with the root password set during the database configuration
14. Run the following commands to create the database and database user
CREATE DATABASE umami DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
CREATE USER 'umami_rw'@'localhost' IDENTIFIED BY 'um@m1!';
GRANT ALL ON umami.* TO 'umami_rw'@localhost;
FLUSH PRIVILEGES;
EXIT;
exit
15. Back in File Explorer, navigate to the Downloads directory
16. Install NodeJS, accepting all defaults
17. Extract the downloaded Umami files
18. Rename the extracted folder Umami
19. Cut the Umami folder to a location it can safely run from, C:\apps\Umami in this example
20. Hold the SHIFT key and right click in the white space ≫ Open PowerShell windows here...
21. Run the following commands in the PowerShell window
# create .env file
notepad .\.env
22. Paste the following into the .env file
DATABASE_URL=mysql://umami_rw:um@m1!@localhost:3306/umami
HASH_SALT=SomethingSecure
23. Save the changes to .env and close Notepad
24. Continue with the following commands in the PowerShell window
# make sure .env didn't get a .txt extension
mv .\.env.txt .\.env
# install dependencies
npm install --force
# build umami
npm run build
# run umami
npm start
25. Open a web browser and navigate to http://DNSorIP:3000
26. Login with the username admin and password umami
27. Navigate to Settings ≫ Profile and click the Change Password button
28. Enter the current password (umami) and enter and confirm the new password ≫ Click save
29. Welcome to Umami
--------------------------------------------------------------------
Run Umami on System Startup (Optional, but recommended)
--------------------------------------------------------------------
01. Press CTRL + C to kill the running Umami process in the open PowerShell window
02. Open a text editor and paste the following
:: Start Umami server
cd /D "%~dp0"
start "Umami" /b npm start
03. Save the file as umami.bat in the Umami directory, C:\apps\umami 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 Umami 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: "C:\apps\Umami\umami.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 Umami task ≫ Run
17. Refresh the open web browser to verify Umami is now running from the scheduled task
Documentation: github.com/umami-software/umami
### Connect with me and others ###
★ Discord: discord.com/invite/EzenvmSHW8
★ Reddit: reddit.com/r/i12bretro
★ Twitter: twitter.com/i12bretro

![Running a MacOS 14 Sonoma VM in VMware
#MacOS #Sonoma #VMware
Full steps can be found at https://i12bretro.github.io/tutorials/0602.html
Installing and Configuring VMware
💡 NOTE: MacOS higher than version 12 requires a CPU with AVX2 instruction support
01. Download a MacOS Sonoma .iso https://archive.org/search.php?query=MacOS%20Collection&and[]=mediatype%3A%22software%22 OR create your own https://youtu.be/JFMvUpdCMwo
02. Download VMware Workstation Player https://www.vmware.com/products/workstation-player.html
03. Download MacOS Unlocker for VMware Workstation https://github.com/paolo-projects/auto-unlocker/releases
04. Install VMware Workstation Player, accepting the defaults
05. Extract the downloaded MacOS Unlocker for VMware Workstation
06. Inside the extracted file, right click Unlocker.exe ≫ Run as administrator
07. Click the Patch button
08. Wait for patching to complete before continuing
Creating the Sonoma VM
01. Launch VMware Workstation Player
02. Click Continue to use Workstation Player for free for non-commercial use
03. Click Finish
04. Click Create a New Virtual Machine on the right side of the application
05. Select Installer disc image file (iso) ≫ Browse to and select the downloaded MacOS Sonoma .iso ≫ Click Next
06. Select Apple Mac OS X and macOS 13 ≫ Click Next
07. Name the VM MacOS14 and set the path to store the VM files ≫ Click Next
08. Adjust the disk size if necessary ≫ Click Next
09. Click Finish
10. Open File Explorer and navigate to the VM files
11. Edit the .vmx file in a text editor
12. Search for board-id.reflectHost and set the value to FALSE
board-id.reflectHost = FALSE
13. Search for ethernet0.virtualDev and set the value to vmxnet3
ethernet0.virtualDev = vmxnet3
14. Then paste the following options at the bottom of the file
board-id = Mac-AA95B1DDAB278B95
hw.model.reflectHost = FALSE
hw.model = MacBookPro19,1
serialNumber.reflectHost = FALSE
serialNumber = C01234567890
15. Right click on the MacOS14 VM ≫ Power On
Installing MacOS Sonoma
01. After an initialization sequence the MAC OS Setup should start
02. Select a Language ≫ Click the next arrow
03. Select Disk Utility
04. Select the VMware Virtual SATA Hard Drive Media ≫ Click Erase
05. Name the drive MacOS ≫ Set the Format to APFS ≫ Click Erase
06. Click Done ≫ Close Disk Utility
07. Click Install macOS
08. Click Continue ≫ Click Agree ≫ Click Agree again
09. Select the MacOS disk ≫ Click Install
10. Wait while Mac OS installs files, the VM will reboot several times
11. Select your Country or Region ≫ Click Continue
12. Confirm your languages and keyboard layout ≫ Click Continue
13. Click Not Now on the Accessibility screen
14. Click Continue on the Data & Privacy screen
15. Select Not Now on the Migration Assistant screen
16. Select Set Up Later and then Skip on the Apple ID screen
17. Click Agree ≫ Agree again
18. Enter a name, user name, password ≫ Click Continue
19. Click Continue ≫ Select Use or Dont Use for Location Services
20. Pick a timezone ≫ Click Continue
21. Uncheck Share Mac Analytics with Apple ≫ Click Continue
22. Click Set Up Later on the Screen Time screen
23. Pick a theme ≫ Click Continue
24. Welcome to MacOS 14 Sonoma
Install VMware Tools (optional, but recommended)
01. Right click the Install MacOS disc on the desktop ≫ Eject
02. On the VMware toolbar click Player ≫ Removable Devices ≫ CD/DVD ≫ Settings
03. Click Browse next to ISO Image File ≫ Browse to the extracted Unlocker files tools ≫ Select darwin.iso
04. Click the Connected checkbox
05. Click OK
06. Inside the VM, double click the mounted VMware tools and run the installer
07. When prompted, go into the Security settings and scroll to the bottom ≫ Click Allow next to VMware ≫ Reboot
08. After rebooting double click the mounted VMware tools and run the installer again
09. After the install succeeds, reboot again
### Connect with me and others ###
★ Discord: https://discord.com/invite/EzenvmSHW8
★ Reddit: https://reddit.com/r/i12bretro
★ Twitter: https://twitter.com/i12bretro Running a MacOS 14 Sonoma VM in VMware](https://i.ytimg.com/vi/JRYECTBP-Yg/mqdefault.jpg)

![Run BookStack - Documentation/Wiki Platform - in Docker
#BookStack #Wiki #Docker
Full steps can be found at https://i12bretro.github.io/tutorials/0921.html
What is BookStack?
BookStack is an opinionated wiki system that provides a pleasant and simple out-of-the-box experience. New users to an instance should find the experience intuitive and only basic word-processing skills should be required to get involved in creating content on BookStack. The platform should provide advanced power features to those that desire it but they should not interfere with the core simple user experience. - https://github.com/BookStackApp/BookStack
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 BookStack
01. Continue with the following commands in a terminal window
# list current uid and gid, note these for later
id $user
# create working directories
mkdir ~/docker/bookstack/config -p && mkdir ~/docker/mariadb -p
# set ownership on the working directories
sudo chown $USER:$USER ~/docker -R
# run the mariadb docker container
docker run -d name mariadb -e MYSQL_ROOT_PASSWORD=r00tp@$$ -e MYSQL_USER=bookstack_rw -e MYSQL_PASSWORD=B00k$t@ck! -e MYSQL_DATABASE=bookstack -v ~/docker/mariadb:/var/lib/mysql -p 3306:3306 restart=unless-stopped mariadb:latest
# run the bookstack docker image
# replace PUID, GUID with the output of the id $user command above
# replace DB_HOST and APP_URL with the docker host DNS name or IP address
docker run -d name bookstack -e PUID=1000 -e PGID=1000 -e TZ=America/New_York -e APP_URL=http://ubuntuserver.local:6875 -e DB_HOST=172.17.0.1 -e DB_PORT=3306 -e DB_USER=bookstack_rw -e DB_PASS=B00k$t@ck! -e DB_DATABASE=bookstack -p 6875:80 -v ~/docker/bookstack/config:/config restart unless-stopped lscr.io/linuxserver/bookstack:latest
02. Open a web browser and navigate to http://DNSorIP:6875
03. Login with the username admin@admin.com and the password password
04. Click the user dropdown at the top right ≫ My Account
05. Update the user name and email address as needed ≫ Click Save
06. Select Access & Security from the left navigation menu
07. Enter and confirm a new password ≫ Click Update
08. Click the user dropdown at the top right ≫ Logout
09. Log back in using the updated email address and password
10. Welcome to BookStack
Documentation: https://hub.docker.com/r/linuxserver/bookstack
### Connect with me and others ###
★ Discord: https://discord.com/invite/EzenvmSHW8
★ Reddit: https://reddit.com/r/i12bretro
★ Twitter: https://twitter.com/i12bretro Run BookStack - Documentation/Wiki Platform - in Docker](https://i.ytimg.com/vi/L2W3gJHQgdY/mqdefault.jpg)

![Run Actual Budget - Open Source Finance Management - in Docker
#ActualBudget #FOSS #Docker
Full steps can be found at https://i12bretro.github.io/tutorials/0969.html
What is Actual Budget?
Actual is a local-first personal finance tool. It is 100% free and open-source, written in NodeJS, it has a synchronization element so that all your changes can move between devices without any heavy lifting. - https://github.com/actualbudget/actual
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 Actual
01. Now that Docker is installed, run the following commands to setup the Actual Docker container and run it
# create working directories
mkdir ~/docker/actualbudget/data -p
# create config.json
touch ~/docker/actualbudget/config.json
# write empty config file
echo {} ≫ ~/docker/actualbudget/config.json
# set owner of working directories
sudo chown $USER:$USER ~/docker -R
# allow the container to write to working directories
sudo chmod a+rwx -R ~/docker/actualbudget
# run actual budget container
docker run -d name actualbudget -p 5006:5006 -v ~/docker/actualbudget/config.json:/app/config.json -v ~/docker/actualbudget/data:/data restart=unless-stopped actualbudget/actual-server
02. Open a web browser and navigate to http://DNSorIP:5006
03. Click on the Advanced Options link
04. Check the I understand the risks box ≫ Click Open Actual
05. Enter and confirm an admin password
06. Click Start Fresh
07. Welcome to Actual running in Docker
Source: https://actualbudget.org/docs/install/docker/
### Connect with me and others ###
★ Discord: https://discord.com/invite/EzenvmSHW8
★ Reddit: https://reddit.com/r/i12bretro
★ Twitter: https://twitter.com/i12bretro Run Actual Budget - Open Source Finance Management - in Docker](https://i.ytimg.com/vi/LOsnghXY3uU/mqdefault.jpg)



![Run FreshRSS - RSS Feed Aggregator - in Docker
#FreshRSS #RSS #Docker
Full steps can be found at https://i12bretro.github.io/tutorials/0237.html
What is FreshRSS?
FreshRSS is a self-hosted RSS feed aggregator. It is lightweight, easy to work with, powerful, and customizable. - https://github.com/FreshRSS/FreshRSS
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 FreshRSS
01. Now that Docker is installed, run the following commands to setup the FreshRSS Docker container and run it
# create working directories
mkdir ~/docker/mariadb -p && mkdir ~/docker/freshrss/{data,extensions} -p
# set owner of working directories
sudo chown $USER:$USER ~/docker -R
# create containers network
docker network create containers
# run the mariadb docker container
docker run -d name mariadb network containers network-alias db -e MYSQL_ROOT_PASSWORD=r00tp@ss -e MYSQL_USER=freshrss_rw -e MYSQL_PASSWORD=Fr3shRSS! -e MYSQL_DATABASE=freshrss -v /home/$USER/docker/mariadb:/var/lib/mysql restart=unless-stopped mariadb:latest
# run the freshrss docker container
docker run -d name freshrss network containers -p 8089:80 -e CRON_MIN=1,31 -e TZ=America/New_York -v ~/docker/freshrss/data:/var/www/FreshRSS/data -v ~/docker/freshrss/extensions:/var/www/FreshRSS/extensions restart=unless-stopped freshrss/freshrss
02. Open a web browser and navigate to http://DNSorIP:8089
03. Select a Language ≫ Click Submit
04. Click the Go to the next step button
05. Complete the database configuration form as follows
Type of database: MySQL
Host: mariadb
Database username: freshrss_rw
Database password: Fr3shRSS!
Database: freshrss
Table prefix:
06. Click the Go to the next step button
07. Enter a username and password ≫ Click Submit
08. Click the Complete Installation button
09. Login with the username and password created earlier
10. Welcome to FreshRSS
Documentation: https://hub.docker.com/r/freshrss/freshrss
### Connect with me and others ###
★ Discord: https://discord.com/invite/EzenvmSHW8
★ Reddit: https://reddit.com/r/i12bretro
★ Twitter: https://twitter.com/i12bretro Run FreshRSS - RSS Feed Aggregator - in Docker](https://i.ytimg.com/vi/MOF0SfFp3zs/mqdefault.jpg)
