Wednesday, March 29, 2017

Week 11

Current Week Objectives: Database server and SSH

Current Week Accomplishments/Hours Worked:

Day 46 - 3/20/17 |

Started the week off by setting up SSH service for users to remotely log into server. Changed the default port number in sshd_config to 5901. Set the router to allow a port number to be port forwarded so the connection can be established via ssh.

Day 47 - 3/21/17 |

Made sure SSH is working correctly and users can connect to the server. Connected via SSH by using the External MAC address and port number. Tested SSH connection with user and it is up and running.

Day 48 - 3/22/17 |

Created a document to help students with PuTTy. The document guides the students step-by-step on how to SSH into the server. Updated java and all Linux machines.

Day 49 - 3/23/17 |



Day 50 - 3/24/17 | Worked with SQL databases



Week 11 total = 25 Hours

Next Week Objectives: MySQL server.

Key Lessons Learned/New Skills Acquired: ESXi, VMware, and Linux

Issues and Concerns: I did not have any issues.

Friday, March 17, 2017

Week 10

Current Week Objectives: Setting up a server for database class

Current Week Accomplishments/Hours Worked:

Day 41 - 3/13/17 |


Day 42 - 3/14/17 |


Day 43 - 3/15/17 |

Installed ESXi on each server and set up a virtual machine environment for one server.

Day 44 - 3/16/17 |

Installed MySQL and MongoDB on the server

Day 45- 3/17/17 |

Installed Ubuntu server on the virtual machine and updated Ubuntu. Installed Java and the necessary programs for Ubuntu. I installed Hadoop onto the virtual machine today and configured it to run datanodes and nodenames. I have installed three databases on the virtual machine so far. I added a group of students from a database class so they can ssh into the database server.

Week 10 total = 15 Hours

Next Week Objectives: Try test databases on the virtual machine.

Key Lessons Learned/New Skills Acquired: ESXi, VMware, and Linux

Issues and Concerns: I did not have any issues.

Week 9 - Spring Break

Wednesday, March 15, 2017

Week 8

Current Week Objectives: MySQL

Current Week Accomplishments/Hours Worked:

Day 36 - 2/27/17 |

I installed MySQL on Linux and started using it to create simple databases.

Day 37 - 2/28/17 |

Started creating a PowerPoint Presentation on MySQL.

Day 38 - 3/01/17 |

Ran simple MySQL commands and tested it with the database I created.

Day 39 - 3/02/17 |

Finished up PowerPoint on MySQL and put finishing touches on it.

Day 40 - 3/03/17 |

Showed supervisor my finished PowerPoint. Got new servers for VMware and set the servers in the black box. Checked to see if all five servers were fully functional.

Week 8 total = 22 Hours

Next Week Objectives: Setting up a database server on a virtual machine.

Key Lessons Learned/New Skills Acquired: MySQL and MySQL commands

Issues and Concerns: I did not have any issues with MySQL.