sudo apt update
sudo apt upgrade
sudo add-apt-repository ppa:ondrej/php 
sudo apt install php5.6
sudo apt install apache2 libapache2-mod-php5.6 -y 
sudo ufw allow 80/tcp 
sudo ufw allow 443/tcp 
sudo apt-get install mysql-server 
sudo mysql_secure_installation      
sudo mysql 
exit

apt-get install php5.6-gd php5.6-mysql php5.6-imap php5.6-curl php5.6-intl php5.6-pspell php5.6-recode php5.6-sqlite3 php5.6-tidy php5.6-xmlrpc php5.6-xsl php5.6-zip php5.6-mbstring php5.6-soap php5.6-opcache libicu65 php5.6-common php5.6-json php5.6-readline php5.6-xml
sudo apt-get install php5.6-gd
sudo apt install net-tools

sudo apt-get install software-properties-common
sudo add-apt-repository universe
sudo add-apt-repository ppa:certbot/certbot
sudo apt-get update
sudo apt install certbot python3-certbot-apache
sudo apt install ntpdate

sudo mkdir /var/www/vmserver10
sudo chown -R $USER:$USER /var/www/vmserver10
sudo chmod -R 755 /var/www/vmserver10

sudo nano /var/www/vmserver10/index.html
type in 
hello world,
Ctrl O to save
Ctrl X to Exit

sudo nano /var/www/vmserver10/server.php
type in
<?php
phpinfo();
?>
Ctrl O to save
Ctrl X to Exit

sudo nano /etc/apache2/sites-available/vmserver10.thevault.me.uk.conf
sudo a2ensite vmserver10.thevault.me.uk.conf
sudo a2dissite 000-default.conf
sudo systemctl restart apache2

open route port 80 to the vmserver10
open route port 443 to the vmserver10
sudo certbot --apache

test http://vmserver10.thevault.me.uk



sudo nano /etc/mysql/my.cnf

Add to end of file
[mysqld]
default-authentication-plugin=mysql_native_password
sql_mode=NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION



# Create users and databse in mysql
sudo mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 10
Server version: 8.0.34-0ubuntu0.22.04.1 (Ubuntu)

Copyright (c) 2000, 2023, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> create DATABASE viamed;
Query OK, 1 row affected (0.01 sec)

mysql> CREATE USER 'viamed'@'localhost' IDENTIFIED WITH 'mysql_native_password' BY 'ish5168ooxiz';
Query OK, 0 rows affected (0.01 sec)

mysql> GRANT ALL PRIVILEGES ON viamed.* TO 'viamed'@'localhost';
Query OK, 0 rows affected (0.00 sec)

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

mysql> 


[global]
sql_mode=NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBS>


# Setup the Symlinks


mkdir -p /home/network/intrastats/intranet/databases/iso_documents/micro_nails
touch /home/network/intrastats/intranet/databases/iso_documents/micro_nails/init

ln -s /home/network/intrastats/intranet/databases/iso_documents/files /var/www/vmserver10/intranet/databases/iso_documents/files
ln -s /home/network/intrastats/intranet/databases/iso_documents/micro_nails /var/www/vmserver10/intranet/databases/iso_documents/micro_nails
ln -s /home/network/intrastats_docs /home/network_extended/network/driveu/operadocs
ln -s /home/network/intrastats_docs /var/www/vmserver10/intranet/operadocs