Setting Up Webserver on Ubuntu Server

Hyper-V VLANS:

https://www.nakivo.com/blog/guide-setting-hyper-v-vlans/

Setting up Ubuntu Server: (With dedicated NIC srvio on VLAN)

How To Install Linux, Apache, MySQL, PHP (LAMP) stack on Ubuntu 20.04

https://www.digitalocean.com/community/tutorials/how-to-install-linux-apache-mysql-php-lamp-stack-on-ubuntu-20-04

Determining which window manager is running:

https://askubuntu.com/questions/72549/how-to-determine-which-window-manager-and-desktop-environment-is-running

Setting up XRDP:

https://www.ubuntupit.com/how-to-install-and-use-xrdp-server-remote-desktop-on-linux-system/#:~:text=Configure%20the%20Xrdp%20Server%201%201.%20Check%20the,7.%20Connect%20the%20Xrdp%20from%20Windows%20Machine%20

Note: Connection using Windows RDP will fail if user remains logged into local instance

Apache2:

Installing:

https://www.digitalocean.com/community/tutorials/how-to-install-the-apache-web-server-on-ubuntu-20-04

Checking if service active:

https://askubuntu.com/questions/1082746/apache2-service-is-not-active-how-can-make-it-active#:~:text=You%20can%20check%20if%20apache2%20service%20is%20already,it%20is%20not%20already%20enabled%20you%20can%20do

Stop and Start Apache2 service:

https://www.cyberciti.biz/faq/star-stop-restart-apache2-webserver/

Configuring subdomain in Apache2:

https://codeburst.io/configuring-a-subdomain-in-apache2-f7a8b316b42c

Supressing Fully Qualified Domain name error:

https://www.digitalocean.com/community/tutorials/apache-configuration-error-ah00558-could-not-reliably-determine-the-server-s-fully-qualified-domain-name

GUI for Apa:

https://www.techrepublic.com/article/how-to-install-apachegui-on-ubuntu-server-18-04/

Switching Default PHP version:

https://tecadmin.net/how-to-install-php-on-ubuntu-22-04/

https://tecadmin.net/install-php5-on-ubuntu/

https://linuxhint.com/install-php5-ubuntu/#:~:text=Install%20PHP5%20Ubuntu%201%20Adding%20PHP5%20PPA%3A%20The,DocumentRoot%2FWebRoot%20of%20Apache2%3A%20So%20far%20so%20good.%20

https://www.skillsugar.com/how-to-change-php-version#:~:text=Setting%20PHP%20Version%20For%20a%20Single%20Site%20in,the%20version%20you%20wish%20to%20use%3A%20AddHandler%20application%2Fx-httpd-php72.php

Configuring Ubuntu Firewall:

https://www.configserverfirewall.com/ufw-ubuntu-firewall/ubuntu-check-firewall-status-ufw/

https://ubuntu.com/server/docs/security-firewall

Note: sudo ufw allow from (Remote public IP) to any port 3389

block all other external users

Mysql Workbench:

Installing:

https://askubuntu.com/questions/1127179/e-unable-to-locate-package-mysql-workbench-community

AppArmor password issue fix:

https://blockdev.io/mysql-workbench-ubuntu-20-04-and-app-armor/#:~:text=An%20AppArmor%20policy%20prevents%20this%20sender%20from%20sending,allowing%20the%20two%20to%20talk%20to%20each%20other.

Logging in and errors:

https://exerror.com/failed-error-set-password-has-no-significance-for-user-rootlocalhost-as-the-authentication-method-used-doesnt-store-authentication-data-in-the-mysql-server/#:~:text=You%20just%20need%20to%20Update,this%20command%20in%20your%20terminal.&text=Then%20Update%20the%20user%20With%20the%20mysql_native_password%20method.

Error 1045 (28000) access denied:

https://www.stechies.com/error-1045-28000-access-denied-user-root-localhost/

Error 1396(HY000):

https://stackoverflow.com/questions/56946299/how-to-resolve-error-1396-hy000-operation-alter-user-failed-for-rootlocal

Note: Workbench schema (or DB list) is in left pane and have to click arrow to switch visible lefthand pane

Mysql Creating database and user:

https://docs.bitnami.com/aws/infrastructure/mysql/configuration/create-database-mysql/

Setting up VSFTPD site:

https://www.ismoothblog.com/2020/12/how-to-install-ftp-server-on-ubuntu-with-vsftpd.html

FTP errors:

https://superuser.com/questions/153888/ftp-error-425-failed-to-establish-connection

https://bobcares.com/blog/server-sent-passive-reply-with-unroutable-address/

https://unix.stackexchange.com/questions/270539/vsftpd-filezilla-gnutls-error-15-unexpected-tls-packet-was-received

DNS records reference:

https://blog.dnsimple.com/2015/04/common-dns-records/

User Management:

https://ubuntu.com/server/docs/security-users