DeVry University

3. DeVry University Presents…

4. Senior Project

5. Tiffaney DeAmicis

6. Jason Bundage

7. David Haney II

8. Carlos Williams

9. Sarah Overshon

10. Marty Williams

11. The Client

13. The Clients Needs… • To have the ability to register and track users (Residents). • To have the ability to filter and block inappropriate web content.

14. Executive Summary The DeVry team has signed an agreement with Rainbow Housing Assistance Corporation and the residents of the Cool Wood Oaks Apartment complex to implement a Login Tracking System for our senior project. The purpose of this application is to authorize the staff of Cool Wood to track the computer usage of the residents and provide the residents with a secure purpose of accessing the system. The application will contain a simple login-in system that will gather the information from the users to create a unique username and password to allow them a timed access of the internet browser.

15. Project Description Previously, the computer lab at Cool Wood Oaks Apartment complex consisted of only two workstations. The companies ultimate goal is to be able to increase the number of computers to five. The new network will access the internet via a proxy server, which will also be installed. A login system is connected to a database, and will require residents to enter their credentials before access to the computers will be granted. This, along with the proxy server will ensure acceptable internet usage among the respective tenants.

16. The Previous Senior Project

18. The Technology Involved • Linux • Apache • Netfilter • Squid • MySQL • PHP • FreeRADIUS • Perl • Chillispot

19. Linux The Ubuntu Linux OS serves as the core of the proxy server. Linux is the origin of how the project is built and what it is capable of…

20. Apache Apache is unquestionably the most well-known web server in existence because it is responsible for serving the login application to the clients.

21. Netfilter Netfilter allows for us to DHCP all of our clients and for us to redirect traffic from port 80 to port 3128 to be filtered by the application Squid.

22. Squid Squid is the most widely used content filtering system in use today because it handles blocking inappropriate content.

23. MySQL MySQL is a world class enterprise level database application and it stores all the client information.

24. PHP PHP is a scripting language that was created for designing web pages so that it can be used to enter the information into the database.

25. FreeRADIUS FreeRADIUS is an application that handles Authentication, Authorization and Accounting (AAA)

26. Perl Perl is a scripting language that is actual a gateway application that is embedded in itself.

27. Chillispot Chillispot is a mesh technology that allows a user to use FreeRADIUS and MySQL in a combination to decide weather a client should have access to the internet and/or continue being redirected to the login page.

28. Our Senior Project

30. The Server Procedures

33. PROXY SERVER BACKUP CONFIGURATION sudofdisk -l cd/ sudo -s -H mount -t ext 3 /dev/sda1 /mnt mount -t proc proc /mnt/proc mount -t sysfs sys /mnt/sys mount -o bind /dev /mnt/dev chroot /mnt /bin/bash grub -install /dev/sda

34. The Certificates

40. The Workstation Procedures

42. The Technology Involved • Linux Ubuntu Proxy Server • Symantec Ghost 8.3

43. Symantec Ghost 8.3

44. Symantec Ghost 8.3

45. The Components Involved • One Modem • Two Switches • One Router • One Proxy Server • Two Workstations • One Administration System

46. The Login Application

48. The Login Process

50. The Logout Process