Ubuntu 20.04
This guide assumes that you already have SSH (console) access to a clean Ubuntu installation. If you do not already have a server, check out the recommended server specs.

Steps summary:

You will learn how to setup the LAMP stack and how to install UXWizz.

LAMP Setup

Run each of those commands to install, in order: Apache, PHP, MariaDB sudo apt install apache2
1
sudo apt install apache2
2
sudo apt install php libapache2-mod-php
3
sudo apt install mariadb-server
4
sudo apt-get install php-mysql
Copied!

Basic Security

Use those commands to enable firewall (ufw) and improve the default MySQL security.
Those steps are optional, but recommended. Follow the prompts whenever necessary.
1
sudo ufw allow ssh
2
sudo ufw allow http
3
sudo ufw allow https
4
sudo ufw enable
5
sudo mysql_secure_installation
Copied!

Installing UXWizz

Replace YOUR_ROOT_DATABASE_PASSWORD with the password chosen when you ran mysql_secure_installation.
1
cd /var/www/html
2
curl -Lo userTrack.zip https://www.usertrack.net/trial-download
3
apt install unzip
4
unzip userTrack.zip
5
rm userTrack.zip
6
mv userTrack/* userTrack/.* .
7
find . -type d -exec chmod 0777 {} +
8
find . -type f -exec chmod 0666 {} +
9
rm userTrack -r
10
ust_rootp=YOUR_ROOT_DATABASE_PASSWORD
11
ust_db=userTrack
12
ust_user=userTrack
13
ust_password="$(openssl rand -base64 12)"
14
mysql -u root -p"$ust_rootp" -e "CREATE DATABASE $ust_db /*\!40100 DEFAULT CHARACTER SET utf8 */;"
15
mysql -u root -p"$ust_rootp" -e "CREATE USER $ust_user@'%' IDENTIFIED BY \"$ust_password\";"
16
mysql -u root -p"$ust_rootp" -e "GRANT ALL PRIVILEGES ON $ust_db.* TO $ust_user@'%';FLUSH PRIVILEGES;"
17
sed -i "s*password = ''*password = '$ust_password'*" server/dbconfig.php
18
sed -i "s*username = 'root'*username = '$ust_user'*" server/dbconfig.php
19
sed -i "s*db_name = 'usertrack'*db_name = '$ust_db'*" server/dbconfig.php
20
sed -i "s*host = '127.0.0.1'*host = '$ust_host'*" server/dbconfig.php
21
apt-get install php-zip -y
22
a2enmod headers rewrite
23
systemctl restart apache2
Copied!

Adding your domain name

Install certbot

Certbot is used to generate a free Let's Encrypt certificate and manage its auto-renewal.
1
sudo apt update
2
sudo apt install snapd -y
3
sudo snap install snap-store
4
sudo snap install --classic certbot
Copied!
To set your own domain name for this dashboard, see this adding your domain name section.
Last modified 1mo ago