This is an old revision of the document!
Open Source Data Solution Example (OSDSE)
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
Host Setup
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
Firewall
See Firewall
# Allow SSH before we turn on sudo ufw allow 22 # Enable Firewall sudo ufw enable # View status ufw status
GitHub
As user (if interaction with git repos is required):
ssh-keygen -t ed25519 -C "david@osdse.roman-halliday.com" vi ~/.ssh/id_ed25519.pub
Python
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
PostgreSQL
see: PostgreSQL
apt-cache search postgres | grep '^postgresql-*[0-9]* ' sudo apt-get install postgresql
Config
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
MySQL
See: mysql
Apache
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
# certbot : Generates certificates # python3-certbot-apache : Automates the apache part sudo apt-get install certbot python3-certbot-apache sudo certbot --apache
Website & Data Viewer
cd /var/www/html sudo vi index.html
<!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1"> <title>Home: osdse.roman-halliday.com</title> <link rel="stylesheet" href="styles.css"> </head> <body> <h1>Home : osdse.roman-halliday.com</h1> <p>See the sample data:</p> <ul> <li>Explore: <a href="sample_data_explore/">explore</a></li> <li>Docs: https://github.com/d-roman-halliday/simple_shop_data_generator</li> </ul> </body> </html>
Adminer User on DB:
CREATE USER simple_shop_adminer_reader WITH ENCRYPTED PASSWORD 'simple_shop_adminer_reader_password';
Junk
Probably ignore this
Link
<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> [](https://www.digitalocean.com/?refcode=bb281f2fae53&utm_campaign=Referral_Invite&utm_medium=Referral_Program&utm_source=badge)
