==== VirtualBox running Ubuntu 18 Notes ====

__20 Jul 2020__

Updated VirtualBox to 6.1.12 and Ubuntu 18 would not login after MATE authentication screen (just got black screen).  Went into /opt/VBoxGuestAdditions-6.1.8 and uninstalled the Guest Additions.  Rebooted, logged in correctly.  Then installed latest version of GuestAdditions.  Rebooted again, logged in and all worked correctly.

If restarting makes the screen go black again, use CTRL-F in VirtualBox 2 times, and that restores it.

__Other Notes__

[[https://linuxize.com/post/how-to-install-teamviewer-on-ubuntu-18-04/|TeamViewer installation]]

[[https://linuxconfig.org/how-to-install-lamp-ubuntu-18-04-bionic-beaver-linux-apache-mysql-php|LAMP on Ubuntu 18.04]]

[[http://howtoubuntu.org/how-to-install-lamp-on-ubuntu|General LAMP install]]

[[https://help.ubuntu.com/stable/ubuntu-help/net-firewall-on-off.html|Firewall settings]]

[[https://askubuntu.com/questions/44418/how-to-enable-root-login|Enabling root]] (or use sudo -i)

Release info:  
<code>
lsb_release -a
</code>

View installed kernels:
<code>
# dpkg --list | grep linux-image
</code>

Remove old kernels:

  * https://code.launchpad.net/~jarnos/linux-purge/+git/linux-purge
    * # linux-purge -s
    * # linux-purge
    * # linux-purge -m
  * https://www.pontikis.net/blog/remove-old-kernels-debian-ubuntu (deprecated)

[[https://packages.ubuntu.com/search?keywords=openconnect|Searching for Ubuntu Packages and versions]]

View installed packages:
<code>
# apt list --installed
# dpkg --get-selections | grep -v deinstall |grep unifi
</code>

Remove installed package:
<code>
# dpkg -r package_name
</code>


----

Ubuntu 18.04 LTS
  * After initial login, change preferences in terminal and remove undesired favorites
  * [[https://websiteforstudents.com/how-to-install-ubuntu-16-04-17-10-18-04-guest-machines-on-virtualbox/|VirtualBox installation notes]]
  * Allow Virtualbox guest additions:
<code>
sudo apt update
sudo apt install build-essential gcc make perl
sudo apt install vim
sudo apt install gnome-software
sudo apt install openssh-server
reboot
</code>

  * [[https://linuxconfig.org/how-to-install-mate-desktop-on-ubuntu-18-04-bionic-beaver-linux|Install MATE Desktop link #1]]
  * [[https://www.hiroom2.com/2018/05/06/ubuntu-1804-mate-en/|Install MATE Desktop link #2]]
  * [[Install UniFi on Ubuntu|Install UniFi on Ubuntu]]

__12 Sep 2019__

[[https://hostadvice.com/how-to/configure-apache-with-tls-ssl-certificate-on-ubuntu-18/|Configure Apache HTTPS on Ubuntu 18]]

__26 Jan 2019__

Logging into Desktop GUI only gives a blank screen:
  * Final fix was to do CTRL-F to toggle VirtualBox between fullscreen mode
  * Tried updating VirtualBox Guest Additions to v5.2-5.2.24 but no change
  * Tried updating packages using commands below

Use these commands to update packages, as it allows interactive use to answer questions:
<code>
sudo apt update
sudo apt upgrade
sudo apt --with-new-pkgs upgrade
</code>

Very slow using Ubuntu GUI now:
  * Enable 3D acceleration in VirtualBox settings
  * Allocate 128MB video RAM
  * Restart and test
  * Also see these links:
    * [[https://thomas.vanhoutte.be/miniblog/guide-speed-up-ubuntu-virtualbox/|Speeding up Ubuntu]]
    * [[https://www.linuxbabe.com/virtualbox/speed-up-ubuntu-virtualbox]]

Check that 3D acceleration is supported:

  sudo apt install nux-tools
  /usr/lib/nux/unity_support_test -p


Installing mysql:

<code>
sudo apt install mysql-client-core-5.7   
sudo apt install mysql-server
sudo /usr/bin/mysql_secure_installation
</code>

Then login like this:
  sudo mysql -u root -p
  
Login with a non-root user like this:
  mysql -u username -p
  
See notes at [[https://www.digitalocean.com/community/tutorials/how-to-install-mysql-on-ubuntu-18-04]] for setting up a new user

Other SQL commands/testing:


  CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';
  GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost' IDENTIFIED BY 'password';
  CREATE DATABASE dbname;
  SET PASSWORD FOR 'username'@'localhost' = PASSWORD('password');
  
To allow logins to mysql via adminer:

https://serverfault.com/questions/1001274/adminer-denied-acces-for-user

  # su -
  # mysql -u root -p 
  > ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'YOUR_PASSWORD';
  # systemctl restart mysql
  # systemctl restart apache2.service
  
To upgrade MySQL v5.7 to 8.x follow [[https://www.javacodemonk.com/upgrade-mysql-from-5-7-to-8-on-ubuntu-18-04-bd9b5e46|this link]]

To fix this locale error upon login:

<code>
-bash: warning: setlocale: LC_ALL: cannot change locale (en_US)
</code>

run the following:
  
  sudo locale-gen en_US
  locale -a
  
and confirm you see en_US now.  See [[https://ubuntuforums.org/showthread.php?t=1675347&page=2]] for more info.