Working example for my Open Source Data Solution Example. Hosted VM with digitalocean.com (if interested see my referral link for an offer benefitting both of us)

Check with other notes on Server Configuration - Virtual Host

Hostname: osdse.roman-halliday.com

################################################################
# As root : or sudo su
 
apt-get update && apt-get upgrade -y
# Kept new version (root login key only)
 
################################################################
# create a user for me
adduser david
# Add my user to sudo
usermod -a -G sudo david
 
#Setup keys
su david
# As david (paste key to new authorized_keys file)
mkdir -p ~/.ssh
vi ~/.ssh/authorized_keys
 
################################################################
# sshd config (stop root login, all authentication by keys only is now default)
vi /etc/ssh/sshd_config
systemctl restart ssh

See Firewall

# Allow SSH before we turn on
sudo ufw allow 22
# Enable Firewall
sudo ufw enable
# View status
ufw status

As user (if interaction with git repos is required):

• https://docs.github.com/en/authentication/connecting-to-github-with-ssh/generating-a-new-ssh-key-and-adding-it-to-the-ssh-agent
• https://docs.github.com/en/authentication/connecting-to-github-with-ssh/adding-a-new-ssh-key-to-your-github-account

ssh-keygen -t ed25519 -C "david@osdse.roman-halliday.com"
 
vi ~/.ssh/id_ed25519.pub

If you need multiple versions/more control, go for pyenv. But in most cases the latest stable will be fine (right how that's 3.12).

Ubuntu searching python versions

apt-cache search python3 | grep 'python3 '
apt-cache search python3 | grep -e 'python3\.[0-9][0-9]-full'

Just get the latest full package for this version of Ubuntu (more than we need, but it's not like it's expensive)

sudo apt-get install python3-full
 
# Test
python3 --version

Optional (make the word python still point to python3):

sudo apt-get install python-is-python3
 
# Test
python --version

see: PostgreSQL

apt-cache search postgres | grep '^postgresql-*[0-9]* '
sudo apt-get install postgresql

sudo vi /etc/postgresql/16/main/postgresql.conf

listen_addresses = '*'          # what IP address(es) to listen on;

sudo vi /etc/postgresql/16/main/pg_hba.conf

#host    all             all             127.0.0.1/32            scram-sha-256
host    all             all             0.0.0.0/0               scram-sha-256

/etc/init.d/postgresql restart

Firewall:

sudo ufw allow 5432

Configure simple shop: https://github.com/d-roman-halliday/simple_shop_data_generator/blob/main/database_setup/database_and_users_postgres.sql

See: mysql

See: Apache2 Configuration

sudo apt-cache search apache2 | grep php
sudo apt-cache search php | grep mysql
sudo apt-cache search php | grep pgsql

Apache, PHP and connectivity for MySQL & PostgreSQL:

sudo apt-get install apache2 libapache2-mod-php php-mysql php-pgsql

Python: wsgi

sudo apt-cache search apache2 | grep wsgi

Apache, Python:

sudo apt-get install apache2 libapache2-mod-wsgi-py3

sudo ufw app list
 
sudo ufw allow 'Apache Full'
 
sudo ufw status

Probably ignore this

<a href="https://www.digitalocean.com/?refcode=bb281f2fae53&utm_campaign=Referral_Invite&utm_medium=Referral_Program&utm_source=badge"><img src="https://web-platforms.sfo2.cdn.digitaloceanspaces.com/WWW/Badge%201.svg" alt="DigitalOcean Referral Badge" /></a>
[![DigitalOcean Referral Badge](https://web-platforms.sfo2.cdn.digitaloceanspaces.com/WWW/Badge%201.svg)](https://www.digitalocean.com/?refcode=bb281f2fae53&utm_campaign=Referral_Invite&utm_medium=Referral_Program&utm_source=badge)