The following requirements need to be completed on all Virtual Machines

1. Restore the VM to a vanilla state. That is restore all VMs and do not select any additional packages or add-ons during the main installation screen. In Ubuntu please remember to add SSH so that you and I can connect to the server.

2. Add the professor account based on the code at the end of this file.
3. Install, start and enable MariaDB

User Accounts

Using the following CSV data. Complete the account creating on both MySQL and UNIX. The CSV has the following data in the following order.

uid,first,last,gender,dob,country,event,sport,medal,shell,permission

To retrieve your CSV please download it from the URL below. Make sure to replace USERNAME with the first part of your roary001@fiu.edu email.

http://users.cis.fiu.edu/~ggome002/files/[USERNAME].csv i.e http://users.cis.fiu.edu/~ggome002/files/roary001.csv

MySQL

1. Add all odd lines from the users file to Fedora // 1pt
2. Add all lines multiple of 7 to Ubuntu // 1pt Use the following syntax for step 1 and step 2 under MySQL MariaDB > create user roary001@localhost;

3. Add all female users to CentOS with the syntax below. Make sure to add the country as the users password. // 1pt MariaDB > create user roary001@localhost identified by 'PASSWORD';

4. Add all male users to CentOS with the syntax below. Make sure to add the country as the users password. // 1pt MariaDB > grant PERMISSION on *.* to roary001@localhost;

UNIX

1. Add all the users to Fedora. // 1.pt $ useradd roary001
2. Add All the country as groups in Ubuntu. // 1pt $ groupadd united_states
3. From the csv, use lines 1 - 300 and add the users with their name as a comment. CentOS // 1pt $ useradd roary001 -c 'Roary Panther'
4. From the csv, use lines 301 - 600 and add the users with their name as a comment and their shell.CentOS // 1pt $ useradd roary001 -c 'Roary Panther' -s /bin/bash
5. From the csv, use lines 601 - 1000 and add the users with their name as a comment, their shell and their primary group must be their country CentOS // 1pt HINT: To complete this step, you must use a mixture of step 2 and step 5. You will need to research how to add a user to a primary group.

Professor account

# create professor's account

$ useradd -m -d /home/ggome002 -s /bin/bash ggome002

# create the ~/.ssh folder under the users directory

$ mkdir /home/ggome002/.ssh

# add the professor's public rsa key into the authorized_keys file

$ cat < /home/ggome002/.ssh/authorized_keys

ssh-rsa AAAAB3NzaC1yc2EAAAABIwAAAQEAta6av2gO7mccXIg4ccGr3zh8A6JOkF7YDODGGKiYEMn0r5zD2mhLSpC0OLKe4A78UlIa+HLmH3Y0DlF4RkFsxU3NeowpLwVr8t8H6gAnsMdxOKf4FiJqyflROR33OS65y2dC5wGwQhQRfBtmr8LQ8E1+utdgtFEU1IBXZh6VZOTib76QR4zFFaHVMs34zm1tdo19Wo5OD/ibiOVZoh20BwuqFE2BMBEKKelPzd7ZTzLbJPtifbYUKXNw1VtTgChis/foyjAh4Gd3UgcSMQ6lfjBHsHIgDj7Fz4FLvl7YZE2HKzq7aaook2hU9zhDmS3oNvLUGc3l9oDqetIwXggc+Q== ggome002@localhost

EOF

# change permission and ownership for both the .ssh folder and authorized_keys file

$ chmod 700 /home/ggome002/.ssh

$ chmod 600 /home/ggome002/.ssh/authorized_keys

$ chown -R ggome002:ggome002 /home/ggome002/.ssh/

# modify sudoers file

$ echo -e "ggome002\tALL=(ALL) NOPASSWD: ALL" >> /etc/sudoers