Your Source for Movie/TV series ratings and reviews
Switch branches/tags
Nothing to show
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
Screenshots
client
server
.gitignore
README.txt
entertainmentdb.sql
package.json

README.txt

Entertainment-DB is part of a project submission for CS5200 Introduction to Database Management.

Running the project:

1. NodeJS v4.5.x
2. MySQL
3. MySQL connector for NodeJS

PRE-REQUISITES:

1. NodeJS is to be installed.
2. MySQL is to be present in the system.

STEP 0: Import the "entertainmentdb.sql" to a database in MySQL.
STEP 1: Clone the repo and go to "server > database > dbconnection.js" to edit your credentials and the DB name
STEP 2: Go to "client > JS > main.js" Edit 'URL' to your server's IP address or URL
STEP 3: Go to your root folder where "package.json" exists and run command "npm install"
STEP 4: run command "npm install mysql"

To run use : node server/app.js or "npm start"

Login Credentials:

Administrator:
    Username: admin , password: admin

Moderator:
    Username: mod , password: mod

User:
    Username: user, password: user

If it says port is already taken , Follow the below steps:

1. Find the process that is blocking the port by : netstat -nlp | grep :3000
2. Copy the Process ID from */node that we got from above command.
     EX : 10196/node or 2442/node
3. Kill the process by : kill -9 pid
     EX: kill -9 10196 or kill -9 2442
4. Rerun the app.


Steps For a newly installed Ubuntu system:

1. sudo apt-get update
2. sudo apt-get install apache2
3. sudo nano /etc/apache2/apache2.conf
4. Add "ServerName <your ip>"
5. sudo apache2ctl configtest
6. sudo apt-get update
7. sudo apt-get install mysql-server
8. sudo apt-get install php libapache2-mod-php php-mcrypt php-mysql
9. sudo nano /etc/apache2/mods-enabled/dir.conf
10. put .php to first
11. sudo systemctl restart apache2
12. sudo systemctl status apache2
13 PhpMyadmin : sudo apt-get install phpmyadmin apache2-utils

Installing nodejs :

sudo apt-get install nodejs
sudo apt-get install npm
Setting path:  sudo ln -s /usr/bin/nodejs /usr/bin/node