sudo apt update
sudo apt upgrade
do defaults


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 php5.6-common php5.6-json php5.6-readline php5.6-xml
apt-get libicu5.6
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 mkdir /var/www/vmserver9
sudo chown -R $USER:$USER /var/www/vmserver9
sudo chmod -R 755 /var/www/vmserver9

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

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

sudo nano /etc/apache2/sites-available/vmserver9.thevault.me.uk.conf
----FROM

<VirtualHost *:80>
    ServerAdmin webmaster@localhost
    ServerName vmserver9.thevault.me.uk
    ServerAlias vmserver9.thevault.me.uk
    DocumentRoot /var/www/vmserver9
    ErrorLog ${APACHE_LOG_DIR}/error.log
    CustomLog ${APACHE_LOG_DIR}/access.log combined
</VirtualHost>

TO----
sudo a2ensite vmserver9.thevault.me.uk.conf
sudo a2dissite 000-default.conf
sudo systemctl restart apache2

open route port 80 to the vmserver9
open route port 443 to the vmserver9
sudo certbot --apache
sudo apt install chrony
test http://vmserver9.thevault.me.uk


#


# 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 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> 


#Smylinks
ln -s /home/network/intrastats/intranet/databases/iso_documents/files /var/www/vmserver9/intrastats/intranet/databases/iso_documents/files
ln -s /home/network/intrastats_docs /home/network_extended/network/driveu/operadocs
sudo ln -s /home/network/intrastats_docs /var/www/vmserver9/intrastats/intranet/operadocs
sudo ln -s /home/network/intrastats/intranet/databases/iso_documents/micro_nails /var/www/vmserver9/intrastats/intranet/databases/iso_documents/micro_nails