Uploaded October 2023 | Updated September 2026, 2 weeks ago
#FreshRSS #RSS #Windows
*** Updated 12/03/2024
Full steps can be found at i12bretro.github.io/tutorials/0234.html
--------------------------------------------------------------------
What is FreshRSS?
--------------------------------------------------------------------
FreshRSS is a self-hosted RSS feed aggregator. It is lightweight, easy to work with, powerful, and customizable. - github.com/FreshRSS/FreshRSS
--------------------------------------------------------------------
Installation
--------------------------------------------------------------------
01. Download XAMPP sourceforge.net/projects/xampp/files/XAMPP%20Windows
02. Download FreshRSS github.com/FreshRSS/FreshRSS/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 FreshRSS.zip file ≫ Extract All...
07. Rename the extracted folder freshrss
08. Cut the freshrss folder inside the XAMPP/htdocs directory
09. Copy the extracted XAMPP directory to a safe location to run from, C:\Program Files for example
10. Run XAMPP/setup_xampp.bat to update the configuration files with the new server location
11. Run XAMPP/xampp-control.exe
12. Click the Start button next to Apache and MySQL
13. Navigate to XAMPP/mysql/bin
14. Hold the SHIFT key and right click in the white space ≫ Open PowerShell windows here...
15. Type the following in the PowerShell window to setup the database
.\mysql -u root
CREATE DATABASE freshrss DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE USER 'freshrss_rw'@'localhost' IDENTIFIED BY 'Fr3s4R$S!!';
GRANT ALL ON freshrss.* TO 'freshrss_rw'@'localhost';
FLUSH PRIVILEGES;
exit;
16. Open a web browser and navigate to http://DNSorIP:8089
17. Select a Language ≫ Click Submit
18. Click the Go to the next step button
19. Complete the database configuration form as follows
Type of database: MySQL
Host: localhost
Database username: freshrss_rw
Database password: Fr3s4R$S!!
Database: freshrss
Table prefix:
20. Click the Go to the next step button
21. Enter a username and password ≫ Click Submit
22. Click the Complete Installation button
23. Login with the username and password created earlier
24. Welcome to FreshRSS
### Connect with me and others ###
★ Discord: discord.com/invite/EzenvmSHW8
★ Reddit: reddit.com/r/i12bretro
★ Twitter: twitter.com/i12bretro
#FreshRSS #RSS #Windows
*** Updated 12/03/2024
Full steps can be found at i12bretro.github.io/tutorials/0234.html
--------------------------------------------------------------------
What is FreshRSS?
--------------------------------------------------------------------
FreshRSS is a self-hosted RSS feed aggregator. It is lightweight, easy to work with, powerful, and customizable. - github.com/FreshRSS/FreshRSS
--------------------------------------------------------------------
Installation
--------------------------------------------------------------------
01. Download XAMPP sourceforge.net/projects/xampp/files/XAMPP%20Windows
02. Download FreshRSS github.com/FreshRSS/FreshRSS/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 FreshRSS.zip file ≫ Extract All...
07. Rename the extracted folder freshrss
08. Cut the freshrss folder inside the XAMPP/htdocs directory
09. Copy the extracted XAMPP directory to a safe location to run from, C:\Program Files for example
10. Run XAMPP/setup_xampp.bat to update the configuration files with the new server location
11. Run XAMPP/xampp-control.exe
12. Click the Start button next to Apache and MySQL
13. Navigate to XAMPP/mysql/bin
14. Hold the SHIFT key and right click in the white space ≫ Open PowerShell windows here...
15. Type the following in the PowerShell window to setup the database
.\mysql -u root
CREATE DATABASE freshrss DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE USER 'freshrss_rw'@'localhost' IDENTIFIED BY 'Fr3s4R$S!!';
GRANT ALL ON freshrss.* TO 'freshrss_rw'@'localhost';
FLUSH PRIVILEGES;
exit;
16. Open a web browser and navigate to http://DNSorIP:8089
17. Select a Language ≫ Click Submit
18. Click the Go to the next step button
19. Complete the database configuration form as follows
Type of database: MySQL
Host: localhost
Database username: freshrss_rw
Database password: Fr3s4R$S!!
Database: freshrss
Table prefix:
20. Click the Go to the next step button
21. Enter a username and password ≫ Click Submit
22. Click the Complete Installation button
23. Login with the username and password created earlier
24. Welcome to FreshRSS
### Connect with me and others ###
★ Discord: discord.com/invite/EzenvmSHW8
★ Reddit: reddit.com/r/i12bretro
★ Twitter: twitter.com/i12bretro



