Roll Your Own Google Analytics Alternative with Umami on Windows
5#Umami #Analytics #Windows
Full steps can be found at https://i12bretro.github.io/tutorials...
--------------------------------------------------------------------
What is Umami?
--------------------------------------------------------------------
Umami is a simple, fast, privacy-focused alternative to Google Analytics. - https://github.com/umami-software/umami
--------------------------------------------------------------------
Installation
--------------------------------------------------------------------
01. Log into the Windows device
02. Download the latest Umami release https://github.com/umami-software/uma...
03. Download NodeJS https://nodejs.org/en/download/prebui...
04. Download the latest MySQL .msi installer https://dev.mysql.com/downloads/mysql/
05. Download Microsoft Visual C++ https://aka.ms/vs/16/release/vc_redis...
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: https://github.com/umami-software/umami
Connect with me and others ###
★ Discord: / discord
★ Reddit: / i12bretro
★ Twitter: / i12bretro