required to use a static IP or a cross-over Ethernet cable for this homework.
This is not a group project so you are required to do your own work.
Why do we have to do homework? “Tell me and I forget. Show me and I remember. Involve me and I understand.” –
Chinese proverb.
Pre-requirement:
o Before you work on any of the exercises below, please create a new user account with the following credentials:
Username: webuser; Password: sosu-2015
o Make sure the Firewall setting is correct for this assignment.
o Google the web to learn how to do any of the following exercises, if necessary.
1. Make a Straight-through Ethernet cable. [5%]
• Refer to the file, cable_Cat5.pdf, and use page 2 as the guide of making the straight-through cable.
• You can check out the cabling tools from Mr. Preston Bingham in room CB-107.
To test:
Use the Ethernet cable tester and make sure that the sequences of go by the following orders:
On one side (e.g. left) 1-2- 3-4- 5-6- 7-8 and the other side (e.g. right) 1-2- 3-4- 5-6- 7-8. [the
number-5 light on the tester might not lite on so please ignore it.]
Otherwise, please re-do the wiring again.
2. Set up a vsftpd service/server. [10%]
Refer to the text book for more information if necessary.
Do the following changes:
I. Change the ftpd_banner message to “Welcome to YourName’s FTP Durant site!” [2%]
II. Enable the anonymous user login permission (read/create/delete/list permissions). [2%]
III. Allow the anonymous user to upload files to your ftp server [2%]
To test the connection, use any ftp client software (e.g., FileZilla) from your Win7 workstation and make a
connection to your server. And make sure that a local user (e.g., webuser) has the read/write/create/delete
permissions.
3. Putting LAMP (Linux, Apache, MySql, and Php) together to create a Comment Forum website.
[45%]
a. Create a comment_table with the fields of id, comment, email and phone and assign all the
permissions to the webuser.[5%]
b. Create a new comment forum webpage containing three textboxes and two buttons. (Refer to Figure
1 below) [10%]
Don’t worry about the format/style if you are not familiar with HTML language. Just putting up the
three textboxes on your webpage will be fine.
Feel free to refer to/use any of the sample files (e.g., AllinOne_phpFormComment_sp15.doc,
phpFormComment.html.txt, phpInsertComment.php.txt, …, etc) for references.
c. Test your forum application using the url below from any other machine [5%]
http://LinuxServerIP/~webuser/phpFormComment.html
Refer to figure 2 as an example.
d. Create a new page to indicate the comment, email, phone-no have been insert into the comment_table
after a user clicks the Submit button from the form comment page. In addition, provide a php-select-
sqlcommend link on the same page. [15%].
Refer to figure 2 as an example.
e. Create a new page to make sure that after a user clicks the php-select- sqlcomment link it will display
all the comments, emails, and phones from your comment_table table. [10%]
Refer to figure 3 as an example.
f. Zip all the files into one file and submit it to your blackboard account. You will lose 10 points if you
haven’t done so by 11:59 pm on the demonstration day.
Remarks:
I. Make sure that all the webpage and php files are stored under the webuser’s public_html directory. In addition, in
your php code, you have to use webuser’s credential to access or insert data into the comment_table. A 15 points will
be ducted if you don’t do so.
II. Refer to the website, http://babbage.se.edu/~msu/sp12/phpFormComment.html to see what a simple comment forum