![Install Zammad on Linux [Opensource Helpdesk Ticketing System]
#Zammad #Helpdesk #Linux
Full steps can be found at https://i12bretro.github.io/tutorials/0907.html
What is Zammad?
Zammad is a web based open source helpdesk/customer support system with many features to manage customer communication via several channels like telephone, facebook, twitter, chat and emails. - https://github.com/zammad/zammad
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 prerequisite packages
sudo apt install curl wget apt-transport-https gnupg -y
# add elasticsearch gpg key
wget -qO - https://artifacts.elastic.co/GPG-KEY-elasticsearch | sudo gpg dearmor -o /usr/share/keyrings/elasticsearch-keyring.gpg
# add zammad gpg key
curl -fsSL https://dl.packager.io/srv/zammad/zammad/key | gpg dearmor | sudo tee /etc/apt/keyrings/zammad.gpg≫ /dev/null
# add elasticsearch apt repository
echo deb [signed-by=/usr/share/keyrings/elasticsearch-keyring.gpg] https://artifacts.elastic.co/packages/8.x/apt stable main | sudo tee /etc/apt/sources.list.d/elastic-8.x.list
# add zammad apt repository
echo deb [signed-by=/etc/apt/keyrings/zammad.gpg] https://dl.packager.io/srv/deb/zammad/zammad/stable/debian 12 main| sudo tee /etc/apt/sources.list.d/zammad.list
# update software repositories
sudo apt update
# list installed languages
locale | grep LANG=
# if not listed in the above output
# install en_US.UTF-8 and set as default locale
sudo apt install locales -y && sudo locale-gen en_US.UTF-8 && echo LANG=en_US.UTF-8 ≫ sudo /etc/default/locale
# install supporting packages
sudo apt install libimlib2 elasticsearch postgresql postgresql-common redis-server nginx nodejs -y
# start and enable services
sudo systemctl enable postgresql now && sudo systemctl enable redis-server now && sudo systemctl enable nginx now && sudo systemctl enable elasticsearch now
# update postgres max connections to 2000
sudo sed -i s/max_connections = 100/max_connections = 2000/ /etc/postgresql/*/main/postgresql.conf
# restart postgres service
sudo systemctl restart postgresql
# install ingest-attachment for elasticsearch
sudo /usr/share/elasticsearch/bin/elasticsearch-plugin install ingest-attachment
# restart elasticsearch service
sudo systemctl restart elasticsearch
# install zammad
sudo apt install zammad -y
# configure elasticsearch url
sudo zammad run rails r Setting.set(es_url, http://localhost:9200)
# rebuild elasticsearch search index
sudo zammad run rake zammad:searchindex:rebuild
# update server name in nginx config
# replace ≪% SERVER DNS NAME %≫ before executing
sudo sed -i s/server_name localhost;/server_name ≪% SERVER DNS NAME %≫;/ /etc/nginx/sites-available/zammad.conf
# restart nginx service
sudo systemctl restart nginx
03. Open a web browser and navigate to http://DNSorIP
04. Click the Set up a new system button
05. Enter a login, first name, last name, email address, password and check full permissions ≫ Click Create
06. Complete the Organization details form ≫ Click Next
07. Click Skip on the Email Notification screen
08. Click Skip on the Connect Channels screen
09. Welcome to Zammad
Source: https://docs.zammad.org/en/latest/install/package.html
### Connect with me and others ###
★ Discord: https://discord.com/invite/EzenvmSHW8
★ Reddit: https://reddit.com/r/i12bretro
★ Twitter: https://twitter.com/i12bretro Install Zammad on Linux [Opensource Helpdesk Ticketing System]](https://i.ytimg.com/vi/wVpvKu0T4Co/mqdefault.jpg)
![Run Mealie - Recipe Tracker and Meal Planner - in Docker
#Mealie #Docker #MeanPlanner
Full steps can be found at https://i12bretro.github.io/tutorials/0398.html
What is Mealie?
Mealie is a self hosted recipe manager and meal planner with a RestAPI backend and a reactive frontend application built in Vue for a pleasant user experience for the whole family. Easily add recipes into your database by providing the url and mealie will automatically import the relevant data or add a family recipe with the UI editor. - https://github.com/hay-kot/mealie/
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 Mealie
01. Continue following commands in a terminal window
# create working directories
mkdir ~/docker/mealie -p
# set owner of docker directory
sudo chown $USER:$USER ~/docker -R
# run mealie container
docker run -d name=mealie -v ~/docker/mealie:/app/data/ -p 9925:80 restart=unless-stopped hkotel/mealie
02. Open a web browser and navigate to http://DNSorIP:9925
03. Login with the username changeme@email.com and password MyPassword
04. Click the admin username in the left navigation menu
05. Update the Username, Full Name and Email as needed ≫ Click Update
06. Click the Change Password button
07. Enter the Current Password (MyPassword), enter and confirm a new password ≫ Click Change Password
08. Log out and log back in using the updated username and password
09. Welcome to Mealie
Documentation: https://hay-kot.github.io/mealie/documentation/getting-started/install/
### Connect with me and others ###
★ Discord: https://discord.com/invite/EzenvmSHW8
★ Reddit: https://reddit.com/r/i12bretro
★ Twitter: https://twitter.com/i12bretro Run Mealie - Recipe Tracker and Meal Planner - in Docker](https://i.ytimg.com/vi/wf7peKkCa88/mqdefault.jpg)
![Install Organizr - A Homelab Services Organizer/Dashboard - on Linux
#Organizr #Dashboard #Linux
Full steps can be found at https://i12bretro.github.io/tutorials/0795.html
What is Organizr?
ORGANIZR aims to be your one stop shop for your Servers Frontend. Do you have quite a bit of services running on your computer or server? Do you have a lot of bookmarks or have to memorize a bunch of ip’s and ports? Well, Organizr is here to help with that... - https://organizr.app/
Installation
01. Log into the Linux device
02. Run the following commands in a terminal window:
# update software repositories
sudo apt update
# install available software updates
sudo apt upgrade -y
# install prerequisites
sudo apt install curl wget zip git openssl -y
# install Apache HTTPD and SQLite
sudo apt install apache2 sqlite3 -y
# install PHP components
sudo apt install php7.4 libapache2-mod-php php7.4-common php7.4-mysql php7.4-sqlite3 php7.4-xml php7.4-zip php7.4-curl php7.4-fpm -y
# download the latest organizr release
wget -O ./organizr.zip https://github.com/causefx/Organizr/archive/v2-master.zip
# extract the downloaded zip to /var/www/html
sudo unzip ./organizr.zip -d /var/www/html
# rename the extracted folder organizr
sudo mv /var/www/html/Organizr* /var/www/html/organizr
# set the owner of the organizr directory
sudo chown -R www-data:www-data /var/www/html/organizr
# create organizr apache configuration
sudo nano /etc/apache2/sites-available/organizr.conf
03. Paste the following configuration into organizr.conf
≪Directory /var/www/html/organizr≫
Options Indexes FollowSymLinks
AllowOverride All
Require all granted
RewriteEngine On
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^ /organizr/api/v2/index.php [QSA,L]
≪/Directory≫
04. Press CTRL+O, Enter, CTRL+X to write the changes
05. Run the following command to enable the Organizr site
# enable rewrite module
sudo a2enmod rewrite
# enable the organizr site
sudo a2ensite organizr
# restart the apache2 service
sudo systemctl restart apache2
# generate a random string
head /dev/urandom | LC_ALL=C tr -dc A-Za-z0-9 | head -c 30
Organizr Web Installer
01. Open a web browser and navigate to http://DNSorIP/organizr
02. Set the Installation Type to Personal ≫ Click Next
03. Complete the registration form by entering a username, email address and password ≫ Click Next
04. Copy the randomly generated string from the open terminal and paste it in the Hash Key field
05. Enter a Registration Password ≫ Click Next
06. Enter organizr.db as the Database Name and /var/www/html/organizr/data/ as the Database Path ≫ Click Test / Create Path ≫ Click Next
07. Review the summary ≫ Click Finish
08. Welcome to Organizr
Source: https://docs.organizr.app/installation/prerequisites/installing-php
### Connect with me and others ###
★ Discord: https://discord.com/invite/EzenvmSHW8
★ Reddit: https://reddit.com/r/i12bretro
★ Twitter: https://twitter.com/i12bretro Install Organizr - A Homelab Services Organizer/Dashboard - on Linux](https://i.ytimg.com/vi/wfy3BsZAhmY/mqdefault.jpg)

![Host Your Own GitHub Alternative with Gitea
#Gitea #Git #Linux
Full steps can be found at https://i12bretro.github.io/tutorials/0521.html
What is Gitea
Gitea is a community managed lightweight code hosting solution written in Go. - https://gitea.io/
Installing Gitea
01. Log into the Linux device
02. Run the following commands in a terminal:
# update software repositories
sudo apt update
# install software updates
sudo apt upgrade -y
# install preprequisites
sudo apt install git mariadb-server -y
# create gitea user
sudo adduser system shell /bin/bash gecos Git Version Control group disabled-password home /home/gitea gitea
# 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 Gitea database and database user
CREATE DATABASE gitea CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE USER gitea_rw@localhost IDENTIFIED BY G1te@!;
GRANT ALL PRIVILEGES ON gitea.* TO gitea_rw@localhost;
FLUSH PRIVILEGES;
EXIT;
exit
12. Continue with the following commands:
# download the Gitea binary
wget -O ./gitea https://github.com/go-gitea/gitea/releases/download/v1.14.2/gitea-1.14.2-linux-amd64
# make gitea executable
sudo chmod +x gitea
# move gitea to /usr/local/bin
sudo mv ./gitea /usr/local/bin/
# verify gitea can be found
gitea version
# create required directory structures
sudo mkdir -p /etc/gitea /var/lib/gitea/{custom,data,indexers,public,log}
sudo chown gitea:gitea /var/lib/gitea/{data,indexers,log}
sudo chmod 750 /var/lib/gitea/{data,indexers,log}
sudo chown root:gitea /etc/gitea
sudo chmod 770 /etc/gitea
# create gitea service
sudo nano /etc/systemd/system/gitea.service
13. Paste the following into gitea.service
[Unit]
Description=Gitea
After=syslog.target
After=network.target
After=mysql.service
[Service]
LimitMEMLOCK=infinity
LimitNOFILE=65535
RestartSec=2s
Type=simple
User=gitea
Group=gitea
WorkingDirectory=/var/lib/gitea/
ExecStart=/usr/local/bin/gitea web -c /etc/gitea/app.ini
Restart=always
Environment=USER=git HOME=/home/gitea GITEA_WORK_DIR=/var/lib/gitea
[Install]
WantedBy=multi-user.target
14. Press CTRL+O, Enter, CTRL+X to write the changes to gitea.service
15. Continue with the following commands:
# reload services
sudo systemctl daemon-reload
# enable gitea to run on boot and start now
sudo systemctl enable now gitea
16. Open a web browser and navigate to http://DNSorIP:3000
17. Complete the database settings on the Initial Configuration screen ≫ Click the Install Gitea button
18. Click the Register Now link
19. Enter a username, email and password ≫ Click the Register Account button
20. Welcome to Gitea
Source: https://about.gitlab.com/
### Connect with me and others ###
★ Discord: https://discord.com/invite/EzenvmSHW8
★ Reddit: https://reddit.com/r/i12bretro
★ Twitter: https://twitter.com/i12bretro Host Your Own GitHub Alternative with Gitea](https://i.ytimg.com/vi/xzfGv6NWXgw/mqdefault.jpg)


![Running Organizr - A Homelab Services Organizer/Dashboard - in Docker
#Organizr #Dashboard #Docker
Full steps can be found at https://i12bretro.github.io/tutorials/0794.html
What is Organizr?
ORGANIZR aims to be your one stop shop for your Servers Frontend. Do you have quite a bit of services running on your computer or server? Do you have a lot of bookmarks or have to memorize a bunch of ip’s and ports? Well, Organizr is here to help with that... - https://organizr.app/
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 Organizr Container
01. Now that Docker is installed, run the following commands to setup the Organizr Docker container and run it
# create working directory
mkdir ~/docker/organizr -p
# set ownership on the working directories
sudo chown $USER:$USER ~/docker -R
# list current uid and gid, note these for later
id $user
# run the organizr container
docker run -d name=organizr -p 8880:80 -v ~/docker/organizr:/config -e PGID=1000 -e PUID=1000 restart unless-stopped organizr/organizr
02. Open a web browser and navigate to http://DNSorIP:8880
03. Select Personal from the Install Type dropdown ≫ Click Next
04. Enter an Admin Username, Email and Password ≫ Click Next
05. Open a new browser tab and navigate to https://www.random.org/passwords/?num=1&len=24&format=plain&rnd=new
06. Copy the generated random string ≫ Paste the string in the Hash Key field
07. Go back to the random.org tab and refresh the page to generate a new string
08. Copy the generated random string ≫ Paste the string in the Registration Password
09. Click Next
10. On the Database settings page enter the Database Name organizr and set the Database Location to /config/www/organizr/data/ ≫ Click the Test/Create Path button ≫ Click Next
11. Review the Summary ≫ Click Finish
12. Welcome to Organizr
Documentation: https://hub.docker.com/r/organizr/organizr
Source: https://docs.organizr.app/installation/installing-organizr
### Connect with me and others ###
★ Discord: https://discord.com/invite/EzenvmSHW8
★ Reddit: https://reddit.com/r/i12bretro
★ Twitter: https://twitter.com/i12bretro Running Organizr - A Homelab Services Organizer/Dashboard - in Docker](https://i.ytimg.com/vi/zFdAQoph1aQ/mqdefault.jpg)