1 / 9

PNT Web Based Knowledge Portal Project

PNT Web Based Knowledge Portal Project. Group Name: PNT Group Members: Prabin Joshi and Ngoc Vu. Content. Technology Used Functions Security Issues System Configuration SSH Configuration Database Schema Demo. Techology. Three tier web application Web technology: PHP

judith-pruitt
Download Presentation

PNT Web Based Knowledge Portal Project

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. PNT Web Based Knowledge Portal Project Group Name: PNT Group Members: Prabin Joshi and Ngoc Vu

  2. Content • Technology Used • Functions • Security Issues • System Configuration • SSH Configuration • Database Schema • Demo

  3. Techology • Three tier web application • Web technology: PHP • Web server: Apache • Database: Mysql Server

  4. Functions • Users • Post articles, write comment on particular article • Create group and mange group permission (access control) • Each user and article can be ranked • Admin • Manage groups and users on entire system • Collect statistics about user behaviors (group activity, user activity …)

  5. Security Issues • Password hashing with salt • User account activation code sending to email • Recaptcha • Sql Injection prevention (using mysql_real_escape_string function) • Secure connection between web browser and web server. • Future work: support secure connection between web application and database (mysql) using ODBC driver and SSH

  6. System Configuration

  7. SSH Configuration (uhcl1) • Forward port 3306 of uhcl1 to port 3307 of uhcl2 • Connection string for ODBC driver: localhost:3307, username, password (uhcl2)

  8. Database Schema create * * Users Groups Permissions * * 1 1 * Articles Comments has 1 *

  9. DEMO

More Related