search

Progressive-Learning-Platform / PLPTool6

Prototype for PLPTool frontend interface overhaul
2 stars 4 forks source link

Installing Database #127

Open sschava1 opened 6 years ago

sschava1 commented 6 years ago

Feb 1: Doing/Done:

  1. I do the research on MySQL deployment on server from https://dev.mysql.com/doc/mysql-getting-started/en/
  2. Discussed about the error log database scheme with Mukul. Problem/Solution:
  3. Error logging for users still ambiguous to understand
  4. Need to discuss more with Prashanth ToDo: What are you going to do for tomorrow.
  5. Try to make progress on installing database on server
sschava1 commented 6 years ago

Feb 2: Doing/Done:

  1. Tried to install MySQL on server and set it up but came up with an error. Still trying to get through
  2. Discussed with Tushar to finalize the schema (fields) for user information table.
  3. Referred stackoverflow and other web sites to debug the installation error. https://stackoverflow.com/questions/48012246/unable-to-install-mysql-on-ubuntu-16-04 To Do:
  4. Complete the installation 100% and work on tables
sschava1 commented 6 years ago

Feb 10: Doing/Done:

  1. Database has finally been installed.
  2. Was getting errors because the system had some packages missing
  3. The server has version 6 OS and I was earlier trying to install Red Hat Enterprise Linux 7 / Oracle Linux 7 (Architecture Independent), RPM Package. Later, found the compatible one. IMPORTANT: Server has linux on Centos OS (powered by RedHat). The commands for normal Linux machines do not work. Be specific about OS and version while searching for references online
  4. Referring https://support.rackspace.com/how-to/installing-mysql-server-on-centos/ set the privileges of the root user and remote access to the database To Do: Create a database
sschava1 commented 6 years ago

Feb 17: Doing/Done:

Tables for logs and user information have been created. Discussed with Mukul for deciding the final design of the logs table Discussed with Tushar and used online resources tor decide the final design of the user info tables Referred this amazing blog https://www.getdonedone.com/building-the-optimal-user-database-model-for-your-application/ for the same Basically created 3 tables- logs, user_information and user_credentials To Do: write triggers/stored procedures to insert into user_credentials table when user information is inserted into user_information table

sschava1 commented 6 years ago

Done: The guide with commands for installing the database and initializing it is ready. This guide will be updated in case the schema of our database changes. I have updated the schema for the user_information table by making the gender column integer type and creating another table for genders which will have multiple options that can be added. Also uploading the database schema document which will be updated in case the schema is changed in future. To Do: Stored procedure for inserting new user and verifying existing users. Database Schema.pdf Installation Guidelines.pdf