Advanced-Database-Systems

Getting Started

Download and install VirtualBox 5.1.x
Download and install Vagrant
Download and install Git for Windows (Windows only)
Open Terminal or Git Bash
Clone this repository to a folder of your choice git clone https://github.com/Tello-Wharton/Advanced-Database-Systems.git
Run chmod -R 755 Advanced-Database-Systems on the folder (Linux and Mac only)
Enter the Advanced-Database-Systems folder
Run vagrant up
Run vagrant ssh to ssh into the virtual machine's shell
Use sudo -s to switch to the root user, the machine, the machine is designed to be used by root
Use psql -U root -d adb to access the database

If there is something wrong with your setup, you can remove everything by using vagrant destroy
If you just want to shutdown your virtual machine, you can use vagrant halt

This virtual machine is set up to be used by the root user, trying to use other users may not work out for you
To get data onto the virtual machine, simply place it in the Advanced-Database-Systems directory on your host machine, this is accessible from your virtual machine in the /vagrant folder
If you are using a lab computer, I suggest backing up your data before leaving the lab. For now I would do this by backing up to the /vagrant folder, and copying that to a memory stick. I will look for a more elegant solution in the future.
If your vagrant up does not work on the first try, that is likely due to a network error on the lab computer's part, and you should perform vagrant destroy and try again.