SIPA Programming for Social Impact - Spring 2022 - Final Project Template Repository

Setup of Server and Database

SQL PHP Tutorial Video
Get EC2 VM running using the template
Use http://<Public IP Address>/phpmyadmin/ to access SQL database portal
- Username: root
- Password: root
- Use "test" database which is already created by default
- Run the following query customized to your requirements:
```
CREATE TABLE users(
    user_id varchar(255),
    first_name varchar(255),
    last_name varchar(255),
    password varchar(255),
    address varchar(255)
);
```
For filezilla you use:
- IP
- username: studentuser
- password: studentuser
- port 22

Tutorial Video
AWS guide
- Create Hosted Zone in AWS with its name as your domain name (from netfirms)
- Routing traffic to EC2
  - As shown in the above link, create A record with www.<domain name> as record name. (You only need to fill www in the form) with the Public IP of your EC2 instance as Value. All other entries can be default values.
  - Wait for the record to get updated, you can see the status after you add the record.
Netfirms guide
- Add the nameservers (NS records) from your AWS public hosted zone to netfirms nameservers and remove existing ones.
Test by accessing www.<domain name>. The www is critical.
If not working try deleting the old NS records in the DNS records part in netfirms as well.